文章标题

package net.zuxia.shop.common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class DBUtil {
static List Conn_list = new ArrayList();

// 到与数据库的连接
private static Connection getConn() {
    Connection conn = null;
    // 加载驱动
    try {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        // 得到连接
        conn = DriverManager.getConnection(
                "jdbc:sqlserver://localhost:1433;DatabaseName=e_shop",
                "sa", "Lql123520");
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return conn;
}

// 用静态块来初化连接池
static {
    for (int i = 0; i < 10; i++) {
        Connection conn = getConn();
        Conn_list.add(conn);
    }

// System.out.println(“连接池初始化完毕!”);
}

public static Connection getConnection(){
    Connection conn=null;
      if(Conn_list.size()>0){
          conn=Conn_list.get(0);
          //防止两次取同一条连接
          Conn_list.remove(conn);
      }else{
          conn=getConn();
      }
    return conn;
}

//对连接进行处理
public static void dealConnction(Connection conn, ResultSet rs,
PreparedStatement ps) {
try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
if (conn != null) {
if (Conn_list.size() < 10) {
Conn_list.add(conn);
} else {
conn.close();
}
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}