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( )?