aspose file tools*
The moose likes JDBC 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
Bookmark "Loading data from ArrayList to d/b Table" Watch "Loading data from ArrayList to d/b Table" New topic
Author

Loading data from ArrayList to d/b Table

Pete
Greenhorn

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

Joined: Jan 10, 2002
Posts: 61413
    
  67

"makmak makmak" please check your private messages.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

"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


My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Loading data from ArrayList to d/b Table