SysUserMapper.java 947 B

123456789101112131415161718192021222324252627
  1. package com.gis.mapper;
  2. import com.gis.domain.entity.SysUserEntity;
  3. import org.apache.ibatis.annotations.Mapper;
  4. import org.apache.ibatis.annotations.Select;
  5. import org.apache.ibatis.annotations.SelectProvider;
  6. import org.springframework.stereotype.Component;
  7. import java.util.List;
  8. @Component
  9. @Mapper
  10. public interface SysUserMapper extends IBaseMapper<SysUserEntity, Long> {
  11. // @SelectProvider(type = UserProvider.class, method = "findAllBySearchKey")
  12. // List<UserResponse> findAllBySearchKey(String searchKey);
  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. //
  18. // @SelectProvider(type = UserProvider.class, method = "findBySearchKey")
  19. // List<UserEntity> findBySearchKey(String searchKey);
  20. }