wood burning stoves 2.0*
The moose likes JDBC and the fly likes JDBC & JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC & JSP" Watch "JDBC & JSP" New topic
Author

JDBC & JSP

msridhar reddy
Greenhorn

Joined: Apr 28, 2001
Posts: 5
I want to Know how to insert multiple records at a time in a table from the jsp page. to make it i clear, I explain what i am doing. At first i have a html page which consists of a table and multiple rows. I will be giving inputs in multiple records. After submitting this page, It will open the JDBC connection. But how to get all the values which i had given as the input and how to store the same in database using JDBC?
------------------
Sridhar Reddy Mosali


Sridhar Reddy Mosali
Daniel Dunleavy
Ranch Hand

Joined: Mar 13, 2001
Posts: 276
I might be missing your point, but it seems straightforward.
You have to create a loop going through each row in your table -- making sure it has data and is valid, and do an insert for each of the html rows.
Dan
msridhar reddy
Greenhorn

Joined: Apr 28, 2001
Posts: 5
Hi Dan,
I am submitting the data in an HTML Table format and the rows are in multiple number. The validations have been done. And the number of rows is not constant always in the input screen table. How to get the count the rows of an html table. Please give me an example code.
Thank U,
Sridhar Reddy
msridhar reddy
Greenhorn

Joined: Apr 28, 2001
Posts: 5
Hi Dan,
how can I get the multiple number of records from an HTML page into a loop. Please help me by giving an example code.
Thank you
Sridhar Reddy Mosali
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JDBC & JSP
 
Similar Threads
Submit parent and child records using JSP
Problem with selecting Check box in a jsp
Paging with JDBC/JSP/Servlet
JSP with XML
batch insertion into database