【Spring】 常用的连接池配置

常用的连接池配置

常用的连接池配置参考
java数据连接池的几种区别和使用参考

---

• 读取jdbcConfig.properties

    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:jdbc.properties"></property>
    </bean>

---

• jdbcConfig.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm
jdbc.username=root
jdbc.password=root

---

在applicationContext.xml（Spring的配置文件）的配置

一、Spring框架内置的连接池

• spring-jdbc-4.2.0.RELEASE.jar

<bean id="driverManagerDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="${jdbc.driver}"></property>
    <property name="url" value="${jdbc.url}"></property>
    <property name="username" value="${jdbc.username}"></property>
    <property name="password" value="${jdbc.password}"></property>
  </bean>

---

二、使用c3p0连接池

• 使用的是:com.springsource.com.mchange.v2.c3p0-0.9.1.2.jar

    <bean id="c3p0DataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${jdbc.driver}"></property>
        <property name="url" value="${jdbc.url}"></property>
        <property name="username" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>

---

三、Apache的DBCP连接池

• com.springsource.org.apache.commons.dbcp-1.2.2.osgi.jar

• com.springsource.org.apache.commons.pool-1.3.0.jar

    <bean id="dbcpDataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${jdbc.driver}"></property>
        <property name="url" value="${jdbc.url}"></property>
        <property name="username" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>

---

四、阿里巴巴框架 的druid连接池

• druid-0.1.18.jar

   <bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.driver}"></property>
        <property name="url" value="${jdbc.url}"></property>
        <property name="username" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
   </bean>

---