package com.cirle.scientific.dao;

import com.cirle.scientific.po.QkjTqcourseApp;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import java.util.List;

public interface QkjTqcourseAppDao extends PagingAndSortingRepository<QkjTqcourseApp, Long>,
        JpaSpecificationExecutor<QkjTqcourseApp>{


    @Query(value = "SELECT * FROM qkj_tqcourse_app WHERE type = ?1 and status = ?2" ,nativeQuery = true)
    List<QkjTqcourseApp> findByTypeAndStatus(Integer type, Integer status);
}
