简单springboot实现Jxls导出excel

package com.lihm.springboot.domain; import java.io.Serializable; import java.math.BigDecimal; import java.util.List; /** * 会员信息查询结果封装 * @author Bryant * */ public class UserResultDTO implements Serializable{ private static final long serialVersionUID = 6522377111773993405L; /** * 主键，自增长 */ private Integer id; /** * 用户编号：按照一定规则生成 */ private String userId; /** * MD5密码 */ private String password; /** * MD5密码盐 */ private String salt; /** * 性别 ： 值为1时是男性，值为2时是女性，值为0时是未知 */ private Integer sex; /** * 手机 */ private String mobile; /** * 会员状态编码：1-正常 0-停用 */ private String status; /** * 会员状态显示 */ private String showStatus; /** * 是否注销：1 是，0否 */ private Integer isWriteoff; /** * 注销时间 */ private String writeoffTime; /** * 最后登录时间 */ private String lastLoginTime; private String updateBy; /** * 是否删除：1-是 0-否 */ private Integer deleteFlag; private String updateDate; private String createDate; /** * 微信openId */ private String openId; /** * 微信头像地址 */ private String headIcon; /** * 微信昵称 */ private String nickName; /** * 是否是微信用户：1-是 0-否 */ private Integer isWechatUser; /** * 姓名 */ private String name; /** * 生日 */ private String birthday; /** * 会员当前渠道ID：华夏银行，红塔集团 */ private Integer currentChannelId; /** * 会员当前渠道：华夏银行，红塔集团 */ private String currentChannelName; /** * 华夏银行渠道会员等级编号：普卡 金卡 贵宾卡 */ private String hxbChannelLevel; /** * 华夏银行渠道会员等级：普卡 金卡 贵宾卡 */ private String hxbChannelLevelName; /** * 华夏银行渠道会员等级更新时间 */ private String hxbChannelLevelUpdateTime; /** * 平台会员等级：与会员成长体系对应 */ private String userLevel; /** * 平台会员等级：与会员成长体系对应 */ private String userLevelName; /** * 会员消费金额 */ private BigDecimal userExpense; /** * 推荐人 */ private String referee; /** * 推荐人电话 */ private String refereePhone; /** * 银行账号 */ private String bankCardNo; /** * 银行账号姓名 */ private String bankCardName; /** * 银行预留手机 */ private String bankCardPhone; /** * 身份证号码 */ private String bankCardIdNum; /** * 会员所有渠道名称 */ private String userChannelsName; /** * 用户渠道 */ List<UserChannelDTO> userChannelDTOS; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getUserId() { return userId; } public void setUserId(String userId) { this.userId = userId; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getSalt() { return salt; } public void setSalt(String salt) { this.salt = salt; } public Integer getSex() { return sex; } public void setSex(Integer sex) { this.sex = sex; } public String getMobile() { return mobile; } public void setMobile(String mobile) { this.mobile = mobile; } public String getStatus() { return status; } public void setStatus(String status) { this.status = status; } public String getShowStatus() { return showStatus; } public void setShowStatus(String showStatus) { this.showStatus = showStatus; } public Integer getIsWriteoff() { return isWriteoff; } public void setIsWriteoff(Integer isWriteoff) { this.isWriteoff = isWriteoff; } public String getWriteoffTime() { return writeoffTime; } public void setWriteoffTime(String writeoffTime) { this.writeoffTime = writeoffTime; } public String getLastLoginTime() { return lastLoginTime; } public void setLastLoginTime(String lastLoginTime) { this.lastLoginTime = lastLoginTime; } public String getUpdateBy() { return updateBy; } public void setUpdateBy(String updateBy) { this.updateBy = updateBy; } public Integer getDeleteFlag() { return deleteFlag; } public void setDeleteFlag(Integer deleteFlag) { this.deleteFlag = deleteFlag; } public String getUpdateDate() { return updateDate; } public void setUpdateDate(String updateDate) { this.updateDate = updateDate; } public String getCreateDate() { return createDate; } public void setCreateDate(String createDate) { this.createDate = createDate; } public String getOpenId() { return openId; } public void setOpenId(String openId) { this.openId = openId; } public String getHeadIcon() { return headIcon; } public void setHeadIcon(String headIcon) { this.headIcon = headIcon; } public String getNickName() { return nickName; } public void setNickName(String nickName) { this.nickName = nickName; } public Integer getIsWechatUser() { return isWechatUser; } public void setIsWechatUser(Integer isWechatUser) { this.isWechatUser = isWechatUser; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getBirthday() { return birthday; } public void setBirthday(String birthday) { this.birthday = birthday; } public Integer getCurrentChannelId() { return currentChannelId; } public void setCurrentChannelId(Integer currentChannelId) { this.currentChannelId = currentChannelId; } public String getCurrentChannelName() { return currentChannelName; } public void setCurrentChannelName(String currentChannelName) { this.currentChannelName = currentChannelName; } public String getHxbChannelLevel() { return hxbChannelLevel; } public void setHxbChannelLevel(String hxbChannelLevel) { this.hxbChannelLevel = hxbChannelLevel; } public String getHxbChannelLevelName() { return hxbChannelLevelName; } public void setHxbChannelLevelName(String hxbChannelLevelName) { this.hxbChannelLevelName = hxbChannelLevelName; } public String getHxbChannelLevelUpdateTime() { return hxbChannelLevelUpdateTime; } public void setHxbChannelLevelUpdateTime(String hxbChannelLevelUpdateTime) { this.hxbChannelLevelUpdateTime = hxbChannelLevelUpdateTime; } public String getUserLevel() { return userLevel; } public void setUserLevel(String userLevel) { this.userLevel = userLevel; } public String getUserLevelName() { return userLevelName; } public void setUserLevelName(String userLevelName) { this.userLevelName = userLevelName; } public BigDecimal getUserExpense() { return userExpense; } public void setUserExpense(BigDecimal userExpense) { this.userExpense = userExpense; } public String getReferee() { return referee; } public void setReferee(String referee) { this.referee = referee; } public String getRefereePhone() { return refereePhone; } public void setRefereePhone(String refereePhone) { this.refereePhone = ref