在JSBC中处理可滚动的结果集

import  java.sql. * ;

public   class  TestPrepStmt  ... {

    public static void main(String[] args) ...{
        
        Statement stmt = null;
        Connection conn = null;
        try ...{
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost/data?user=root&password=123456";
            conn = DriverManager.getConnection(url);
            
            stmt = conn.createStatement(
                    ResultSet.TYPE_SCROLL_INSENSITIVE,
                    ResultSet.CONCUR_READ_ONLY);
            ResultSet rs = stmt
                    .executeQuery("select * from user");
            rs.next();//第一条记录
            System.out.println(rs.getInt(1));
            rs.last();//定位到最后一条记录
            System.out.println(rs.getString(1));
            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));
            
            
        } catch (ClassNotFoundException e) ...{
            e.printStackTrace();
        } catch (SQLException e) ...{
            e.printStackTrace();
        } finally ...{
            try ...{
                if(stmt != null) ...{
                    stmt.close();
                    stmt = null;
                }
                if(conn != null) ...{
                    conn.close();
                    conn = null;
                }
            } catch (SQLException e) ...{
                e.printStackTrace();
            }
        }
    }

}