From ce64e667815b39efdc2f8bd52be0d43d49db8d84 Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期日, 17 七月 2022 00:06:29 +0800
Subject: [PATCH] 优化小区位置
---
java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java | 19 +++++++++----------
1 files changed, 9 insertions(+), 10 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 2d20850..391c7f4 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;
@@ -77,7 +77,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 tmpTable = sql.substring(sql.indexOf("from") + 4, sql.indexOf("where")).trim();
String tmpTableHasT = tmpTable;
if(tmpTable.indexOf(" ") > 0){
tmpTable = tmpTable.substring(0,tmpTable.indexOf(" "));
@@ -282,7 +282,11 @@
String propertyName = parameterMapping.getProperty();
if (metaObject.hasGetter(propertyName)) {
Object obj = metaObject.getValue(propertyName);
- sql = sql.replaceFirst("\\?", getParameterValue(obj));
+ String value = getParameterValue(obj);
+ if(value.contains("${")){
+ value = value.replace("${","\\${");
+ }
+ sql = sql.replaceFirst("\\?", value);
values.add(getParameterValue(obj));
} else if (boundSql.hasAdditionalParameter(propertyName)) {
Object obj = boundSql.getAdditionalParameter(propertyName);
@@ -349,6 +353,7 @@
return sql;
}
+
private String getParameterValue(Object obj) {
String value = null;
if (obj instanceof String) {
@@ -369,11 +374,5 @@
}
- public static void main(String[] args) {
- String tmpTable = "product_label t";
- if(tmpTable.indexOf(" ") > 0){
- tmpTable = tmpTable.substring(0,tmpTable.indexOf(" "));
- }
- System.out.printf(tmpTable);
- }
+
}
--
Gitblit v1.8.0