package qst.com.Util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
- 连接数据库工具类
- @author hzh
*/
public class DBUtil {
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USER = "xx";
private static final String PWD = "xx123";
static {
try {
Class.forName("oracle.jdbc.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
Connection connection = null;
try {
connection = DriverManager.getConnection(URL, USER, PWD);
}catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
public static void closeDBUtil(ResultSet rs,PreparedStatement pstmt,Connection connection) {
if(rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(pstmt != null) {
try {
pstmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(connection != null) {
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}