jpa 模糊查找后 获取list前10条记录

Repository:

@Repository
public interface BankRepository extends JpaRepository<Bank, Integer>, JpaSpecificationExecutor {


    List<Bank> findByNameLike(Pageable pageable, String name);
}

 

service:

PageRequest pr = new PageRequest(0, 10);

/**
 */
@Component
public class BankFacadeImpl implements BankFacade {
    @PersistenceContext
    private EntityManager entityManager;
    @Autowired
    private BankRepository bankRepository; 


    @Override
    public List<Bank> queryBankByName(String name) {
        PageRequest pr = new PageRequest(0, 10);
        List<Bank> list = bankRepository.findByNameLike(pr,"%"+name+"%");
        return list;
    }
}

 

 

 

Controller:

 

    @RequestMapping("/queryBankByName")
    public ResponseEntity queryBankByName(String name){
        List<Bank> list =bankFacade.queryBankByName(name);
        return ResponseEntity.ok(Result.success(list));
    }