Hello , I am working on a project "Online Book Mart" using JSP and Servlets and I am astuck at a position. I am using MySql at back end ,. My query is:- Suppose I clicked a link java books in my project, and there are 100 books info stored in the database but i want to show only 20 at the time and there will be 5 buttons for next page means when i click next, the next 20 books will be displayed from db on the same page.
Hope you got my point , please help me, I am unable to understand how to do this.
hi friend, you can use the mysql limit query as
select * from table_name limit x, y;
where x is the first record and y is the number of records you want to display.
For detail tutorial of mysql limit you can visit the following link Mysql Limit
I hope this may helpful for you.
Hmm, well i was thinking of using limit query, but i would have been great if I had got an illutration, if possible then can you provide an illustration with sample code,
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.