databasemanager.java

一個模仿ATM自動提款机功能的系統,

package DataBaseManager;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
public class DataBaseManager {
    Connection con;//声明數據庫連接類
    Statement stmt;//声明執行sql語句的容器
    ResultSet rs,rs1;//查询语句返回的结果集
    String Driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    private String URL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ATM";
    private String user="sa";
    private String password="";
    public DataBaseManager() {//创建数据库连接的构造函数
        try {
            Class.forName(Driver);//装载驱动程序
        } catch (Exception sqle) {
            System.out.println("载驱动程序装载错误");
        }}
    public boolean connect(){
        try {con=DriverManager.getConnection(URL,user,password);
             stmt=con.createStatement();
        } catch (Exception ee) {
            System.out.println("数据库连接错误");
            return false;
        }
           return true;
    }
  public ResultSet getResult(String strSQL){//执行sql语句，返回结果集
      try {
             rs=stmt.executeQuery(strSQL);
             return rs;
      } catch (SQLException sqle) {
          System.out.println("getResult():执行sql语句失败");
          return null;
      }
  }
  public void disconnect(){//断开数据库连接
      try {
             if(con!=null){con.close();
                           con=null;

             }
      } catch (Exception ex) {
          System.out.println("关闭数据库失败");
      }
  }

}