wlyy2.0/svr/svr-wlyy-health-bank/src/main/java/com/yihu/jw/dao/AccountDao.java

package com.yihu.jw.dao;/**
 * Created by nature of king on 2018/5/10.
 */

import com.yihu.jw.entity.health.bank.AccountDO;
import com.yihu.jw.entity.health.bank.ActivityDO;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import java.util.List;

/**
 * @author wangzhinan
 * @create 2018-05-10 11:15
 * @desc health bank account dict
 **/
public interface AccountDao extends PagingAndSortingRepository<AccountDO,String>,JpaSpecificationExecutor<AccountDO> {
    @Query("select t from AccountDO t where t.patientId=?1 and t.status=1")
    AccountDO selectByPatientId(String patientId);

    @Query("select t from AccountDO t where t.patientId=?1 and t.status=1")
    List<AccountDO> selectsByPatientId(String patientId);

    @Query("select t from AccountDO t where t.patientId=?1")
    List<AccountDO> findByPatientId(String patientId);
}