how to show only 11 to 20 records out of 1000 records

[dcbtux]

how to show only 11 to 20 records out of 1000 records through jdbc

[jkmyoung]

Could you show the code to display records 1 - 10? Then we can customize your code a lot easier.

[dcbtux]

Showing 1-10 records is done by a method of Statement Class named setMaxRows(int). Code is as follows......

import java.sql.*;
class RecordFetcher
{
    Connection cn=null;
    Statement stmt=null;
    ResultSet rs=null;
    RecordFetcher()
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            cn=DriverManager.getConnection("jdbc:odbc:mydsn");
            stmt=cn.createStatement();
            stmt.setMaxRows(10);
            rs=stmt.executeQuery("select * from test");
            while(rs.next())
            {
                System.out.println(rs.getString(1)+" "+rs.getString(2));
            }
        }
        catch(Exception e)
        {
        }
    }
    public static void main(String args[])
    {
        new RecordFetcher();
    }    
}
 

[jkmyoung]

I'm not sure if it's supported, but can you add

"LIMIT 10 OFFSET 10"
to your query string?

Or have you looked at getMoreResults()?