【Mybatis】MyBatis查询,返回值Map或List<Map>
1.返回值Map
- mapper.xml
<select id="selectUserMapLimitOne" resultType="java.util.HashMap">
select id,name
from
user order by id desc limit 1
</select>
- 接口定义
/**
* 获取仅含一个的map(map的size=字段个数)
* @return
*/
Map<String,Object> selectUserMapLimitOne();
2. 返回List
- mapper.xml
<select id="selectUserMapList" resultType="java.util.HashMap">
select id,name from
user order by id desc limit 2
</select>
- 接口定义
/**
* 获取map list
* @return
*/
List<Map<String,Object>> selectUserMapList();

浙公网安备 33010602011771号