Mybatis返回自定义结果集

来源:互联网 发布:假面骑士exaid知乎 编辑:程序博客网 时间:2024/06/17 13:29
实体类:
private User user;
private String username;


Mybatis:
<resultMap id="vtnmmap" type="VTNM">
        <id column="ID" property="id"/>
        <result column="PARENT_ID" property="parent_id" />
        <result column="RECSTATE" property="recstate" />
        <result column="USER" property="username" />//实体为对象时,要转成值类型
        <result column="CREATE_DATE" property="createDate" />
        <result column="UPDATE_DATE" property="updateDate" />
        <result column="REMARKS" property="remarks" />
        <result column="DEL_FLAG" property="delFlag" />
        <result column="CXDM" property="cxdm" />
        <result column="SLOT_DH_JHSJ" jdbcType="DATE" property="slot_dh_jhsj" />//日期必须指定格式
        <result column="SLOT_ET1_JHSJ" jdbcType="DATE" property="slot_et1_jhsj" />
        <result column="SLOT_ET1_SJSJ" jdbcType="DATE" property="slot_et1_sjsj" />
        <result column="ET1_DH_JHSJ" jdbcType="DATE" property="et1_dh_jhsj" />
        <result column="ET2_DH_JHSJ" jdbcType="DATE" property="et2_dh_jhsj" />
        <result column="ET_PT_JHSJ" jdbcType="DATE" property="et_pt_jhsj" />
        <result column="ET_PT_SJSJ" jdbcType="DATE" property="et_pt_sjsj" />
        <result column="PT1_DH_JHSJ" jdbcType="DATE" property="pt1_dh_jhsj" />
        <result column="PT2_DH_JHSJ" jdbcType="DATE" property="pt2_dh_jhsj" />
        <result column="PT_SOP_JHSJ" jdbcType="DATE" property="pt_sop_jhsj" />
        <result column="PT_SOP_SJSJ" jdbcType="DATE" property="pt_sop_sjsj" />
        <result column="LX" property="lx" />
        <result column="ZT" property="zt" />
    </resultMap>


使用:    
<select id="getPage" resultMap="vtnmmap">
SELECT * FROM CAR
    </select>
原创粉丝点击