java连接Oralce的基本步骤

1，安装Oracle11g（省略）

2，将Orcale11g的jdbc驱动包拷到项目中

没有拷贝驱动包会出现抛出异常：

拷贝步骤如下：

3，编写java文件程序，运行

package Jinhao.Oracle.Test;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


public class JinJDBCTest {


public static void main(String[] args) {

Connection connection = null;


PreparedStatement prepareStatment = null;


ResultSet rs = null;
// 寻找连接Oracle数据库驱动类
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


// 获取Oracle数据库连接对象
try {
connection = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:ORCL11G", "scott",
"tiger");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


// 创建sql语句
String sql = "select * from emp";
// 获取操作数据库的PrepareStatement对象
try {
prepareStatment = connection.prepareStatement(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// 获取实行数据库的结果集
try {
rs = prepareStatment.executeQuery();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


// 打印结果集合
try {
while (rs.next()) {
System.out.print(rs.getString(1) +"\t");
System.out.print(rs.getString("ENAME")+ "\t");
System.out.println(rs.getString(3));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


// 关闭所有连接，此操作会抛出异常
try {
rs.close();
prepareStatment.close();
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


// 设置所有对象为null
rs = null;
prepareStatment = null;
connection = null;
}
编译后运行结果：

对应的数据库查询结果如下