java控制台现在能输出最新用户信息,怎么使用List输出所有用户信息

Servlet


protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        Connection conn = null;
        conn = DBHelper.getConnection();
        String sql="select * from root";
        try {
            Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery(sql);
//            List<User> list=new ArrayList<>();
            User user = new User();
            while(rs.next()) {
                
                user.setRootId(rs.getInt("rootId"));
                user.setRootName(rs.getString("rootName"));
                user.setRootPass(rs.getString("rootPass"));
//                list.add(user);
            }

            //将数据库中查询到的信息封装在user对象中,use对象保存在request中,之后将通过request对象将数据传递到页面
            //需要的话也可以只传递一个参数request.setAttribute("id", user.getId());
            request.setAttribute("user", user);
            //这里是转发,从Servlet跳转到showinfo.jsp页面,并且带上request和response对象中原有的参数
            request.getRequestDispatcher("/showinfo.jsp").forward(request, response);

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

jsp


<%
    User user = (User)request.getAttribute("user");

%>

id:<%=user.getRootId() %>
username:<%=user.getRootName() %>
password:<%=user.getRootPass() %>

把注释的List代码放开,用request.setAttribute设置变量

request.setAttribute("list",list);

在页面用forEach循环输出。

<c:forEach item="${list} var="d">

</c:forEach>