import java.sql.*; public class database { Connection conn = null; String dbip = "127.0.0.1";//設置數據庫ip //設置數據庫用戶名和密碼： String use = "administrator"; String pass = "123456"; Statement stmt; ResultSet rs; public database(){ } public java.sql.Connection getConn(String dbip1,String use1,String pass1,String DSN){ try{ String dbip = dbip1;//設置數據庫ip String use= use1; //設置數據庫用戶名和密碼： String pass = pass1; String sDSN = "jdbc:odbc:"+DSN; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); conn = DriverManager.getConnection(sDSN,use,pass); stmt = conn.createStatement(); } catch(Exception e){ e.printStackTrace(); } return this.conn; } public java.sql.ResultSet getRS(String sql){ try{ rs = stmt.executeQuery(sql); } catch(Exception e){ e.printStackTrace(); } return rs; } public void exec(String sql){ try{ int n = stmt.executeUpdate(sql); //return n; } catch(Exception e){ e.printStackTrace(); } //return -1; } public boolean CloseRS(){ try{ rs.close(); } catch(Exception e){ e.printStackTrace(); return false; } return true; } public boolean CloseDB(){ try{ stmt.close(); conn.close(); } catch(Exception e){ e.printStackTrace(); } return true; } }