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>