Edit Question - KnowledgeHub

Title Body

For multiple image retrieval I am calling a PhotoHelperServlet with an anchor tag to get imageNames(multiple images) as follows PhotoHelperServlet to get names of Images protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // Getting userid from session Image image = new Image(); image.setUserid(userid); ImageDAO imageDAO = new ImageDAO(); try { List<Image> imageId = imageDAO.listNames(image); if (imageId == null) { // check if imageId is retreived } request.setAttribute("imageId", imageId); //Redirect it to home page RequestDispatcher rd = request.getRequestDispatcher("/webplugin/jsp/profile/photos.jsp"); rd.forward(request, response); catch (Exception e) { e.printStackTrace(); } In ImageDAO listNames() method : public List<Image> listNames(Image image) throws IllegalArgumentException, SQLException, ClassNotFoundException { Connection connection = null; PreparedStatement preparedStatement = null; ResultSet resultset = null; Database database = new Database(); List<Image> imageId = new ArrayList<Image>(); try { connection = database.openConnection(); preparedStatement = connection.prepareStatement(SQL_GET_PHOTOID); preparedStatement.setLong(1, image.getUserid()); resultset = preparedStatement.executeQuery(); while(resultset.next()) { image.setPhotoid(resultset.getLong(1)); imageId.add(image); } } catch (SQLException e) { throw new SQLException(e); } finally { close(connection, preparedStatement, resultset); } return imageId; } In JSP code: <c:forEach items="${imageId}" var="imageid"> <img src="Photos/${imageid}"> </c:forEach> </

Tags (comma-separated) Cancel