springboot使用jdbc优雅的配置数据源

1.加依赖

<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<!--druid-->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.2.11</version>
		</dependency>
		<!--mysql-->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	</dependencies>

2.配置连接信息

在springboot的配置文件application.properties加入:

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=root

3.配置数据源

@Configuration   //当前类作为配置类使用
public class DruidConfig {

    @Bean
    /**
     * 将springboot的配置文件中且前缀为jdbc的数据注入的方法中，
     * 前提方法中的setXXX。XXX要和配置文件除jdbc前缀名要相同.
     */
    @ConfigurationProperties(prefix = "jdbc")
    public DruidDataSource getDateSource(){
        DruidDataSource druid=new DruidDataSource();
       /* druid.setDriverClassName();
        druid.setUrl();
        druid.setUsername();
        druid.setPassword();*/
        return druid;
    }
}