database.java

来自「WAP PUSH后台源码,WAP PUSH后台源码」· Java 代码 · 共 44 行

package com.sxit.wap.common;
import java.sql.*;
import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
import com.sxit.wap.exception.*;

public class Database {
  public static int dbType = DBType.ORACLE;
  private static DataSource dataSource = null;
  public static Connection getConnection() throws SysException {
    if (dbType == DBType.MYSQL) {
      try {
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1/wap?useUnicode=true&characterEncoding=gb2312", "root", "");
        return conn;
      }catch(Exception e){
        e.printStackTrace();
        throw new SysException("cannot get connection : \n" + e);
      }
    } else {
      Connection conn = null;
      try {
        Class.forName ( "oracle.jdbc.driver.OracleDriver" );
          // conn = DriverManager.getConnection ( "jdbc:oracle:thin:@211.90.72.161:1521:ora8", "tssxwap", "tssxwap" );
          conn = DriverManager.getConnection ( "jdbc:oracle:thin:@10.29.1.2:1521:ora8", "tssxwap", "tssxwap" );
         //conn = DriverManager.getConnection ( "jdbc:oracle:thin:@10.10.10.169:1521:cqwap", "nxwap", "nxwap" );
        //dataSource = ( javax.sql.DataSource )new InitialContext ().lookup ( "DataSource" );
        //conn = dataSource.getConnection ();
      } catch ( Exception ex ) {
        ex.printStackTrace();
      }
      return conn;
    }
  }
  public static void main(String[] args){
    try{
      getConnection();
    }catch(Exception ex){
      ex.printStackTrace();
    }
  }
}