指定时区指令示例(指定的时区是上海):useUnicode = true & serverTimezone = Asia/Shanghai
如果是定义的是前世界标准时区GMT或现世界标准时区UTC,而身处中国的我们输入2010-01-01,会变成2009-12-31,时区有八小时的误差。
定义时区示例:
private static final String URL = "jdbc:mysql://localhost:3306/airmessage?"
+ "useUnicode = true & serverTimezone = Asia/Shanghai"
//若指定GMT时区: "useUnicode = true & serverTimezone = GMT"
+ "& characterEncoding = utf8 & useSSL = false";
private static final String NAME = "root";
private static final String PASSWORD = "201704060320";
private static Connection conn = null;
...