如何在Spring Boot ApplicationJava中从thymeleaf到MySQL获取日期输入值？

Question

我想从Spring Boot应用程序thymeleaf（HTML）中获取输入值，并以日期格式输入MySQL数据库。但我收到了以下错误消息：“未能将类型为“java.lang.String”的值转换为所需的类型“java.sql.Date”。

下面是我的控制器路径代码。提前谢谢。

@GetMapping("/saveApplication")
    public String saveApplication(@RequestParam(name="name", required = false) String name,
            @RequestParam(name="surname", required = false) String surname,
            @RequestParam(name="place", required = false) String place,
            @RequestParam(name="start", required = false) @DateTimeFormat(pattern = "dd.MM.yyyy") Date start,
            @RequestParam(name="end", required = false) @DateTimeFormat(pattern = "dd.MM.yyyy") Date end,
            @RequestParam(name="identity", required = false) Integer identity,
            @RequestParam(name="tel", required = false) Integer tel,
            Model model) 
    {

        final Integer id = 1;
        
        
        String sql = "INSERT INTO `user`.`application` (`kullaniciid`, `name`, `surname`, `place`,`start`, `end`,`identity`,`tel`) VALUES ( ?, ?, ?,  ?, ?, ?, ?, ?)";
        
        jdbcTemplate.update(sql, id,name, surname, place,start, end,identity,tel);
        
        
        return "screen3";
    }

Answer 1

我修复了它将@DateTimeFormat更改为@Date并导入Date。