database.java

是一个JSP实例原代码

package com.gbsource.homepage.admin;

import java.sql.*;

/**
 * Title:        华源网络主页基地管理
 * Description:
 * Copyright:    Copyright (c) 2001
 * Company:      Gbsource Studio
 * @author fishwu
 * @version 1.0
 */

public class Database {

  private BeansConstants CONST;
  private Connection conn = null;
  private Statement stmt = null;
  private PreparedStatement prepstmt = null;

  public Database() throws Exception
  {
    Class.forName(CONST.dbDriver);
    conn = DriverManager.getConnection(CONST.dbName,CONST.dbUserid,CONST.dbPassword);
    stmt = conn.createStatement();
  }
  public Database(String sql) throws Exception
  {
    Class.forName(CONST.dbDriver);
    conn = DriverManager.getConnection(CONST.dbName,CONST.dbUserid,CONST.dbPassword);
    prepareStatement(sql);
  }
  public Database(String sql,int resultSetType,int resultSetConcurrency) throws Exception
  {
    Class.forName(CONST.dbDriver);
    conn = DriverManager.getConnection(CONST.dbName,CONST.dbUserid,CONST.dbPassword);
    prepareStatement(sql,resultSetType,resultSetConcurrency);
  }
  public void prepareStatement(String sql) throws SQLException
  {
    prepstmt = conn.prepareStatement(sql);
  }
  public void prepareStatement(String sql,int resultSetType,int resultSetConcurrency) throws SQLException
  {
    prepstmt = conn.prepareStatement(sql,resultSetType,resultSetConcurrency);
  }
  public void setString(int index,String value) throws SQLException
  {
    prepstmt.setString(index,value);
  }
  public void setInt(int index,int value) throws SQLException
  {
    prepstmt.setInt(index,value);
  }
  public void clearParameters() throws SQLException
  {
    prepstmt.clearParameters();
  }
  public ResultSet executeQuery(String sql) throws SQLException
  {
    if (stmt != null) {
      return stmt.executeQuery(sql);
    }
      else return null;
  }
  public ResultSet executeQuery() throws SQLException
  {
    if (prepstmt != null)
    {
      return prepstmt.executeQuery();
    }
      else return null;
  }
  public void Execute() throws SQLException
  {
    if(prepstmt != null)
    {
      prepstmt.execute();
    }
  }
  public void Execute(String sql) throws SQLException
  {
    if(stmt != null)
    {
      stmt.execute(sql);
    }
  }
  /**
   * 关闭连接
   */
  public void close() throws SQLException
  {
    if (stmt != null)
    {
      stmt.close();
      stmt = null;
    }
    if (prepstmt != null)
    {
      prepstmt.close();
      prepstmt = null;
    }
    conn.close();
    conn = null;
  }
}