databasemanager.java~2~

图书馆管理系统 运用简单的Java语言与SQLSERVER2000数据库 开发的一个图书管理系统

import java.sql.*;

public class DataBaseManager {
  Connection con;
  ResultSet rs;
  Statement stmt;
  public DataBaseManager() {
    try {
      //DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
      //con=DriverManager.getConnection("jdbc:oracle:thin:@happy:1521:myoracle","maimihui","maimihui");
      //stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
      String url = "jdbc:odbc:LibraryBase";
      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) {
      // process ClassNotFoundExceptions here
      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 boolean updateSql(String strSQL) {
    try {
      stmt.executeUpdate(strSQL);
      con.commit();
      return true;

    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
      return false;
    }

  }

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

}