审视TestDb这个类中调用DBUtil取得数据的部分
- Connection conn = DBUtil.getConnection();
- Statement stmt = DBUtil.getStatement(conn);
- String sql = "select * from article";
- ResultSet rs = DBUtil.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 {
- DBUtil.close(rs);
- DBUtil.close(stmt);
- DBUtil.close(conn);
- }
1,2两行有些繁琐,可以重构DBUtil更简洁,更OO。
DBUtil.java:
- package com.mycompany.db;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;