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