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