how to get a number of record from the Resultset

Greenhorn

Posts: 23

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

how to get a number of record from the Resultset ? for example , from 10 rows to 20 rows records ,please give me some examples!
thanks!

Lasse Koskela

author

Posts: 11962

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

"skyspeed skyspeed",
Your more than welcome to the JavaRanch but your display name does not comply with our naming policy so I'll have to ask you to change it.
Thanks.

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]

Sainudheen Mydeen

Ranch Hand

Posts: 218

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi
Inside while(rs.next()) loop you can write a logic to skip the first 9 records and the records after 20.
-Sainudheen

Joe Ess

Bartender

Posts: 9626

I like...

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

If your database supports the TOP keyword you can use a subquery to ORDER BY x ASC and get the top 20, and have the outer query ORDER BY x DESC and get the top 10.

[How To Ask Questions On JavaRanch]

Robert Smith

Greenhorn

Posts: 23

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

thanks !

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.