From 8a524787c88a9128cc69af890d4181a01aad0e8c Mon Sep 17 00:00:00 2001
From: 吴学文 <wuxuewen@wuxuewendeMacBook-Pro.local>
Date: 星期六, 06 七月 2019 23:09:33 +0800
Subject: [PATCH] 修改代码生成器生成的app 加入user_id 的问题
---
java110-db/src/main/resources/mapper/app/AppServiceDaoImplMapper.xml | 28 +++++++++-------------------
1 files changed, 9 insertions(+), 19 deletions(-)
diff --git a/java110-db/src/main/resources/mapper/app/AppServiceDaoImplMapper.xml b/java110-db/src/main/resources/mapper/app/AppServiceDaoImplMapper.xml
index f9a92f7..6117a50 100644
--- a/java110-db/src/main/resources/mapper/app/AppServiceDaoImplMapper.xml
+++ b/java110-db/src/main/resources/mapper/app/AppServiceDaoImplMapper.xml
@@ -16,7 +16,7 @@
<!-- 鏌ヨ搴旂敤淇℃伅锛圔usiness锛� add by wuxw 2018-07-03 -->
<select id="getBusinessAppInfo" parameterType="Map" resultType="Map">
- select t.operate,t.app_id,t.app_id appId,t.black_list_ip,t.black_list_ip blackListIp,t.name,t.security_code,t.security_code securityCode,t.remark,t.user_id,t.user_id userId,t.while_list_ip,t.while_list_ip whileListIp
+ select t.operate,t.app_id,t.app_id appId,t.black_list_ip,t.black_list_ip blackListIp,t.name,t.security_code,t.security_code securityCode,t.remark,t.while_list_ip,t.while_list_ip whileListIp
from business_app t
where 1 =1
<if test="operate !=null and operate != ''">
@@ -37,9 +37,7 @@
<if test="remark !=null and remark != ''">
and t.remark= #{remark}
</if>
-<if test="userId !=null and userId != ''">
- and t.user_id= #{userId}
-</if>
+
<if test="whileListIp !=null and whileListIp != ''">
and t.while_list_ip= #{whileListIp}
</if>
@@ -53,8 +51,8 @@
<!-- 淇濆瓨搴旂敤淇℃伅鑷� instance琛ㄤ腑 add by wuxw 2018-07-03 -->
<insert id="saveAppInfoInstance" parameterType="Map">
insert into c_app(
-app_id,black_list_ip,name,security_code,remark,status_cd,user_id,while_list_ip
-) select t.app_id,t.black_list_ip,t.name,t.security_code,t.remark,'0',t.user_id,t.while_list_ip from business_app t where 1=1
+app_id,black_list_ip,name,security_code,remark,status_cd,while_list_ip
+) select t.app_id,t.black_list_ip,t.name,t.security_code,t.remark,'0',t.while_list_ip from business_app t where 1=1
and t.operate= 'ADD'
<if test="appId !=null and appId != ''">
and t.app_id= #{appId}
@@ -71,9 +69,7 @@
<if test="remark !=null and remark != ''">
and t.remark= #{remark}
</if>
-<if test="userId !=null and userId != ''">
- and t.user_id= #{userId}
-</if>
+
<if test="whileListIp !=null and whileListIp != ''">
and t.while_list_ip= #{whileListIp}
</if>
@@ -84,7 +80,7 @@
<!-- 鏌ヨ搴旂敤淇℃伅 add by wuxw 2018-07-03 -->
<select id="getAppInfo" parameterType="Map" resultType="Map">
- select t.app_id,t.app_id appId,t.black_list_ip,t.black_list_ip blackListIp,t.name,t.security_code,t.security_code securityCode,t.remark,t.status_cd,t.status_cd statusCd,t.user_id,t.user_id userId,t.while_list_ip,t.while_list_ip whileListIp
+ select t.app_id,t.app_id appId,t.black_list_ip,t.black_list_ip blackListIp,t.name,t.security_code,t.security_code securityCode,t.remark,t.status_cd,t.status_cd statusCd,t.while_list_ip,t.while_list_ip whileListIp
from c_app t
where 1 =1
<if test="appId !=null and appId != ''">
@@ -105,9 +101,7 @@
<if test="statusCd !=null and statusCd != ''">
and t.status_cd= #{statusCd}
</if>
-<if test="userId !=null and userId != ''">
- and t.user_id= #{userId}
-</if>
+
<if test="whileListIp !=null and whileListIp != ''">
and t.while_list_ip= #{whileListIp}
</if>
@@ -135,9 +129,7 @@
<if test="remark !=null and remark != ''">
, t.remark= #{remark}
</if>
-<if test="userId !=null and userId != ''">
-, t.user_id= #{userId}
-</if>
+
<if test="whileListIp !=null and whileListIp != ''">
, t.while_list_ip= #{whileListIp}
</if>
@@ -170,9 +162,7 @@
<if test="statusCd !=null and statusCd != ''">
and t.status_cd= #{statusCd}
</if>
-<if test="userId !=null and userId != ''">
- and t.user_id= #{userId}
-</if>
+
<if test="whileListIp !=null and whileListIp != ''">
and t.while_list_ip= #{whileListIp}
</if>
--
Gitblit v1.8.0