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);
}
spring boot使用原生sql分页查询以及两张表的内连接查询sql
最新推荐文章于 2023-04-16 22:20:40 发布