From b18b5236d2984cc2f9bb93c5ae91b22fbfddb015 Mon Sep 17 00:00:00 2001
From: 1098226878 <1098226878@qq.com>
Date: 星期一, 09 八月 2021 14:24:05 +0800
Subject: [PATCH] 优化代码
---
java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java | 18 ++++++++++++------
1 files changed, 12 insertions(+), 6 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..ad15598
--- a/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java
+++ b/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java
@@ -315,12 +315,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 +333,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 +349,9 @@
key = keyValues[0].trim();
}
String value = "";
+ if (values.size() - 1 < keyIndex) {
+ continue;
+ }
value = values.get(keyIndex);
if ("''".equals(value)) {
continue;
--
Gitblit v1.8.0