c3p0数据源

需要读取的配置文件c3p0-cinfig.xml

<c3p0-config>
	<!-- c3p0-config.xml的默认配置,在classpath下-->
	<!-- 如果要使用自己的配置，需要该name属性 -->
	<default-config>
		<property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="jdbcUrl">jdbc:mysql://localhost:3306/test</property>
		<property name="user">root</property>
		<property name="password">mysqladmin</property>
		
		<property name="initialPoolSize">10</property>
		<property name="maxIdleTime">30</property>
		<property name="maxPoolSize">20</property>
		<property name="minPoolSize">5</property>
		<property name="maxStatements">200</property>
	</default-config>
	
	<!-- 自己的配置 -->
	<named-config name="mysql">
		<property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="jdbcUrl">jdbc:mysql://localhost:3306/test</property>
		<property name="user">root</property>
		<property name="password">mysqladmin</property>
		
		<property name="acquireIncrement">50</property>
		<property name="initialPoolSize">100</property>
		<property name="minPoolSize">50</property>
		<property name="maxPoolSize">1000</property><!-- intergalactoApp adopts a different approach to configuring statement caching -->
		<property name="maxStatements">0</property>
		<property name="maxStatementsPerConnection">5</property>
	</named-config>
	
	<named-config name="oracle">
		<property name="acquireIncrement">50</property>
		<property name="initialPoolSize">100</property>
		<property name="minPoolSize">50</property>
		<property name="maxPoolSize">1000</property><!-- intergalactoApp adopts a different approach to configuring statement caching -->
		<property name="maxStatements">0</property>
		<property name="maxStatementsPerConnection">5</property>
	</named-config>
</c3p0-config>

操作数据库的工具类JdbcUtils.java

import com.mchange.v2.c3p0.ComboPooledDataSource;
public class JdbcUtils{
	private static ComboPooledDataSource ds = null;
	static{
		try{
			//c3p0-config.xml配置文件在classpath下
			ds = new ComboPooledDataSource("mysql");	//使用c3p0-config.xml中的mysql的配置,
//			ds = new ComboPooledDataSource();	//使用c3p0-config.xml的默认配置
			
			//如果不使用c3p0-cinfig.xml配置文件，自己写配置
//			ds.setDriverClass("com.mysql.jdbc.Driver");
//			ds.setJdbcUrl("jdbc:mysql://localhost:3306/test");
//			ds.setUser("root");
//			ds.setPassword("mysqladmin");
//			ds.setMaxPoolSize(30); //最大允许30个链接
//			ds.setMinPoolSize(5);	//最小允许5个链接
//			ds.setInitialPoolSize(10);	//初始化链接个数
		}catch (Exception e) {
			throw new ExceptionInInitializerError(e);
		}
		
	}
	
	public static Connection getConnection() throws SQLException{	
		return ds.getConnection();	//从c3p0数据源中获得数据库链接
	}
	
	
	public static void release(Connection conn,Statement st,ResultSet rs){	
		if(rs != null){
			try{
				rs.close();	
			}catch(Exception e){}
		}
		if(st != null){
			try{
				st.close();
			}catch(Exception e){}
		}
		if(conn != null){
			try{
				conn.close();//从c3p0数据源中获得数据库链接的close方法被增强，将数据库链接归还给连接池
			}catch(Exception e){}
		}
	}
}

test.java

public class test {

	public static void main(String[] args) {
		Connection conn = null;
		PreparedStatement st= null;
		ResultSet rs = null;
		
		try{
			conn = JdbcUtils.getConnection();	// 从c3p0数据源中获得链接
			System.out.println(conn.getClass().getName());
		}catch (Exception e) {
			// TODO: handle exception
		}
		JdbcUtils.release(conn, st, rs);//释放链接，将链接归还到连接池
	}
}