前端:

<table id="LAY-user-manage" lay-filter="LAY-user-manage" class="layui-hide"></table> <script th:inline="none">//"[[" 和 thymeleaf模板解析沖突,用th:inline="none"解決layui.config({base: '/layuiAdmin/src/layuiadmin/' //靜態資源所在路徑}).extend({index: 'lib/index' //主入口模塊}).use(['index', 'useradmin', 'table'], function(){var $ = layui.$,form = layui.form,table = layui.table;//table列表渲染table.render({elem:'#LAY-user-manage',height: 'full-200',url:'/admin/cases/list',title:'解決方案表',page:true,//開啟分頁limit:5,//默認每頁顯示條數limtis: [3,5,10]//可選的每頁顯示條數cols:[[{type:'checkbox',fixed:'left'},{field:'id', width:80, sort: true,title:'ID'},{field:'title', width:200, title: '標題'},{field:'pic',width:250,title:'封面圖片',templet:'#imgtmp'},{field:'content', minWidth:400, title: '內容' },{field:'sort', width:100, title: '分類' },{fixed: 'right', width: 165, align:'center', toolbar: '#table-useradmin-webuser'}]]}); </script>

Mapper

public interface CasesMapper {@Select("select * from cases order by id desc limit #{startNum}, #{limit}")public List<Cases> findAllCases(Integer startNum,Integer limit);//獲取數據總條數@Select("select count(id) from cases")public int countId(); }

Service

import com.ncyteng.dazheng.entity.Cases;import java.util.List;public interface CasesService {public List<Cases> findAllCases(Integer page,Integer limit);public int countId(); }

ServiceImpl

@Service public class CasesServiceImpl implements CasesService {@Resourceprivate CasesMapper casesMapper;@Overridepublic List<Cases> findAllCases(Integer page,Integer limit) {int startNum = (page - 1) * limit;return casesMapper.findAllCases(startNum,limit);}@Overridepublic int countId() {return casesMapper.countId();} }

Controller

layui table組件自動在URL中傳遞page和limit值,直接接收,

@Controller @RequestMapping("/admin/cases") public class CasesController {@Resourceprivate CasesService casesService;//映射list.html@GetMapping("/")public String listIndex() {return "/admin/cases/list";}//list傳值url@GetMapping("/list")@ResponseBody//變量名需要同步layui,或者在前端配置變量名public Map findAllCases(@RequestParam(defaultValue = "1") Integer page,@RequestParam(defaultValue = "10") Integer limit) {System.out.println(page+","+limit);List<Cases> allCases = casesService.findAllCases(page,limit);int count = casesService.countId();Map<String, Object> res = new HashMap<>();res.put("code", "0");res.put("msg", "上傳成功");res.put("data", allCases);res.put("count", count);//layui會自動接收所有數據條數count并處理成分頁return res;} }

controller必須傳遞count總數,不然layui接收以后不能計算總共需要多少頁,分頁會失敗

顯示效果

總結

以上是生活随笔為你收集整理的springboot layuiAdmin实现分页的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。