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小时的多种问题 统统解决
原文地址:https://blog.csdn.net/yzl495/article/details/136134135
免责声明:本站文章内容转载自网络资源,如本站内容侵犯了原著者的合法权益,可联系本站删除。更多内容请关注自学内容网(zxcms.com)!