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

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: 63208

"makmak makmak" please check your private messages.

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

Joined: Oct 23, 2005
Posts: 3740


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]
Have you checked out Aspose?
subject: Loading data from ArrayList to d/b Table
It's not a secret anymore!