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>
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>
阅读全文
0 0
- Mybatis返回自定义结果集
- mybatis返回Map结果集
- Mybatis下配置调用Oracle自定义函数返回的游标结果集
- MyBatis调用存储过程返回结果集
- mybatis的mapper返回map结果集
- mybatis的mapper返回map结果集
- mybatis 结果返回原理
- Mybatis 返回结果映射
- 自定义返回结果类
- Mybatis 查询结果返回 Map
- mybatis 自定义返回值
- mybatis 调用 oracle 返回结果集 存储过程
- Mybatis 调用oracle存储过程返回结果集
- Mybatis调用存储过程返回多个结果集
- mybatis调用mysql存储过程返回结果集
- mybatis 调用 oracle 返回结果集 存储过程
- SSM-Mybatis调用Oracle存储过程返回结果集(游标)
- mybatis调用oracle存储过程返回结果集
- hashset中hashcode和equals方法
- [bigdata] 基于docker 打开hadoop
- 求最小生成树(Prim算法)(1075)
- WindowsServer2003搭建FTP服务器整套教程
- win10 快捷切换输入法的简繁体
- Mybatis返回自定义结果集
- 假装能a的网络流,弱化的费用流
- mfc hittest 使用方法
- 欢迎使用CSDN-markdown编辑器
- maven搭建springmvc环境
- QObject: Cannot create children for a parent that is in a different thread.
- 写一个全局的方法替换字符串中相应位置的内容
- logstash 区分多个文件index端配置
- BAT命令替换变量中的值为新值