From cc8e103aed0cdaf681d813f7601a38d2dd134289 Mon Sep 17 00:00:00 2001
From: Your Name <you@example.com>
Date: 星期五, 11 八月 2023 00:22:17 +0800
Subject: [PATCH] 优化费用
---
java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java | 54 ++++++++++++++++++++++++++++++++++--------------------
1 files changed, 34 insertions(+), 20 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..c32f4f0 100755
--- a/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java
+++ b/java110-db/src/main/java/com/java110/db/Java110MybatisInterceptor.java
@@ -3,6 +3,7 @@
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.java110.core.client.RestTemplate;
+import com.java110.core.context.Environment;
import com.java110.core.factory.Java110TransactionalFactory;
import com.java110.db.dao.IQueryServiceDAO;
import com.java110.dto.order.OrderItemDto;
@@ -11,16 +12,13 @@
import com.java110.utils.util.DateUtil;
import com.java110.utils.util.StringUtil;
import org.apache.ibatis.executor.Executor;
-import org.apache.ibatis.mapping.BoundSql;
-import org.apache.ibatis.mapping.MappedStatement;
-import org.apache.ibatis.mapping.ParameterMapping;
-import org.apache.ibatis.mapping.SqlCommandType;
+import org.apache.ibatis.mapping.*;
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 com.java110.core.log.LoggerFactory;
import org.springframework.http.*;
import java.sql.Timestamp;
@@ -54,7 +52,11 @@
Map<String, Object> sqlValue = new HashMap<>();
//鑾峰彇sql璇彞
String sql = showSql(configuration, boundSql, sqlValue, sqlCommandType);
- restTemplate = ApplicationContextFactory.getBean("restTemplate", RestTemplate.class);
+ if(Environment.isStartBootWay()){
+ restTemplate = ApplicationContextFactory.getBean("outRestTemplate", RestTemplate.class);
+ }else {
+ restTemplate = ApplicationContextFactory.getBean("restTemplate", RestTemplate.class);
+ }
switch (sqlCommandType) {
case INSERT:
dealInsertSql(mappedStatement, parameter, sql, sqlValue);
@@ -77,7 +79,8 @@
*/
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(" "));
}
@@ -85,7 +88,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);
@@ -114,6 +117,9 @@
String url = ServiceConstant.SERVICE_ORDER_URL + "/order/oIdApi/createOrderItem";
HttpHeaders httpHeaders = new HttpHeaders();
HttpEntity httpEntity = new HttpEntity(orderItemDto.toString(), httpHeaders);
+ if(Environment.isStartBootWay()){
+ url = ServiceConstant.BOOT_SERVICE_ORDER_URL + "/order/oIdApi/createOrderItem";
+ }
ResponseEntity<String> responseEntity = restTemplate.exchange(url, HttpMethod.POST, httpEntity, String.class);
if (responseEntity.getStatusCode() != HttpStatus.OK) {
@@ -130,7 +136,9 @@
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")).trim();
+ 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 +149,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);
@@ -171,7 +179,11 @@
String url = ServiceConstant.SERVICE_ORDER_URL + "/order/oIdApi/createOrderItem";
HttpHeaders httpHeaders = new HttpHeaders();
HttpEntity httpEntity = new HttpEntity(orderItemDto.toString(), httpHeaders);
- ResponseEntity<String> responseEntity = restTemplate.exchange(url, HttpMethod.POST, httpEntity, String.class);
+ ResponseEntity<String> responseEntity = null;
+ if(Environment.isStartBootWay()){
+ url = ServiceConstant.BOOT_SERVICE_ORDER_URL + "/order/oIdApi/createOrderItem";
+ }
+ responseEntity = restTemplate.exchange(url, HttpMethod.POST, httpEntity, String.class);
if (responseEntity.getStatusCode() != HttpStatus.OK) {
throw new IllegalArgumentException("娉ㄥ唽浜嬪姟鍥炴粴鏃ュ織澶辫触" + responseEntity);
@@ -240,6 +252,9 @@
String url = ServiceConstant.SERVICE_ORDER_URL + "/order/oIdApi/createOrderItem";
HttpHeaders httpHeaders = new HttpHeaders();
HttpEntity httpEntity = new HttpEntity(orderItemDto.toString(), httpHeaders);
+ if(Environment.isStartBootWay()){
+ url = ServiceConstant.BOOT_SERVICE_ORDER_URL + "/order/oIdApi/createOrderItem";
+ }
ResponseEntity<String> responseEntity = restTemplate.exchange(url, HttpMethod.POST, httpEntity, String.class);
if (responseEntity.getStatusCode() != HttpStatus.OK) {
@@ -279,7 +294,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);
@@ -295,7 +314,7 @@
String[] tmpKeys = tmpKey.split(",");
// if (values.size() < tmpKeys.length) {
-// throw new IllegalArgumentException("sql 閿欒 key 鍜寁alue 涓暟涓嶇瓑" + sql);
+// throw new IllegalArgumentException("sql 閿欒 key P鍜寁alue 涓暟涓嶇瓑" + sql);
// }
for (int keyIndex = 0; keyIndex < tmpKeys.length; keyIndex++) {
String key = tmpKeys[keyIndex].trim();
@@ -346,6 +365,7 @@
return sql;
}
+
private String getParameterValue(Object obj) {
String value = null;
if (obj instanceof String) {
@@ -366,11 +386,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