Java 连接Oracle数据库实体类（ConnectionUtil）

最新推荐文章于 2023-02-14 15:03:54 发布

langdexinyang6

最新推荐文章于 2023-02-14 15:03:54 发布

阅读量185

点赞数

文章标签： Oracle Java JDBC

本文链接：https://blog.csdn.net/langdexinyang6/article/details/83709486

版权

public class ConnectionUtil {

/**
* 对数据库进行连接
* @author FanChengLong
* @return Connection连接对象
*/
public static Connection getConnection() {

  String url = "jdbc:oracle:thin:@10.6.109.52:1521:or10g";
  String userName = "ytbdatadr2";
  String password = "ytbdatadr2";
  Connection con = null;
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   con = DriverManager.getConnection(url, userName, password);

  } catch (Exception e) {
   e.printStackTrace();
  }

return con;
}

public static void closeCon(Connection con) throws SQLException {
con.close();
}

public static void closeSt(Statement st) throws SQLException {
st.close();
}

public static void closeRs(ResultSet rs) throws SQLException {
rs.close();
}
}