jsp里:
<td style="width:150px;height:10%;color:#000;padding-left: 10px;padding-bottom: 10px;">
<label>开始时间:</label>
<input type="text" id="tmbegin" οnfοcus="WdatePicker({skin:'whyGreen',dateFmt:'yyyy-MM-dd HH:mm:ss'})" class="Wdate" name="tmbegin" value="${tmbegin}"/>
</td>
<td style="width:150px;height:10%;color:#000;padding-left: 10px;padding-bottom: 10px;">
<label>结束时间:</label>
<input type="text" id="tmend" οnfοcus="WdatePicker({skin:'whyGreen',dateFmt:'yyyy-MM-dd HH:mm:ss'})" class="Wdate" name="tmend" value="${tmend}"/>
</td>
controller里:
String tmbegin1=request.getParameter("tmbegin");
String tmend1=request.getParameter("tmend");SimpleDateFormat sdf1=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date tmbegin2=new java.util.Date();
java.sql.Timestamp tmbegin=null;
if(!isNull(tmbegin1)){
try {
tmbegin2= (java.util.Date) sdf1.parse(tmbegin1);
tmbegin = new java.sql.Timestamp(tmbegin2.getTime());
} catch (ParseException e) {
e.printStackTrace();
}
}
SimpleDateFormat sdf2=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date tmend2=new java.util.Date();
java.sql.Timestamp tmend=null;
if(!isNull(tmend1)){
try {
tmend2= (java.util.Date) sdf1.parse(tmend1);
tmend = new java.sql.Timestamp(tmend2.getTime());
} catch (ParseException e) {
e.printStackTrace();
}
}
HashMap queryParams = new HashMap();
PageInfo pageInfo = new PageInfo();
queryParams.put("stcd", stcd);
Date now = new Date();
SimpleDateFormat dateFormat1 = new SimpleDateFormat("yyyy");//设置时间为当年的一月一日,也就是今年的刚开始
SimpleDateFormat dateFormat2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String nowtime1 = dateFormat1.format( now ); //结果为:2016-01-01 00:00:00
String nowtime2 = dateFormat2.format( now );
if(!isNull(tmbegin1)){
queryParams.put("tmbegin", tmbegin1);
}else{
queryParams.put("tmbegin", nowtime1);
}
if (!isNull(tmend1)){
queryParams.put("tmend", tmend1);
}else{
queryParams.put("tmend", nowtime2);
}
/*
mybatis里:
<select id="queryRain" parameterType="java.util.HashMap" resultType="java.util.HashMap">
select * from (select row_number() over (order by id asc) rn, a.*
from
dt_rain a
<where>
<if test="null != stcd and stcd != ''">
and stcd=#{stcd}
</if>
<if test="null != tmbegin and tmbegin != ''"> //外部传过来的是String
and
tm>=#{tmbegin}
</if>
<if test="null != tmend and tmend != ''">
and
tm<=#{tmend}
</if>
</where>
) t
<where>
<if test="null != pageInfo">
t.rn>=#{pageInfo.startRow} and t.rn<=#{pageInfo.endRow}
</if>
</where>
order by t.rn asc
</select>
java bean里部分:
public class Rain extends BaseObject{
private int id;
private String pstcd;
private String stcd;
private Timestamp tm;
private Double rain;
private int intv;
private Timestamp moditime;
mybatis里:
<resultMap id="rainInfo" type="com.szllt.pingshan.entity.data.Rain" > //如果resultType="java.util.HashMap"写成这样,其实这个映射根本没用到,也就不用考虑javabean和这里的映射了。
<id column="id" property="id" />
<result column="pstcd" property="pstcd" />
<result column="stcd" property="stcd" />
<result column="tm" property="tm" />
<result column="rain" property="rain" />
<result column="intv" property="intv" />
<result column="moditime" property="moditime" />
</resultMap>
*/
数据库:
页面