bootstrap分页

实现下图：

jsp:

 function initTable() {  
        //先销毁表格  
        $('#MenuTable').bootstrapTable('destroy');  
        //初始化表格,动态从服务器加载数据  
        $('#MenuTable').bootstrapTable({  
            method: "get",  //使用get请求到服务器获取数据  
           // method: "post",
            //contentType: "application/x-www-form-urlencoded",
            url: 'wxgl/follower/wxfollowerList.do', //获取数据的Servlet地址  
            //toolbar: '#toolbar',
            striped: true,  //表格显示条纹  
            pagination: true, //启动分页  
            pageSize: 10,  //每页显示的记录数  
            pageNumber:1, //当前第几页  
            pageList: [10, 15, 20, 25],  //记录数可选列表   
            smartDisplay: false,//智能显示分页按钮
            paginationPreText: "上一页",
            paginationNextText: "下一页",
            search: false,  //是否启用查询  
            //showColumns: true,  //显示下拉框勾选要显示的列  
           // showRefresh: true,  //显示刷新按钮  
            sidePagination: "server", //表示服务端请求  
            //设置为undefined可以获取pageNumber，pageSize，searchText，sortName，sortOrder  
            //设置为limit可以获取limit, offset, search, sort, order  
            queryParamsType : "undefined",   
            queryParams: function queryParams(params) {   //设置查询参数  
              var param = {    
                  pageNumber: params.pageNumber,    
                  pageSize: params.pageSize,
                  orderNum : $("#orderNum").val()
              };  
              console.log(param);  
              return param;                   
            },  
            columns: [{
                      checkbox: true
                  },{
                     field: 'OPENID',
                     title:'关注人ID ',
                     width:200
                  },{
                  field: 'NICKNAME',
                  title:'昵称',
                  width:150
                  },{
                  field: 'SEX',
                  title:'性别',
                  width:30
                  },{
                  field: 'COUNTRY',
                  title:'国籍',
                  width:100
                  },{
                  field: 'SUBSCRIBE_TIME',
                  title:'关注时间',
                  align: 'center',
                    valign: 'middle',
                    width:150
                  }],
            onLoadSuccess: function(data){  //加载成功时执行  
             // alert("加载成功");        
            },  
            onLoadError: function(){  //加载失败时执行  
              alert("加载数据失败", {time : 1500, icon : 2});  
            }  
          });  
      }  

控制层：注意MAP里的值

public void queryMenuList(HttpServletResponse response,HttpServletRequest request,String NICKNAME) throws IOException{
    List<FollowerMessage> rows = null;  
    //需要传入微信ID
    HttpSession session=request.getSession();
    wxid=(String)session.getAttribute(Const.WB_wxId);
    SysUser sysUser=(SysUser)session.getAttribute(Const.WBUSER_SESSION);
    userid=sysUser.getUserId();
    int pageSize = Integer.parseInt(request.getParameter("pageSize"));
    int pageNumber = Integer.parseInt(request.getParameter("pageNumber"));
    int start = (pageNumber-1)*pageSize;
    int end = pageNumber*pageSize;
    Map map = new HashMap();
    map.put("wxid", wxid);
    map.put("start", start);
    map.put("end", end);
    map.put("NICKNAME", NICKNAME);
    rows = wxFollowerService.getFollower(map);
    int total=wxFollowerService.countFollower(map);
    Map<String, Object> jsonMap = new HashMap<String, Object>();// 定义map
    jsonMap.put("rows", rows);// rows键 存放每页记录 list
    jsonMap.put("total", total);// total键 存放总记录数，必须的
    //JSONArray result=JSONArray.fromObject(jsonMap);
    JSONObject result = JSONObject.fromObject(jsonMap);// 格式化result
    //logger.info(result);
    // 一定要是JSONObject
    response.setContentType("text/html;charset=utf-8");
    PrintWriter writer = response.getWriter();
    writer.write(result.toString());
    writer.flush();
}

mybatis:

<select id="getFollower" resultType="com.htxx.wxgl.entity.FollowerMessage" parameterType="map">
  select * from(
        select a.* ,ROWNUM rn from (
             SELECT OPENID,NICKNAME,COUNTRY,SUBSCRIBE_TIME,
                      (CASE WHEN SEX='1' THEN '男' WHEN   SEX='2' THEN '女' ELSE '未知' END) AS SEX 
             from wechat_user WHERE WID=#{wxid} AND ZT='1'
             <if test=" NICKNAME!=null and  NICKNAME!='' ">
                 and NICKNAME like '%${NICKNAME}%'
             </if>
        ) a
        where ROWNUM <= #{end}
    ) 
      where rn > #{start}  
</select> 
 <select id="countFollower" resultType="int" parameterType="map">
     select count(*) from wechat_user WHERE WID=#{wxid} AND ZT='1'
     <if test="NICKNAME !=null and NICKNAME !='' ">
     and NICKNAME like '%${NICKNAME}%'
</if>
</select>