Printable View
How do I use the JDBC resultset when you want to have scroll forward and backward
on the web page ? Like when you have 20 lines on the page and the resultset
is more than 20 rows, how do I do it to scroll forward and backwards ? Do
I have to put the resultset on an array and play around the array ? What
if the resultset has more than a million rows ?
Thanks.
You can use "fatch" functionality. Which fatches certain amout of rows at
a time.
"binggy" <benedict@hotmail.com> wrote:
>
>How do I use the JDBC resultset when you want to have scroll forward and
backward
>on the web page ? Like when you have 20 lines on the page and the resultset
>is more than 20 rows, how do I do it to scroll forward and backwards ? Do
>I have to put the resultset on an array and play around the array ? What
>if the resultset has more than a million rows ?
>
>Thanks.
hello binggy,
if you use the concept "Scrollable Record Set" which is included in the jdbc2.0
specifaction its east to move the resultset both forward and backward.
...................................
"binggy" <benedict@hotmail.com> wrote:
>
>How do I use the JDBC resultset when you want to have scroll forward and
backward
>on the web page ? Like when you have 20 lines on the page and the resultset
>is more than 20 rows, how do I do it to scroll forward and backwards ? Do
>I have to put the resultset on an array and play around the array ? What
>if the resultset has more than a million rows ?
>
>Thanks.
hello binggy,
if you use the concept "Scrollable Record Set" which is included in the jdbc2.0
specifaction its easy to move the resultset both forward and backward.
...................................
"binggy" <benedict@hotmail.com> wrote:
>
>How do I use the JDBC resultset when you want to have scroll forward and
backward
>on the web page ? Like when you have 20 lines on the page and the resultset
>is more than 20 rows, how do I do it to scroll forward and backwards ? Do
>I have to put the resultset on an array and play around the array ? What
>if the resultset has more than a million rows ?
>
>Thanks.
