Question

jsp中如何把ResultSet rs中的结果放入list中再循环取出呢？

String mno=request.getParameter("mno");

String sql="select seatno from seatchoose where mno='"+mno+"'";

ResultSet rs=SQLHelper.executeQuery(sql);
请教下接下去该怎么写

Answer 1

1.

List list = new ArrayList();
try {
rs = ps.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
while(rs.next()){
for(int i=1;i<=columnCount;i++){
//这里也可以放到MAP里面
String columnName = rsmd.getColumnName(i);
Object value = rs.getObject(i);
list.add(columnName+":"+value);
}
}
} catch (Exception e) {
// TODO: handle exception
}

Answer 2

while (rs.next())
 {
 rs.getString("seatno")
 }
 rs.close();

追问

那如果我想逐个输出该怎么办，比如就用system.out.println();来说呢

追答

while (rs.next())
 {
 System.out.println(rs.getString("seatno"))
 }
 rs.close();