package JDBCUtils; import java.sql.*; public class JDBCUtils{ private static final String driverClass; private static final String url; private static final String username; private static final String password; static{ driverClass="com.mysql.jdbc.Driver"; url="jdbc:mysql:///jdbc?serverTimezone=UTC"; username="root"; password="root"; } public void loadDriver() throws ClassNotFoundException { Class.forName(driverClass); } public static Connection getConnection() throws SQLException { Connection conn = DriverManager.getConnection(url, username, password); return conn; } public static void release(Connection conn, Statement stat) { if (stat != null) { try { stat.close(); } catch (SQLException e) { e.printStackTrace(); } stat = null; } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } conn = null; } } public static void release(ResultSet rs,Connection conn, Statement stat) { if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } rs = null; } if (stat != null) { try { stat.close(); } catch (SQLException e) { e.printStackTrace(); } stat = null; } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } conn = null; } } }
原文:https://www.cnblogs.com/shouyaya/p/12319133.html