Load data with scroll down in Servlet-JSP

Well, In this case you will need to design the page with lot of javascript. What I got from the question is there is some table which is having 6000 records. Now you want to show this data on the page. You also want whenever something gets changed you want to map the changes in the screen as well.

For this, 1st thing you need is to map each row with its key on front side. You need to read a bit of AJAX and rest is very simple.

You can hit server after a fixed interval say 5 sec. So this hit will return you the changed items. Now the max id you had on the page will be compared with the records which the server return.

Response can be of three parts: a) deleted b) edited c) inserted

you can go with combining editing and inserting as at a given point you cannot track whether you might not want to have a overhead of keeping track of the same.

So only two blocks a) deleted and b) inserted/modified

while creating the view, each row will be a div with id containing the primary key. So the id of the div will be say "div23" where 23 is primary key.

Now you need to iterate the response. You can go with either XML or JSON to work this solution easily.

Lets take a sample response.

response having json bojects with ids 23, 45, 97 etc in delete and 46, 1000, 6001 etc in insert/edit.

now to delete, you need to just write: document.getElementById("div" + id).innerHTML = ""; or you can delete the same from dom model.

Similarly you can get the div and edit the same. If you do not get any div will mean that you need to insert which you can do in the end.

For ajax you can get many frameworks like prototype, dojo etc. Basic example of AJAX you can find on w3schools site.

I hope it helps.