spring boot使用原生sql分页查询以及两张表的内连接查询sql

public interface TestDao extends CrudRepository< User,Integer> {//mysql的sql写法 @Query(value = "select * from sys_user t where 0<t.discount and t.discount<1 ORDER BY t.discount DESC limit ?1,?2",nativeQuery = true)    public List<Book> getBooksBy(int pageNum,int pageSize);//表sys_order和表sys_order_book内连接查询及分页 @Query(value = "select booknum,bookId from sys_order_book join sys_order on (sys_order.state=0) ORDER BY sys_order_book.booknum DESC limit ?1,?2",nativeQuery = true)    public List<Object> getByBookNum(int pagaNum,int pageSize);}