Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Devaka Cooray
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Tim Moores
  • Carey Brown
  • Mikalai Zaikin
Bartenders:
  • Lou Hamers
  • Piet Souris
  • Frits Walraven

JDBC & JSP

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
reply
    Bookmark Topic Watch Topic
  • New Topic