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;  }}