bootstrap-table的使用与条件搜索

jsp页面导入：

三、body

只有一个form表单用来添加查询条件，一个table用来装载填充数据。

系统编号：所有PMS畅游通    渠道名称：所有九寨沟青都

<%--用户ID：--%>    <%--请求路径：--%>    <%--会话ID：--%>    查询

三、script或者说JS

这里就是来把数据填充到table里面的。属性意思可以去查看 官方文档，有很详细的说明，建议自己对着看，能学的深刻点，不容易忘。reloadTable方法里面是重新加载填充table。

四、后台控制层

查询数据库得到需要展示的数据。

    @ResponseBody@RequestMapping(value = "/findOptRecordList",method = RequestMethod.GET)public Object findOptRecordList(Integer offset,Integer limit,String order,String userId,String sysCode,String channelCode,String channelName,String terminalName,String sessionId,String reqUrl,String sceneNo) {int pageNo = 1;if(offset != null) {pageNo = (offset/limit +1);}PageInfo pageInfo = optManageService.findOptRecordAndEnvListPage(pageNo,limit,userId,sysCode,channelCode,channelName,terminalName,sessionId,reqUrl,sceneNo);Map resultMap = new HashMap<>();resultMap.put("rows",pageInfo.getList());resultMap.put("total",pageInfo.getTotal());return resultMap;}

PageInfo实体类（分页对象），应该不用注释了，见名思意就行了。

