DBCP数据库连接池使用

maven依赖

<dependency>  
  <groupId>org.apache.commons</groupId>  
  <artifactId>commons-dbcp2</artifactId>  
  <version>2.7.0</version>  
</dependency>

<dependency>  
  <groupId>org.springframework</groupId>  
  <artifactId>spring-jdbc</artifactId>  
  <version>5.2.1.RELEASE</version>  
</dependency>

<dependency>  
  <groupId>mysql</groupId>  
  <artifactId>mysql-connector-java</artifactId>  
  <version>8.0.18</version>  
</dependency>

bean注册

@Bean  
public DataSource dataSource() {  
    BasicDataSource dataSource = new BasicDataSource();  
    dataSource.setDriverClassName(databaseProperties.get("driverClassName"));  
    dataSource.setUrl(databaseProperties.get("url"));  
    dataSource.setUsername(databaseProperties.get("username"));  
    dataSource.setPassword(databaseProperties.get("password"));  
    return dataSource;  
}

PREVIOUSSpring Security使用

NEXTSpring声明式事务