package com.joop;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConnectionManager {//加载驱动程序的方法
static {
try {
Class.forName("oracle.jdbc.OracleDriver");
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnnection() throws SQLException {// 数据库连接方法
return DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:EDUASK", "buck", "5210");
}
public static void closeConnection(ResultSet rs, Statement ps,// 关闭数据库的方法
Connection conn) throws SQLException {
try {
if (rs != null)// 如果结果集不为空,
rs.close();// 则关闭
} finally {// 最后
try {
if (ps != null)
ps.close();
} finally {
if (conn != null)
conn.close();
}
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConnectionManager {//加载驱动程序的方法
static {
try {
Class.forName("oracle.jdbc.OracleDriver");
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnnection() throws SQLException {// 数据库连接方法
return DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:EDUASK", "buck", "5210");
}
public static void closeConnection(ResultSet rs, Statement ps,// 关闭数据库的方法
Connection conn) throws SQLException {
try {
if (rs != null)// 如果结果集不为空,
rs.close();// 则关闭
} finally {// 最后
try {
if (ps != null)
ps.close();
} finally {
if (conn != null)
conn.close();
}
}
}
}