From ba5210dc8c6c537cacc59c18d58baa9744cd2b9d Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期二, 10 五月 2022 11:14:39 +0800
Subject: [PATCH] 优化报修单推送bug
---
java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java | 20 +++++++++++++-------
1 files changed, 13 insertions(+), 7 deletions(-)
diff --git a/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java b/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java
index ffca6b9..0f03572 100755
--- a/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java
+++ b/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java
@@ -20,7 +20,7 @@
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.type.TypeHandlerRegistry;
import org.slf4j.Logger;
-import org.slf4j.LoggerFactory;
+import com.java110.core.log.LoggerFactory;
import org.springframework.http.*;
import java.sql.Timestamp;
@@ -78,6 +78,7 @@
private void dealDeleteSql(MappedStatement mappedStatement, Object parameter, String sql, Map<String, Object> sqlValue) {
String tmpTable = sql.substring(sql.indexOf("into") + 4, sql.indexOf("(")).trim();
+ String tmpTableHasT = tmpTable;
if(tmpTable.indexOf(" ") > 0){
tmpTable = tmpTable.substring(0,tmpTable.indexOf(" "));
}
@@ -85,7 +86,7 @@
//鎻掑叆鎿嶄綔鏃朵箣鍓嶇殑 娌℃湁鏁版嵁 鎵�浠� preValue 涓虹┖瀵硅薄
JSONArray preValues = new JSONArray();
- String execSql = "select * from " + tmpTable + " " + tmpWhere;
+ String execSql = "select * from " + tmpTableHasT + " " + tmpWhere;
queryServiceDAOImpl = ApplicationContextFactory.getBean("queryServiceDAOImpl", IQueryServiceDAO.class);
List<Map<String, Object>> deleteDatas = queryServiceDAOImpl.executeSql(execSql, null);
@@ -132,6 +133,8 @@
String tmpTable = sql.substring(sql.indexOf("update") + 6, sql.indexOf("set")).trim();
+ String tmpTableHasT = tmpTable;
+
if(tmpTable.indexOf(" ") > 0){
tmpTable = tmpTable.substring(0,tmpTable.indexOf(" "));
}
@@ -141,7 +144,7 @@
JSONArray preValues = new JSONArray();
JSONArray afterValues = new JSONArray();
JSONObject afterVaule = null;
- String execSql = "select * from " + tmpTable + " " + tmpWhere;
+ String execSql = "select * from " + tmpTableHasT + " " + tmpWhere;
queryServiceDAOImpl = ApplicationContextFactory.getBean("queryServiceDAOImpl", IQueryServiceDAO.class);
List<Map<String, Object>> deleteDatas = queryServiceDAOImpl.executeSql(execSql, null);
@@ -346,6 +349,7 @@
return sql;
}
+
private String getParameterValue(Object obj) {
String value = null;
if (obj instanceof String) {
@@ -367,10 +371,12 @@
public static void main(String[] args) {
- String tmpTable = "product_label t";
- if(tmpTable.indexOf(" ") > 0){
- tmpTable = tmpTable.substring(0,tmpTable.indexOf(" "));
+ String tmpTable = "" +
+ " id_card,open_id,link,remark,user_id,app_type,app_user_name,nickname,headimgurl,community_name,state,app_user_id,community_id,app_type_cd,member_id\n" +
+ " ";
+ String[] a = tmpTable.split(",");
+ for(String a1:a){
+ System.out.println(a1);
}
- System.out.printf(tmpTable);
}
}
--
Gitblit v1.8.0