JSP后台管理系统新闻的增删改查

package com.ldci.t35.group01.admin.db.conn; import java.io.*; import java.sql.*; import java.util.*; import com.ldci.t35.group01.admin.common.Tools; //import com.ldci.t25.group00.admin.common.Tools; /*连接池管理类,可以管理多个数据库连接池*/ public class DBConnManager { // 连接池名列表 private Vector poolnames = new Vector(); // 驱动程序名列表 private Vector drivernames = new Vector(); // 数据库标识列表 private Vector dbids = new Vector(); // 用户名列表 private Vector usernames = new Vector(); // 密码列表 private Vector passwds = new Vector(); // 最大连接数列表 private Vector maxconns = new Vector(); // 连接池队列 private static Hashtable connPools = new Hashtable(); static DBConnManager instance; public DBConnManager() { try { // 这样写是可以的,运行时有可能报null错误,要用/ // /代表是WEB-INF\classes; InputStream is = getClass().getResourceAsStream( "/com/ldci/t35/group01/admin/db/db.properties"); Properties pro = new Properties(); pro.load(is); // 添加数据库的连接信息 poolnames.addElement("mssql"); drivernames.addElement(pro.getProperty("drivers")); dbids.addElement(pro.getProperty("dbids")); usernames.addElement(pro.getProperty("user")); passwds.addElement(pro.getProperty("password")); maxconns.addElement(pro.getProperty("maxconns")); } catch (Exception e) { Tools.writeLog(e); } // 创建连接池 createPools(); } /* 将连接返回给由指定的连接池 */ public void releaseConnection(String name, Connection con) { DBConnPool pool = (DBConnPool) connPools.get(name); if (pool != null) pool.releaseConnection(con); } /* 得到一个指定连接池中的连接 */ public Connection getConnection(String name) { DBConnPool pool = (DBConnPool) connPools.get(name); if (pool != null) return pool.getConnection(); return null; } /* 关闭所有连接 */ public synchronized void closeConns() { Enumeration allPools = connPools.elements(); while (allPools.hasMoreElements()) { DBConnPool pool = (DBConnPool) allPools.nextElement(); pool.closeConn(); } } /* 创建连接池 */ private void createPools() { for (int i = 0; i < poolnames.size(); i++) { String poolname = poolnames.elementAt(i).toString(); String drivername = drivernames.elementAt(i).toString(); String dbid = dbids.elementAt(i).toString(); String username = usernames.elementAt(i).toString(); String passwd = passwds.elementAt(i).toString(); System.out.println(username); int maxconn = 0; try { maxconn = Integer.parseInt(maxconns.elementAt(i).toString()); } catch (NumberFormatException e) { Tools.writeLog(e); } DBConnPool pool = new DBConnPool(poolname, drivername, dbid, username, passwd, maxconn); connPools.put(poolname, pool); } } public static int getLinkNum(String name) { DBConnPool pool = (DBConnPool) connPools.get(name); return pool.getInUse(); } static synchronized public DBConnManager getInstance() { if (instance == null) { System.out.println("shi ");// 判断本类的静态实例对象是否有值 instance = new DBConnManager(); // 没有：生成一个本类的实例 } return instance; // 返回本类的实例对象 } }