用limit 实现java的简单分页

- 日理万妓 2023-01-05 03:56 257阅读 0赞

[https://blog.csdn.net/xinyuezitang/article/details/84324359][https_blog.csdn.net_xinyuezitang_article_details_84324359]

# 用limit 实现java的简单分页 #

![426136e8363e68fc321f3d3551b0d579.png][]

[xinyuezitang][] 2018-11-21 16:01:13 ![11d4e66b47a786d7307438a15382d44a.png][] 4447 ![50c7c045de1e4400c6f27a33ed55cf7c.png][] 收藏 9

分类专栏： [Java 小Demo][Java _Demo] 文章标签： [分页][Link 1] [limit][] [mysql][] [实现java分页][java]

版权

**一 mysql 中limit 用法**

select * from table limit m,n       
    意思是: 在table数据库中, 从m开始,拉取n条数据.
    
    在mysql中, m代表index, 默认从0 开始;   n最小从m+1开始,取n条
    limit start,size           从start条开始,获取size条数据

**二 分页实现**

**前端思路:**

将page 和 rows 两个参数传递给后端	
    page : 代表第几页
    rows:  代表当前页显示的数据条数

**java思路:**

获取当前页的第一条:          (page-1)*rows	
    sql语句查询分页: 	        limit (page-1)*rows,rows
    sql语句获取列表总数量:       select count(1) from table

**三 后端代码:**

**Controller:**

@Autowired
        private ActivityService activityService;
        	
    	@RequestMapping("/url")
        public ResponseEntity<?> getRecords(@RequestParam("uid") String uid,
                                                @RequestParam(value="page",required = false, defaultValue ="1") int page,
                                                @RequestParam(value="rows",required = false, defaultValue ="10") int rows){ 
            List<MyRecord> records = activityService.getMyRecord(uid,page,rows);
            Long  total = activityService.getMyRecordCount(uid);
            JSONObject result = new JSONObject();
            result.put("result", "ok");
            result.put("records", records);
            result.put("total ", total );
            return new ResponseEntity<>(result, HttpStatus.OK);
        }

**Service:**

List<MyRecord> getMyRecord((String uid, int page, int rows);
    Long  getMyRecordCount(String uid);

**ServiceImpl：**

@Autowired
    private ActivityMapper activityMapper;
       
       /**
       * 获取分页列表
       */
    public List<MyRecord> getMyRecord(String uid, int page, int rows) {
        int i = (page - 1) * rows;
        List<MyRecord> records = activityMapper.getMyRecordToPage(uid, i, rows);
        return records;
    }
    
    /**
       * 获取列表总数量
       */
    public Long getMyRecorCount(String uid) {
         Long total= activityMapper.getMyRecordToPageCount(uid);
         return total;
    }

**Dao:**

@Select("select * from myRecord where uid = #{0} order by create_time desc limit #{1},#{2}")
    List<NineMyRecord> getMyWinRecordToPage(String uid, int i, int rows);
    
    @Select("select count(*) from myRecord where uid = #{0}”)
    Long  getMyWinRecordToPageCount(String uid);

[https_blog.csdn.net_xinyuezitang_article_details_84324359]: https://blog.csdn.net/xinyuezitang/article/details/84324359
[426136e8363e68fc321f3d3551b0d579.png]: /images/20221119/78aaf519c552403595f6b6d57cff79ec.png
[xinyuezitang]: https://blog.csdn.net/xinyuezitang
[11d4e66b47a786d7307438a15382d44a.png]: https://img-blog.csdnimg.cn/img_convert/11d4e66b47a786d7307438a15382d44a.png
[50c7c045de1e4400c6f27a33ed55cf7c.png]: /images/20221119/f55aaf599d0344f49eead377b64a71d7.png
[Java _Demo]: https://blog.csdn.net/xinyuezitang/category_8909613.html
[Link 1]: https://www.csdn.net/tags/MtTaEg0sMzg1ODItYmxvZwO0O0OO0O0O.html
[limit]: https://www.csdn.net/tags/MtTaEg0sMjQzMjEtYmxvZwO0O0OO0O0O.html
[mysql]: https://www.csdn.net/tags/MtTaEg5sOTYwNC1ibG9n.html
[java]: https://so.csdn.net/so/search/s.do?q=%E5%AE%9E%E7%8E%B0java%E5%88%86%E9%A1%B5&t=blog&o=vip&s=&l=&f=&viparticle=