mybatis查询实现返回List<Map>类型数据操作

**只要设定resultType而不设定resultMap就可以了**：



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

and rs.title like #{rsTitle}

order by rs.crt_time desc limit #{pageIndex}, #{pageSize}

 
 select id,name 
 from 
 user order by id desc limit 1 
 

/** 
 * 获取仅含一个的map（map的size=字段个数） 
 * @return 
 */ 
Map selectUserMapLimitOne(); 

 
 select id,name from 
 user order by id desc limit 2 
 

/** 
 * 获取map list 
 * @return 
 */ 
List> selectUserMapList();

 @Value("${domain}")
 public void setDomain(String domain) {
 DomainUtil.domain = domain;
 }