| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- package nju.seec.helper.dao;
- import nju.seec.helper.entity.Slide;
- import nju.seec.helper.util.enums.SlideState;
- import nju.seec.helper.util.exception.HelperException;
- import org.springframework.data.domain.Page;
- import org.springframework.data.domain.Pageable;
- import org.springframework.data.jpa.repository.JpaRepository;
- import org.springframework.stereotype.Repository;
- import java.util.Set;
- /**
- * @author cst
- */
- @Repository
- public interface SlideDAO extends JpaRepository<Slide, Integer> {
- /**
- * 封装findById
- *
- * @param id
- * @return
- */
- default Slide findSlideById(Integer id) {
- return this.findById(id)
- .orElseThrow(() -> HelperException.of(HelperException.ExceptionType.NOT_FOUND, "找不到幻灯片"));
- }
- /**
- * 查询教师创建的幻灯片
- *
- * @param teacherId
- * @param key
- * @param pageable
- * @return
- */
- Page<Slide> findByTeacherIdAndNameContains(Integer teacherId, String key, Pageable pageable);
- /**
- * 查询教师创建的该课程的幻灯片
- *
- * @param courseId
- * @param teacherId
- * @param key
- * @param pageable
- * @return
- */
- Page<Slide> findByCourseIdAndTeacherIdAndNameContains(Integer courseId, Integer teacherId, String key, Pageable pageable);
- /**
- * 根据课程和幻灯片状态查询
- *
- * @param courseId
- * @param exclusiveStates
- * @param key
- * @param pageable
- * @return
- */
- Page<Slide> findByCourseIdAndStateNotInAndNameContains(Integer courseId, Set<SlideState> exclusiveStates, String key, Pageable pageable);
- }
|