java - 使用 where 子句使用 spring JDBC 从数据库中查找记录

Question

我想使用 spring JDBC 从数据库中搜索两个日期的记录。我用 where startDate=? 和 endDate=? 我需要更正控制器。我得到了例外

org.springframework.web.servlet.handler.AbstractHandlerExceptionResolver resolveException 警告：已解决 [org.springframework.web.method.annotation.MethodArgumentConversionNotSupportedException：无法将“java.lang.String”类型的值转换为所需的“java.sql.Date”类型'; 嵌套异常是 java.lang.IllegalStateException：无法将类型“java.lang.String”的值转换为所需类型“java.sql.Date”：找不到匹配的编辑器或转换策略] [图片][1]

    public class EmpDao {  
JdbcTemplate template;  
  
public void setTemplate(JdbcTemplate template) {  
    this.template = template;  
}  

public List<Event> getEmployees(Date start, Date end){  
    return template.query("select * from Event where startDate=? and endDate=?",new RowMapper<Event>(){  
        public Event mapRow(ResultSet rs, int row) throws SQLException {  
            Event e=new Event();  
            e.setEventName(rs.getString(1));  
            e.setEventOrgName(rs.getString(2));  
            e.setEventFare(rs.getInt(3));  
            e.setStartDate(rs.getDate(4));
            e.setEndDate(rs.getDate(5));
            return e;  
        }  
    });  
}  
}    



public class Event {  
private String eventName;  
private String eventOrgName;  
private int eventFare;  
private Date startDate;
private Date endDate;

} 



@Controller  
public class EmpController {  
    @Autowired  
    EmpDao dao;
   
   @GetMapping("/viewemp")  
public String viewemp(@RequestParam(value="start") @DateTimeFormat(pattern="dd/MM/yyyy") Date start,
        @RequestParam(value="end") @DateTimeFormat(pattern="dd/MM/yyyy") Date end, Model m){  
    List<Event> list=dao.getEmployees(start,end);  
    
    m.addAttribute("list",list);
    return "viewemp";  
}  
    
}





<h1>Add New Employee</h1>
       <form method="get" action="viewemp">  
       <input type="date" id="start" name="start"/>
        <input type="date" id="end" name="end"/>
        <input type="submit" value="Filter" />
        
        </form>

标签： javaspringspring-mvccontrollerspring-jdbc