| | |
| | | package com.lf.server.mapper.sys; |
| | | |
| | | import com.lf.server.entity.sys.User; |
| | | import com.lf.server.entity.sys.UserEntity; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.springframework.stereotype.Repository; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * UserMapper |
| | | * @author |
| | | * 用户管理 |
| | | * @author sws |
| | | * @date 2022-09-27 |
| | | */ |
| | | @Mapper |
| | | @Repository |
| | | public interface UserMapper { |
| | | /** |
| | | * 根据名称查询用户 |
| | | * @param loginName |
| | | * 查询记录数 |
| | | * |
| | | * @param uname 用户名 |
| | | * @return 记录数 |
| | | */ |
| | | public Integer selectCount(String uname); |
| | | |
| | | /** |
| | | * 分页查询 |
| | | * |
| | | * @param uname 用戶名 |
| | | * @param limit 记录表 |
| | | * @param offset 偏移量 |
| | | * @return 列表 |
| | | */ |
| | | public List<UserEntity> selectByPage(String uname, Integer limit, Integer offset); |
| | | |
| | | /** |
| | | * 根据token有效期查询 |
| | | * |
| | | * @param token |
| | | * @return |
| | | */ |
| | | public User queryUserByName(String loginName); |
| | | } |
| | | public UserEntity selectByToken(String token); |
| | | |
| | | /** |
| | | * 插入一条 |
| | | * |
| | | * @param userEntity |
| | | * @return |
| | | */ |
| | | public Integer insertUser(UserEntity userEntity); |
| | | |
| | | /** |
| | | * 插入多条 |
| | | * |
| | | * @param userEntity |
| | | * @return |
| | | */ |
| | | public Integer insertUsers(List<UserEntity> userEntity); |
| | | |
| | | /** |
| | | * 删除一条 |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | public Integer deleteUser(int id); |
| | | |
| | | /** |
| | | * 删除多条 |
| | | * |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | public Integer deleteUsers(List<Integer> ids); |
| | | |
| | | /** |
| | | * 更新一条 |
| | | * |
| | | * @param userEntity |
| | | * @return |
| | | */ |
| | | public Integer updateUsers(UserEntity userEntity); |
| | | |
| | | /** |
| | | * 查询单条数据 |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | public UserEntity selectUser(int id); |
| | | |
| | | /** |
| | | * 根据uid查询 |
| | | * |
| | | * @param uid |
| | | * @return |
| | | */ |
| | | public UserEntity selectByUid(String uid); |
| | | |
| | | /** |
| | | * 查询所有 |
| | | * |
| | | * @return |
| | | */ |
| | | public List<UserEntity> selectUserAll(); |
| | | |
| | | /** |
| | | * 根据角色+单位查询记录数 |
| | | * |
| | | * @param uname |
| | | * @param roleid |
| | | * @param depid |
| | | * @return |
| | | */ |
| | | public Integer selectCountForRole(String uname, Integer roleid, Integer depid); |
| | | |
| | | /** |
| | | * 根据角色+单位分页查询 |
| | | * |
| | | * @param uname |
| | | * @param roleid |
| | | * @param depid |
| | | * @param limit |
| | | * @param offset |
| | | * @return |
| | | */ |
| | | public List<UserEntity> selectByPageForRole(String uname, Integer roleid, Integer depid, Integer limit, Integer offset); |
| | | |
| | | /** |
| | | * 更新多个用户密码 |
| | | * |
| | | * @param updateUser |
| | | * @param pwd |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | public Integer updateUsersPwd(Integer updateUser, String pwd, List<Integer> ids); |
| | | } |