dynamic column names and it's values

[Edward Durai]

Consider I have a table Name, It's dynamic table. Column Names or it's data type is changable.

It contains lot of column names with different data type. How can I fetch all the rows in the Database.

if first column field type is date, then I have to use

rs.getDate(1); //

if it is String

rs.getString(1);

But in my situation,

It's dynamic table. Column Names or it's data type is changable.

Then How can I fetch all the rows? Please explain.

[Jeanne Boyarsky]

Edward,
You can always fetch all columns as Strings is you don't need them formatted in a certain way. The alternative is to use the result set meta data API to determine the specific data types.

[steve souza]

The getObject method returns the data and doesn't convert it to a String. This is useful should you ever need to manipulate the data in its original form via casting.

http://java.sun.com/j2se/1.4.2/docs/api/java/sql/ResultSet.html#getObject(int)

 
Object obj=rs.getObject(1);
 
if (obj instanceof Double) {
  Double doub=(Double) obj
  do doubly stuff
}