@RequestMapping( value = "**/downloadStatement", method = {RequestMethod.POST, RequestMethod.GET}) public ModelAndView downloadStatement( HttpServletRequest request, HttpServletResponse response, HttpSession session) throws IOException, SQLException { LoginHandler handler = new LoginHandler(); String userName = (String) session.getAttribute("USERNAME"); ResultSet rs = handler.requestTrasactionDetails(userName); List<TransactionRequestDetails> transactionDetails = new ArrayList<TransactionRequestDetails>(); while (rs.next()) { TransactionRequestDetails details = new TransactionRequestDetails(); details.setTransactionID(rs.getString("transactionid")); details.setTransactionAmount(rs.getString("transactionamount")); details.setSourceAccount(rs.getString("sourceaccountnumber")); details.setDestAccount(rs.getString("destinationaccountnumber")); details.setDateandTime(rs.getString("dateandtime")); details.setTransferType(rs.getString("transfertype")); details.setStatus(rs.getString("status")); transactionDetails.add(details); } rs.close(); return new ModelAndView("WritePDF", "transactionDetails", transactionDetails); }