From e0e1d790b1e9137bb863b202c467d7f2e2e792ba Mon Sep 17 00:00:00 2001
From: chenjiahe <763432473@qq.com>
Date: 星期三, 06 四月 2022 18:49:57 +0800
Subject: [PATCH] 优化加密初始化方法

---
 src/main/java/com/hx/mybatis/aes/springbean/InitMysqlData.java |   13 +++++++++----
 1 files changed, 9 insertions(+), 4 deletions(-)

diff --git a/src/main/java/com/hx/mybatis/aes/springbean/InitMysqlData.java b/src/main/java/com/hx/mybatis/aes/springbean/InitMysqlData.java
index 712f351..fa7f431 100644
--- a/src/main/java/com/hx/mybatis/aes/springbean/InitMysqlData.java
+++ b/src/main/java/com/hx/mybatis/aes/springbean/InitMysqlData.java
@@ -79,7 +79,9 @@
         sqlSentence.sqlSentence("SELECT "+selectField.toString()+" FROM "+fieldData.getTableName()+" LIMIT "+pageNum+","+pageSize,values);
         List<Map<String,Object>> list = commonService.selectListMap(CommonMapper.class,sqlSentence);
 
+        boolean isUpdate = false;
         for (Map<String,Object> map:list){
+            isUpdate = false;
             StringBuilder setField = new StringBuilder();
             for (Map.Entry<String, Object> entry : map.entrySet()) {
                 String mapKey = entry.getKey();
@@ -97,13 +99,16 @@
                     setField.append(",");
                 }
                 setField.append(mapKey+" = #{m."+mapKey+"}");
+                isUpdate = true;
             }
 
-            values = map;
-            sqlSentence.sqlSentence("UPDATE "+fieldData.getTableName()+" SET "+setField.toString()+" WHERE "+fieldData.getId()+" = #{m."+fieldData.getId()+"}",values);
+            if(isUpdate){
+                values = map;
+                sqlSentence.sqlSentence("UPDATE "+fieldData.getTableName()+" SET "+setField.toString()+" WHERE "+fieldData.getId()+" = #{m."+fieldData.getId()+"}",values);
 
-            if(commonService.updateSentence(sqlSentence)!=1){
-                throw new ServiceException("鏇存柊瓒呰繃1鏉★紝鏇存柊澶辫触锛�");
+                if(commonService.updateSentence(sqlSentence)!=1){
+                    throw new ServiceException("鏇存柊瓒呰繃1鏉★紝鏇存柊澶辫触锛�");
+                }
             }
         }
 

--
Gitblit v1.8.0