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

评论