testservlet.java

JSPdatabaseprogramming05

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class TestServlet extends HttpServlet
{
	private DBConnectionManager connManager;
	public void init(ServletConfig conf)throws ServletException
	{
		super.init(conf);
		connManager=new DBConnectionManager();
	}
	
	public void service(HttpServletRequest req,HttpServletResponse res)throws IOException
	{
		res.setContentType("text/html");
		printWriter out=res.getWriter();
		Connection con=connManager.getConnection("access");
		if(con==null)
		{
			out.println("Cann't get connection");
			return;
		}
		Statement stmt=con.createStatement();
		ResultSet rs=stmt.executeQuery("select * from Users");
        while(rs.next())
        {
		    out.println("<table border=1 align='center'>");
		    out.println("<tr>");
		    out.println("<td>用户名</td>");
		    out.println("<td>姓名</td>");
		    out.println("<td>电子邮件</td>");
		    out.println("<td>住址</td>");
		    out.println("</tr>");
		    out.println("<td>"+rs.getString("UserID")+"</td>");
		    out.println("<td>"+rs.getString("Name")+"</td>");
		    out.println("<td>"+rs.getString("Email")+"</td>");
		    out.println("<td>"+rs.getString("Address")+"</td>");
		    out.println("</tr>");
		    out.println("</table>");
         
         }
         rs.close();
         stmt.close();
         connManager.releaseConnection("access",con);
      }
      
      public void destory()
      {
      	 connManager.closeConns();;
      	 super.destory();
      }
    
}