File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How to retrieve multiple row data from oracle table and show it in jsp page Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to retrieve multiple row data from oracle table and show it in jsp page" Watch "How to retrieve multiple row data from oracle table and show it in jsp page" New topic
Author

How to retrieve multiple row data from oracle table and show it in jsp page

Harshal Gurav
Ranch Hand

Joined: May 29, 2008
Posts: 151
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 .




Thanks,
Harshal
[ October 07, 2008: Message edited by: Harshal Gurav ]
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31054
    
162

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?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Harshal Gurav
Ranch Hand

Joined: May 29, 2008
Posts: 151
Hi Jeanne,
Thanks for your kind support.
The below JavaScript code is used to add row in the table when I want to add multiple row data into table for single entry no field.
I am unable to add java sript code here which used to add multiple rows for footer table.
When i am trying to add it, the post shows the error.


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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to retrieve multiple row data from oracle table and show it in jsp page