From 966e0ad10a904691d2124f807fc25642e28d478c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 15 九月 2023 10:32:28 +0800
Subject: [PATCH] 颜色表添加创建人和更新人
---
src/main/resources/mapper/data/ColortabMapper.xml | 7 ++++---
src/main/java/com/moon/server/entity/data/ColortabEntity.java | 20 ++++++++++++++++++++
2 files changed, 24 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/moon/server/entity/data/ColortabEntity.java b/src/main/java/com/moon/server/entity/data/ColortabEntity.java
index b5ca454..1b00433 100644
--- a/src/main/java/com/moon/server/entity/data/ColortabEntity.java
+++ b/src/main/java/com/moon/server/entity/data/ColortabEntity.java
@@ -28,6 +28,10 @@
private String bak;
+ private String createName;
+
+ private String updateName;
+
public ColortabEntity() {
}
@@ -102,4 +106,20 @@
public void setBak(String bak) {
this.bak = bak;
}
+
+ public String getCreateName() {
+ return createName;
+ }
+
+ public void setCreateName(String createName) {
+ this.createName = createName;
+ }
+
+ public String getUpdateName() {
+ return updateName;
+ }
+
+ public void setUpdateName(String updateName) {
+ this.updateName = updateName;
+ }
}
diff --git a/src/main/resources/mapper/data/ColortabMapper.xml b/src/main/resources/mapper/data/ColortabMapper.xml
index 7f2a508..84d48d5 100644
--- a/src/main/resources/mapper/data/ColortabMapper.xml
+++ b/src/main/resources/mapper/data/ColortabMapper.xml
@@ -11,7 +11,8 @@
</select>
<select id="selectByPage" resultType="com.moon.server.entity.data.ColortabEntity">
- select * from lf.sys_colortab
+ select a.*, fn_uname(a.create_user) createName, fn_uname(a.update_user) updateName
+ from lf.sys_colortab a
<where>
<if test="name != null">
upper(name) like #{name}
@@ -22,11 +23,11 @@
</select>
<select id="selectAll" resultType="com.moon.server.entity.data.ColortabEntity">
- select * from lf.sys_colortab order by id desc;
+ select a.*, fn_uname(a.create_user) createName, fn_uname(a.update_user) updateName from lf.sys_colortab a order by id desc;
</select>
<select id="selectById" resultType="com.moon.server.entity.data.ColortabEntity">
- select * from lf.sys_colortab where id = #{id}
+ select a.*, fn_uname(a.create_user) createName, fn_uname(a.update_user) updateName from lf.sys_colortab a where id = #{id}
</select>
<insert id="insert" parameterType="com.moon.server.entity.data.ColortabEntity">
--
Gitblit v1.9.3