我正在使用 Spring Data Jpa 進(jìn)行開發(fā)。我有一個(gè)擴(kuò)展JpaRepository的接口,我想使用Query Method和分頁進(jìn)行查詢。我想查詢“從作弊中選擇 * 投票 <= 5”我有一個(gè)簡單的代碼。該實(shí)體如下:@Entity@Table(name="cheat")@DynamicInsert@DynamicUpdate@Data@RequiredArgsConstructor(staticName="of")public class Cheat implements Serializable{ private static final long serialVersionUID = 1L; @Id @GeneratedValue(strategy=GenerationType.IDENTITY) @Column(name="cheat_seq", length=10) private Long cheatSeq; @Column(name="question", unique=true, nullable=false) private String question; @Column(name="answer", unique=true, nullable=false) private String answer; @Column(name="writer_ip", nullable=false) private String writerIP; @Temporal(TemporalType.TIMESTAMP) @Column(name="reg_date", nullable=false) private Date regDate; @Column(name="vote", nullable=false) private Long vote; @Column(name="bad_vote", nullable=false) private Long badVote;}存儲(chǔ)庫如下:public interface CheatRepository extends JpaRepository<Cheat, Long>{ Page<Cheat> findByVoteLessThan(int i, PageRequest page);}我查詢:PageRequest pgRequest = PageRequest.of(pageNo, 5, new Sort(Direction.DESC, "regDate"));cheatRepository.findByVoteLessThan(5, pgRequest);它說只有 1 個(gè)參數(shù)存在。當(dāng)然,我只是為投票 <= 5和分頁信息提供“5”值。什么地方出了錯(cuò)??編輯我找到了正確答案。在repository類中,參數(shù)PageRequest是錯(cuò)誤的。它是可分頁的。
帶有分頁的 Spring Data JPA 方法查詢給了我一個(gè)錯(cuò)誤
動(dòng)漫人物
2021-11-03 14:47:06