Currently I am working on one form development using Java. In JSP page I retrieved the data from table using F9 keys i.e for any input field variable available in JSP page, once I pressed the F9 key, all the related data is displayed in the popup window. Once I select particular item , item description would be displayed on page and related item code was used to store the particular item in database. In this form I used add new row as a button to add a new row (this is for the automatic row increment purposes) it work fine for adding the item into table/ Now in next task I have to retrieve all this data from particular table which is available in multiple row format in table . How can I retrieve all this data for particular dynamic rows. Here with I have attached the JSP page which is showing adding multiple row in dynamically. Also I am attaching related servlet page used to retrieve the data . Any suggestion is highly appreciated .
Harshal, You know this forum doesn't support attachments, right? Please show the relevant code snippets (not the whole thing.) Also, please provide more information about where you are stuck. Do you have a working query yet?
Then this data are send to the next Servlet for adding into two table. My header portion data are added into one table which added only one row in table. while footer section data are added into the no of rows in another table dependent on No. of Rows added into jsp page. Here is an code for that logic.
Now I looking for to retrieve this footer section data available in multiple rows from footer table and present it in jsp page . I am finding difficulties in how to show this multiple row data for dynamic no of rows .i.e. variable no. of rows. I have able to show the data in Header portions of page in this ways here i am adding the part of code which shows the data from header part of table i.e from Header table
Any suggestion on any above works is highly appreciated. Thanks and regards harshal
subject: How to retrieve multiple row data from oracle table and show it in jsp page