J2EE应用开发中与Oracle数据库的连接(1)

/**
* 在本地获得数据库连接
*/

package com.j2ee.db;

import java.util.*;
import java.sql.*;
import javax.sql.*;
import java.io.*;
import oracle.jdbc.driver.*; 
import javax.naming.*;    

/**
* 通过OCI方式获得Oracle数据库连接
*/
public class DbConnection 
{
  final static String sDBDriver = 
  "oracle.jdbc.driver.OracleDriver";
  final static String sConnStr = 
  "jdbc:oracle:oci8:sr/sr@ora199";
  
  /**
  * 
  */
  public DbConnection() 
  {
  }
  
  /**
  * 获得Oracle数据库连接 
  */
  public java.sql.Connection connectDbByOci() 
  {  
  java.sql.Connection conn=null;  
  try
  {
  Class.forName(sDBDriver);
  conn = DriverManager.getConnection(sConnStr);
  }
  catch (Exception e) 
  {
      System.out.println("ERROR:"+e.getMessage()); 
  } 
  return conn;
  }
}