From 95270d9f2d0c93b52569268737902c4f09216c6b Mon Sep 17 00:00:00 2001
From: 廖井涛 <2265517004@qq.com>
Date: 星期五, 13 九月 2024 12:04:39 +0800
Subject: [PATCH] 返工查询后端筛选提交
---
north-glass-erp/src/main/java/com/example/erp/mapper/userInfo/UserMapper.java | 39 +++++++++++++++++++++++++++++++++++++++
1 files changed, 39 insertions(+), 0 deletions(-)
diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/userInfo/UserMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/userInfo/UserMapper.java
new file mode 100644
index 0000000..3a87237
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/userInfo/UserMapper.java
@@ -0,0 +1,39 @@
+package com.example.erp.mapper.userInfo;
+
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.example.erp.controller.dto.UserDTO;
+import com.example.erp.entity.userInfo.User;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
+
+@Mapper
+
+public interface UserMapper extends BaseMapper<User> {
+ List<User> findAll();
+
+ User findOne(Integer id);
+
+ User findOneLoginName(String LoginName);
+
+ User findOnePassWord(Integer id,String passWord);
+ @Select("select count(id) FROM `user` where login_name=#{userName} and password=#{password} ")
+ int checkUser(@Param("userName") String userName,@Param("password") String password);
+
+ @Select("select password FROM `user` where login_name=#{userId} ")
+ String getUserByID(String userId);
+
+
+ Boolean register(User user);
+
+ List<String> getUserRole(Integer id);
+
+ Boolean userDelete(Integer id);
+
+ Boolean updatePassWordById(Integer id,String passWord);
+
+ Boolean updateUserNameById(Integer id,String userName);
+}
--
Gitblit v1.8.0