结果集到列表 [英] Resultset To List

问题描述

我想在我的JSP页面中将Resultset转换为List。并希望显示所有值。这是我的查询：

I want to convert my Resultset to List in my JSP page. and want to display all the values. This is my query:

SELECT userId, userName 
  FROM user;

我已经使用 preparedstatement 执行了该操作，并获得了 Resultset 即可。但是如何将其转换为列表并希望显示如下结果：

I have executed that using preparedstatement and got the Resultset. But how to convert it as a List and want to display the result like this:

userID  userName
------------------
1001    user-X 
1006    user-Y  
1007    user-Z

推荐答案

您需要遍历 ResultSet 对象在一个循环中，逐行，拉出每个列值：

You need to iterate over the ResultSet object in a loop, row by row, to pull out each column value:

List ll = new LinkedList();
ResultSet rs = stmt.executeQuery("SELECT userid, username FROM USER");

// Fetch each row from the result set
while (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);
}

这篇关于结果集到列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！