spring中配置c3p0数据源

1：applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:util="http://www.springframework.org/schema/util"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:jdbc="http://www.springframework.org/schema/jdbc"
xsi:schemaLocation="http://www.springframework.org/schema/jdbc
                  http://www.springframework.org/schema/jdbc/spring-jdbc-4.0.xsd
              http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
              http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
                        
      <!-- 导入资源文件 -->
  <context:property-placeholder location="classpath:db.properties"/>
  <!-- 配置C3p0数据源 -->
  <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
    <property name="user"><value>root</value></property>
    <property name="password"><value>123456</value></property>
    <property name="jdbcUrl"><value>jdbc:mysql://localHost/mydatabase</value></property>
    <property name="driverClass"><value>com.mysql.jdbc.Driver</value></property>
    <property name="initialPoolSize"><value>5</value></property>
    <property name="minPoolSize"><value>5</value></property>
    <property name="maxPoolSize"><value>10</value></property>
  </bean>
 </beans>

  2:db.properties

username=root
password=123456
jdbcUrl=jdbc:mysql://localHost/mydatabase
driverClass=com.mysql.jdbc.Driver
minPoolSize=5
initialPoolSize=5
maxPoolSize=15

 

 3:JUnit

package com.spring.jdbc;


import static org.junit.Assert.*;


import java.sql.SQLException;


import javax.sql.DataSource;


import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;


public class JDBCTest {
  private ApplicationContext ctx=null;
  {
 ctx=new ClassPathXmlApplicationContext("applicationContext.xml");
  }
@Test
public void test() throws SQLException {
DataSource dataSource=ctx.getBean(DataSource.class);
System.out.println(dataSource.getConnection());
}
}