防止遗忘。
Mapper
List<User> getUserListByDateGroup(@Param("startdate")Date startdate,@Param("endDate")Date endDate);
Mapper.xml
<select id="getUserListByDateGroup" resultType="com.*.*.bean.User">
SELECT * FROM user WHERE
<if test="startdate!=null and startdate!=''">
<![CDATA[ DATE_FORMAT(date, '%Y-%m-%d') >= DATE_FORMAT(#{startdate}, '%Y-%m-%d') ]]>
</if>
<if test="endDate!=null and endDate!=''">
AND <![CDATA[ DATE_FORMAT(date, '%Y-%m-%d') <= DATE_FORMAT(#{endDate}, '%Y-%m-%d') ]]>
</if>
</select>