mybatis mapper 传值为Map参数并返回map集合

康__

已于 2022-08-22 13:57:57 修改

阅读量7k

点赞数

于 2019-10-12 15:24:56 首次发布

本文链接：https://blog.csdn.net/qq_30055773/article/details/102521345

版权

Java 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

直接查看源码：
1.service层

List<Map<String,Object>> selectUpCountByTime(Long startTime,Long 
endTime);

2.service实现类层

    @Override
    public List<Map<String,Object>> selectUpCountByTime(Long startTime,Long endTime){
        Map<String,Object> map=new HashMap<>();
        if (startTime!=null && startTime!=0){
            map.put("startTime",new Date(startTime));
        }
        if (endTime!=null && endTime!=0){
            map.put("endTime",new Date(endTime));
        }
        List<Map<String,Object>> list=tBreakRuleDAO.selectUpCountByTime(map);
        String result= new Gson().toJson(list);
        return list;
    }

3.DAO层

List<Map<String,Object>>  selectUpCountByTime(Map<String,Object>map);

4.mapper层（注意:parameterType=“map”，resultType=“java.util.HashMap”）

  <select id="selectUpCountByTime" parameterType="map" resultType="java.util.HashMap">
    SELECT create_by as username,DATE_FORMAT(create_time,'%Y-%m-%d') as dates,count(0) as counts FROM t_break_rule
    <where>
      del_flag='0'
      <if test="startTime != null">
        and  DATE_FORMAT(create_time,'%Y-%m-%d %H:%i:%S')  &gt;= DATE_FORMAT(#{startTime,jdbcType=TIMESTAMP},'%Y-%m-%d %H:%i:%S')
      </if>
      <if test="endTime != null">
        and  DATE_FORMAT(create_time,'%Y-%m-%d %H:%i:%S')  &lt;= DATE_FORMAT(#{endTime,jdbcType=TIMESTAMP},'%Y-%m-%d %H:%i:%S')
      </if>
    </where>
      GROUP BY create_by ,DATE_FORMAT(create_time,'%Y-%m-%d') ORDER BY DATE_FORMAT(create_time,'%Y-%m-%d') ASC
  </select>