JDBC连接Oracle

来源：互联网发布：java 国内书籍编辑：程序博客网时间：2024/06/07 01:21

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