From a48817ffcb840ed803c813c010f3730eb7e9cb87 Mon Sep 17 00:00:00 2001
From: chenjiahe <763432473@qq.com>
Date: 星期三, 06 四月 2022 15:52:01 +0800
Subject: [PATCH] 优化
---
src/main/java/com/hx/common/xml/CommonMapper.xml | 2 +-
src/main/java/com/hx/mybatis/aes/springbean/InitMysqlData.java | 6 +++++-
src/main/java/com/hx/common/service/impl/CommonDaoImpl.java | 2 +-
src/main/java/com/hx/common/dao/mapper/CommonMapper.java | 4 ++--
4 files changed, 9 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/hx/common/dao/CommonMapper.java b/src/main/java/com/hx/common/dao/mapper/CommonMapper.java
similarity index 87%
rename from src/main/java/com/hx/common/dao/CommonMapper.java
rename to src/main/java/com/hx/common/dao/mapper/CommonMapper.java
index 4f6d5d0..24205c8 100644
--- a/src/main/java/com/hx/common/dao/CommonMapper.java
+++ b/src/main/java/com/hx/common/dao/mapper/CommonMapper.java
@@ -1,8 +1,8 @@
-package com.hx.common.dao;
+package com.hx.common.dao.mapper;
import com.hx.mybatisTool.SqlSentence;
-import java.io.Serializable;
+
import java.util.List;
import java.util.Map;
diff --git a/src/main/java/com/hx/common/service/impl/CommonDaoImpl.java b/src/main/java/com/hx/common/service/impl/CommonDaoImpl.java
index dbfa4b8..32fdd9a 100644
--- a/src/main/java/com/hx/common/service/impl/CommonDaoImpl.java
+++ b/src/main/java/com/hx/common/service/impl/CommonDaoImpl.java
@@ -1,7 +1,7 @@
package com.hx.common.service.impl;
import com.hx.common.dao.CommonDao;
-import com.hx.common.dao.CommonMapper;
+import com.hx.common.dao.mapper.CommonMapper;
import com.hx.mybatisTool.SqlSentence;
import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.stereotype.Service;
diff --git a/src/main/java/com/hx/common/xml/CommonMapper.xml b/src/main/java/com/hx/common/xml/CommonMapper.xml
index 9fbc165..62c4dc1 100644
--- a/src/main/java/com/hx/common/xml/CommonMapper.xml
+++ b/src/main/java/com/hx/common/xml/CommonMapper.xml
@@ -3,7 +3,7 @@
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- namespace:璇apper.xml鏄犲皠鏂囦欢鐨� 鍞竴鏍囪瘑 -->
-<mapper namespace="com.hx.common.dao.CommonMapper">
+<mapper namespace="com.hx.common.dao.mapper.CommonMapper">
<update id="updateSentence" parameterType="com.hx.mybatisTool.SqlSentence" >
${sqlSentence}
</update>
diff --git a/src/main/java/com/hx/mybatis/aes/springbean/InitMysqlData.java b/src/main/java/com/hx/mybatis/aes/springbean/InitMysqlData.java
index d1648b3..6e6b5fc 100644
--- a/src/main/java/com/hx/mybatis/aes/springbean/InitMysqlData.java
+++ b/src/main/java/com/hx/mybatis/aes/springbean/InitMysqlData.java
@@ -3,7 +3,7 @@
import com.gitee.sunchenbin.mybatis.actable.annotation.Column;
import com.gitee.sunchenbin.mybatis.actable.annotation.Table;
import com.hx.common.annotations.MysqlHexAes;
-import com.hx.common.dao.CommonMapper;
+import com.hx.common.dao.mapper.CommonMapper;
import com.hx.common.service.CommonService;
import com.hx.exception.ServiceException;
import com.hx.mybatisTool.SqlSentence;
@@ -41,6 +41,7 @@
for(FieldData fieldData:fieldDatas){
//鑾峰彇鏉℃暟
sqlSentence.sqlSentence("SELECT COUNT(0) FROM "+fieldData.getTableName(),values);
+ System.out.println("sqlSentence3:"+sqlSentence.getSqlSentence());
int total = commonService.selectCountSql(sqlSentence);
if(total ==0 ){
continue;
@@ -77,6 +78,7 @@
selectField.append(","+fieldName);
}
sqlSentence.sqlSentence("SELECT "+selectField.toString()+" FROM "+fieldData.getTableName()+" LIMIT "+pageNum+","+pageSize,values);
+ System.out.println("sqlSentence:"+sqlSentence.getSqlSentence());
List<Map<String,Object>> list = commonService.selectListMap(CommonMapper.class,sqlSentence);
for (Map<String,Object> map:list){
@@ -101,6 +103,8 @@
values = map;
sqlSentence.sqlSentence("UPDATE "+fieldData.getTableName()+" SET "+setField.toString()+" WHERE "+fieldData.getId()+" = #{m."+fieldData.getId()+"}",values);
+ System.out.println("sqlSentence2:"+sqlSentence.getSqlSentence());
+
if(commonService.updateSentence(sqlSentence)!=1){
throw new ServiceException("鏇存柊瓒呰繃1鏉★紝鏇存柊澶辫触锛�");
}
--
Gitblit v1.8.0