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;
}
编译后运行结果:
对应的数据库查询结果如下