MsSuspectedMapper.java 822 B

123456789101112131415161718192021222324252627
  1. package com.bofeng.dao;
  2. import com.baomidou.mybatisplus.mapper.BaseMapper;
  3. import com.bofeng.entity.MsReport;
  4. import com.bofeng.entity.MsSuspected;
  5. import org.apache.ibatis.annotations.Mapper;
  6. import org.apache.ibatis.annotations.Param;
  7. import org.apache.ibatis.annotations.Select;
  8. import org.springframework.stereotype.Repository;
  9. import java.util.List;
  10. /**
  11. * @Author: xielianghe
  12. * @Date: 2020/2/4 15:39
  13. */
  14. @Mapper
  15. @Repository
  16. public interface MsSuspectedMapper extends BaseMapper<MsSuspected> {
  17. List<MsSuspected> selectByReportId(@Param("reportId") Long reportId);
  18. //判断家人姓名是否重复
  19. @Select("select count(*) from ms_suspected where report_id=#{reportId} and user_name=#{userName}")
  20. Integer selectUserNameNum(@Param("reportId") Long reportId,@Param("userName") String userName);
  21. }