<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css"> 
<link href="css/bootstrap-table.min.css" rel="stylesheet" type="text/css"> 
<script src="js/jquery.min.js"></script> 
<script src="js/bootstrap.min.js"></script> 
<script src="js/plugins/bootstrap-table.min.js"></script> 
<script src="js/plugins/bootstrap-table-zh-CN.js"></script> 
<table class="table table-hover" id="cusTable" 
  data-pagination="true" 
  data-show-refresh="true" 
  data-show-toggle="true" 
  data-showColumns="true"> 
  <thead> 
   <tr>               
    <th data-field="sellRecordId" data-sortable="true"> 
       銷售記錄id 
    </th> 
    <th data-field="srNumber" > 
       銷售單號(hào) 
    </th> 
    <!-- 在此省略表格列的代碼，代碼和上面差不多 --> 
    <th class="col-xs-2" data-field="action" data-formatter="actionFormatter" data-events="actionEvents">Action</th>  
   </tr> 
  </thead> 
  <tbody> 
  </tbody> 
</table> 

<script type="text/javascript">   
  function initTable() { 
  //先銷毀表格 
  $('#cusTable').bootstrapTable('destroy'); 
  //初始化表格,動(dòng)態(tài)從服務(wù)器加載數(shù)據(jù) 
  $("#cusTable").bootstrapTable({ 
   method: "get", //使用get請(qǐng)求到服務(wù)器獲取數(shù)據(jù) 
   url: "<c:url value='/SellServlet?act=ajaxGetSellRecord'/>", //獲取數(shù)據(jù)的Servlet地址 
   striped: true, //表格顯示條紋 
   pagination: true, //啟動(dòng)分頁(yè) 
   pageSize: 1, //每頁(yè)顯示的記錄數(shù) 
   pageNumber:1, //當(dāng)前第幾頁(yè) 
   pageList: [5, 10, 15, 20, 25], //記錄數(shù)可選列表 
   search: false, //是否啟用查詢 
   showColumns: true, //顯示下拉框勾選要顯示的列 
   showRefresh: true, //顯示刷新按鈕 
   sidePagination: "server", //表示服務(wù)端請(qǐng)求 
   //設(shè)置為undefined可以獲取pageNumber，pageSize，searchText，sortName，sortOrder 
   //設(shè)置為limit可以獲取limit, offset, search, sort, order 
   queryParamsType : "undefined", 
   queryParams: function queryParams(params) { //設(shè)置查詢參數(shù) 
    var param = { 
     pageNumber: params.pageNumber, 
     pageSize: params.pageSize, 
     orderNum : $("#orderNum").val() 
    }; 
    return param;     
   }, 
   onLoadSuccess: function(){ //加載成功時(shí)執(zhí)行 
    layer.msg("加載成功"); 
   }, 
   onLoadError: function(){ //加載失敗時(shí)執(zhí)行 
    layer.msg("加載數(shù)據(jù)失敗", {time : 1500, icon : 2}); 
   } 
   }); 
  } 
  $(document).ready(function () {   
   //調(diào)用函數(shù)，初始化表格 
   initTable(); 
   //當(dāng)點(diǎn)擊查詢按鈕的時(shí)候執(zhí)行 
   $("#search").bind("click", initTable); 
  }); 
</script> 

/** 
  * 根據(jù)頁(yè)碼和每頁(yè)記錄數(shù)，以及查詢條件動(dòng)態(tài)加載銷售記錄 
  * @param request 
  * @param response 
  * @throws IOException 
  * @author lzx 
  */ 
 private void ajaxGetSellRecord(HttpServletRequest request, 
   HttpServletResponse response) throws IOException { 
  response.setCharacterEncoding("utf-8"); 
  PrintWriter pw = response.getWriter(); 
  //得到客戶端傳遞的頁(yè)碼和每頁(yè)記錄數(shù)，并轉(zhuǎn)換成int類型 
  int pageSize = Integer.parseInt(request.getParameter("pageSize")); 
  int pageNumber = Integer.parseInt(request.getParameter("pageNumber")); 
  String orderNum = request.getParameter("orderNum"); 
  //分頁(yè)查找商品銷售記錄，需判斷是否有帶查詢條件 
  List<SimsSellRecord> sellRecordList = null; 
  sellRecordList = sellRecordService.querySellRecordByPage(pageNumber, pageSize, orderNum); 
  //將商品銷售記錄轉(zhuǎn)換成json字符串 
  String sellRecordJson = sellRecordService.getSellRecordJson(sellRecordList); 
  //得到總記錄數(shù) 
  int total = sellRecordService.countSellRecord(orderNum); 
  //需要返回的數(shù)據(jù)有總記錄數(shù)和行數(shù)據(jù) 
  String json = "{\"total\":" + total + ",\"rows\":" + sellRecordJson + "}"; 
  pw.print(json); 
 }