mybatis查询的结果只拿到了id,其他属性未获取到

错误示范:
mapper.xml

  <sql id="BaseColumnList">
        id,create_by,create_time,update_by,update_time,delete_flag,import_flag,company_id,etab_code,etab_desc,etab_type,etab_unitid,etab_deptid
        ,etab_postid,etab_pernum,etab_isctrl,status,etab_sdate,etab_edate,comment,etab_takeupsum
    </sql>
    <select id="geyPostByName" resultType="com.hrocloud.znjs.orgemp.model.OrgEatabinfo">
        SELECT 
        <include refid="BaseColumnList" />
        FROM org_eatabinfo as o1,org_post as o2
        where  o1.delete_flag=0 and o2.delete_flag=0 and o1.etab_postid=o2.id and o2.post_cname like concat('%',#{postName},'%');
    </select>

应该为

  <sql id="BaseColumnList">
        id,create_by,create_time,update_by,update_time,delete_flag,import_flag,company_id,etab_code,etab_desc,etab_type,etab_unitid,etab_deptid
        ,etab_postid,etab_pernum,etab_isctrl,status,etab_sdate,etab_edate,comment,etab_takeupsum
    </sql>
    
    <resultMap id="BaseResultMap" type="com.hrocloud.znjs.orgemp.model.OrgEatabinfo">
        <id column="id" jdbcType="BIGINT" property="id"/> 
        <result column="create_by" jdbcType="BIGINT" property="createBy"/> 
        <result column="create_time" jdbcType="DATE" property="createTime"/> 
        <result column="update_by" jdbcType="BIGINT" property="updateBy"/> 
        <result column="update_time" jdbcType="DATE" property="updateTime"/> 
        <result column="delete_flag" jdbcType="TINYINT" property="deleteFlag"/> 
        <result column="import_flag" jdbcType="TINYINT" property="importFlag"/> 
        <result column="company_id" jdbcType="BIGINT" property="companyId"/> 
        <result column="etab_code" jdbcType="VARCHAR" property="etabCode"/> 
        <result column="etab_desc" jdbcType="VARCHAR" property="etabDesc"/> 
        <result column="etab_type" jdbcType="VARCHAR" property="etabType"/> 
        <result column="etab_unitid" jdbcType="BIGINT" property="etabUnitid"/> 
        <result column="etab_deptid" jdbcType="BIGINT" property="etabDeptid"/> 
        <result column="etab_postid" jdbcType="BIGINT" property="etabPostid"/> 
        <result column="etab_pernum" jdbcType="DECIMAL" property="etabPernum"/>
        <result column="etab_isctrl" jdbcType="TINYINT" property="etabIsctrl"/> 
        <result column="status" jdbcType="VARCHAR" property="status"/>
        <result column="etab_sdate" jdbcType="DATE" property="etabSdate"/> 
        <result column="etab_edate" jdbcType="DATE" property="etabEdate"/> 
        <result column="comment" jdbcType="VARCHAR" property="comment"/>
        <result column="etab_takeupsum" jdbcType="VARCHAR" property="etabTakeupsum"/>
    </resultMap> 
    
   <select id="geyPostByName" resultMap="BaseResultMap">
        SELECT 
        <include refid="BaseColumnList" />
        FROM org_eatabinfo as o1,org_post as o2
        where  o1.delete_flag=0 and o2.delete_flag=0 and o1.etab_postid=o2.id and o2.post_cname like concat('%',#{postName},'%');
    </select>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

JavaSupeMan

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值