www.pudn.com > sendmail.rar > ConnectionDB.java

package com.sendmail;

/**
 * 
Title: 内容监控
 * 
Description: 数据库连接类
 * 
Copyright: Copyright (c) 2003
 * 
Company: 
 * @author 
 * @version 1.0
 */

import java.sql.*;

public class ConnectionDB {

  /**数据库连接参数*/
  private ConnParameter conP;

  /**
   * 构造函数
   * @param data 数据库连接参数
   * @return No
   * @throws No
   */
  public ConnectionDB(ConnParameter data) {
    this.conP = data;
  }

  /**
   * 和数据库建立连接
   * @return Connection 数据库连接
   * @throws SQLException 无法和数据库建立连接
   */
  public Connection getConnection() throws SQLException {
    Connection con = null;
    try {
      Class.forName(conP.getDriver());
    }catch(Exception e) {
      System.out.println("未发现相关数据库驱动程序类,请确认驱动程序已经加载.");
    }
    try {
      /*OracleConnectionPoolDataSource ocpds =
          new OracleConnectionPoolDataSource();
      ocpds.setURL(conP.getUrl());
      ocpds.setUser(conP.getUser());
      ocpds.setPassword(conP.getPass());
      PooledConnection pc = ocpds.getPooledConnection();
      con = pc.getConnection();*/
      con = DriverManager.getConnection(conP.getUrl(), conP.getUser(), conP.getPass());

    } catch(SQLException ex) {
      throw ex;
    }catch(Exception e) {
    }

    return con;
  }

}