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
