package Ge.ConnectionDB;import java.sql.*;public class Condb { String driver="com.mysql.jdbc.Driver"; String url="jdbc:mysql:3306//172.32.34.253/gecris"; String user="root"; String passwd="root"; Connection conn=null; ResultSet rs=null; Statement st=null; public Condb(){ try { Class.forName(driver); }catch(ClassNotFoundException e){ e.printStackTrace(); } } //in order to update and insert operation public int update(String sql){ int result=0; try{ conn=DriverManager.getConnection(url,user,passwd); st=conn.createStatement(); result=st.executeUpdate(sql); }catch (SQLException e){ e.printStackTrace(); } return result; } //in order to select operation public ResultSet query(String sql){ try{ conn=DriverManager.getConnection(url,user,passwd); st=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=st.executeQuery(sql); }catch (SQLException e){ e.printStackTrace(); } return rs; } //in order to delete operation public int del(String sql){ int DelResult=0; try{ conn=DriverManager.getConnection(url,user,passwd); st=conn.createStatement(); DelResult=st.executeUpdate(sql); }catch (SQLException e){ e.printStackTrace(); } return DelResult; } //in order to close with database public void close(){ try{ if (rs!=null) rs.close(); }catch(Exception e){ e.printStackTrace(); } try{ if (conn!=null) conn.close(); }catch(Exception e){ e.printStackTrace(); } }}
本文转自你是路人甲还是霍元甲博客51CTO博客,原文链接http://blog.51cto.com/world77/291545如需转载请自行联系原作者
world77