数据库连接

package base.db.lib.util;
import java.sql.*;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

import base.listener.DBListener;
@SuppressWarnings("all")
public class DBConnection {

public static Connection getConnection(){
Connection conn = null;
if(conn != null){
return conn;
}
try {
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@"+DBListener.host+":1521:"+DBListener.source;

Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr,DBListener.userName,DBListener.pwd);
return conn;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}

public static Connection getContextConnection(){
Connection conn=null;
  DataSource ds = null;
try{
Context ctx = new InitialContext(); 
    Context envctx =  (Context) ctx.lookup("java:comp/env");
    ds =  (DataSource) envctx.lookup("jdbc/"+DBListener.contxtSource); 
    return ds.getConnection();
}catch(Exception e){
e.printStackTrace();
}
return null;

}

public static Connection getMysqlConnection(){
try {
String sDBDriver = "com.mysql.jdbc.Driver";
// jdbc:mysql://<hostname>[<:3306>]/<dbname>
String sConnStr = "jdbc:mysql://192.168.8.26:3306/wfe";
Connection conn = null;
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr,"root","root");
// System.out.println("commen:" +conn.toString());


return conn;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}

public static Connection getConnection(String JNDIDatabaseName) {
try {
//java:comp/env/jdbc/
Connection conn=null;
InitialContext ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup(JNDIDatabaseName);
conn=ds.getConnection();
System.out.println("jndi:" +conn.toString());
return conn;
} catch (Exception sex) {
sex.printStackTrace();
}
return null;
}

}