File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 63858

"makmak makmak" please check your private messages.

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

Joined: Oct 23, 2005
Posts: 3753


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
It's not a secret anymore!