springboot中对加了@RestController或者@Controller+@ResponseBody注解的方法的返回值默认是Json格式, 所以,对date类型的数据,在返回浏览器端时,会被springboot默认的Jackson框架转换,而Jackson框架默认的时区GMT(相对于中国是少了8小时)。所以最终返回到前端结果是相差8小时
解决办法:只要在url后面加上&serverTimezone=GMT+8就完美解决了
spring: # 数据源和druid连接池信息配置 datasource: type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.cj.jdbc.Driver druid: url: jdbc:mysql://@project.sql.url@:@project.sql.port@/@project.sql.datasource@?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2b8 username: @project.sql.username@ password: @project.sql.password@ initialSize: 10 minIdle: 5 maxActive: 20 maxWait: 60000 timeBetweenEvictionRunsMillis: 60000 minEvictableIdleTimeMillis: 300000 validationQuery: SELECT 1 FROM DUAL testWhileIdle: true testOnBorrow: false testOnReturn: false filters: stat,wall # 监控页面的用户名和密码 以及页面地址 stat-view-servlet: login-username: admin login-password: admin enabled: true url-pattern: /druid/* reset-enable: false web-stat-filter: url-pattern: /* exclusions: "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*" filter: stat: merge-sql: true slow-sql-millis: 3000 log-slow-sql: true