main-site/mooctest-site-server/src/main/java/cn/iselab/mooctest/site/dao/ExamDao.java

package cn.iselab.mooctest.site.dao;

import cn.iselab.mooctest.site.models.Task;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.data.repository.query.Param;

import javax.transaction.Transactional;
import java.util.List;


/**
 * Created by major on 2017/6/23.
 */
@Transactional
public interface ExamDao extends PagingAndSortingRepository<Task, Long> {

    Page<Task> findByManagerId(long organizerId, Pageable pageable);

    @Query("SELECT t " +
            "FROM Task t " +
            "WHERE t.id IN( " +
            " SELECT at.taskId " +
            " FROM AssignedTask at " +
            " WHERE at.workerId=:participantId)")
    Page<Task> findByParticipantId(@Param("participantId") long participantId, Pageable pageable);
}