######求助大佬们 我刚学ssm 但遇到查询时间真就没办法了 百度了很多但找不到解决办法
jsp前端代码
<div class="col-md-4 column">
<form class="form-inline" action="${pageContext.request.contextPath}/book/queryTime" method="post" style="float: right">
<span style="color: red;font-weight: bold">${error}</span>
<input type="date" name="queryBookTime" >
<input type="submit" value="查询" class="btn btn-primary">
</form>
</div>
dao层以及xml
List<Books> queryBookByTime(@Param("time") Date time);
<select id="queryBookByTime" parameterType="list" resultMap="archivesidVo">
select * from news1.new
<where>
<if test="time != null">
AND date_format(time,'%y-%m-%d') >= date_format(#{time},'%y-%m-%d')
</if>
</where>
</select>
<resultMap type="com.kuang.pojo.Books" id="archivesidVo">
<id property="id" column="id"/>
<result property="title" column="title"/>
<result property="time" column="time"/>
<result property="author" column="author"/>
<result property="content" column="content"/>
</resultMap>
controller层
@RequestMapping("/queryTime")
public String queryTime(Date time, Model model){
List<Books> books=bookService.queryBookByTime (time);
System.out.println("time "+time);
List<Books> list=books;
for (Books books1 : books) {
if (books1==null) {
model.addAttribute("error","未查到");
}
//System.out.println("77"+books1);
}
model.addAttribute("list",list);
return "manage/allBook";
}