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