spirngboot application.yml配置方式:
spring:
datasource: #设置数据库
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: org.gjt.mm.mysql.Driver
url: jdbc:mysql://localhost:3306/asc
username: csd #数据库账户名
password: dsd #密码
dbcp2: #启用dbcp2配置
min-idle: 5 #最小空闲连接:连接池中容许保持空闲状态的最小连接数量,
initial-size: 5 #初始化连接数量
max-total: 5
max-wait-millis: 200
application.properties
# 数据源配置
spring.datasource.url=jdbc:mysql://localhost:3306/adzdb
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=acc
spring.datasource.password=acd
#连接池配置
spring.datasource.type=org.apache.commons.dbcp2.BasicDataSource
spring.datasource.dbcp2.max-wait-millis=10000
spring.datasource.dbcp2.min-idle=5
spring.datasource.dbcp2.initial-size=5
spring.datasource.dbcp2.validation-query=SELECT x
spring.datasource.dbcp2.connection-properties=characterEncoding=utf8
xml配置方式:
<bean id="jdbc" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" >
<property name="locations" value="/WEB-INF/jdbc.properties"/>
</bean>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
&