From b889cb66aabba6553b7bc7027cf3d768abc58db1 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期五, 11 九月 2020 19:09:55 +0800
Subject: [PATCH] 优化代码
---
java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java | 79 ++++++++++++++++++++++++---------------
1 files changed, 48 insertions(+), 31 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 eccd651..cdd5fd1 100644
--- a/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java
+++ b/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java
@@ -15,30 +15,17 @@
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.mapping.ParameterMapping;
import org.apache.ibatis.mapping.SqlCommandType;
-import org.apache.ibatis.plugin.Interceptor;
-import org.apache.ibatis.plugin.Intercepts;
-import org.apache.ibatis.plugin.Invocation;
-import org.apache.ibatis.plugin.Plugin;
-import org.apache.ibatis.plugin.Signature;
+import org.apache.ibatis.plugin.*;
import org.apache.ibatis.reflection.MetaObject;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.type.TypeHandlerRegistry;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
-import org.springframework.http.HttpEntity;
-import org.springframework.http.HttpHeaders;
-import org.springframework.http.HttpMethod;
-import org.springframework.http.HttpStatus;
-import org.springframework.http.ResponseEntity;
+import org.springframework.http.*;
import java.sql.Timestamp;
import java.text.DateFormat;
-import java.util.Date;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Locale;
-import java.util.Map;
-import java.util.Properties;
+import java.util.*;
@Intercepts({
@Signature(type = Executor.class, method = "update", args = {MappedStatement.class,
@@ -216,9 +203,9 @@
Date date = new Date(((Timestamp) value).getTime());
String tmpValue = DateUtil.getFormatTimeString(date, DateUtil.DATE_FORMATE_STRING_A);
map.put(key, "'" + tmpValue + "'");
- } else if(value instanceof Double){
+ } else if (value instanceof Double) {
map.put(key, "'" + map.get(key) + "'");
- }else {
+ } else {
if (value != null) {
map.put(key, "'" + value.toString() + "'");
} else {
@@ -242,24 +229,42 @@
JSONArray preValues = new JSONArray();
JSONArray afterValues = new JSONArray();
- JSONObject afterValue = new JSONObject();
+
String tmpTable = sql.substring(sql.toLowerCase().indexOf("into") + 4, sql.indexOf("("));
String tmpKey = sql.substring(sql.indexOf("(") + 1, sql.indexOf(")"));
- String tmpValue = sql.substring(sql.lastIndexOf("(") + 1, sql.lastIndexOf(")"));
String[] tmpKeys = tmpKey.split(",");
- String[] tmpValues = tmpValue.split(",");
+ int valuePos = 0;
+ if (sql.contains("VALUES")) {
+ valuePos = sql.indexOf("VALUES") + 6;
+ } else {
+ valuePos = sql.indexOf("values") + 6;
+ }
+ String sqlValues = sql.substring(valuePos);
+ //璇存槑鎵规搷浣�
- if (tmpKeys.length != tmpValues.length) {
- throw new IllegalArgumentException("sql 閿欒 key 鍜寁alue 涓暟涓嶇瓑" + sql);
+ String[] sqlVauleses = sqlValues.split("\\)");
+ JSONObject afterValue = null;
+ for (String sqlV : sqlVauleses) {
+ String tmpValue = sqlV.substring(sqlV.lastIndexOf("(") + 1);
+ String[] tmpValues = tmpValue.split(",");
+ afterValue = new JSONObject();
+
+ if (tmpKeys.length != tmpValues.length) {
+ throw new IllegalArgumentException("sql 閿欒 key 鍜寁alue 涓暟涓嶇瓑" + sql);
+ }
+
+ if (tmpKeys.length < 1) {
+ throw new IllegalArgumentException("sql 閿欒 鏈壘鍒発ey" + sql);
+ }
+ for (int keyIndex = 0; keyIndex < tmpKeys.length; keyIndex++) {
+ if ("''".equals(tmpValues[keyIndex])) {
+ continue;
+ }
+ afterValue.put(tmpKeys[keyIndex], tmpValues[keyIndex]);
+ }
+ afterValues.add(afterValue);
}
- if (tmpKeys.length < 1) {
- throw new IllegalArgumentException("sql 閿欒 鏈壘鍒発ey" + sql);
- }
- for (int keyIndex = 0; keyIndex < tmpKeys.length; keyIndex++) {
- afterValue.put(tmpKeys[keyIndex], tmpValues[keyIndex]);
- }
- afterValues.add(afterValue);
JSONObject logText = new JSONObject();
logText.put("preValue", preValues);
@@ -334,10 +339,22 @@
if (obj != null) {
value = obj.toString();
} else {
- value = "";
+ value = "''";
}
}
return value;
}
+
+
+ public static void main(String[] args) {
+ String tmpKey = " prime_rate,detail_id,receivable_amount,cycles,remark,status_cd,received_amount,community_id,b_id,fee_id,state";
+ String tmpValue = "'1.00','912020080411040001','1500.0','1.0',,'0','1500.0','7020181217000001','-1',,";
+ String[] tmpKeys = tmpKey.split(",");
+ String[] tmpValues = tmpValue.split(",");
+
+ if (tmpKeys.length != tmpValues.length) {
+ throw new IllegalArgumentException("sql 閿欒 key 鍜寁alue 涓暟涓嶇瓑");
+ }
+ }
}
--
Gitblit v1.8.0