1、返回结果集后,遍历结果集的语句:
while(rs.next()){
id = rs.getInt("id");
agentId = rs.getString("agentid");
language = rs.getString("language");
time = rs.getString("time");
for(int i=0;i<6;i++){
arrStrAns[i]=rs.getString("ans"+(i+1));
}
}
或者
while(rs.next()){
System.out.println(rs.getObject(1));
}
注意到上述方法取不到标题名称。如果要取标题名称,要用到metadata,请看下面的例子: