在
Spring中集成
Druid连接池并使用线程池的示例代码如下：
1. 首先，在pom.xml文件中添加以下依赖：
```xml
<dependencies>
<!--
Spring JDBC -->
<dependency>
<groupId>org.
springframework.boot</groupId>
<artifactId>
spring-boot-starter-jdbc</artifactId>
</dependency>
<!--
Druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>
druid-
spring-boot-starter</artifactId>
<version>1.1.23</version>
</dependency>
<!--
Spring Boot Test -->
<dependency>
<groupId>org.
springframework.boot</groupId>
<artifactId>
spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!-- H2 Database (for testing) -->
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
```
2. 在application.properties文件中配置
Druid连接池的相关属性：
```properties
# 数据源配置
spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.
username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#
Druid连接池配置
spring.datasource.type=com.alibaba.
druid.pool.
DruidDataSource
spring.datasource.
druid.initial-size=5
spring.datasource.
druid.min-idle=5
spring.datasource.
druid.max-active=20
spring.datasource.
druid.max-wait=60000
spring.datasource.
druid.time-between-eviction-runs-millis=60000
spring.datasource.
druid.min-evictable-idle-time-millis=300000
spring.datasource.
druid.validation-query=SELECT 1
spring.datasource.
druid.test-while-idle=true
spring.datasource.
druid.test-on-borrow=false
spring.datasource.
druid.test-on-return=false
spring.datasource.
druid.pool-prepared-statements=true
spring.datasource.
druid.max-pool-prepared-statement-per-connection-size=20
spring.datasource.
druid.filters=stat,wall,logback
spring.datasource.
druid.connection-properties=
druid.stat.mergeSql=true;
druid.stat.slowSqlMillis=5000
```
3. 创建一个配置类，用于配置
Druid连接池和
Spring的JdbcTemplate：
```java
import com.alibaba.
druid.pool.
DruidDataSource;
import org.
springframework.beans.factory.annotation.Value;
import org.
springframework.context.annotation.Bean;
import org.
springframework.context.annotation.Configuration;
import org.
springframework.jdbc.core.JdbcTemplate;
import javax.sql.DataSource;
@Configuration
public class DataSourceConfig {
@Value("${
spring.datasource.url}")
private String url;
@Value("${
spring.datasource.
username}")
private String
username;
@Value("${
spring.datasource.password}")
private String password;
@Bean
public DataSource dataSource() {
DruidDataSource dataSource = new
DruidDataSource();
dataSource.setUrl(url);
dataSource.set
Username(
username);
dataSource.setPassword(password);
return dataSource;
}
@Bean
public JdbcTemplate jdbcTemplate(DataSource dataSource) {
return new JdbcTemplate(dataSource);
}
}
```
4. 使用
Druid连接池和JdbcTemplate进行数据库操作：
```java
import org.
springframework.beans.factory.annotation.Autowired;
import org.
springframework.jdbc.core.JdbcTemplate;
import import org.
springframework.stereotype.Service;
@Service
public class UserService {
private final JdbcTemplate jdbcTemplate;
@Autowired
public UserService(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
public void addUser(User user) {
String sql = "INSERT INTO users (id, name) VALUES (?, ?)";
jdbcTemplate.update(sql, user.getId(), user.getName());
}
// 其他数据库操作方法...
}
```
以上代码示例了如何在
Spring中集成
Druid连接池并使用线程池。你可以根据自己的需求进行配置和扩展。
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
