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

rui183000

于 2017-07-11 23:24:41 发布

阅读量2k

点赞数

分类专栏： spring-boot 文章标签： spring-boot 分页查询

本文链接：https://blog.youkuaiyun.com/rui18300072030/article/details/75000321

版权

spring-boot 专栏收录该内容

5 篇文章

订阅专栏


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);
}