【Mybatis】根据时间区间，使用动态SQL，查询list集合数据

需要SQL内置函数

birthday >= STR_TO_DATE(#{beginDate},'%Y-%m-%d')

//数据形式
List<User> rows = userMapper.GetRows(0, 10, null, null, "2020-01-01", null);

接口

List<User> GetRows(@Param("offset") int offset,
					@Param("limit") int limit,
					@Param("name") String name,
					@Param("gender") String gender,
					@Param("beginDate") String beginDate,
					@Param("endDate") String endDate);

UserMapper.xml

    <select id="GetTotal" resultType="long">
        select count(*) from user
        <where>
            <!--and 如果是跟在where后面，框架会自动省略-->
            <if test="name != null and name.trim() != ''">
                and name like #{name}
            </if>
            <if test="gender != null">
                and gender = #{gender}
            </if>
            <if test="beginDate != null and beginDate.trim() != ''">
                and birthday >= STR_TO_DATE(#{beginDate},'%Y-%m-%d')
            </if>
            <if test="endDate != null and endDate.trim() != ''">
                and birthday &lt;= STR_TO_DATE(#{endDate},'%Y-%m-%d')
            </if>
            <!--
            xml语法：
            <![CDATA[
                and endDate <= #{endDate}
            ]]
            -->
        </where>
    </select>