mybatis多个参数 判断非空

来源:互联网 发布:淘宝差评师曝光台 编辑:程序博客网 时间:2024/06/04 18:25

public List<Map> statistics( @Param("startTime")String startTime,@Param("endTime")String endTime,Integer pageIndex,Integer pageSize);<select id="statistics" resultType="java.util.Map">
SELECT COUNT(*) AS 'total_cnt',SUM(consume_change) AS 'change_cnt',COUNT(DISTINCT(uid)) AS 'user_cnt',DATE_FORMAT(
consume_time,'%Y-%m-%d') 'data_time'
FROM kpl_matchs_vote.guess_consume
WHERE consume_status=0 AND consume_type='bet'
<if test="startTime != null" >
AND consume_time >= #{startTime,jdbcType=TIMESTAMP}
</if>
<if test="endTime != null" >
AND #{endTime,jdbcType=TIMESTAMP} >= consume_time
</if>
GROUP BY DATE_FORMAT(
consume_time,'%Y-%m-%d') limit #{2},#{3}
</select>

原创粉丝点击