例如:
package lesson13;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class BaseDao {
// 数据库基本链接字符串、参数
private static String driver = "oracle.jdbc.driver.OracleDriver";//驱动,需导包ojdbc6.jar(Oracle 11g)
private static String url = "jdbc:oracle:thin:@10.0.0.41:1521:sjbitdb";//可用计算机名+端口号+SID的方式连接
private static String dbuser = "epet";
private static String password = "bdqn";
/**
* 获取数据库连接对象
*/
public static Connection getConnection() {
Connection conn = null;
// 异常代码
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, dbuser, password);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
/**
* 用于清空和关闭现有数据库组件Connect,PreparedStatement,ResultSet等
*
* @param obj
*/
public static void dataBaseCloseChecked(Connection conn, Statement stmt,
ResultSet rs) {
// 关闭连接
try {
if (conn != null) {
conn.close();
}
if (stmt != null) {
stmt.close();
}
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}