Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Iterate through columns in tables. 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 "Iterate through columns in tables." Watch "Iterate through columns in tables." New topic
Author

Iterate through columns in tables.

Koos Kombuis
Greenhorn

Joined: Mar 10, 2009
Posts: 5
Hi guys,

I'm a bit stuck here, I'm not that comfortable with SQL and would like to get a push into the right direction.

What I'm trying to do is, compare Java fields via reflection to those in an Oracle DB.

The reflection part isn't the problem though..

How will I go about it to get a table with a given name and loop through all the columns/fields inside the specified table?

Thanks in advance.
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3702
    
    5

getMetaData is your friend.


My Blog: Down Home Country Coding with Scott Selikoff
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Iterate through columns in tables.
 
Similar Threads
Present Database Field LIst
Callable statement ...?
Help using OJB and Criteria.addLike()
Basic question regarding Hibernate, Oracle and Sequence Numbers
Serializable Problem