[Java][ibatis]通过resultMap与resultClass取得Map结果集的差异

 通过resultMap与resultClass取得Map结果集的差异

别名映射->实体类:resultClass
<select id=" selectAll" resultClass="AppLog">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #id#
</select>
List list = sqlMapper.queryForList("selectAll");
for (int i = 0; i < list.size(); i++) {
  AppLog log = (AppLog) list.get(i);
//add your code here;
}

别名映射->Map类:resultClass
<select id=" selectAll" resultClass="java.util.HashMap<String, String>">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #id#
</select>
List list = sqlMapper.queryForList("selectAll");
for (int i = 0; i < list.size(); i++) {
  Map map = (Map) list.get(i);
  String id = (String) map.get("id");
  String type = (String) map.get("type");
  String descr = (String) map.get("descr");
//add your code here;
}

显式映射->实体类:resultMap
<resultMap id="AppLogResult" class="AppLog">
<result property="id" column="ID"/>
<result property="type" column="Type"/>
<result property="descr" column="DESCR"/>
</resultMap>

<select id="selectAll" resultMap="AppLogResult">
select * from APP_LOG
</select>
List list = sqlMapper.queryForList("selectAll");
for (int i = 0; i < list.size(); i++) {
  AppLog log = (AppLog) list.get(i);
//add your code here;
}

显式映射->Map类:resultMap
  <resultMap id="map-result" class="java.util.HashMap">
    <result property="id" column="ID"/>
  <result property="type" column="Type"/>
  <result property="descr" column="DESCR"/>
  </resultMap>

<select id="selectAll2" resultMap="map-result">
select * from APP_LOG
</select>
List list = sqlMapper.queryForList("selectAll2");
    for (int i = 0; i < list.size(); i++) {
      Map map = (Map) list.get(i);
      String id = (String) map.get("id");
      String type = (String) map.get("type");
      String descr = (String) map.get("descr");      
    }

无映射
<select id="selectAll3" resultClass="java.util.HashMap">
select * from APP_LOG
</select>
List list = sqlMapper.queryForList("selectAll3");
for (int i = 0; i < list.size(); i++) {
  Map map = (Map) list.get(i);
  String id = (String) map.get("ID");
  String type = (String) map.get("TYPE");
  String descr = (String) map.get("DESCR");
}

xml

<select id="selectxml" parameterClass="java.lang.String" resultClass="xml" xmlResultName="log">
select
ID as id,
TYPE as type,
DESCR as descr
from APP_LOG
where ID = #id#
</select>
String o=(String) sqlMapper.queryForObject("selectxml", id);
System.out.println(o);

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值