配置文件 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中