databasemanager.java

来自「大二做的实训. 纯Java程序」· Java 代码 · 共 65 行

package bookmanagesystem;
import java.sql.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class DataBaseManager {
  Connection con;
  ResultSet rs;
  Statement stmt;
  public DataBaseManager() {
    try {
      String url = "jdbc:odbc:sos";//数据源名为 sos
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con = DriverManager.getConnection(url,"sa","sa");//用户名、密码均为 sa
      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());
    }
  }
}