可滚动的游标记录集JDBC_jdbc使用滚动游标-CSDN博客

本文链接：https://blog.csdn.net/aptweasel/article/details/1205600

可滚动的游标记录集
package text;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
public class RollQuery {
public static void main(String[] args) {
        final String query = "select * from emp order by deptno";
        Connection conn = DBConn.getConnection();
        try {
               Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);       //可滚动的游标选项
               ResultSet rs = stmt.executeQuery(query);
               ResultSetMetaData rsmd = rs.getMetaData();
               int colCount = rsmd.getColumnCount();
               while(rs.next()){                   //取所有行
                      for(int i = 0; i < colCount; i++){
                             System.out.print(rs.getString(i + 1) + "/t");
                      }
                      System.out.println();
               }
               if(rs.first()){                      //取第一行
                      System.out.println("First Row: ");
                      for(int i = 0; i < colCount; i++){
                             System.out.print(rs.getString(i + 1) + "/t");
                      }
                      System.out.println();
               }
               if(rs.absolute(5)){                         //取绝对行数
                      System.out.println("5:**************** ");
                      for(int i = 0; i < colCount; i++){
                             System.out.print(rs.getString(i + 1) + "/t");
                      }
                      System.out.println();
               }
               if(rs.relative(-2)){                       //取相对行数
                      System.out.println("3:**************** ");
                      for(int i = 0; i < colCount; i++){
                             System.out.print(rs.getString(i + 1) + "/t");
                      }
                      System.out.println();
               }
               if(rs.previous()){                              //指针前滚
                      System.out.println("2:**************** ");

                      for(int i = 0; i < colCount; i++){
                             System.out.print(rs.getString(i + 1) + "/t");
                      }
                      System.out.println();
               }
               rs.close();
               stmt.close();
        }
//catch
}