在JPA的@Query注解中使用limit条件(详解)

下面小编就为大家带来一篇在JPA的@Query注解中使用limit条件(详解)。小编觉得挺不错的，现在就分享给大家，也给大家做个参考。一起跟随小编过来看看吧

在@Query注解注释的JPQL语句中写limit语句是会报错的

unexpected token :limit near line ....

解决方法是讲@Query注解中的limit语句去掉，然后传一个Pageable pageable=new PageRequest(offset,limit)进去

示例代码：

controller

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

import java.util.List;   import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController;   @RestController @RequestMapping(value = "/misaka") public class MisakaController {   @Autowired   private MisakaService misakaService;     @RequestMapping(value = "/list")   public List<Misaka> getBaselineOverview()   {     return misakaService.getMisaka();   }   }

service

?

1 2 3 4 5 6

import java.util.List;   public interface MisakaService {   List<Misaka> getMisaka(); }

serviceimpl

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

import java.util.List;   import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Page; import org.springframework.data.domain.PageRequest; import org.springframework.data.domain.Pageable; import org.springframework.data.domain.Sort.Direction; import org.springframework.stereotype.Service;   @Service public class MisakaServiceImpl implements MisakaService {   @Autowired   private MisakaDao misakaDao;     @Override   public List<Misaka> getMisaka()   {     Pageable pageable = new PageRequest(1, 2, Direction.ASC, "name");     Page<Misaka> misakaPage = misakaDao.search(pageable);     List<Misaka> misakaList = misakaPage.getContent();     System.out.println(misakaList);     return misakaList;   } }

dao

?

1 2 3 4 5 6 7 8 9 10

import org.springframework.data.domain.Page; import org.springframework.data.domain.Pageable; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.CrudRepository;   public interface MisakaDao extends CrudRepository<Misaka, Long> {   @Query("SELECT m FROM Misaka m WHERE m.id>4")   Page<Misaka> search(Pageable pageable); }

model

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table;   @Entity @Table(name = "t_test") public class Misaka {   @Id   @GeneratedValue(strategy = GenerationType.AUTO)   private Long id;     @Column(name = "name")   private String name;     public Long getId()   {     return id;   }     public void setId(Long id)   {     this.id = id;   }     public String getName()   {     return name;   }     public void setName(String name)   {     this.name = name;   }     @Override   public String toString()   {     return "Misaka [id=" + id + ", name=" + name + "]";   }   }

数据库t_test

id	name
1	m1
2	m2
3	m3
4	m4
5	m5
6	m6
7	m7
8	m8
9	m9

输出

?

1 2 3

Hibernate: select count(misaka0_.id) as col_0_0_ from t_test misaka0_ where misaka0_.id>4 Hibernate: select misaka0_.id as id1_29_, misaka0_.name as name2_29_ from t_test misaka0_ where misaka0_.id>4 order by misaka0_.name asc limit ?, ? [Misaka [id=7, name=m7], Misaka [id=8, name=m8]]

以上这篇在JPA的@Query注解中使用limit条件(详解)就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持服务器之家。