File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes [Help] Store database table in ArrayList for lookup Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "[Help] Store database table in ArrayList for lookup" Watch "[Help] Store database table in ArrayList for lookup" New topic
Author

[Help] Store database table in ArrayList for lookup

Jake Lee
Greenhorn

Joined: Apr 02, 2002
Posts: 18
I have a table in Oracle, which has 7 columns and 40 rows of entries.
I want to retrieve the whole table and store it in ArrayList for later lookup.
Anyone has some sample code for this?
Thanks a lot.
W
Pauline McNamara
Sheriff

Joined: Jan 19, 2001
Posts: 4012
    
    6
"Wishmaster",
Could you please change your display name to comply with JavaRanch's naming policy? (It's our only rule.) You can make the change quickly right here. Thanks, and welcome to JavaRanch.

Pauline
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

what have you done so far? You can find a whole lot of sample code for Oracle and jdbc here
Jamie
Jake Lee
Greenhorn

Joined: Apr 02, 2002
Posts: 18
Thanks a lot...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: [Help] Store database table in ArrayList for lookup
 
Similar Threads
Hashset, Hashtable and Hashmap
ArrayList does it maintain order
how to get the table column name as key of the hasmap and values as arraylist in hibernate
Retrieving Database Table Column names using JDBC
search for a value within list of HashMaps