spring框架创建连接池

配置文件 db.properties

# db connection parameters

配置pom.xml导包

   <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-webmvc</artifactId>
  <version>3.2.8.RELEASE</version>
  </dependency>
  <dependency>
  <groupId>jstl</groupId>
  <artifactId>jstl</artifactId>
  <version>1.2</version>
</dependency>
<dependency>
  <groupId>junit</groupId>
  <artifactId>junit</artifactId>
  <version>4.12</version>
</dependency>


<dependency>
  <groupId>com.oracle</groupId>
  <artifactId>ojdbc14</artifactId>
  <version>10.2.0.4.0</version>
</dependency>


<dependency>
  <groupId>commons-dbcp</groupId>
  <artifactId>commons-dbcp</artifactId>
  <version>1.3</version>
</dependency>

在配置文件中spring-mvc.xml中创建连接池

<!-- 用spring创建连接池 -->
<util:properties id="db"
location="classpath:db.properties"/>

<bean id="ds" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="#{db.driver}"/>
<property name="url" value="#{db.url}"/>
<property name="username" value="#{db.user}"/>
<property name="password" value="#{db.pwd}"/>
<property name="initialSize" value="#{db.initsize}"/>
<property name="maxActive" value="#{db.maxsize}"/>
</bean>

编写测试代码

@Test
public void test() throws SQLException{
String config ="spring-mvc.xml";
ApplicationContext ac = 
new ClassPathXmlApplicationContext(config);

BasicDataSource a = ac.getBean("ds",BasicDataSource.class);
Connection conn =a.getConnection();
System.out.println(conn);

}

先配置”org.apache.commons.dbcp.BasicDataSource"加载BasicDataSource类

然后配置spring语句读取db.properties文件中的键值对，启动容器时会，底层是调用BasicDataSource的set方法，从而加载参数，创建连接。

将db注入到BasicDataSource中