From 1cc39fcee029ead0aa87898d67023855ce24a419 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 21 十二月 2022 15:15:03 +0800
Subject: [PATCH] 1

---
 src/main/java/com/lf/server/extend/UpdateBatchMethod.java |    4 ++--
 src/main/java/com/lf/server/entity/all/StaticData.java    |    6 +++---
 src/main/java/com/lf/server/entity/all/BaseEntity.java    |   11 ++++++-----
 src/main/java/com/lf/server/extend/InsertBatchMethod.java |    6 +++---
 4 files changed, 14 insertions(+), 13 deletions(-)

diff --git a/src/main/java/com/lf/server/entity/all/BaseEntity.java b/src/main/java/com/lf/server/entity/all/BaseEntity.java
index 1cdf7d8..905a1ca 100644
--- a/src/main/java/com/lf/server/entity/all/BaseEntity.java
+++ b/src/main/java/com/lf/server/entity/all/BaseEntity.java
@@ -1,5 +1,6 @@
 package com.lf.server.entity.all;
 
+import com.baomidou.mybatisplus.annotation.FieldStrategy;
 import com.baomidou.mybatisplus.annotation.IdType;
 import com.baomidou.mybatisplus.annotation.TableField;
 import com.baomidou.mybatisplus.annotation.TableId;
@@ -31,19 +32,19 @@
 
     private Timestamp updatetime;
 
-    @TableField(value = "fn_rec_query(dirid,'dir')")
+    @TableField(value = "fn_rec_query(dirid,'dir')", updateStrategy = FieldStrategy.NEVER)
     private String dirName;
 
-    @TableField(value = "fn_rec_query(depid,'dep')")
+    @TableField(value = "fn_rec_query(depid,'dep')", updateStrategy = FieldStrategy.NEVER)
     private String depName;
 
-    @TableField(value = "fn_ver(verid)")
+    @TableField(value = "fn_ver(verid)", updateStrategy = FieldStrategy.NEVER)
     private String verName;
 
-    @TableField(value = "fn_uname(createuser)")
+    @TableField(value = "fn_uname(createuser)", updateStrategy = FieldStrategy.NEVER)
     private String createName;
 
-    @TableField(value = "fn_uname(updateuser)")
+    @TableField(value = "fn_uname(updateuser)", updateStrategy = FieldStrategy.NEVER)
     private String updateName;
 
     public BaseEntity() {
diff --git a/src/main/java/com/lf/server/entity/all/StaticData.java b/src/main/java/com/lf/server/entity/all/StaticData.java
index a6a7655..8e82dc4 100644
--- a/src/main/java/com/lf/server/entity/all/StaticData.java
+++ b/src/main/java/com/lf/server/entity/all/StaticData.java
@@ -72,17 +72,17 @@
     /**
      * 鎻掑叆鎺掗櫎瀛楁
      */
-    public final static List<String> INSERT_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("gid", "objectid", "updateuser", "updatetime", "shape_leng", "shape_area", "dirName", "depName", "verName", "createName", "updateName"));
+    public final static List<String> INSERT_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("gid", "objectid", "updateuser", "updatetime", "shape_leng", "shape_area", "serialVersionUID", "dirName", "depName", "verName", "createName", "updateName"));
 
     /**
      * 鏇存柊鎺掗櫎瀛楁
      */
-    public final static List<String> UPDATE_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("objectid", "createuser", "createtime", "shape_leng", "shape_area", "dirName", "depName", "verName", "createName", "updateName"));
+    public final static List<String> UPDATE_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("objectid", "createuser", "createtime", "shape_leng", "shape_area", "serialVersionUID", "dirName", "depName", "verName", "createName", "updateName"));
 
     /**
      * 璇诲彇鎺掗櫎瀛楁
      */
-    public final static List<String> READ_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("gid", "objectid", "dirid", "depid", "verid", "createtime", "createuser", "updateuser", "updatetime", "shape_leng", "shape_area", "dirName", "depName", "verName", "createName", "updateName"));
+    public final static List<String> READ_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("gid", "objectid", "dirid", "depid", "verid", "createtime", "createuser", "updateuser", "updatetime", "shape_leng", "shape_area", "serialVersionUID", "dirName", "depName", "verName", "createName", "updateName"));
 
     /**
      * MDB鎺掗櫎瀛楁
diff --git a/src/main/java/com/lf/server/extend/InsertBatchMethod.java b/src/main/java/com/lf/server/extend/InsertBatchMethod.java
index 9827fd7..9031eba 100644
--- a/src/main/java/com/lf/server/extend/InsertBatchMethod.java
+++ b/src/main/java/com/lf/server/extend/InsertBatchMethod.java
@@ -41,7 +41,7 @@
         // fieldSql.append(tableInfo.getKeyColumn()).append(",")
         // tableInfo.getFieldList().forEach(x -> fieldSql.append(x.getColumn()).append(","))
         for (TableFieldInfo f : tableInfo.getFieldList()) {
-            if (StaticData.INSERT_EXCLUDE_FIELDS.contains(f.getColumn())) {
+            if (StaticData.INSERT_EXCLUDE_FIELDS.contains(f.getProperty())) {
                 continue;
             }
 
@@ -61,11 +61,11 @@
         // valueSql.append("#{item.").append(tableInfo.getKeyProperty()).append("},")
         // tableInfo.getFieldList().forEach(x -> valueSql.append("#{item.").append(x.getProperty()).append("},"))
         for (TableFieldInfo f : tableInfo.getFieldList()) {
-            if (StaticData.INSERT_EXCLUDE_FIELDS.contains(f.getColumn())) {
+            if (StaticData.INSERT_EXCLUDE_FIELDS.contains(f.getProperty())) {
                 continue;
             }
 
-            valueSql.append("geom".equals(f.getColumn()) ? "${item." : "#{item.").append(f.getProperty()).append("},");
+            valueSql.append("geom".equals(f.getProperty()) ? "${item." : "#{item.").append(f.getProperty()).append("},");
         }
 
         valueSql.delete(valueSql.length() - 1, valueSql.length());
diff --git a/src/main/java/com/lf/server/extend/UpdateBatchMethod.java b/src/main/java/com/lf/server/extend/UpdateBatchMethod.java
index 234d403..7a14dbe 100644
--- a/src/main/java/com/lf/server/extend/UpdateBatchMethod.java
+++ b/src/main/java/com/lf/server/extend/UpdateBatchMethod.java
@@ -68,7 +68,7 @@
     private String getSqlSet(TableInfo tableInfo) {
         StringBuilder sb = new StringBuilder();
         for (TableFieldInfo f : tableInfo.getFieldList()) {
-            if (StaticData.UPDATE_EXCLUDE_FIELDS.contains(f.getColumn())) {
+            if (StaticData.UPDATE_EXCLUDE_FIELDS.contains(f.getProperty())) {
                 continue;
             }
 
@@ -77,7 +77,7 @@
                 continue;
             }
 
-            sb.append(String.format("<if test=\"item['%s'] != null\">%s=#{item.%s},</if>\n", f.getColumn(), f.getColumn(), f.getColumn()));
+            sb.append(String.format("<if test=\"item['%s'] != null\">%s=#{item.%s},</if>\n", f.getProperty(), f.getColumn(), f.getProperty()));
         }
         sb.deleteCharAt(sb.length() - 1);
 

--
Gitblit v1.9.3