SpringBoot配置DataSource的两种方式

1 导入依赖

	   <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.20</version>
        </dependency>
        <!-- mysql 数据库驱动. -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>

2 两种方式

2.1 手动配置

在application.yml中配置：

jdbc:
    username: root
    password: 123456
    url: jdbc:mysql:///crm
    driver-class-name: com.mysql.jdbc.Driver

在主配置类ApplicationConfig中配置DataSource：

/**
 * 手动配置DataSource
 * @return
 */
@Bean
@ConfigurationProperties(prefix = "jdbc")
public DataSource dataSource(){
    DruidDataSource dataSource = new DruidDataSource();
    return dataSource ;
}

2.2 自动配置

在application.yml中配置：

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql:///ssm
    driver-class-name: com.mysql.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource