列表导出方法简单实现,导出格式可以根据返回数据具体更改
public ResultData exportUserList(UserSearchRequest userSearchRequest, HttpServletResponse response) {
ResultData resultData = new ResultData();
// 用户数据
List<UserSearchVo> userSearchVos = userDao.userList(userSearchRequest);
PageInfo<UserSearchVo> list = new PageInfo<>(userSearchVos);
if (list.getTotal() > 0) {
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
// excel标题
String[] title = {
"ID", "头像", "姓名", "性别", "手机号", "用户类型", "用户等级", "余额", "佣金余额", "注册时间"};