Displaying next 10 records from resultset

  • 18 years ago


    Hi all
    I am developing a website for some writers.
    The website is database driven and contains writings and poetries
    by different writers.
    I am using servlet to connect to Database and using MySQL
    as database.
    I wanted to know that how can i display only some fields
    from the recordset after search and then make the name of the
    writer a hyperlink to next page which shows the details about
    his/her work.
    Also the data fetched into resultset should be displayed
    on the page in such a way that only firt 10 records get displayed
    in the first page and then i could navigate through rest
    of the results using next and previous buttons.


    Your help would be really appreciated..
    Thank you in advance


    Regards
    Vikas

  • 18 years ago

    provide me with your FULL java code...


    u can mail the code at :


    [email protected]


    Regards,
    - js


  • 18 years ago

    you can use the SQL to do this work.


    for example :
     Select fname, lname
     From   staff
     where salary > 2500


     the SQl statement is said that ur only select the staff first name 'fname' and last name 'lname' from 'staff' table, furthemore, the staff who the salary is over 2500 only.

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Never trust a programmer in a suit.” - Anonymous