database.java~2~

图书管理系统,B/S,C/S都有,附有源代码

package database;
import java.sql.*;
import database.*;
/**
 * <p>Title: library</p>
 * <p>Description: library</p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: </p>
 * @author nino
 * @version 0.1
 */

public class DataBase {
  protected Connection conn = null;		//Connection接口
  protected Statement stmt = null;		//Statement接口
  protected ResultSet rs = null;		//记录结果集
  protected PreparedStatement prepstmt = null;	//PreparedStatement接口
  protected String sqlStr;		//sql String
  protected boolean isConnect=true;	//与数据库连接标识

  public DataBase() {
          try
          {
                  sqlStr = "";
                  DBConnectionManager dcm = new DBConnectionManager();
                  conn = dcm.getConnection();
                  stmt = conn.createStatement();
          }
          catch (Exception e)
          {
                  System.out.println(e);
                  isConnect=false;
          }

  }

  public Statement getStatement() {
          return stmt;
  }

  public Connection getConnection() {
          return conn;
  }

  public PreparedStatement getPreparedStatement() {
          return prepstmt;
  }

  public ResultSet getResultSet() {
          return rs;
  }


  public String getSql() {
          return sqlStr;
  }

  public String toSql(String newString) {
  try {
    String sqlString = new String(newString.getBytes("ISO-8859-1"), "GBK");
    return sqlString;
  }
  catch (Exception e) {}
  return "null";
}


  public boolean execute() throws Exception  {
          return false;
  }

  public boolean insert() throws Exception {
          return false;
  }

  public boolean update() throws Exception  {
          return false;
  }

  public boolean delete() throws Exception  {
          return false;
  }
  public boolean query() throws Exception {
          return false;
  }

  public void close() throws SQLException {
          if ( stmt != null )
          {
                  stmt.close();
                  stmt = null;
          }
          conn.close();
          conn = null;
  }

}