Spring Boot实践应用开发（8）

来源：互联网发布：小米数据迁移分身编辑：程序博客网时间：2024/06/03 10:46
【使用jquery.dataTables.js,dataTables.fixedColumns.js】
准备，下载fifth.zip并导入到eclipse，下载地址http://pan.baidu.com/s/1o6spOJS
1，修改users.html
<!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"xmlns:th="http://www.thymeleaf.org"><head><meta charset="UTF-8" /><title>Users</title><metacontent='width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no'name='viewport' /><meta th:replace="head-cssjs" /></head><body class="skin-blue"><div class="wrapper"><!-- Content Wrapper. Contains page content --><div class="content-wrapper"><!-- Content Header (Page header) --><section class="content-header"><h1>Users</h1></section><!-- Main content --><section class="content"><div class="row"><div class="col-md-12"><form id="usersInputForm" method="post" class="form-horizontal"><div id="maincontent" class="box box-primary"style="overflow-y: auto; overflow-x: hidden;"><div class="box-body"><div class="form-group"><div class="col-md-12"><div th:if="${page} != null and ${ph} != null " class="row"><div class="col-md-12"><p class="pageList">检索结果 <span th:text="${page.totalElements}"></span>件 <spanclass="prev"th:attr="style=${ph.hiddenFirst} ? 'visibility:hidden'"><aclass="js-pagenation"th:href="@{/sample/users/show(page=0,size=${page.size})}"id="searchIdFirst"><<</a></span> <span class="prev"th:attr="style=${ph.hiddenPrev} ? 'visibility:hidden'"><aclass="js-pagenation"th:href="@{/sample/users/show(page=${page.number - 1},size=${page.size})}"><</a></span><span th:text="${page.number + 1}"></span> / <spanth:text="${page.totalPages}"></span> 页 <span class="next"th:attr="style=${ph.hiddenNext} ? 'visibility:hidden'"><aclass="js-pagenation"th:href="@{/sample/users/show(page=${page.number + 1},size=${page.size})}">></a></span><span class="next"th:attr="style=${ph.hiddenLast} ? 'visibility:hidden'"><aclass="js-pagenation"th:href="@{/sample/users/show(page=${page.totalPages - 1},size=${page.size})}">>></a></span></p></div></div><div class="box box-success"th:attrappend="style=${page == null ? 'display: none;' : ''}"><div class="col-md-12" style="width: 99%;"><table id="searchResult"class="table table-condensed table-striped table-hover"><thead><tr><th class="col-md-1">No.</th><th class="col-md-1">username</th><th class="col-md-1">password</th><th class="col-md-1">role</th></tr></thead><tbody><tr th:each="content, iterStat : ${page}"><td class="col-md-1" th:id="${iterStat.index}"th:name="${iterStat.index}"th:value="${iterStat.index}"th:text="${iterStat.index} + 1"></td><td class="col-md-1"th:id="'page['+${iterStat.index}+'].username'"th:name="'page['+${iterStat.index}+'].username'"th:value="${content.username}"th:text="${content.username}"></td><td class="col-md-1"th:id="'page['+${iterStat.index}+'].password'"th:name="'page['+${iterStat.index}+'].password'"th:value="${content.password}"th:text="${content.password}"></td><td class="col-md-1"th:id="'page['+${iterStat.index}+'].role'"th:name="'page['+${iterStat.index}+'].role'"th:value="${content.role}" th:text="${content.role}"></td></tr></tbody></table></div></div><div th:if="${page} != null and ${ph} != null " class="row"><div class="col-md-12"><p class="pageList">检索结果 <span th:text="${page.totalElements}"></span>件 <spanclass="prev"th:attr="style=${ph.hiddenFirst} ? 'visibility:hidden'"><aclass="js-pagenation"th:href="@{/sample/users/show(page=0,size=${page.size})}"id="searchIdFirst"><<</a></span> <span class="prev"th:attr="style=${ph.hiddenPrev} ? 'visibility:hidden'"><aclass="js-pagenation"th:href="@{/sample/users/show(page=${page.number - 1},size=${page.size})}"><</a></span><span th:text="${page.number + 1}"></span> / <spanth:text="${page.totalPages}"></span> 页 <span class="next"th:attr="style=${ph.hiddenNext} ? 'visibility:hidden'"><aclass="js-pagenation"th:href="@{/sample/users/show(page=${page.number + 1},size=${page.size})}">></a></span><span class="next"th:attr="style=${ph.hiddenLast} ? 'visibility:hidden'"><aclass="js-pagenation"th:href="@{/sample/users/show(page=${page.totalPages - 1},size=${page.size})}">>></a></span></p></div></div></div></div></div></div></form></div></div></section><!-- /.content --></div><!-- /.content-wrapper --></div><!-- ./wrapper --><div th:replace="bottom-js"></div><script th:inline="javascript">/*<![CDATA[*/$(document).ready(function() {var table = $('#searchResult').DataTable({scrollY : "390px",scrollX : true,scrollCollapse : true,paging : false,searching : false,});new $.fn.dataTable.FixedColumns(table, {leftColumns : 1});$('.js-pagenation').each(function() {$(this).click(function() {$('#usersInputForm').attr('action', $(this).attr('href'));$(this).attr('href', '#');$('#usersInputForm').submit();});});});/*]]>*/</script></body></html>
2, 启动项目，输入URL，http://localhost:8888/sample/users/show
点击标题就可以排序了。
代码下载地址
http://pan.baidu.com/s/1o6spOJS,sixth.zip
0 0