mysql时间处理问题

oracle中用的datetime 在mysql中还是用timestamp感觉好用些，坑，前台页面显示时间竟然与数据库时间相差8小时，通过数据连接中设置url参数serverTimezone=GMT%2B8，同时在Gson类中进行相关处理：

（1）创建类

public class GsonUTCDateAdapter implements JsonSerializer<Date>, JsonDeserializer<Date> {
    private final DateFormat dateFormat;

    public GsonUTCDateAdapter() {
        dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");      //This is the format I need
        dateFormat.setTimeZone(TimeZone.getTimeZone("GMT+8"));                               //This is the key line which converts the date to UTC which cannot be accessed with the default serializer
    }

    @Override public synchronized JsonElement serialize(Date date, Type type, JsonSerializationContext jsonSerializationContext) {
        return new JsonPrimitive(dateFormat.format(date));
    }

    @Override public synchronized Date deserialize(JsonElement jsonElement, Type type, JsonDeserializationContext jsonDeserializationContext) {
        try {
            return dateFormat.parse(jsonElement.getAsString());
        } catch (ParseException e) {
            throw new JsonParseException(e);
        }
    }
}

（2）同时注册：

Gson gson = new GsonBuilder().registerTypeAdapter(Date.class, new GsonUTCDateAdapter()).create();

最终解决前台时间差问题。参考文章：Mysql 时区差8小时的多种问题 统统解决