潘鑫博客

Mybatis按日期范围搜索

10/22/2022 Mybatis后端
(adsbygoogle = window.adsbygoogle || []).push({});

实体类的一个属性时date数组，直接使用会报错，需要写明javaType=java.util.Date, jdbcType=DATE

<select id="list" resultMap="BaseResultMap">
    select * from sys_notice
    <where>
      <if test="fromUser != null and fromUser != ''"> and from_user = #{fromUser}</if>
      <if test="description != null and description != ''">and (description like '%${description}%' or title like'%${description}%')</if>
      <if test="datetimeRange != null">and datetime between #{datetimeRange[0], javaType=java.util.Date, jdbcType=DATE} and #{datetimeRange[1],javaType=java.util.Date, jdbcType=DATE} </if>
    </where>
    order by `read` asc, datetime desc
  </select>
1
2
3
4
5
6
7
8
9

我的博客即将同步至腾讯云开发者社区，邀请大家一同入驻：https://cloud.tencent.com/developer/support-plan?invite_code=38dpnhkh4o8wo