You may want to look into batch updates: http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/batchupdates.html
Quoting Julia Weaver <[EMAIL PROTECTED]>: > Andrew, Thanks for your fast response. > > Yes, my user need to edit a whole bunch of records > (rows), and there might be more than 20, and for each > update, my code have to call updateRecord method to > connect to database, and do the following: > try { > stmt = conn.prepareStatement(stringSQL); > rs = stmt.executeQuery(); > while (rs.next()) { > > ...update record.... > > rs.close(); > stmt.close(); > > ...disconnect database... > > For each record process the code, so the performance > is very slow... > > Could you please give me more help? > > > > --- Andrew Hill <[EMAIL PROTECTED]> > wrote: > > You mean like edit a whole bunch of records (rows) > > at one go where you dont > > necessarily know how many there are, etc...? > > > > Take a look at the examples here: > > http://www.keyboardmonkey.com/next/index.jsp > > (btw: You didnt really make your problem very clear > > so I hope this was what > > you meant) > > > > > > > > -----Original Message----- > > From: Julia Weaver > > [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, 23 December 2003 22:12 > > To: Struts Users Mailing List > > Subject: how to perform update records faster? > > > > > > Hi All, > > > > Can someone please tell me how I able to do > > update/modify records faster? My user need to > > click/select individual records to update in one big > > table(or one web page). Since there are so many > > records need to update continually, is a way can > > perform faster? Someone told me using session and > > Arraylist, another person told me using pop-up > > window, > > but I do not know how to use these specifially, can > > anyone help me? > > > > Thanks, -- Kris Schneider <mailto:[EMAIL PROTECTED]> D.O.Tech <http://www.dotech.com/> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]