连接池

 import java.sql.Connection;

import org.apache.commons.dbcp.BasicDataSource;

public class DBCPUtil {
 static String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
 static String url = "jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs";
 static String user = "sa";
 static String password = null;
 
 private static BasicDataSource bds = null;

 static {
  bds = new BasicDataSource();

  bds.setDriverClassName(driver);
  bds.setUrl(url);
  bds.setUsername(user);
  bds.setPassword(password);
  bds.setInitialSize(10);
  bds.setMaxActive(20);
 }

 public static Connection getConnection() throws Exception {
  Connection conn = bds.getConnection();
  return conn;
 }
 
 public static void main(String[] args) throws Exception{
  Connection conn = DBCPUtil.getConnection();
 }
}