Springboodate实体问题"无法将'java.lang.String'类型的值转换为所需类型'java.util.Date'

Question

当我尝试使用这些url时：http://www.localhost:8080/api/employee/search?startDate=2000-10-22

此错误消息显示："未能将'java.lang.String'类型的值转换为所需的类型'java.util.Date'；嵌套异常org.springframework.core.convert.ConversionFailedException：未能将值'2000-10-22'从类型[java.lang.String]转换为类型[@org.springframework.web.bind.annotation.Request estParamjava.util.Date]；嵌套异常java.lang.IllegalArgumentException"

参数：起始日期=2000-10-22工资=10000

这里的问题是什么？

员工类别：

@NoArgsConstructor
@AllArgsConstructor
@Data
@Builder
@Entity
@Table(name = "employee")
public class Employee {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;

    @NotBlank
    private String nationalId;

    @NotBlank
    private String name;

    @NotBlank
    private String surname;

    private Integer salary;

    @JoinColumn(name="start_date")
    @JsonFormat(pattern="yyyy-MM-dd")
    private Date startDate;

    private String office;

    private String department;

在我的存储库中查询：

  @Query("Select e FROM Employee e  " +
            "where " +
            " (:startDate is NULL or e.startDate > :startDate) " +
            " AND " +
            " (:salary is NULL or e.salary > :salary) ")
    List<Employee> searchEmployees(Date startDate,Integer salary);

服务Impl：

 @Override
    public List<Employee> searchEmployees(Date startDate,Integer salary){
        List <Employee> employees = employeeRepository.searchEmployees(startDate,salary);
        return employees;
    }

控制器：

@GetMapping(path="/search")
    public ResponseEntity<List<Employee>> searchEmployees(@RequestParam("startDate") Date startDate,
                                                          @RequestParam("salary") Integer salary){
        return ResponseEntity.ok(employeeService.searchEmployees(startDate,salary));
    }

Answer 1

问题是java转换字符串到日期你可以试试这个

@GetMapping(path="/search")
public ResponseEntity<List<Employee>> searchEmployees(@RequestParam("startDate") @DateTimeFormat(iso = DateTimeFormat.ISO.DATE) Date startDate,
                                                      @RequestParam("salary") Integer salary){
    return ResponseEntity.ok(employeeService.searchEmployees(startDate,salary));
}

Answer 2

这是因为默认情况下，Spring无法将String参数转换为任何日期或时间对象。

改用这个。

@RequestParam@DateTimeFormat（pattern=“yyyy-MM-dd”）日期开始日期