From cc01f01a9ff12f4167d7d5d40bc3cff2ffb366c6 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 15 十一月 2022 15:51:20 +0800
Subject: [PATCH] Excel数据操作

---
 src/main/java/com/lf/server/entity/bs/Gxcg.java |  111 +++++++++++++++++++++++++++++++++++++------------------
 1 files changed, 74 insertions(+), 37 deletions(-)

diff --git a/src/main/java/com/lf/server/entity/bs/Gxcg.java b/src/main/java/com/lf/server/entity/bs/Gxcg.java
index 772fec1..4aae1ec 100644
--- a/src/main/java/com/lf/server/entity/bs/Gxcg.java
+++ b/src/main/java/com/lf/server/entity/bs/Gxcg.java
@@ -1,15 +1,19 @@
 package com.lf.server.entity.bs;
 
 import com.alibaba.excel.annotation.ExcelProperty;
-import com.lf.server.annotation.HeadRowNumber;
+import com.lf.server.annotation.ExcelHead;
+import lombok.AllArgsConstructor;
 import lombok.Data;
+import lombok.NoArgsConstructor;
 
 /**
  * 绠￠亾鎴愭灉琛�
  * @author WWW
  */
 @Data
-@HeadRowNumber(value = 3)
+@NoArgsConstructor
+@AllArgsConstructor
+@ExcelHead(headRows = 3,excludeSheets = "灏侀潰,鐩綍")
 public class Gxcg {
     @ExcelProperty(index = 0)
     private String bh;
@@ -18,42 +22,51 @@
     private String gxdh;
 
     @ExcelProperty(index = 2)
-    private String bh2;
+    private String ljdh;
 
     @ExcelProperty(index = 3)
     private String msfs;
 
     @ExcelProperty(index = 4)
-    private String chiChun;
+    private String gxcl;
 
     @ExcelProperty(index = 5)
-    private String tz;
+    private String gjcc;
 
     @ExcelProperty(index = 6)
-    private String fsw;
+    private String tz;
 
     @ExcelProperty(index = 7)
-    private double x;
+    private String fsw;
 
     @ExcelProperty(index = 8)
-    private double y;
+    private Double x;
 
     @ExcelProperty(index = 9)
-    private String gnd;
+    private Double y;
 
     @ExcelProperty(index = 10)
-    private double ms;
+    private Double dm;
 
     @ExcelProperty(index = 11)
-    private String zks;
+    private Double gd;
 
     @ExcelProperty(index = 12)
-    private String gkpl;
+    private Double gnd;
 
     @ExcelProperty(index = 13)
-    private String dy;
+    private Double ms;
 
     @ExcelProperty(index = 14)
+    private String dngs;
+
+    @ExcelProperty(index = 15)
+    private String gkpl;
+
+    @ExcelProperty(index = 16)
+    private String dldy;
+
+    @ExcelProperty(index = 17)
     private String bz;
 
     public String getBh() {
@@ -72,12 +85,12 @@
         this.gxdh = gxdh;
     }
 
-    public String getBh2() {
-        return bh2;
+    public String getLjdh() {
+        return ljdh;
     }
 
-    public void setBh2(String bh2) {
-        this.bh2 = bh2;
+    public void setLjdh(String ljdh) {
+        this.ljdh = ljdh;
     }
 
     public String getMsfs() {
@@ -88,12 +101,20 @@
         this.msfs = msfs;
     }
 
-    public String getChiChun() {
-        return chiChun;
+    public String getGxcl() {
+        return gxcl;
     }
 
-    public void setChiChun(String chiChun) {
-        this.chiChun = chiChun;
+    public void setGxcl(String gxcl) {
+        this.gxcl = gxcl;
+    }
+
+    public String getGjcc() {
+        return gjcc;
+    }
+
+    public void setGjcc(String gjcc) {
+        this.gjcc = gjcc;
     }
 
     public String getTz() {
@@ -112,44 +133,60 @@
         this.fsw = fsw;
     }
 
-    public double getX() {
+    public Double getX() {
         return x;
     }
 
-    public void setX(double x) {
+    public void setX(Double x) {
         this.x = x;
     }
 
-    public double getY() {
+    public Double getY() {
         return y;
     }
 
-    public void setY(double y) {
+    public void setY(Double y) {
         this.y = y;
     }
 
-    public String getGnd() {
+    public Double getDm() {
+        return dm;
+    }
+
+    public void setDm(Double dm) {
+        this.dm = dm;
+    }
+
+    public Double getGd() {
+        return gd;
+    }
+
+    public void setGd(Double gd) {
+        this.gd = gd;
+    }
+
+    public Double getGnd() {
         return gnd;
     }
 
-    public void setGnd(String gnd) {
+    public void setGnd(Double gnd) {
         this.gnd = gnd;
     }
 
-    public double getMs() {
+    public Double getMs() {
         return ms;
     }
 
-    public void setMs(double ms) {
+    public void setMs(Double ms) {
         this.ms = ms;
     }
 
-    public String getZks() {
-        return zks;
+    public String getDngs() {
+        return dngs;
     }
 
-    public void setZks(String zks) {
-        this.zks = zks;
+    public void setDngs(String dngs) {
+        this.dngs = dngs;
     }
 
     public String getGkpl() {
@@ -160,12 +197,12 @@
         this.gkpl = gkpl;
     }
 
-    public String getDy() {
-        return dy;
+    public String getDldy() {
+        return dldy;
     }
 
-    public void setDy(String dy) {
-        this.dy = dy;
+    public void setDldy(String dldy) {
+        this.dldy = dldy;
     }
 
     public String getBz() {

--
Gitblit v1.9.3