jdbc 工具类 JdbcUtils  简化数据…

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;

public final class JdbcUtils { //  构造方法私有化 private JdbcUtils() { } //  注册驱动 static { try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { throw new ExceptionInInitializerError(); }  } // 创建连接 public static Connection getConnection() throws SQLException { return DriverManager.getConnection(url,user,password); } // 释放资源 public static void release(ResultSet rs ,Statement st,Connection conn) { try{ if (rs!=null) rs.close(); }catch (SQLException e) { e.printStackTrace(); } finally { try { if (st!=null) st.close(); }catch (SQLException e) { e.printStackTrace(); }finally { try{ if(conn!=null)  conn.close(); }catch(SQLException e) { e.printStackTrace(); } } } } private static  String url ="jdbc:mysql://localhost:3306/library"; private static  String user ="root"; private static  String password ="shuangyuzuo";

}