java连接数据库并显示到窗口上少了一行数据?这是为啥?
public Collection getTableCollection(String sqlString){
Collection collection=new Vector();
try{new CommonJdbc();
Connection con=CommonJdbc.connection;
ResultSet rs=con.prepareStatement(sqlString).executeQuery();
ResultSetMetaData rsmd=rs.getMetaData();
Vector vtitle= new Vector();
for(int i=1;i<=rsmd.getColumnCount();i++)
{
vtitle.add(rsmd.getColumnName(i));
}
collection.add(vtitle);
while(rs.next())
{
Vector vdata=new Vector();
for(int i=1;i<=rsmd.getColumnCount();i++){
vdata.add(rs.getObject(i));
}collection.add(vdata);
}
}catch(SQLException e){
e.printStackTrace();
collection=null;
}
return collection;
}
连接数据库并且遍历数据,为啥不加下面这句话,就会数据库显示表格信息就会少一行?
for(int i=1;i<=rsmd.getColumnCount();i++)
{
vtitle.add(rsmd.getColumnName(i));
}
collection.add(vtitle);