package com.qst.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
//数据库连接和释放工具类
public class DBU {
//数据库实例用户名,可根据自己的设置进行更改
static String user = "shixun";
//数据库实例密码,可根据自己的设置进行更改
static String password = "orcl";
//数据库实例链接地址,可根据自己的设置进行更改
static String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
static {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
Connection conn = null;
try {
conn = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void closeJDBC(ResultSet rs, Statement stmt, Connection conn) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
连接Oracle 11g时用到的数据库连接和释放工具类DBUtil
最新推荐文章于 2024-05-12 22:02:06 发布