连接Oracle 11G数据库的范例

来源：互联网发布：中国有嘻哈双冠军知乎编辑：程序博客网时间：2024/06/05 18:28

例如：

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();}}}