package manager

public List<User> getAllUsers() throws SQLException { Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery("select * from user"); List<User> users = new ArrayList<>(); while (resultSet.next()) { User user = new User(); user.setId(resultSet.getInt(1)); user.setName(resultSet.getString(2)); user.setSurname(resultSet.getString(3)); user.setEmail(resultSet.getString(4)); user.setPassword(resultSet.getString(5)); user.setPicUrl(resultSet.getString(6)); users.add(user); } return users; }

}

package serlvet

  @WebServlet(urlPatterns = "/userHomeServlet") public class UserHomeServlet extends HttpServlet { @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { UserManager userManager = new UserManager(); try { List<User> allUsers = userManager.getAllUsers(); req.setAttribute("users", allUsers); req.getRequestDispatcher("/userHome.jsp").forward(req,resp); } catch (SQLException e) { e.printStackTrace(); } } }

web

  <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>userHome</title> </head> <body> <% List<User> users = (List<User>) request.getAttribute("users");%> <%for (User user : users) {%> <div><%=user.getName()%> <div><%=user.getSurname()%> <%}%> </body> </html>
  • Formulate the question more precisely. what exactly does not work? get an exception or not, and if not, at what stage of the problem? From the database get a list of users? - Dmitriy

1 answer 1

Start by putting in order the data to fill the user. Java is not PHP. Java strongly typed language.

And yes, as they have rightly suggested to you - Show the text of the error or what is happening there.