条件查询按时间段查询

controller层中：

//hrs 2015-02-05 新闻条件查询增加时间段查询 start

String startTime = request.getParameter("startTime");
String endTime = request.getParameter("endTime");
//end
Map<String, Object> map = new HashMap<String, Object>();
map.put("name", name);
map.put("content", content);
//hrs 2015-02-05 新闻条件查询增加时间段查询start
map.put("startTime", startTime);
map.put("endTime", endTime);

//end

//hrs 2015-02-05 新闻条件查询增加时间段查询start
modelAndView.addObject("startTime", startTime);
modelAndView.addObject("endTime", endTime);
//end

Dao层中：

//hrs 2015-02-05 新闻条件查询增加时间段查询 start
Object startTime = map.get("startTime");
if(startTime!=null&&!startTime.toString().equals("")){
if(wherehql.equals("")){
wherehql+=" where ";
}else{
wherehql += " and ";
}
wherehql += "time >= '" + startTime.toString() + "'";
}

Object endTime = map.get("endTime");
if(endTime!=null&&!endTime.toString().equals("")){
if(wherehql.equals("")){
wherehql+=" where ";
}else{
wherehql += " and ";
}
wherehql += "time <= '" + endTime.toString() + "'";
}
//end

页面：

<!--hsr 2015-02-05 新闻条件查询增加时间段查询功能  start-->
                                新闻发布时间：<input type = "text" name = "startTime" value = "${startTime}" class = "date" dateFmt="yyyy-MM-dd HH:mm" readonly="true"  >
                                -<input type = "text" name = "endTime" value = "${endTime}" class = "date" dateFmt = "yyyy-MM-dd HH:mm" readonly = "true" >
                                <!--end  -->