From 1acf9a48021d0af1d81fdf3ed8fcf8dffd020f6b Mon Sep 17 00:00:00 2001
From: hongjli <3117313295@qq.com>
Date: 星期二, 15 四月 2025 14:20:51 +0800
Subject: [PATCH] 登录，注册，获取用户信息---接口
---
src/main/java/com/weiwojc/mapper/UserMapper.java | 26 ++++++++++++++++++++++++++
1 files changed, 26 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/weiwojc/mapper/UserMapper.java b/src/main/java/com/weiwojc/mapper/UserMapper.java
new file mode 100644
index 0000000..6087e4d
--- /dev/null
+++ b/src/main/java/com/weiwojc/mapper/UserMapper.java
@@ -0,0 +1,26 @@
+package com.weiwojc.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.weiwojc.model.entity.User;
+import org.apache.ibatis.annotations.*;
+
+@Mapper
+public interface UserMapper extends BaseMapper<User> {
+
+ @Select("SELECT * FROM user WHERE username = #{username} AND is_deleted = 0")
+ User findByUsername(String username);
+
+ @Select("SELECT * FROM user WHERE user_id = #{userId} AND is_deleted = 0")
+ User findById(Long userId);
+
+ @Update("UPDATE user SET last_login = #{lastLogin} WHERE user_id = #{userId}")
+ int updateLastLogin(@Param("userId") Long userId, @Param("lastLogin") java.time.LocalDateTime lastLogin);
+
+ @Update("UPDATE user SET login_attempts = #{attempts}, locked_until = #{lockedUntil} WHERE user_id = #{userId}")
+ int updateLoginAttempts(@Param("userId") Long userId,
+ @Param("attempts") Integer attempts,
+ @Param("lockedUntil") java.time.LocalDateTime lockedUntil);
+
+ @Update("UPDATE user SET login_attempts = 0, locked_until = null WHERE username = #{username}")
+ int resetLoginAttempts(String username);
+}
\ No newline at end of file
--
Gitblit v1.9.3