用Java 通过JDBC完成对Oracle数据的操作

首先在oracle 数据库安装目录下 D:\orcale\product\11.2.0\dbhome_1\jdbc\lib 找到ojdbc6的jar包
当然也可以用maven下载

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class JDBCTest {
    public static void main(String[] args) throws Exception {

        //1 加载驱动
        Class.forName("oracle.jdbc.driver.OracleDriver");
        //2 建立连接 thin, OCI 两种连接方式
        Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "yuan");
        //3,测试连接是否成功
        System.out.println(connection);
        /*
        *   Connected to the target VM, address: '127.0.0.1:63771', transport: 'socket'
orac        le.jdbc.driver.T4CConnection@1d119efb
Disc        onnected from the target VM, address: '127.0.0.1:63771', transport: 'socket'
        *
        * */
        //4, 定义sql语句
        String sql = "select * from emp";
        //5, 准备静态处理块对象, 将sql语句放置在静态处理块中
        Statement statement = connection.createStatement();
        //6, 执行sql语句,返回值对象是结果集合
        ResultSet resultSet = statement.executeQuery(sql);
        //7, 循环处理
        //ctrl+o重载父类方法 ctrl+p 显示当前重载 ctrl+I实现接口方法
        while (resultSet.next())
        {
            int anInt = resultSet.getInt(1);
            System.out.println(anInt);
            String ename = resultSet.getString("ename");
            System.out.println(ename);
        }
        //8, 关闭连接
        statement.close();
        connection.close();

    }
}

查询结果:

7369
SMITH
7499
ALLEN
7521
WARD
7566
JONES
7654
MARTIN
7698
BLAKE
7782
CLARK
7788
SCOTT
7839
KING
7844
TURNER
7876
ADAMS
7900
JAMES
7902
FORD
7934
MILLER

Process finished with exit code 0