public static void main(String argv[]){
Connection conn=null;
conn=connect();
try {
Statement statement = conn.createStatement();
String sql = "select * from user";
ResultSet rs = statement.executeQuery(sql);
while(rs.next()){
for(int i=0;i<rs.getMetaData().getColumnCount();i++){
System.out.print(rs.getObject(i+1));
System.out.print("\t");
}
System.out.println("");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
ResultSet的getMetaData()之后的getColumnCount()方法能够得到当前一条记录集的长度遍历ResultSet结果集
最新推荐文章于 2022-10-10 11:00:09 发布