From 3ed2627f7c05e8eaa4559371f9d6d2cb71aa4275 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期日, 12 九月 2021 14:11:08 +0800
Subject: [PATCH] 优化刷新缓存功能
---
java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java | 80 +++++++++++++++------------------------
1 files changed, 31 insertions(+), 49 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
old mode 100644
new mode 100755
index 4d9bcaa..ffca6b9
--- a/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java
+++ b/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java
@@ -77,7 +77,10 @@
*/
private void dealDeleteSql(MappedStatement mappedStatement, Object parameter, String sql, Map<String, Object> sqlValue) {
- String tmpTable = sql.substring(sql.indexOf("into") + 4, sql.indexOf("("));
+ String tmpTable = sql.substring(sql.indexOf("into") + 4, sql.indexOf("(")).trim();
+ if(tmpTable.indexOf(" ") > 0){
+ tmpTable = tmpTable.substring(0,tmpTable.indexOf(" "));
+ }
String tmpWhere = sql.substring(sql.indexOf("where"));
//鎻掑叆鎿嶄綔鏃朵箣鍓嶇殑 娌℃湁鏁版嵁 鎵�浠� preValue 涓虹┖瀵硅薄
JSONArray preValues = new JSONArray();
@@ -127,7 +130,11 @@
private void dealUpdateSql(MappedStatement mappedStatement, Object parameter, String sql, Map<String, Object> sqlValue) {
//RestTemplate restTemplate = ApplicationContextFactory.getBean("restTemplate", RestTemplate.class);
- String tmpTable = sql.substring(sql.indexOf("update") + 6, sql.indexOf("set"));
+ String tmpTable = sql.substring(sql.indexOf("update") + 6, sql.indexOf("set")).trim();
+
+ if(tmpTable.indexOf(" ") > 0){
+ tmpTable = tmpTable.substring(0,tmpTable.indexOf(" "));
+ }
String tmpWhere = sql.substring(sql.indexOf("where"));
//鎻掑叆鎿嶄綔鏃朵箣鍓嶇殑 娌℃湁鏁版嵁 鎵�浠� preValue 涓虹┖瀵硅薄
@@ -210,40 +217,11 @@
JSONArray afterValues = new JSONArray();
- String tmpTable = sql.substring(sql.toLowerCase().indexOf("into") + 4, sql.indexOf("("));
-// String tmpKey = sql.substring(sql.indexOf("(") + 1, sql.indexOf(")"));
-// String[] tmpKeys = tmpKey.split(",");
-// int valuePos = 0;
-// if (sql.contains("VALUES")) {
-// valuePos = sql.indexOf("VALUES") + 6;
-// } else {
-// valuePos = sql.indexOf("values") + 6;
-// }
-// String sqlValues = sql.substring(valuePos);
-// //璇存槑鎵规搷浣�
-//
-// 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]);
-// }
-//
-// }
+ String tmpTable = sql.substring(sql.toLowerCase().indexOf("into") + 4, sql.indexOf("(")).trim();
+
+ if(tmpTable.indexOf(" ") > 0){
+ tmpTable = tmpTable.substring(0,tmpTable.indexOf(" "));
+ }
afterValues.add(sqlValue);
@@ -269,6 +247,7 @@
}
}
+
@Override
public Object plugin(Object target) {
@@ -315,12 +294,15 @@
String tmpKey = orgSql.substring(orgSql.indexOf("(") + 1, orgSql.indexOf(")"));
String[] tmpKeys = tmpKey.split(",");
- if (values.size() < tmpKeys.length) {
- throw new IllegalArgumentException("sql 閿欒 key 鍜寁alue 涓暟涓嶇瓑" + sql);
- }
+// if (values.size() < tmpKeys.length) {
+// throw new IllegalArgumentException("sql 閿欒 key 鍜寁alue 涓暟涓嶇瓑" + sql);
+// }
for (int keyIndex = 0; keyIndex < tmpKeys.length; keyIndex++) {
String key = tmpKeys[keyIndex].trim();
String value = "";
+ if (values.size() - 1 < keyIndex) {
+ continue;
+ }
value = values.get(keyIndex);
if ("''".equals(value)) {
continue;
@@ -330,9 +312,9 @@
} else if (sqlCommandType == SqlCommandType.UPDATE) {
String tmpKey = orgSql.substring(sql.indexOf("set") + 3, orgSql.indexOf("where"));
String[] tmpKeys = tmpKey.split(",");
- if (values.size() < tmpKeys.length) {
- throw new IllegalArgumentException("sql 閿欒 key 鍜寁alue 涓暟涓嶇瓑" + sql);
- }
+// if (values.size() < tmpKeys.length) {
+// throw new IllegalArgumentException("sql 閿欒 key 鍜寁alue 涓暟涓嶇瓑" + sql);
+// }
for (int keyIndex = 0; keyIndex < tmpKeys.length; keyIndex++) {
String tmpSetKey = tmpKeys[keyIndex];
String[] keyValues = tmpSetKey.split("=");
@@ -346,6 +328,9 @@
key = keyValues[0].trim();
}
String value = "";
+ if (values.size() - 1 < keyIndex) {
+ continue;
+ }
value = values.get(keyIndex);
if ("''".equals(value)) {
continue;
@@ -382,13 +367,10 @@
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 涓暟涓嶇瓑");
+ String tmpTable = "product_label t";
+ if(tmpTable.indexOf(" ") > 0){
+ tmpTable = tmpTable.substring(0,tmpTable.indexOf(" "));
}
+ System.out.printf(tmpTable);
}
}
--
Gitblit v1.8.0