JDBC 可以滚动的结果集

import java.sql.*;import com.sun.crypto.provider.RSACipher;public class TestScroll {/** * @param args */public static void main(String[] args) {// TODO Auto-generated method stubtry {Class.forName("oracle.jdbc.driver.OracleDriver");Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","system","123456");Statement statement = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);String sql = "select * from student order by id";ResultSet resultSet = statement.executeQuery(sql);resultSet.next();System.out.println(resultSet.getInt(1));resultSet.last();System.out.println(resultSet.isLast());System.out.println(resultSet.isAfterLast());System.out.println(resultSet.getRow());resultSet.previous();System.out.println(resultSet.getString(1));resultSet.absolute(6);System.out.println(resultSet.getString(1));resultSet.close();statement.close();conn.close();} catch (Exception e) {// TODO: handle exception}}}