JDBC连接Oracle

private static final String URL = "jdbc:oracle:thin:@10.138.1.84:1521/oracle";
private static final String USERNAME = "yj";
private static final String USERPWD = "yj";
private static final String CLASSDRIVER = "oracle.jdbc.driver.OracleDriver";

/**
* 连接
*
* @Title: getCon
* @Description: TODO
* @param @return 设定文件
* @return Connection 返回类型
* @throws
*/

public static Connection getCon() {
Connection conn = null;
try {
Class.forName(CLASSDRIVER);
conn = DriverManager.getConnection(URL, USERNAME, USERPWD);
} catch (Exception e) { // TODO: handle exception
System.out.println(e.getMessage());
}
return conn;
}

/**
* 关闭
*
* @Title: closeConn
* @Description: TODO
* @param @param conn
* @param @param sm
* @param @param rs 设定文件
* @return void 返回类型
* @throws
*/

public static void closeConn(Connection conn, Statement sm, ResultSet rs) {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block e.printStackTrace();
}
}
if (sm != null) {
try {
sm.close();
} catch (SQLException e) { // TODO Auto-generated
// catch block e.printStackTrace();
}
}
if (rs != null) {
try {
rs.close();
} catch (SQLException e) { // TODO Auto-generated catch block
e.printStackTrace();
}
}
}

/**
* 测试连接
*
* @Title: main
* @Description: TODO
* @param @param args 设定文件
* @return void 返回类型
* @throws
*/

public static void main(String[] args) {
System.out.println(getCon());
}