1.ResultSet的getInt、getString等方法的参数既可以是表的属性名,也可以是表的列号。例如下面的这张表:
ResultSet rs = stmt.excuteQuery(sql);
while(rs.next()){
int a = rs.getInt(1);
String s = rs.getString(5);
}
/**
int a = rs.getInt("SNo");
String s = rs.getString("Ssex");
*/