Spring的Json响应中的时区问题 [英] Problem with timezone in Json response from Spring

问题描述

我在JSON输出中显示日期时遇到问题.在代码中，我使用java.util.Date，其值是2019-03-07，但是在JSON中，我得到了2019-03-06 23:00:00.我认为问题出在时区，但是我也没有在数据库和代码中使用时区.

I have a problem with displaying dates in JSON output. In code I use java.util.Date and its value is 2019-03-07 but in JSON I got 2019-03-06 23:00:00. I think the problem is in timezone, but I don't use timezones in DB and in code too.

我试图用

@JsonFormat(pattern = "yyyy-MM-dd hh:mm:ss", timezone="UTC")

和

@JsonFormat(pattern = "yyyy-MM-dd hh:mm:ss", timezone="Europe/Warsaw")

第一个没有帮助，第二个没有帮助，但我不接受这种解决方案.

The first didn't help, the second helped but I don't accept this solution.

我的控制器的一部分:

return new ThisDay(
    sysoperMgr.getToday(),
    new Date()
);

这是我返回的对象.

@Getter
@Setter
public class ThisDay {

    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    Date dataZamkniecia;

    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    Date dataSystemowa;

    public BiezacaDoba(Date dataZamkniecia, Date dataSystemowa) {
        this.dataZamkniecia = dataZamkniecia;  // cdate = 2019-03-07T00:00:00.000+0100
        this.dataSystemowa = dataSystemowa; // cdate = 2019-03-27T16:08:12.343+0100
    }
}

此函数获取日期:

public Date getToday() {

    Timestamp timestamp = sysoperDao.getDataOstatniejZamknietejDoby(); // cdate = 2019-03-06T00:00:00.000+0100
    java.util.Date lastDay = new java.sql.Date(misc.roundTimestamp(timestamp).getTime()); // cdate = 2019-03-06T00:00:00.000+0100
    java.util.Date thisDay = misc.incrementDate(ostatniaDoba, Increment.DAILY, 1); // cdate = 2019-03-07T00:00:00.000+0100
    return thisDay;
}

Json结果:

{
  "dataZamkniecia":"2019-03-06 23:00:00",
  "dataSystemowa": "2019-03-27 15:12:15"
}

如何获取JSON以始终在本地时区显示日期?

How do yo get the JSON to display the date always in the local timezone?

推荐答案

Date是过时的类，自Java 8发布java.time软件包以来不应该使用，否则我们可以使用

Date is outdated class and should not be used since Java 8 released java.time package or we can use Joda-Time. You are converting date from Timestamp to java.sql.Date and later to java.util.Date. This is very unsafe, see below example:

import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.databind.SerializationFeature;

import java.time.LocalDate;
import java.time.ZoneId;
import java.util.Calendar;
import java.util.Date;
import java.util.TimeZone;

public class JsonApp {

    public static void main(String[] args) throws Exception {
        ObjectMapper mapper = new ObjectMapper();
        mapper.enable(SerializationFeature.INDENT_OUTPUT);

        // Java time precise dates
        LocalDate localDateOpened = LocalDate.of(2019, 03, 07);
        LocalDate localDateClosed = localDateOpened.plusDays(20);

        ZoneId utc = ZoneId.of("UTC");
        Date opened = Date.from(localDateOpened.atStartOfDay(utc).toInstant());
        Date closed = Date.from(localDateClosed.atStartOfDay(utc).toInstant());

        System.out.println("Dates generated from java.time.*");
        System.out.println(mapper.writeValueAsString(new ThisDay(opened, closed)));

        // Calculate dates with default timezone
        Calendar calendar = Calendar.getInstance();
        opened = calendar.getTime();
        calendar.add(Calendar.DAY_OF_MONTH, 20);
        closed = calendar.getTime();

        System.out.println("Dates generated from Calendar");
        System.out.println(mapper.writeValueAsString(new ThisDay(opened, closed)));

        // Calculate dates with UTC timezone
        calendar = Calendar.getInstance();
        calendar.setTimeZone(TimeZone.getTimeZone(utc));
        calendar.set(Calendar.MILLISECOND, 0); // Recompute

        opened = calendar.getTime();
        calendar.add(Calendar.DAY_OF_MONTH, 20);
        closed = calendar.getTime();

        System.out.println("Dates generated from UTC Calendar");
        System.out.println(mapper.writeValueAsString(new ThisDay(opened, closed)));
    }
}

class ThisDay {

    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date opened;

    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date closed;

    public ThisDay(Date opened, Date closed) {
        this.opened = opened;
        this.closed = closed;
    }

    public Date getOpened() {
        return opened;
    }

    public void setOpened(Date opened) {
        this.opened = opened;
    }

    public Date getClosed() {
        return closed;
    }

    public void setClosed(Date closed) {
        this.closed = closed;
    }
}

上面的代码显示:

Dates generated from java.time.*
{
  "opened" : "2019-03-07 00:00:00",
  "closed" : "2019-03-27 00:00:00"
}
Dates generated from Calendar
{
  "opened" : "2019-03-27 23:45:12",
  "closed" : "2019-04-16 22:45:12"
}
Dates generated from UTC Calendar
{
  "opened" : "2019-03-28 00:45:12",
  "closed" : "2019-04-17 00:45:12"
}

请注意，第二个和第三个opened日期相差一小时.我手动将日历时区设置为UTC，并强制重新计算将毫秒设置为0的值:

Notice that second and third opened dates has difference one hour. I manually set calendar timezone to UTC and force to recompute values setting milliseconds to 0:

calendar.setTimeZone(TimeZone.getTimeZone(utc));
calendar.set(Calendar.MILLISECOND, 0); // Recompute

这就是为什么Date过时并应使用java.time软件包的原因.如果您不想显示时间，则只显示日期-将格式更改为@JsonFormat(pattern = "yyyy-MM-dd").

This is why Date is outdated and java.time package should be used. If you do not want to show time, only date - change format to @JsonFormat(pattern = "yyyy-MM-dd").

另请参阅:

• Spring Boot Jackson日期和时间戳格式

这篇关于Spring的Json响应中的时区问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！