Hi,
page 545, JDBC API tutorial and reference by White et
al., use PreparedStatement with addBatch() and
executeBatch().
ron
--- Portal Team <[EMAIL PROTECTED]> 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
>
>
______________________________________________________
> Get Your Private, Free Email at
> http://www.hotmail.com
>
>
===========================================================================
> 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
>
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
===========================================================================
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
