JDBC工具类的提取
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";
try{
loadDriver();
}catch(ClassNotFoundException e){
e.printStackTrace();
}
} 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; } } }
try {
loadDriver();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}