c3p0连接池

来源:互联网 发布:js非法登录自动跳转 编辑:程序博客网 时间:2024/06/16 05:59

 C3P0是一个开源的JDBC连接池,它实现了数据源和JNDI绑定,支持JDBC3规范和JDBC2的标准扩展。

配置文件:

 <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">        <property name="driverClass" value="com.mysql.jdbc.Driver"></property>        <property name="jdbcUrl" value="jdbc:mysql:///hib_demo"></property>        <property name="user" value="root"></property>        <property name="password" value="root"></property>        <property name="initialPoolSize" value="3"></property>        <property name="maxPoolSize" value="10"></property>        <property name="maxStatements" value="100"></property>        <property name="acquireIncrement" value="2"></property>    </bean>
获得connction连接

package com.wang.utils;import java.beans.PropertyVetoException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import com.mchange.v2.c3p0.ComboPooledDataSource;public class JDBCutils {    private static Connection conn;    private static ComboPooledDataSource ds = new ComboPooledDataSource();    public static Connection getConnection() {        try {            conn = ds.getConnection();        } catch (SQLException e) {            e.printStackTrace();        } catch (PropertyVetoException e) {            e.printStackTrace();        }        return conn;    }

0 0