This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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
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: 63208
    
  69

"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: 3740
    
  10

"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


[OCA 8 Book] [Blog]
 
Have you checked out Aspose?
 
subject: Loading data from ArrayList to d/b Table
 
It's not a secret anymore!