connectionmanager.java

该压缩文件包含有多个连接池管理包

//package com.redfox.sql;

/**
 * <p>Title: ConnectionManager</p>
 * <p>Description: ConnectionManager</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: Powerise. Chao.Liu</p>
 * @author not attributable
 * @version 1.0
 */

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.PooledConnection;
import oracle.jdbc.pool.*;

public class ConnectionManager {

  private PooledConnection pooledConnection = null;
  private OracleConnectionPoolDataSource poolDataSource = null;

  private static ConnectionManager connectionManager = null;

  private ConnectionManager(String url, String userName, String password) throws
        SQLException {
    poolDataSource = new OracleConnectionPoolDataSource();
    poolDataSource.setURL(url);
    poolDataSource.setUser(userName);
    poolDataSource.setPassword(password);
    pooledConnection = poolDataSource.getPooledConnection();
  }

  /**
   * Get ConnectionManager, when the connectionManager object has been
   * created. or create and return.
   * @param url
   * @param userName
   * @param password
   * @return ConnectionManager
   * @throws SQLException
   */
  public static ConnectionManager getConnectionManager(String url,
        String userName, String password) throws SQLException {
    if (connectionManager == null) {
      connectionManager = new ConnectionManager(url, userName, password);
    }
    return connectionManager;
  }

  /**
   * Create a new Connection Manager with new attributes.
   * @param url
   * @param userName
   * @param password
   * @return ConnectionManager
   * @throws SQLException
   */
  public static ConnectionManager getNewConnectionManager(String url,
        String userName, String password) throws SQLException {
    connectionManager = new ConnectionManager(url, userName, password);
    return connectionManager;
  }

  /**
   * Get a SQL Connection
   * @return java.sql.Connection
   * @throws SQLException
   */
  public Connection getConnection() throws SQLException {
    return pooledConnection.getConnection();
  }

  public static void main(String[] args) throws SQLException {

    // usage:
    ConnectionManager connectionManager = null;
    Connection conn = null;
    try{
      connectionManager = ConnectionManager.getConnectionManager(
            "jdbc:oracle:thin:@192.168.0.192:1521:test",
            "scott",
            "tiger");
      conn = connectionManager.getConnection();
      Statement state = conn.createStatement();
      ResultSet result = state.executeQuery("SELECT * FROM demo");
      while (result.next()) {
        System.out.print(result.getString(1));
        System.out.print(result.getString(2));
        //System.out.print(result.getString(3));
        //System.out.print(result.getString(4));
        //System.out.println(result.getString(5));
      }
      result.close();
      state.close();
    }
    catch(SQLException ex){
      throw ex;
    }
    finally{
      try{
        if(conn != null){
          //曐\u8BC1connection揑\u5173\u95ED丅斲\u5219\u8FDE愙抮夛晄抐揑\u5219壛怴揑\u8FDE愙丅
          conn.close();
        }
      }
      catch(SQLException ex){};
    }
  }
}