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