databasemanager.java~3~

来自「航班查询与订票系统 用Java与sqlserver2000来编写一个航班查询与订」· JAVA~3~ 代码 · 共 68 行

package flight.assist;

import java.sql.*;

public class DataBaseManager {
  private static DataBaseManager instance;
  private Connection con;
  private ResultSet rs;
  private Statement stmt;

  public static DataBaseManager getInstance() {
    if (instance == null) {
      instance = new DataBaseManager();
    }
    return instance;
  }

  private DataBaseManager() {
    try {
      String url = "jdbc:odbc:flight";
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con = DriverManager.getConnection(url);
      stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                 ResultSet.CONCUR_UPDATABLE);
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
    }
    catch (ClassNotFoundException cnfex) {
      cnfex.printStackTrace();
    }
  }

  public ResultSet getResult(String strSQL) {
    try {
      rs = stmt.executeQuery(strSQL);
      return rs;
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
      return null;
    }

  }

  public int updateSql(String strSQL) {
    try {
      int i = stmt.executeUpdate(strSQL);
      con.commit();
      return i;
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
      return -1;
    }
  }

  public void closeConnection() {
    try {
      con.close();
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
    }
  }

}