public class DBHelper { /** * 获得connection * @return */ public Connection getConnection() { Connection c=null; try { Class.forName("com.mysql.jdbc.Driver"); c=DriverManager.getConnection("jdbc:mysql://localhost:3306/projectSelect","root","sa"); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return c; } /** * 关闭连接 * @param c * @param s * @param r */ public void closeAll(Connection c,Statement s,ResultSet r) { if(r!=null){try { r.close(); } catch (SQLException e) { e.printStackTrace(); }r=null;} if(s!=null){try { s.close(); } catch (SQLException e) { e.printStackTrace(); }s=null;} if(c!=null){try { c.close(); } catch (SQLException e) { e.printStackTrace(); }c=null;} } /** * 增删改 * @param sql * @return */ public int excuteSql(String sql) { Connection c=null; Statement s=null; int num=-1; try { c=this.getConnection(); s=c.createStatement(); num=s.executeUpdate(sql); } catch (Exception e) { e.printStackTrace(); }finally { this.closeAll(c, s, null); } return num; } }</
Java访问数据库通用帮助类
最新推荐文章于 2022-01-05 18:52:08 发布