| | |
| | | package com.whyc.pojo; |
| | | |
| | | import cn.afterturn.easypoi.excel.annotation.Excel; |
| | | import cn.afterturn.easypoi.excel.annotation.ExcelTarget; |
| | | import cn.afterturn.easypoi.handler.inter.IExcelDataModel; |
| | | import cn.afterturn.easypoi.handler.inter.IExcelModel; |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.*; |
| | | import org.apache.ibatis.type.Alias; |
| | | import org.apache.poi.ss.formula.functions.T; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | @ExcelTarget("User") |
| | | @Alias("User") |
| | | @TableName( schema = "`db_3.5mw_web`",value = "tb_user") |
| | | public class User { |
| | | @Data |
| | | @ApiModel |
| | | public class User implements IExcelDataModel, IExcelModel { |
| | | @TableField(exist = false) |
| | | private Integer rowNum; |
| | | @TableField(exist = false) |
| | | private String errorMsg; |
| | | |
| | | @TableId |
| | | private Integer id; |
| | | @ApiModelProperty("用户账号") |
| | | @Excel(name = "账号",width = 25,orderNum = "1",isImportField = "true_st") |
| | | private String name; |
| | | @ApiModelProperty("用户密码") |
| | | @Excel(name = "密码",width = 25,orderNum = "2",isImportField = "true_st") |
| | | private String password; |
| | | @ApiModelProperty("姓名") |
| | | @Excel(name = "姓名",width = 25,orderNum = "3",isImportField = "true_st") |
| | | private String realName; |
| | | @ApiModelProperty("性别") |
| | | @Excel(name = "性别",replace = {"男_0","女_1"},width = 25,orderNum = "4",isImportField = "true_st") |
| | | private Integer sex; |
| | | @ApiModelProperty("手机号") |
| | | @Excel(name = "手机号",width = 25,orderNum = "5",isImportField = "true_st") |
| | | private String phone; |
| | | @ApiModelProperty("邮箱地址") |
| | | @Excel(name = "邮箱地址",width = 25,orderNum = "6",isImportField = "true_st") |
| | | private String email; |
| | | @ApiModelProperty("部门") |
| | | @Excel(name = "部门",width = 25,orderNum = "7",isImportField = "true_st") |
| | | private String dept; |
| | | @ApiModelProperty("职务") |
| | | @Excel(name = "职务",width = 25,orderNum = "8",isImportField = "true_st") |
| | | private String job; |
| | | @ApiModelProperty("加密因子") |
| | | private String salt; |
| | | @ApiModelProperty("状态:0正常,1冻结") |
| | | //@Excel(name = "状态",width = 25,orderNum = "9",isImportField = "true_st") |
| | | private Integer state; |
| | | @JsonFormat(locale = "zh",timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss") |
| | | private Date createTime; |
| | | @ApiModelProperty("模糊查询信息") |
| | | @TableField(exist = false) |
| | | private String search; |
| | | @ApiModelProperty("是否被选中") |
| | | @TableField(exist = false) |
| | | private boolean selected; |
| | | |
| | | public User() { |
| | | } |
| | |
| | | this.name = name; |
| | | } |
| | | |
| | | |
| | | public Integer getId() { |
| | | return id; |
| | | } |
| | | |
| | | public void setId(Integer id) { |
| | | public User(int rowNum, String errorMsg, Integer id, String name, String password, String realName, Integer sex, String phone, String email, String dept, String job, String salt, Integer state, Date createTime) { |
| | | this.rowNum = rowNum; |
| | | this.errorMsg = errorMsg; |
| | | this.id = id; |
| | | } |
| | | |
| | | public String getName() { |
| | | return name; |
| | | } |
| | | |
| | | public void setName(String name) { |
| | | this.name = name; |
| | | } |
| | | |
| | | public String getPassword() { |
| | | return password; |
| | | } |
| | | |
| | | public void setPassword(String password) { |
| | | this.password = password; |
| | | } |
| | | |
| | | public String getSalt() { |
| | | return salt; |
| | | } |
| | | |
| | | public void setSalt(String salt) { |
| | | this.realName = realName; |
| | | this.sex = sex; |
| | | this.phone = phone; |
| | | this.email = email; |
| | | this.dept = dept; |
| | | this.job = job; |
| | | this.salt = salt; |
| | | } |
| | | |
| | | public Date getCreateTime() { |
| | | return createTime; |
| | | } |
| | | |
| | | public void setCreateTime(Date createTime) { |
| | | this.state = state; |
| | | this.createTime = createTime; |
| | | } |
| | | |
| | | |
| | | } |