資料來源連線資料庫

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




public class ManagerConn {
private static String url;
private static String user;
private static String password;
private static Connection conn = null;

/**
* 採用連線池連線oracle
* @throws Exception 
*/
public static Connection init_oracle_dataSource(){
try {
Context context = new InitialContext();
//獲取資料來源
DataSource ds = (DataSource) context.lookup("java:/comp/env/jdbc/oracleds");
//通過資料來源獲取connection
conn = ds.getConnection();
} catch (Exception e) {
}

return conn;
}
/**
* 採用連線池連線mysql
* @throws Exception 
*/
public static Connection init_mysql_dataSource() throws Exception{
try {
//初始化名稱空間
Context context = new InitialContext();
//獲取資料來源
DataSource ds = (DataSource) context.lookup("java:/comp/env/jdbc/mysqlds");
//通過資料來源獲取connection
conn = ds.getConnection();
} catch (Exception e) {
}

return conn;
}
}