java/com/liujian/gymxmjpa/dao/chongzhiDao.java

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.liujian.gymxmjpa.dao;

import com.liujian.gymxmjpa.entity.Chongzhi;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.domain.Specification;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

/**
 * @Description: 充值信息Dao层接口
 * @Author: LiuJian
 * @Date: 2020/4/3
 */
public interface chongzhiDao extends JpaRepository<Chongzhi,Long> {

    Page<Chongzhi> findAll(Specification<Chongzhi> specification, Pageable pageable);

    @Query(value = "select * FROM  chongzhi where memberid =:memberid",nativeQuery = true)
    public List<Chongzhi> queryByIdNative(@Param("memberid") long memberid) ;
}