Springboot JPA @Query 执行sql语句

执行原生SQL

public interface TransactionRepository extends JpaRepository<Transaction, Long> {
    @Query(value ="select * from transaction where id>?1 limit ?2", nativeQuery = true)
    List< Transaction > getTransactions(Integer startIndex, Integer limit);
}

使用自定义参数名

public interface UserRepository extends JpaRepository<User, Long> {

  @Query("select u from User u where u.firstname = :firstname or u.lastname = :lastname")
  User findByLastnameOrFirstname(@Param("lastname") String lastname,
                                 @Param("firstname") String firstname);
}

支持分页

public interface UserRepository extends JpaRepository<User, Long> {

  @Query(value = "SELECT * FROM USERS WHERE LASTNAME = ?1",
    countQuery = "SELECT count(*) FROM USERS WHERE LASTNAME = ?1",
    nativeQuery = true)
  Page<User> findByLastname(String lastname, Pageable pageable);
}

官方文档