【jsp】数据库多线程连接.docxVIP

public class MyDataSource { private static String url = jdbc:mysql://localhost:3306/test; private static String user = root; private static String password = 1111; private static int initcount = 10;// 初始化连接的个数 private static int maxcount = 20;;// 最大的连接数 private static int currentcount = 0;// 当前连接 LinkedListConnection connectionsPool = new LinkedListConnection(); // 创建10个连接,依次放入linkedlist的链尾 public MyDataSource() { try { for (int i = 0; i initcount; i++) { this.connectionsPool.addLast(this.createConnection()); this.currentcount++; // 记录当前连接数 } } catch (SQLException e) { throw new ExceptionInInitializerError(e); } } // 创建连接 private Connection createConnection() throws SQLException { return DriverManager.getConnection(url, user, password); } // 取得连接,移除并返回linkedList的第一个连接 public Connection getConnection() throws SQLException { synchronized (connectionsPool) { // 同步锁，保证多个线程拿到的不是同一个连接。 if (this.connectionsPool.size() 0) { return this.connectionsPool.removeFirst(); } if (this.currentcount maxcount) { // 判断当前创建的连接个数是否大于最大连接数. this.currentcount++; //记录连接数 return this.createConnection(); } throw new SQLException(已经没有连接); } } // 释放连接,把连接重新放入linkedlist的链尾. public void free(Connection conn) { this.connectionsPool.addLast(conn); } } jdbc工具类: public final class JdbcUtils { private static MyDataSource mydataSource; private JdbcUtils() { } static { try { Class.forName(com.mysql.jdbc.Driver); mydataSource=new MyDataSource();} catch (ClassNotFoundException e) { throw new ExceptionInInitializerError(e); } } public static Connection getConnection() throws SQLException { return mydataSource.getConnection(); //通过连接池取得连接 } public static void free(ResultSet rs, Statement st, Connection conn) { try { if (rs != null) rs.close(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (st != null) st.close(); } catch (SQLException e) { e.printStackTrace(); } finally { if (conn != null) try { mydataSource.free(conn); //释放连接，把连接放回连接池里面. } catch (E