SpringBoot入门(16)- SpringBoot jdbc
1、装配数据源
首先添加依赖(最新版springboot默认数据源为HikariCP[com.zaxxer.hikari.HikariDataSource])
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.apache.tomcat</groupId>
<artifactId>tomcat-jdbc</artifactId>
</dependency>
其次配置数据源参数
2、自定义配置数据源
首先添加依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.11_preview_9</version>
</dependency>
其实创建DataSource配置类
import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.Bean;
import org.springframework.core.env.Environment;
import com.alibaba.druid.pool.DruidDataSource;
@SpringBootApplication
public class DBConfiguration {
@Autowired
private Environment env;
@Bean
public DataSource createDateSource(){
DruidDataSource ds = new DruidDataSource();
ds.setUrl(env.getProperty("spring.datasource.url"));
ds.setUsername(env.getProperty("spring.datasource.username"));
ds.setDriverClassName(env.getProperty("spring.datasource.driverClassName"));
ds.setPassword(env.getProperty("spring.datasource.password"));
return ds;
}
}
注:spring-boot首先使用自定义的Datasoure,没有再使用指定的,之后使用默认的