SysUserMapper.java 873 B

12345678910111213141516171819202122232425262728
  1. package com.gis.mapper;
  2. import com.gis.domain.dto.UserPageDateDto;
  3. import com.gis.domain.po.SysUserEntity;
  4. import com.gis.mapper.provider.UserProvider;
  5. import org.apache.ibatis.annotations.Mapper;
  6. import org.apache.ibatis.annotations.Select;
  7. import org.apache.ibatis.annotations.SelectProvider;
  8. import org.springframework.stereotype.Component;
  9. import java.util.List;
  10. @Component
  11. @Mapper
  12. public interface SysUserMapper extends IBaseMapper<SysUserEntity, Long> {
  13. @Select(value = "select * from sys_user where rec_status = 'A' AND user_name= #{userName}")
  14. SysUserEntity findByUserName(String userName);
  15. @Select(value = "select * from sys_user where rec_status = 'A' AND phone = #{phone}")
  16. SysUserEntity findByPhone(String phone);
  17. @SelectProvider(type = UserProvider.class, method = "search")
  18. List<SysUserEntity> search(UserPageDateDto param);
  19. }