mybatis中大于、小于、大于等于、小于等于示例
<!-- 查询前N天数据 -->
<select id="getLastDayFreeeze" resultType="DayFreeze">
SELECT
<include refid="freezeColumns"/>
FROM dayfreeze a
WHERE a.DeviceID = #{deviceId}
AND TO_DAYS(NOW()) - TO_DAYS(a.sysTime) <= #{dayNum}
AND TO_DAYS(NOW()) - TO_DAYS(a.sysTime) >= 1
</select>
<!-- 查询前N个月数据 -->
<select id="getLastMonthFreeeze" resultType="DayFreeze">
SELECT
<include refid="freezeColumns"/>
FROM dayfreeze a
WHERE a.DeviceID = #{deviceId}
AND PERIOD_DIFF(DATE_FORMAT(NOW(),'%Y%m'),DATE_FORMAT(a.sysTime,'%Y%m')) <= #{monthNum}
AND PERIOD_DIFF(DATE_FORMAT(NOW(),'%Y%m'),DATE_FORMAT(a.sysTime,'%Y%m')) >= 1
</select>