ShowRsUseBean(42_2)

Title:ShowRsUseBean
discription:1、将数据库的相关东西封装在一个类中，在用到的时候可以调用。    2、在封装时，可以运用重载。
@Copyright:
@Company:
@autor:firefly
@version:1.0
@time:2013.1.1

 

import javax.servlet.*;
import javax.servlet.http.*;

import java.io.*;
import java.sql.*;

public class ShowRsUseBean extends HttpServlet {

 @Override
 protected void doGet(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {

  response.setContentType("text/html");
  response.setCharacterEncoding("gb2312");
  PrintWriter out = response.getWriter();

  out.println("<table border=1>");
  out.println("<tr><td>Content:</td></tr>");

  Connection conn = DB.getConn();
  Statement stmt = DB.getStatement(conn);
  String sql = "select * from article";
  ResultSet rs = DB.getResultSet(stmt, sql);
  try {
   while (rs.next()) {
    out.println("<tr>");
    out.println("<td>" + rs.getString("title") + "</td>");
    out.println("</tr>");
   }
   out.println("</table>");
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {

   DB.closeRs(rs);
   DB.closeStmt(stmt);
   DB.closeConn(conn);
  }

 }

}