来自于四明山的码农

 

mybatis查询如何返回List<Map>类型数据

只要设定resultType而不设定resultMap就可以了:
 
<selectid="selectByPage"parameterType="java.util.Map"
resultType="java.util.Map">

select rs.*, rssetting.*, cp.STOCK_CODE, cp.UNAME from RS rs
left join T_COMPANY cp on rs.uid = cp.uid
left join RS_ROADSHOW_SETTING rssetting on rssetting.rs_id = rs.id
where rs.TYPE_ID != 1
<iftest="qKeyWord != null">
and cp.stock_code = #{qKeyWord}
</if>
<iftest="rsTitle != null">
and rs.title like #{rsTitle}
</if>
order by rs.crt_time desc limit #{pageIndex}, #{pageSize}

</select>
 
 
来源:http://blog.csdn.net/shandalue/article/details/41443603

posted on 2017-08-18 17:58  技术先锋  阅读(1362)  评论(0编辑  收藏  举报

导航