@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);
}
