Druid连接池

た入场券 2022-07-13 07:09 250阅读 0赞

## Druid连接池 ##

> 百度: 开源连接池
> 
> C3P0
> 
> DBCP
> 
> PROXOOL
> 
> 推荐: Druid–>由alibaba开源

**property-placeholder** :  
＋导入属性文件  
＋如果有多个属性文件,可以使用**逗号进行分隔**  
**JdbcTemplate的类的使用**

# 驱动类
    jdbc.mysql.driver=com.mysql.jdbc.Driver
    # useUnicode=true
    # characterEncoding=UTF-8
    # allowMultiQueries=true
    jdbc.mysql.url=jdbc:mysql://127.0.0.1:3306/rbac?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true
    jdbc.mysql.username=root
    jdbc.mysql.password=shxt
    #-----------------------------MySQL----------------------------------------#
    
    jdbc.initialSize = 3
    jdbc.minIdle = 5
    jdbc.maxActive = 20
    jdbc.maxWait = 60000
    jdbc.timeBetweenEvictionRunsMillis = 60000
    jdbc.minEvictableIdleTimeMillis = 300000
    jdbc.validationQuery = SELECT 'x'
    jdbc.testWhileIdle=true
    jdbc.testOnBorrow=false
    jdbc.testOnReturn=false

<context:property-placeholder location="classpath:props/jdbc.properties"/>
        
        <bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
            <property name="driverClassName" value="${jdbc.mysql.driver}"/>
            <property name="url" value="${jdbc.mysql.url}"/>
            <property name="username" value="${jdbc.mysql.username}"/>
            <property name="password" value="${jdbc.mysql.password}"/>
    
            
            <property name="initialSize" value="${jdbc.initialSize}"/>
            <property name="minIdle" value="${jdbc.minIdle}"/>
            <property name="maxActive" value="${jdbc.maxActive}"/>
            <property name="maxWait" value="${jdbc.maxWait}"/>
            <property name="timeBetweenEvictionRunsMillis" value="${jdbc.timeBetweenEvictionRunsMillis}"/>
            <property name="minEvictableIdleTimeMillis" value="${jdbc.minEvictableIdleTimeMillis}"/>
            <property name="validationQuery" value="${jdbc.validationQuery}"/>
            <property name="testWhileIdle" value="${jdbc.testWhileIdle}"/>
            <property name="testOnBorrow" value="${jdbc.testOnBorrow}"/>
            <property name="testOnReturn" value="${jdbc.testOnReturn}"/>
        </bean>
        <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
            <property name="dataSource" ref="druidDataSource"/>
        </bean>