package com.mitech.developer;
import javax.sql.DataSource;
import javax.naming.*;
import java.sql.*;
import java.util.*;
public class DBManage {
public static Connection getConn() {
// Connection con = null;
// DataSource ds = null;
// try {
// Context initContext = new InitialContext();
// Context envContext = (Context) initContext.lookup("java:/comp/env");
// ds = (DataSource) envContext.lookup("jdbc/myoracle");
// } catch (NamingException ne) {
// System.err.println("NamingException Error:" + ne);
// }
//
// try {
// con = ds.getConnection();
// } catch (SQLException e) {
// System.err.println(e);
// }
// return con;
return getConn4Class();
}
public static Connection getConn4Class() {
Connection conn = null;
Hashtable pathProp = MultiDesign.getResourcePath();
String url = (String)pathProp.get("conn_string");
//"jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.171.2.131)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = odb) ) )";
//String url = "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = odb.micike.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = odb) ) )";
try {
oracle.jdbc.pool.OracleDataSource ds = new oracle.jdbc.pool.OracleDataSource();
ds.seturl(http://www.blog007.com/url);
conn = ds.getConnection((String)pathProp.get("conn_username"), (String)pathProp.get("conn_password"));
//conn = ds.getConnection("username", "password");
} catch (Exception e) {
System.out.println(e);
}
return conn;
}
}