connectsql.java

来自「自己做的超市管理系统」· Java 代码 · 共 74 行

package shopingmanager;

import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;

public class ConnectSQL {
    String strDriver = null;
    String strCon = null;
    String uid = null;
    String pwd = null;
    Statement stmt = null;
    Connection con = null;
    ResultSet rs = null;
    public ConnectSQL(String dbname) {
        strDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        strCon = "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=" +
                 dbname;
        uid = "sa";
        pwd = "";
        try {
            Class.forName(strDriver);
            con = DriverManager.getConnection(strCon, uid, pwd);
            stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                       ResultSet.CONCUR_READ_ONLY);
        } catch (SQLException ex) {
        } catch (ClassNotFoundException ex) {
        }
    }

    public ResultSet GetRs(String sql) {
        try {
            rs = stmt.executeQuery(sql);
        } catch (Exception ex) {
            //rs = null;
        }
        return rs;
    }

    public void ResultSql(String sql) {
        try {
            stmt.executeUpdate(sql);
            //stmt.close();
           // con.close();
        } catch (Exception ex) {
           // System.out.println(ex.getMessage());
        }
    }

    public void closed() {
        try {
            if (rs == null) {
                rs.close();
            }
        } catch (Exception er) {
           // System.out.println(er);
        }
        try {
            if (stmt == null) {
                stmt.close();
            }
        } catch (Exception er) {
           // System.out.println(er);
        }
        try {
            if (con == null) {
                con.close();
            }
        } catch (Exception er) {
           // System.out.println(er);
        }
    }

}