【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();
posted @ 2021-12-29 15:50  rongbu2  阅读(312)  评论(0)    收藏  举报