public void printResultSet(ResultSet rs)throws SQLException
{
//就是为了获得ResultSet的表头
ResultSetMetaData rsmd = rs.getMetaData();
for(int i = 0;i<rsmd.getColumnCount();i++){
System.out.print(rsmd.getColumnName(i+1)+ "\t");
}
System.out.print("\n");
//下面的next()已经移了cursor了
while(rs.next()){
//使用i< rsmd.getColumnCount()就不用知道ResultSet到底有几列了
for(int i = 0; i< rsmd.getColumnCount();i++){
System.out.print(rs.getString(i+1)+"\t");
}
System.out.print("\n");
}
rs.close();
}