问个很弱智的问题在JSP中用到连接池是不是把DBConnect.class,DBConnectionManager.class，COPY就可以了

Question

编译好的 DBConnectionManager 不止一个 calss 文件

Answer 1

呵呵！放到类路径里，然后在JSP里DBConnectionManager connMgr = DBConnectionManager.getInstance();
Connection con = connMgr.getConnection("idb");
        if (con == null) {
            out.println("Can't get connection");
            return;
        }
        ResultSet rs = null;
        ResultSetMetaData md = null;
        Statement stmt = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery("SELECT * FROM EMPLOYEE");
            md = rs.getMetaData();
            out.println("<H1>Employee data</H1>");
            while (rs.next()) {
                out.println("<BR>");
                for (int i = 1; i < md.getColumnCount(); i++) {
                    out.print(rs.getString(i) + ", ");
                }
            }
            stmt.close();
            rs.close();
        }
        catch (SQLException e) {
            e.printStackTrace(out);
        }
        connMgr.freeConnection("idb", con);