wlyy2.0/svr/svr-rehabilitation/src/main/java/com/yihu/rehabilitation/dao/FrequencyDao.java

package com.yihu.rehabilitation.dao;


import com.yihu.jw.entity.hospital.doctor.Frequency;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import java.util.List;

/**
 * Created by wzn54 on 2019/1/17.
 */
public interface FrequencyDao extends PagingAndSortingRepository<Frequency, Long>, JpaSpecificationExecutor<Frequency> {

    @Query("select f from Frequency f where  f.del=1")
    List<Frequency> findByDel();

    @Query("select f from Frequency  f where f.del=1 and f.code=?1 ")
    Frequency findByCode(String code);
}