数据库连接池获取连接

C3P0

package dao;

import java.sql.Connection;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class C3P0DBUtil {
	private static ComboPooledDataSource cdatasource = new ComboPooledDataSource();

	public static Connection getConnection() {
		Connection conn = null;
		try {
			cdatasource.setDriverClass("net.sourceforge.jtds.jdbc.Driver");
			cdatasource.setJdbcUrl("jdbc:jtds:sqlserver://localhost:1433/lab");
			cdatasource.setUser("sa");
			cdatasource.setPassword("");
			cdatasource.setMaxPoolSize(4);
			cdatasource.setMaxIdleTime(500);
			cdatasource.setMinPoolSize(2);
			conn = cdatasource.getConnection();
		} catch (Exception e) {
			System.out.println("取得数据库连接错误！");
		}
		return conn;
	}
	
	public static void closeConnection(Connection conn)
	{
		try
		{
			conn.close();
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
	}
   }

DBCP

package dao;

import java.sql.Connection;
import java.sql.SQLException;

import org.apache.commons.dbcp.BasicDataSource;

public class DBCPDBUtil {
    private static BasicDataSource  datasource=new BasicDataSource();
    //取得数据库对象
    public static Connection getConnection() {
	Connection conn = null;
	try {
		datasource.setDriverClassName("net.sourceforge.jtds.jdbc.Driver");
		datasource.setUrl("jdbc:jtds:sqlserver://localhost:1433/lab");
		datasource.setUsername("sa");
		datasource.setPassword("");
		datasource.setMaxActive(10);
		datasource.setMaxIdle(5);
		datasource.setMaxWait(500);	
		conn = datasource.getConnection();
	} catch (SQLException e) {
		System.out.println("取得数据库连接错误！");
	}
	return conn;
}

	
	public static void closeConnection(Connection conn)
	{
		try
		{
			conn.close();
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
	}
   }