//Step 3, continued
if (set != null)
{
int columns = 0;
try
{
ResultSetMetaData meta = set.getMetaData();
columns = meta.getColumnCount();
for (int i=1;i<=columns;i++)
{
System.out.print(meta.getColumnLabel(i) + "(" + meta.getColumnTypeName(i) + ")");
System.out.print("\t\t");
}
System.out.println();
}
catch (SQLException e) {System.err.println(e); }
try
{
while (set.next())
{
for (int i=1;i<=columns;i++)
{
Object obj = set.getObject(i);
System.out.print(obj);
System.out.print("\t");
}
System.out.println(); }
}
catch (SQLException e){ System.err.println(e); }
}
|