您需要在循环中逐行遍历 ResultSet 对象，以提取每个列值：
List ll = new linkedList();ResultSet rs = stmt.executeQuery("SELECt userid, username FROM USER");// Fetch each row from the result setwhile (rs.next()) { int i = rs.getInt("userid"); String str = rs.getString("username"); //Assuming you have a user object User user = new User(i, str); ll.add(user);}
