public static Connection getConn() {
Connection conn = null;
try {
Class.forName(ORACLE_DRIVER);
conn = DriverManager.getConnection(ORACLE_TNS, USER, PWD);
} catch (SQLException se) {
se.printStackTrace();
} catch (ClassNotFoundException fe) {
fe.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}