bug
- You must configure either the server or JDBC driver
(via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
2.Error creating bean with name ‘jdbc connector’ defined in class path resource
原因:配置文件application.xml没有规定世界标准时间 utc
()
url: jdbc:mysql://localhost:3306/mldn?serverTimezone=UTC
代码
快速创建选这些
项目结构
application.yml
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/mldn?serverTimezone=UTC
driver-class-name: com.mysql.jdbc.Driver
lianjie(controller)
package com.jdbctry.demo.controller;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import java.util.List;
import java.util.Map;
@Controller
public class lianjie {
@Autowired
JdbcTemplate jdbcTemplate;
@ResponseBody
@GetMapping("/jdbc")
public Map<String, Object> map() {
List<Map<String, Object>> list = jdbcTemplate.queryForList("select * from mldn");
return list.get(6);
}
}
浏览器访问
注意访问地址是localhost:8080/jdbc