springboot自学之路-09（springboot连接datasource）

一、添加依赖

 <!--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