From 3e3d04c82f35561e18fed8b63bff8cb3351fb892 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 12 十月 2022 09:44:34 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/entity/sys/BlacklistEntity.java | 20 ++++++++++++++++++++
说明.txt | 3 +++
src/main/resources/mapper/sys/BlacklistMapper.xml | 12 ++++++------
3 files changed, 29 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/lf/server/entity/sys/BlacklistEntity.java b/src/main/java/com/lf/server/entity/sys/BlacklistEntity.java
index 509dfd5..a59419e 100644
--- a/src/main/java/com/lf/server/entity/sys/BlacklistEntity.java
+++ b/src/main/java/com/lf/server/entity/sys/BlacklistEntity.java
@@ -22,9 +22,13 @@
private int createUser;
+ private String createName;
+
private Timestamp createTime;
private int updateUser;
+
+ private String updateName;
private Timestamp updateTime;
@@ -79,6 +83,14 @@
this.createUser = createUser;
}
+ public String getCreateName() {
+ return createName;
+ }
+
+ public void setCreateName(String createName) {
+ this.createName = createName;
+ }
+
public Timestamp getCreateTime() {
return createTime;
}
@@ -95,6 +107,14 @@
this.updateUser = updateUser;
}
+ public String getUpdateName() {
+ return updateName;
+ }
+
+ public void setUpdateName(String updateName) {
+ this.updateName = updateName;
+ }
+
public Timestamp getUpdateTime() {
return updateTime;
}
diff --git a/src/main/resources/mapper/sys/BlacklistMapper.xml b/src/main/resources/mapper/sys/BlacklistMapper.xml
index 3e04808..709b43d 100644
--- a/src/main/resources/mapper/sys/BlacklistMapper.xml
+++ b/src/main/resources/mapper/sys/BlacklistMapper.xml
@@ -15,26 +15,26 @@
</select>
<select id="selectByPage" resultType="com.lf.server.entity.sys.BlacklistEntity">
- select * from lf.sys_blacklist
+ select a.*,fn_uname(a.create_user) createName,fn_uname(a.update_user) updateName from lf.sys_blacklist a
<where>
1 = 1
<if test="ip != null">
- and ip like #{ip}
+ and a.ip like #{ip}
</if>
<if test="type != null">
- and type = #{type}
+ and a.type = #{type}
</if>
</where>
- order by id
+ order by a.id
limit #{limit} offset #{offset}
</select>
<select id="selectAll" resultType="com.lf.server.entity.sys.BlacklistEntity">
- select * from lf.sys_blacklist order by id;
+ select a.*,fn_uname(a.create_user) createName,fn_uname(a.update_user) updateName from lf.sys_blacklist a order by a.id;
</select>
<select id="selectById" resultType="com.lf.server.entity.sys.BlacklistEntity">
- select * from lf.sys_blacklist where id = #{id}
+ select a.*,fn_uname(a.create_user) createName,fn_uname(a.update_user) updateName from lf.sys_blacklist a where a.id = #{id}
</select>
<insert id="insert" parameterType="com.lf.server.entity.sys.BlacklistEntity">
diff --git "a/\350\257\264\346\230\216.txt" "b/\350\257\264\346\230\216.txt"
index fb4f235..28a1366 100644
--- "a/\350\257\264\346\230\216.txt"
+++ "b/\350\257\264\346\230\216.txt"
@@ -49,6 +49,9 @@
boolean f2 = Md5Helper.validatePassword(pwd, md5Pwd);
new String(Base64.getDecoder().decode(username));
+
+浣跨敤Commons FileUpLoad缁勪欢瀹炵幇鏂囦欢涓婁紶鍔熻兘锛�
+https://www.itdaan.com/blog/2017/08/08/b2dbc1106fa7.html
----------------------------------------------------------------------------------------------------
涓�銆佸紑鍙戣繍琛岀幆澧�
JDK鐗堟湰锛�1.8
--
Gitblit v1.9.3