连接Oracle 11G数据库的范例

例如：

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

	}
}