FileMapper.java 925 B

123456789101112131415161718192021222324252627282930
  1. package com.gis.mapper;
  2. import com.gis.domain.po.FileEntity;
  3. import com.gis.mapper.provider.FileProvider;
  4. import com.gis.mapper.provider.SpiritProvider;
  5. import org.apache.ibatis.annotations.*;
  6. import org.springframework.data.jpa.repository.Modifying;
  7. import org.springframework.stereotype.Component;
  8. import java.util.List;
  9. @Component
  10. @Mapper
  11. public interface FileMapper extends IBaseMapper<FileEntity, Long> {
  12. // @Modifying
  13. // @Update(value = "UPDATE tb_file SET fk_id = #{fkId} WHERE id in ( #{ids} )")
  14. // void setFkIdByIds(String ids, String fkId);
  15. @SelectProvider(type = FileProvider.class, method = "setFkIdByIds")
  16. void setFkIdByIds(String ids, String fkId);
  17. @Select(value = "select * from tb_file where rec_status = 'A' AND fk_id = #{fkId}")
  18. List<FileEntity> findByFkId(String fkId);
  19. @Delete(value = "DELETE FROM tb_file WHERE fk_id = #{fkId}")
  20. void deleteByFkId(String fkId);
  21. }