一、添加依赖
<!--jdbc数据库连接 begin-->
<!--① 添加druid依赖-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.22</version>
</dependency>
<!--② 添加mysql连接驱动依赖-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--③ 添加jdbc依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!--jdbc数据库连接 end-->
注意druid-spring-boot-starter的版本要与springboot的版本匹配,如果版本太低的话会报错。
二、新建Controller
package com.example._03datasource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import javax.sql.DataSource;
import java.sql.SQLException;
/**
* @Package: com.example._03datasource
* @ClassName: DataSourceController
* @Description: <p>Description: </p>
* @author: zq
* @since: 2020/5/2 16:34
* @version: 1.0
* @Copyright: 2020 zq. All rights reserved.
*/
@Controller
public class DataSourceController {
@Autowired
public DataSource dataSource;
@RequestMapping("/dataSourcePage")
@ResponseBody
public String dataSourcePage() throws SQLException {
System.out.println(dataSource.getConnection());
System.out.println(dataSource);
return "dataSourcePage" + dataSource;
}
}
三、在application.properties中配置数据库连接参数
#配置数据库连接参数
spring.datasource.druid.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.druid.username=root
spring.datasource.druid.password=123456
#启动springboot项目,然后访问数据库,报You must configure either the server or JDBC driver (via the serverTimezone conf)的错误,原因
#因为安装mysql的时候时区设置的不正确 mysql默认的是美国的时区,而我们中国大陆要比他们迟8小时,采用+8:00格式
#加上这个 ?serverTimezone=UTC
spring.datasource.druid.url=jdbc:mysql:///test?serverTimezone=UTC
spring.datasource.druid.initial-size=5
四、编写启动类
因为springboot会自动装配datasource,所以不需要写其他配置了,只需要在新建一个启动类即可。
package com.example._03datasource;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
/**
* @Package: com.example._03datasource
* @ClassName: AppConfig
* @Description: <p>Description: </p>
* @author: zq
* @since: 2020/5/2 16:35
* @version: 1.0
* @Copyright: 2020 zq. All rights reserved.
*/
@SpringBootApplication
public class AppConfig {
public static void main(String[] args) {
SpringApplication.run(AppConfig.class, args);
}
}
五、验证:访问http://localhost:8084/dataSourcePage