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;
}
}
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;
}
}