package servlet;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DB {
  public static Connection getConnection() {
   Connection conn = null;
   try {
    Class.forName("com.mysql.jdbc.Driver");
    conn =
     DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=yqs2602555");
   } catch (ClassNotFoundException e) {
    e.printStackTrace();
   } catch (SQLException e) {
    e.printStackTrace();
   }
   
   return conn;
  }
  
  public static Statement getStatement(Connection conn) {
   Statement stmt = null;
   try {
    if(conn != null) {
     stmt = conn.createStatement();
    }
   } catch (SQLException e) {
    e.printStackTrace();
   }
   
   return stmt;
  }
  
  public static ResultSet getResultSet(Statement stmt, String sql) {
   ResultSet rs = null;
   try {
    if(stmt != null) {
     rs = stmt.executeQuery(sql);
    }
   } catch (SQLException e) {
    e.printStackTrace();
   }
   
   return rs;
  }
  
  public static void close(Statement stmt) {
   if(stmt != null) {
    try {
     stmt.close();
     stmt = null;
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
  }
  
  public static void close(Connection conn) {
   if(conn != null) {
    try {
     conn.close();
     conn = null;
    } catch (SQLException e) {
     e.printStackTrace();
    } 
   }
  }
  
  public static void close(ResultSet rs) {
   if(rs != null) {
    try {
     rs.close();
     rs = null;
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
  }
}
定义好上面的bean文件后，下面在ShowRsUseBean中引用它：
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ShowRsUseBean extends HttpServlet {
 @Override
 protected void doGet(HttpServletRequest req, HttpServletResponse resp)
   throws ServletException, IOException {
  resp.setContentType("text/html;charset=gb2312");
  PrintWriter out = resp.getWriter();
  
  out.println("<table border=1>");
  out.println("<tr><td>Content:</td></tr>");
  
  Connection conn = DB.getConnection();
  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.close(rs);
   DB.close(stmt);
   DB.close(conn);
  }
 }
}
在tomcat里部署好上面两个servlet文件后，就可以看到访问结果了。