[jdbc] get Oracle Connection

//jdk1.4
//需要ojdbc14.jar

import java.sql.Connection;
import java.sql.DriverManager;

public class OracleConnection{

 public Connection conn = null;
 
 public OracleConnection() {
  if(conn == null){
   this.conn = getDBConnection();
  }
 }
 
 public OracleConnection(String user, String password) {
  if(conn == null){
   this.conn = getDBConnection(user, password);
  }
 }
 
 public Connection getDBConnection(){
  return getDBConnection("sehzmps", "todtks01");
 }
 
    public Connection getDBConnection(String user, String password)
    {
     if(this.conn == null){
      //@后面是tnsnames.ora里面的连接信息，拼成字符串
         //String strUrl = "jdbc:oracle:thin:@(description=(address=(host=erpdev)(protocol=tcp)(port=1522))(connect_data=(sid=uat)))";
         //String strUrl = "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=eedb01.nc.sgcc.com.cn)(PORT=1521)))(CONNECT_DATA = (SID=PROD1)))";
      String strUrl = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=109.104.1.141)(PORT=1529)))(CONNECT_DATA=(SERVICE_NAME=SPT)))";
 
         String strUser = user;
         String strPassword = password;
         //Connection conn = null;
         try
         {
             String driverName = "oracle.jdbc.driver.OracleDriver";//ojdbc14.jar
             Class.forName(driverName);
             this.conn = DriverManager.getConnection(strUrl, strUser, strPassword);
         }
         catch (Exception e)
         {
             e.printStackTrace();
         }
     }
        return this.conn;
    }
 
 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub

 }

}