aspose file tools*
The moose likes JDBC and the fly likes get a limited no of records Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "get a limited no of records" Watch "get a limited no of records" New topic
Author

get a limited no of records

kevin Johnson
Greenhorn

Joined: Jul 24, 2001
Posts: 1
Hi there,
resultSet.next gives me all the rows from the table. Is there any way to limit the no of records say only 10??
Thanx.
kevin

// print out records

while(resultSet.next())
{
//String[] row = new String[columnCount];
for(int i=1; i<columnCount+1; i++) {>
entry = resultSet.getString(i) + ",";
System.out.println(entry);
}

Daniel Dunleavy
Ranch Hand

Joined: Mar 13, 2001
Posts: 276
setFetchsize
or in Oracle you can have ROWNUM < 11 in the where clause
Dan
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: get a limited no of records