java - 使用 JPA 的 LocalDate 无法正常工作

Question

我确实请求localhost:8080/history/world/2020-02-08

实体:

public class DailyStatistic {
...
@Column(columnDefinition = "DATE")
    private LocalDate date;
...

Controller :

@GetMapping("/world/{date}")
    public ResponseEntity<List<DailyStatistic>> getWorldStatByDate(@PathVariable String date) {
        List<DailyStatistic> worldStatList = null;
        try {
            worldStatList = dataProvider.getWorldStatByDate(LocalDate.parse(date));
...

调用的dataProvider方法:

public List<DailyStatistic> getWorldStatByDate(LocalDate date) throws NoDataException {
        List<DailyStatistic> dailyStatisticList = repository.findAllByDate(date);
...

调用的存储库方法:

 @Repository
public interface DailyStatRepository extends JpaRepository<DailyStatistic, Long> {

    List<DailyStatistic> findAllByDate(LocalDate date);

Json 答案:

{
...
"date": "2020-02-07",
...
}

提醒输入:localhost:8080/history/world/2020-02-08

所以我得到了错误的结果集。有人知道为什么会发生以及如何解决吗？

Answer 1

在您的实体中尝试这种方式

import com.fasterxml.jackson.databind.annotation.JsonDeserialize;
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
import java.time.LocalDateTime;


@JsonSerialize(converter = LocalDateTimeToStringConverter.class)
@JsonDeserialize(converter = StringToLocalDatetimeConverter.class)
private LocalDateTime date;

See this

或者只是这样

@JsonFormat(pattern = "yyyy-MM-dd")
private LocalDate date;