package com.github.pagehelper;import com.github.pagehelper.Page;
import java.io.Serializable;
import java.util.Collection;
import java.util.List;public class PageInfo implements Serializable {private static final long serialVersionUID = 1L;private int pageNum;private int pageSize;private int size;private int startRow;private int endRow;private long total;private int pages;private List list;private int prePage;private int nextPage;private boolean isFirstPage;private boolean isLastPage;private boolean hasPreviousPage;private boolean hasNextPage;private int navigatePages;private int[] navigatepageNums;private int navigateFirstPage;private int navigateLastPage;public PageInfo() {this.isFirstPage = false;this.isLastPage = false;this.hasPreviousPage = false;this.hasNextPage = false;}public PageInfo(List list) {this(list, 8);}public PageInfo(List list, int navigatePages) {this.isFirstPage = false;this.isLastPage = false;this.hasPreviousPage = false;this.hasNextPage = false;if(list instanceof Page) {Page page = (Page)list;this.pageNum = page.getPageNum();this.pageSize = page.getPageSize();this.pages = page.getPages();this.list = page;this.size = page.size();this.total = page.getTotal();if(this.size == 0) {this.startRow = 0;this.endRow = 0;} else {this.startRow = page.getStartRow() + 1;this.endRow = this.startRow - 1 + this.size;}} else if(list instanceof Collection) {this.pageNum = 1;this.pageSize = list.size();this.pages = 1;this.list = list;this.size = list.size();this.total = (long)list.size();this.startRow = 0;this.endRow = list.size() > 0?list.size() - 1:0;}if(list instanceof Collection) {this.navigatePages = navigatePages;this.calcNavigatepageNums();this.calcPage();this.judgePageBoudary();}}private void calcNavigatepageNums() {int startNum;if(this.pages <= this.navigatePages) {this.navigatepageNums = new int[this.pages];for(startNum = 0; startNum < this.pages; ++startNum) {this.navigatepageNums[startNum] = startNum + 1;}} else {this.navigatepageNums = new int[this.navigatePages];startNum = this.pageNum - this.navigatePages / 2;int endNum = this.pageNum + this.navigatePages / 2;int i;if(startNum < 1) {startNum = 1;for(i = 0; i < this.navigatePages; ++i) {this.navigatepageNums[i] = startNum++;}} else if(endNum > this.pages) {endNum = this.pages;for(i = this.navigatePages - 1; i >= 0; --i) {this.navigatepageNums[i] = endNum--;}} else {for(i = 0; i < this.navigatePages; ++i) {this.navigatepageNums[i] = startNum++;}}}}private void calcPage() {if(this.navigatepageNums != null && this.navigatepageNums.length > 0) {this.navigateFirstPage = this.navigatepageNums[0];this.navigateLastPage = this.navigatepageNums[this.navigatepageNums.length - 1];if(this.pageNum > 1) {this.prePage = this.pageNum - 1;}if(this.pageNum < this.pages) {this.nextPage = this.pageNum + 1;}}}private void judgePageBoudary() {this.isFirstPage = this.pageNum == 1;this.isLastPage = this.pageNum == this.pages;this.hasPreviousPage = this.pageNum > 1;this.hasNextPage = this.pageNum < this.pages;}public int getPageNum() {return this.pageNum;}public void setPageNum(int pageNum) {this.pageNum = pageNum;}public int getPageSize() {return this.pageSize;}public void setPageSize(int pageSize) {this.pageSize = pageSize;}public int getSize() {return this.size;}public void setSize(int size) {this.size = size;}public int getStartRow() {return this.startRow;}public void setStartRow(int startRow) {this.startRow = startRow;}public int getEndRow() {return this.endRow;}public void setEndRow(int endRow) {this.endRow = endRow;}public long getTotal() {return this.total;}public void setTotal(long total) {this.total = total;}public int getPages() {return this.pages;}public void setPages(int pages) {this.pages = pages;}public List getList() {return this.list;}public void setList(List list) {this.list = list;}/** @deprecated */@Deprecatedpublic int getFirstPage() {return this.navigateFirstPage;}/** @deprecated */@Deprecatedpublic void setFirstPage(int firstPage) {this.navigateFirstPage = firstPage;}public int getPrePage() {return this.prePage;}public void setPrePage(int prePage) {this.prePage = prePage;}public int getNextPage() {return this.nextPage;}public void setNextPage(int nextPage) {this.nextPage = nextPage;}/** @deprecated */@Deprecatedpublic int getLastPage() {return this.navigateLastPage;}/** @deprecated */@Deprecatedpublic void setLastPage(int lastPage) {this.navigateLastPage = lastPage;}public boolean isIsFirstPage() {return this.isFirstPage;}public void setIsFirstPage(boolean isFirstPage) {this.isFirstPage = isFirstPage;}public boolean isIsLastPage() {return this.isLastPage;}public void setIsLastPage(boolean isLastPage) {this.isLastPage = isLastPage;}public boolean isHasPreviousPage() {return this.hasPreviousPage;}public void setHasPreviousPage(boolean hasPreviousPage) {this.hasPreviousPage = hasPreviousPage;}public boolean isHasNextPage() {return this.hasNextPage;}public void setHasNextPage(boolean hasNextPage) {this.hasNextPage = hasNextPage;}public int getNavigatePages() {return this.navigatePages;}public void setNavigatePages(int navigatePages) {this.navigatePages = navigatePages;}public int[] getNavigatepageNums() {return this.navigatepageNums;}public void setNavigatepageNums(int[] navigatepageNums) {this.navigatepageNums = navigatepageNums;}public int getNavigateFirstPage() {return this.navigateFirstPage;}public int getNavigateLastPage() {return this.navigateLastPage;}public void setNavigateFirstPage(int navigateFirstPage) {this.navigateFirstPage = navigateFirstPage;}public void setNavigateLastPage(int navigateLastPage) {this.navigateLastPage = navigateLastPage;}public String toString() {StringBuffer sb = new StringBuffer("PageInfo{");sb.append("pageNum=").append(this.pageNum);sb.append(", pageSize=").append(this.pageSize);sb.append(", size=").append(this.size);sb.append(", startRow=").append(this.startRow);sb.append(", endRow=").append(this.endRow);sb.append(", total=").append(this.total);sb.append(", pages=").append(this.pages);sb.append(", list=").append(this.list);sb.append(", prePage=").append(this.prePage);sb.append(", nextPage=").append(this.nextPage);sb.append(", isFirstPage=").append(this.isFirstPage);sb.append(", isLastPage=").append(this.isLastPage);sb.append(", hasPreviousPage=").append(this.hasPreviousPage);sb.append(", hasNextPage=").append(this.hasNextPage);sb.append(", navigatePages=").append(this.navigatePages);sb.append(", navigateFirstPage").append(this.navigateFirstPage);sb.append(", navigateLastPage").append(this.navigateLastPage);sb.append(", navigatepageNums=");if(this.navigatepageNums == null) {sb.append("null");} else {sb.append('[');for(int i = 0; i < this.navigatepageNums.length; ++i) {sb.append(i == 0?"":", ").append(this.navigatepageNums[i]);}sb.append(']');}sb.append('}');return sb.toString();}
}

加一段service的代码...

public PageInfo findOptRecordAndEnvListPage(Integer pageNo, Integer pageSize, String userId, String sysCode,String channelCode,String channelName, String terminalName, String sessionId, String reqUrl, String sceneNo) {List list = optRecordAndEnvDAO.findOptRecordListPage(pageNo,pageSize,userId,sysCode,channelCode,channelName,terminalName,sessionId,reqUrl,sceneNo);return new PageInfo<>(list);
}

以上就是完整的实现了。最后附上一张展示效果图：

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！