Guest User

Untitled

a guest
Dec 10th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. @RequestMapping(value = "/export_data")
  2. public void downloadDataInCsv(
  3. @RequestParam("type") String type,
  4. @RequestParam("tID") String tableId,
  5. HttpServletRequest request,
  6. HttpServletResponse response) throws IOException {
  7. if (type.equals("csv")) {
  8. List<UserInfo> list = userInfoDao.findById(tableId);
  9. ExportCsvUtil.downloadCsv(request, response, list);
  10. }
  11. }
  12. private void downloadCsv(HttpServletRequest request, HttpServletResponse response, List<UserInfo> list) throws IOException {
  13. String headerKey = "Content-Disposition";
  14. String headerValue = String.format("attachment; filename=Table_Data.csv");
  15. response.setContentType("text/csv");
  16. response.setHeader(headerKey, headerValue);
  17.  
  18. try (final CSVWriter writer = new CSVWriter(response.getWriter(), ",")) {
  19.  
  20. writer.writeNext(new String[]{"User Id", "First Name", "Last Name", "Roll No", "Email ID", "Gender"});
  21.  
  22. for (UserInfo entry: list) {
  23. // cast/convert to String where needed
  24. writer.writeNext(new String[]{entry.getUserId()+"", entry.getFirstName(), entry.getLastName(),entry.getRollNo(),entry.getEmail(),entry.getGender()});
  25. }
  26. writer.close();
  27. }
  28. }
Add Comment
Please, Sign In to add comment