• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Loading data from ArrayList to d/b Table

 
Pete
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have this scenario,I have a bunch of methods to get data for different columns of a JSP. What I do is I run these methods and make one ArrayLists for each column of JSP and populate the data in the JSP by iterating over the ArrayLists.
Now these methods take a while to load data for the JSP. To fasten the process we are planning to load data from the ArrayLists to a d/b table and retrieve the data from that table for the JSP.

My question what is the most effecient way to load data from arraylist to a table? Would it be multiple INSERT queies kind of thing?
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65216
95
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"makmak makmak" please check your private messages.
 
Scott Selikoff
author
Saloon Keeper
Posts: 4028
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Pete"

Your name still does not conform to the JavaRanch Naming Policy. Please review the policy and update it appropriately. This is your second warning.

Scott
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic