JAVA：数据库操作封装（1）

点击88DOC.COM查找更多文档

package creator.common.db;

import java.io.InputStream;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;

/**
 *
 * <p>Title: dbBean.java</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author TanBo
 * @version 1.0
 */
public class DbBean {
  public java.sql.Connection conn = null; //connection object
  public ResultSet rs = null; //resultset object
  public Statement stmt = null; //statement object
  public PreparedStatement prepstmt = null; //preparedstatement object
  private String drivers = null; //connection parameter:drivers
  private String url = null; //connection parameter:url
  private String user = null; //connection parameter:user
  private String password = null; //connection parameter:password
  private String jndi_name = null; //connection pool parameter:jndi name

  /**
   * init()
   */
  public DbBean(){
    try{
      //parameter init
      drivers = creator.config.ConfigBundle.getString("drivers");
      url = creator.config.ConfigBundle.getString("url");
      user = creator.config.ConfigBundle.getString("user");
      password = creator.config.ConfigBundle.getString("password");
      jndi_name = creator.config.ConfigBundle.getString("jndi_name");

      //db connection pool init
      //InitialContext env = new InitialContext();
      //javax.sql.DataSource pool = (javax.sql.DataSource)env.lookup(jndi_name);
      //conn = pool.getConnection();

      //db connection init
      Class.forName(drivers);
      conn = DriverManager.getConnection(url,user,password);

      //db statement init
      stmt = conn.createStatement();
    }catch(Exception e){
      System.out.println("dbBean: init error!"+e.toString());
    }
  }

  /**
   * @function prepareStatement
   * @param sql String
   * @throws SQLException
   */
  public void prepareStatement(String sql) throws SQLException {
    prepstmt = conn.prepareStatement(sql);
  }

  /**
   * @function prepareStatement
   * @param sql String
   * @param resultSetType int
   * @param resultSetConcurrency int
   * @throws SQLException
   */
  public void prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
      throws SQLException {
    prepstmt = conn.prepareStatement(sql, resultSetType, resultSetConcurrency);
  }

  /**
   * @function executeQuery
   * @param sql String
   * @throws SQLException
   * @return ResultSet
   */
  public ResultSet executeQuery(String sql) throws SQLException {
    if (stmt != null) {
      return stmt.executeQuery(sql);
    }else return null;
  }

  /**
   * @function executeQuery
   * @throws SQLException
   * @return ResultSet
   */
  public ResultSet executeQuery() throws SQLException {
    if (prepstmt != null) {
      return prepstmt.executeQuery();
    }else return null;
  }

  /**
   * @function executeUpdate
   * @param sql String
   * @throws SQLException
   */
  public void executeUpdate(String sql) throws SQLException {
    if (stmt != null)
      stmt.executeUpdate(sql);
  }

  /**
   * @function executeUpdate
   * @throws SQLException
   */
  public void executeUpdate() throws SQLException {
    if (prepstmt != null)
      prepstmt.executeUpdate();
  }