There is a batch update example at
http://technet.oracle.com/tech/java/sqlj_jdbc/ under the Sample Code
section.
^g
Portal Team wrote:
>
> Hi
>
> I have around 100 records worth of data which i collect from the client and
> i need to update the database.
>
> Eg. of one record :
> DateOfInput TimeOfInput InputPerson CompanyCode DateOfChange NewValue
>
> I have all the data in input boxes and their names are sequential eg
> fDate1 fDate2 ..fDate100 fTime1 fTime2.. fTime100........
>
> what i am doing is
>
> First i loop through once and take care of all validations on the client
> side.
>
> i am giving an example for 2 fields
> <!-- create connection to database -->
> <%
> for (i=1 ; i<100; i++)
> {
> Df=fDate + i;
> tf=fTime +i;
>
> dDate=request.getParameter(df);
> dTime=request.getParameter(tf);
>
> <!-- code to insert above values into table -->
>
> }
> %>
>
> This means i would have 100 insert statemets being executed.
>
> I am not sure this is the best way.. and am new to JSP and JDBC. I would
> appreciate your suggestions / comments.
>
> This data updation is happening over the internet and the database is
> Oracle8i.
>
> thanks in advance
> Vineet
--
__________________________________________________________________
Geoff Grandstaff [EMAIL PROTECTED]
eBusiness Technology Solutions
Enterprise Technology Center
Internet Platform Sales
Oracle Corporation
1100 Abernathy Road
BLDG 500, Suite 1120
Atlanta, GA 30328
The statements and opinions expressed here are my own and
do not necessarily represent those of ORACLE Corporation.
__________________________________________________________________
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
