It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Loading data from ArrayList to d/b Table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Loading data from ArrayList to d/b Table" Watch "Loading data from ArrayList to d/b Table" New topic

Loading data from ArrayList to d/b Table


Joined: Nov 24, 2007
Posts: 1
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

Joined: Jan 10, 2002
Posts: 63532

"makmak makmak" please check your private messages.

[Asking smart questions] [About Bear] [Books by Bear]
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3749


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


[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Loading data from ArrayList to d/b Table
jQuery in Action, 3rd edition