¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.lf.server.mapper.sys; |
| | | |
| | | import com.lf.server.entity.sys.UserEntity; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.springframework.stereotype.Repository; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * ç¨æ·ç®¡ç |
| | | * @author sws |
| | | * @date 2022-09-27 |
| | | */ |
| | | @Mapper |
| | | @Repository |
| | | public interface UserMapper { |
| | | /** |
| | | * æ¥è¯¢è®°å½æ° |
| | | * |
| | | * @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 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); |
| | | } |