http://blog.csdn.net/zl544434558/article/details/24428307?utm_source=tuicool&utm_medi
在项目中查询时间段的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)" /> " />
页面表现形式截图: