Hi, I am implementing an application which displays the rows of oracle table in a jsp page by connecting to database using JDBC. I am done with it and now I need to provide edit and delete options to each and every row of my table in jsp. So I got an idea of providing with edit, delete buttons for each and every row. but if the table is too big this method is not good. another idea is to provide all the rows with check boxes so that user can check those boxes and then he can use edit or delete buttons (which are declared globally for the table...not for each row). I need help in this..If you have any idea please share. Thanks, Shanti.
maybe its better if you will display a portion of a table first and a checkbox to the coresponding row. the checkbox will be the que on which rows will be deleted/edited in the database in
Joined: Feb 20, 2006
Thanks for the fast reply. Do you have any idea of how to add check box functionality to my existing table. and moreover if I select one row and click edit...how can I get only those row values into the next page?
first change your name here(JAVARANCH Forum as it is required) then on your checkboxes, put a value of the unique column from your database when you populate your database. when you click either the edit or delete button it should query or delete the said row.
Originally posted by shanti jr: Thanks for the fast reply. Do you have any idea of how to add check box functionality to my existing table. and moreover if I select one row and click edit...how can I get only those row values into the next page?
- insert one more column to your table for checkboxes - map each checkbox to record id - get the checkbox value at the server. If unchecked you would get null, otherwise record id - do whatever you want to do with that particular record. You can open up that record in edit mode in the next page or you can just delete that record and display the same page again.