wood burning stoves 2.0*
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
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: get a limited no of records
 
Similar Threads
getObject() method is not returning the proper result.
comparing two ResultSet
Making arraylist from resultset
JTable won't display records from database
Get results from user defined query