package com.example.erp.mapper.userInfo;
|
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
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);
|
|
Boolean updateProcessMp(Integer id, String process);
|
|
List<User> findByAddress(String userName);
|
|
String selectOptimizeParmsById(@Param("username") String username);
|
}
|
