JDBC处理前后移动结果集(SXT)
原版Demo,备忘用
- import java.sql.*;
- //JDBC处理前后移动结果集
- public class TestScroll {
- public static void main(String args[]) {
- try {
- new oracle.jdbc.driver.OracleDriver();
- String url = "jdbc:oracle:thin:@192.168.0.1:1521:Test";
- Connection conn = DriverManager
- .getConnection(url, "scott", "tiger");
- Statement stmt = conn.createStatement(
- ResultSet.TYPE_SCROLL_INSENSITIVE, //设置结果集自由滚动
- ResultSet.CONCUR_READ_ONLY); //设置并发访问时结果集只读
- ResultSet rs = stmt
- .executeQuery("select * from emp order by sal");
- rs.next();
- System.out.println(rs.getInt(1)); //取第一列结果,相当于System.out.println(rs.getInt
- ("deptno"));
- rs.last(); //最后一行记录
- System.out.println(rs.getString(1)); //把第一个记录当做String类型取出
- System.out.println(rs.isLast()); //是不是最后一条。返回布尔值。
- System.out.println(rs.isAfterLast()); //是不是最后一条的下一条
- System.out.println(rs.getRow()); //获取当前记录是第几条记录
- rs.previous(); //向上滚。往前移
- System.out.println(rs.getString(1)); //打印此时第一个字段记录
- rs.absolute(6); //绝对定位,跳到第六行记录
- System.out.println(rs.getString(1)); //打印此时第一个字段记录
- rs.close();
- stmt.close();
- conn.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }