Print Resultset

[MAB]

How to print the contents of the resultset if the no. of columns and there
types are not known? If I know the no. of columns and types I can do

while (rs.next()) {
System.out.println( rs.getString(1) + ' ' + rs.getInt(2) ) ;
}

thx

 

[Brusque]

How to print the contents of the resultset if the no. of columns and there
types are not known? If I know the no. of columns and types I can do

while (rs.next()) {
System.out.println( rs.getString(1) + ' ' + rs.getInt(2) ) ;
}

thx

Look at the rs.getMetaData() method, and the resulting ResultSetMetaData
object. You can get the column count, plus the column types if you need to
(although you might be able to get away with just using rs.getObject(i)
depending on your JDBC driver)

 

[Alex Kizub]

Always use rs.getString(i); It gives you toString() presentation.
Alex Kziub.

 

[Donald Roby]

How to print the contents of the resultset if the no. of columns and there
types are not known? If I know the no. of columns and types I can do

while (rs.next()) {
System.out.println( rs.getString(1) + ' ' + rs.getInt(2) ) ;
}

thx

You might want to use ResultSetMetaData to find the info you're missing:

ResultSetMetaData rsmd = rs.getMetaData();

The ResultSetMetaData class has methods to tell you how many columns there
are and what their SQL datatypes are. You may still have to play with
datatype conversion somewhat, but this can help make some things much more
generic.