導(dǎo)出按鈕所對(duì)應(yīng)的jsp頁(yè)面userList.jsp
點(diǎn)擊導(dǎo)出按鈕,跳轉(zhuǎn)對(duì)應(yīng)的js頁(yè)面。
處理導(dǎo)出功能對(duì)應(yīng)的controller.
/**
* 導(dǎo)出用戶(hù)數(shù)據(jù)
* @param user
* @param request
* @param response
* @param redirectAttributes
* @return
*/
@RequiresPermissions("sys:user:view")
@RequestMapping(value = "export", method=RequestMethod.POST)
public String exportFile(User user, HttpServletRequest request, HttpServletResponse response, RedirectAttributes redirectAttributes) {
try {
String fileName = "用戶(hù)數(shù)據(jù)"+DateUtils.getDate("yyyyMMddHHmmss")+".xlsx";
Page<User> page = systemService.findUser(new Page<User>(request, response, -1), user);
new ExportExcel("用戶(hù)數(shù)據(jù)", User.class).setDataList(page.getList()).write(response, fileName).dispose();
return null;
} catch (Exception e) {
addMessage(redirectAttributes, "導(dǎo)出用戶(hù)失斚陨颉两芳!失敗信息:"+e.getMessage());
}
return "redirect:" + adminPath + "/sys/user/list?repage";
}
一定記得在對(duì)應(yīng)的實(shí)體類(lèi)中驯鳖,給實(shí)體類(lèi)的屬性加上@ExcelField(title="歸屬公司", align=2, sort=20)注解
最后編輯于 :
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請(qǐng)聯(lián)系作者