数据库连接

永久链接: http://kevin-stu-eye.iteye.com/blog/1536166

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; 
} 

}