Updating Data in Database using JSP
843838Oct 6 2005 — edited Oct 6 2005Hi all,
Can anyone please give me an idea that i have a JSP page that connects to the MS Access database. Now i have a query that shows all the data sorted by date for each individual user. Now if anyone wants to update from there meaning that there should be an update button.And if anyone press that then all the on the particular row will be shown in text boxes and then the user can modify the data. and press update to send the data to the database and show the correct one on that page again.
I know it is a bit hazy. Noe point is i created the query and the update button. Now how can i create text boxes for a particular row if button pressed and also i want to show the dataon this page again dont want to go to another page and do the same thing again. This will enable user to update each row separately on the same page and after all these he can log out. Please help me.
Another question how can i pass some data from an HTML form to the same JSP but in a different place meaning that if i direct the form to the same JSP like "form action=same.jsp" then it will start doing everything from the beginning of the page. But i want to go to a particular form of the same JSP page. Can anyone please help me.
I will be very grateful
Thanks.