connectionservlet.java

关于servlet的很全的例子,对学习servlet很有帮助的,大家

public class ConnectionServlet extends HttpServlet
{
    public void doGet(HttpServletRequest request, HttpServletResponse response)
                    throws ServletException, IOException
    {
        ConnectionPool pool = (ConnectionPool)getServletContext().getAttribute("ConnectionPool");
        Connection con = pool.getConnection();
        Statement st = con.createStatement();
        ResultSet rs = st.exeucteQuery("sql");
        while(rs.next())
        {
        }
        
        rs.close();
        st.close();
        con.close();
    }
    
    public void doPost(HttpServletRequest request, HttpServletResponse response)
                    throws ServletException, IOException
    {
        doGet(request, response);
    }
}