SlideDAO.java 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. package nju.seec.helper.dao;
  2. import nju.seec.helper.entity.Slide;
  3. import nju.seec.helper.util.enums.SlideState;
  4. import nju.seec.helper.util.exception.HelperException;
  5. import org.springframework.data.domain.Page;
  6. import org.springframework.data.domain.Pageable;
  7. import org.springframework.data.jpa.repository.JpaRepository;
  8. import org.springframework.stereotype.Repository;
  9. import java.util.Set;
  10. /**
  11. * @author cst
  12. */
  13. @Repository
  14. public interface SlideDAO extends JpaRepository<Slide, Integer> {
  15. /**
  16. * 封装findById
  17. *
  18. * @param id
  19. * @return
  20. */
  21. default Slide findSlideById(Integer id) {
  22. return this.findById(id)
  23. .orElseThrow(() -> HelperException.of(HelperException.ExceptionType.NOT_FOUND, "找不到幻灯片"));
  24. }
  25. /**
  26. * 查询教师创建的幻灯片
  27. *
  28. * @param teacherId
  29. * @param key
  30. * @param pageable
  31. * @return
  32. */
  33. Page<Slide> findByTeacherIdAndNameContains(Integer teacherId, String key, Pageable pageable);
  34. /**
  35. * 查询教师创建的该课程的幻灯片
  36. *
  37. * @param courseId
  38. * @param teacherId
  39. * @param key
  40. * @param pageable
  41. * @return
  42. */
  43. Page<Slide> findByCourseIdAndTeacherIdAndNameContains(Integer courseId, Integer teacherId, String key, Pageable pageable);
  44. /**
  45. * 根据课程和幻灯片状态查询
  46. *
  47. * @param courseId
  48. * @param exclusiveStates
  49. * @param key
  50. * @param pageable
  51. * @return
  52. */
  53. Page<Slide> findByCourseIdAndStateNotInAndNameContains(Integer courseId, Set<SlideState> exclusiveStates, String key, Pageable pageable);
  54. }