From e8514175f6cf73c5d006ec4d253afb46b18f1840 Mon Sep 17 00:00:00 2001
From: whyczh <hzjl@qq.com>
Date: 星期三, 28 四月 2021 09:25:40 +0800
Subject: [PATCH] 添加批量导入用户功能
---
src/main/java/com/whyc/pojo/User.java | 31 ++++++++++++++++++++++++++++---
1 files changed, 28 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/whyc/pojo/User.java b/src/main/java/com/whyc/pojo/User.java
index 048dcfe..da5227e 100644
--- a/src/main/java/com/whyc/pojo/User.java
+++ b/src/main/java/com/whyc/pojo/User.java
@@ -1,5 +1,10 @@
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.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
@@ -7,32 +12,48 @@
import lombok.*;
import org.apache.ibatis.type.Alias;
+import java.io.Serializable;
import java.util.Date;
+@ExcelTarget("User")
@Alias("User")
@TableName( schema = "`db_3.5mw_web`",value = "tb_user")
@Data
@ApiModel
-public class User {
+public class User implements IExcelDataModel, IExcelModel {
+ @TableField(exist = false)
+ private Integer rowNum;
+ @TableField(exist = false)
+ private String errorMsg;
+
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("鐪熷疄濮撳悕")
+ @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鍐荤粨锛�2鍒犻櫎")
+ //@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;
@@ -45,7 +66,9 @@
this.name = name;
}
- public User(Integer id, String name, String password, String realName, Integer sex, String phone, String email, String dept, String job, String salt, Integer state, Date createTime) {
+ 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;
this.name = name;
this.password = password;
@@ -59,4 +82,6 @@
this.state = state;
this.createTime = createTime;
}
+
+
}
--
Gitblit v1.9.1