http://blog.csdn.net/zl544434558/article/details/24428307?utm_source=tuicool&utm_medium=referral
在项目中查询时间段的sql语句(时间类型为datetime或date):
- <if test="pojo.begintime!=null and pojo.begintime!=''">
- <![CDATA[ and DATE_FORMAT(tr.summary_date, '%Y-%m-%d')>= DATE_FORMAT(#{pojo.begintime}, '%Y-%m-%d') ]]>
- </if>
- <if test="pojo.endtime!=null and pojo.endtime!=''">
- <![CDATA[ and DATE_FORMAT(tr.summary_date, '%Y-%m-%d') <= DATE_FORMAT(#{pojo.endtime}, '%Y-%m-%d') ]]>
- </if>
在项目中查询时间段的sql语句(时间类型为varchar):
- <if test="excelImport_date_begin != null and excelImport_date_begin != '' ">
- AND
- tm.excelImport_date>=#{excelImport_date_begin}
- </if>
- <if test="excelImport_date_end != null and excelImport_date_end != '' ">
- AND
- tm.excelImport_date <=#{excelImport_date_end}
- </if>
<
小于号 < > 大于号>
页面的源码:
- <input id="begintime" class="Wdate date_text" type="text"
- onclick="WdatePicker({el:'begintime'})" name="qureyBean.begintime"
- value="<s:property value="@com.hljw.util.UncDate@shortDate(qureyBean.begintime)" />" />
- <input id="endtime" class="Wdate date_text" type="text"
- onclick="WdatePicker({el:'endtime'})" name="qureyBean.endtime"
- value="<s:property value="@com.hljw.util.UncDate@shortDate(qureyBean.endtime)" />" />
页面表现形式截图: