一篇文章搞定数据库连接池

<bean id= "dataSource" class= "org.apache测试数据mons.dbcp.BasicDataSource" destroy-method= "close" >

<property name = "driverClassName" value= "${db.driverClassName}" />

<property name = "url" value= "${db.url}" />

<property name = "username" value= "${db.username}" />

<property name = "password" value= "${db.password}" />

<property name = "initialSize" value= "5" />

<property name = "maxIdle" value= "10" />

<property name = "minIdle" value= "5" />

<property name = "maxActive" value= "15" />

<property name = "removeAbandoned" value= "true" />

<property name = "removeAbandonedTimeout" value= "180" />

<property name = "maxWait" value= "3000" />

<property name = "validationQuery" >

<value> SELECT 1</value>

</property>

<property name = "testOnBorrow" >

<value> true </value>

</property>

< dependency >

    < groupId >com.alibaba</ groupId >

    < artifactId >druid</ artifactId >

    < version >1.2.6</ version >

  </ dependency >

< bean id = "dataSource" class = "com.alibaba.druid.pool.DruidDataSource" init-method = "init" destroy-method = "close" >

     <!-- 基本属性 url、user、password -->

     < property name = "driverClassName" value = "${jdbc.driver}" />

     < property name = "url" value = "${jdbc_url}" />

     < property name = "username" value = "${jdbc_user}" />

     < property name = "password" value = "${jdbc_password}" />

     <!-- 配置监控统计拦截的filters -->

     < property name = "filters" value = "stat" />

     <!-- 配置初始化大小、最小、最大 -->

     < property name = "maxActive" value = "20" />

     < property name = "initialSize" value = "1" />

     < property name = "minIdle" value = "1" />

     <!-- 配置获取连接等待超时的时间 -->

     < property name = "maxWait" value = "60000" />   

     <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->

     < property name = "timeBetweenEvictionRunsMillis" value = "60000" />

     <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->

     < property name = "minEvictableIdleTimeMillis" value = "300000" />

     < property name = "testWhileIdle" value = "true" />

     < property name = "testOnBorrow" value = "false" />

     < property name = "testOnReturn" value = "false" />

     <!-- 打开PSCache，并且指定每个连接上PSCache的大小 -->

     < property name = "poolPreparedStatements" value = "true" />

     < property name = "maxOpenPreparedStatements" value = "20" />

</ bean >

<!--配置jdbcTemplate，如果userDao没有extends JdbcDaoSupport-->

<< bean id = "jdbcTemplate" class = "com.springframework.jdbc.core.JdbcTemplate" >

        < property name = "dataSource" ref = "dataSource" />

    </ bean >

     < bean id = "userDao" class = "com.caraway.dao.UserDao" >

        < property name = "dataSource" ref = "jdbcTemplate" />

    </ bean >

public static void main(String[] args) {

        ApplicationContext context = new ClassPathXmlApplicationContext( "applicationContext.xml" );

        UserDao userDao = (UserDao) context.getBean( "userDao" );

        User user = new User();

        user.setUsername( "香菜" );

        user.setPassowrd( "root" );

        userDao.saveUser(user);

   }