Question

mybatis怎么实现时间段查询

Answer 1

<select id="selectOrderListByPage" parameterType="com.xhh.webui.system.entity.Order"

resultType="com.xhh.webui.system.entity.Order">

select * from `order`

<where>

<if test="begindate != null and begindate !=''">

createTime>#{begindate,jdbcType=TIMESTAMP}

</if>

<if test="enddate != null and enddate !=''">

and createTime<#{enddate,jdbcType=TIMESTAMP}

</if>

</where>

<if test="sort != null and order != null">

<![CDATA[ order by ${sort} ${order} ]]>

</if>

LIMIT #{start},#{rows}

</select>