ResultSetMetaData m = rs.getMetaDate();
int numberOfColumns = rsmd.getColumnCount();
for(int i=1;i<=numberOfColumns ;i++){
System.out.println(m.getColumnName(i);
System.out.println(m.getColumnType(i);
}http://gceclub.sun.com.cn/Java_Docs/html/zh_CN/api/java/sql/ResultSetMetaData.html
int numberOfColumns = rsmd.getColumnCount();
for(int i=1;i<=numberOfColumns ;i++){
System.out.println(m.getColumnName(i);
System.out.println(m.getColumnType(i);
}http://gceclub.sun.com.cn/Java_Docs/html/zh_CN/api/java/sql/ResultSetMetaData.html
ResultSetMetaData rsmd=rs.getMetaData();
int col=rsmd.getColumnCount(); while(rs.next())
{
for(int i=0;i<col;i++)
{
System.out.print(rsmd.getColumnName(i)+" : "+rs.getString(i)+"");
rs.next();
}
System.out.println();
}