abc.rar_ABC_abc管理系统_新闻管理发布_新闻管理系统

package ncist.network.exercise; import java.sql.*; public class DBGet { //成员变量 private static final String DRIVER_CLASS = "com.mysql.jdbc.Driver"; private static final String DATABASE_URL = "jdbc:mysql://127.0.0.1:3306/jsp"; private static final String DATABASE_USRE = "root"; private static final String DATABASE_PASSWORD = "root"; public DBGet() { } //返回Connection对象 public static Connection getConnection() { Connection conn = null; try { Class.forName(DRIVER_CLASS); conn = DriverManager.getConnection(DATABASE_URL, DATABASE_USRE, DATABASE_PASSWORD); } catch (ClassNotFoundException ex) { System.out.println(ex.getMessage()); } catch (SQLException ex) { System.out.println(ex.getMessage()); } return conn; } //关闭Connection对象 public static void closeConnection(Connection conn) { try { if (conn != null) { conn.close(); } } catch (SQLException ex) { System.out.println(ex.getMessage()); } } //关闭Statement对象 public static void closeStatement(Statement stmt) { try { if (stmt != null) { stmt.close(); } } catch (SQLException ex) { System.out.println(ex.getMessage()); } } // 关闭PreparedStatement对象 public static void closePreparedStatement(PreparedStatement ps) { try { if (ps != null) { ps.close(); } } catch (SQLException ex) { System.out.println(ex.getMessage()); } } //关闭ResultSet对象 public static void closeResultSet(ResultSet rs) { try { if (rs != null) { rs.close(); } } catch (SQLException ex) { System.out.println(ex.getMessage()); } } }