Springmvc + mongodb + dataTables 分页显示数据及导出Excel文件

1、html 

<! DOCTYPE   html>

< html >

< head >

< title >   用户管理 </ title   >

< meta   name =   "keywords"   content   = "keyword1,keyword2,keyword3" >

< meta   name =   "description"   content   = "this is my page" >

< meta   name =   "content-type"   content   = "text/html; charset=UTF-8" >

<!-- DATE RANGE PICKER -->

< style   type =   "text/css"   title   = "currentStyle" >

      @IMPORT   url("${request.contextPath}/plugin/cloudadmin/js/datatables/media/css/demo_page.css")   ;

      @IMPORT   url("${request.contextPath}/plugin/cloudadmin/js/datatables/media/css/demo_table_jui.css")   ;

      @IMPORT   url("${request.contextPath}/plugin/cloudadmin/js/datatables/media/css/demo_table.css")   ;

      @IMPORT   url("${request.contextPath}/plugin/cloudadmin/js/datatables/extras/TableTools/media/css/TableTools.min.css")   ;

      @IMPORT   url("${request.contextPath}/plugin/cloudadmin/js/datatables/extras/TableTools/media/css/TableTools._JUI.css")   ;

</ style >

< script   type =   "text/javascript"   src =   "${request.contextPath}/plugin/cloudadmin/js/datatables/media/js/jquery.js"   ></ script   >

< script   type =   "text/javascript"   src =   "${request.contextPath}/plugin/cloudadmin/js/datatables/media/js/jquery.dataTables.min.js"   ></ script   >

< script   type =   "text/javascript"   src =   "${request.contextPath}/plugin/cloudadmin/js/datatables/extras/TableTools/media/js/ZeroClipboard.min.js"   ></ script   >

< script   type =   "text/javascript"   src =   "${request.contextPath}/plugin/cloudadmin/js/datatables/extras/TableTools/media/js/TableTools.min.js"   ></ script   >

< script   type =   "text/javascript" >

     var   url =   "${request.contextPath}/user/page.do"   ;

     $(document).ready(   function (){

         $(   '#example' ).dataTable({

             "bFilter" :   false ,   //过滤功能

             //关闭过滤功能替换为文件导出按钮

             "sDom"   :   'T<"clear">lfrtip'   ,

             //"sDom" : "<'row-fluid inboxHeader'<'span6'<'dt_actions'>l><'span6'f>r>t<'row-fluid inboxFooter'<'span6'i><'span6'p>>", //待补充

             "bPaginate" :   true ,   //翻页功能

             "bLengthChange" :   true ,   //改变每页显示数据数量

             "bSort" :   true ,   //排序功能

             "bInfo" :   true , //页脚信息

             "bAutoWidth" :   true , //自动宽度

             "sPaginationType"   :   "full_numbers"   ,   //分页风格，full_number会把所有页码显示出来

             "bProcessing" :   false ,   // 是否显示取数据时的那个等待提示

             "bServerSide" :   true , //这个用来指明是通过服务端来取数据

             "sAjaxSource" : url, //这个是请求的地址

             "fnServerData" : retrieveData , // 获取数据的处理函数

             "aoColumns"   : [

              {   "sDefaultContent"   :   ''   }, 

              {   "mData"   :   'name'   }, 

              {   "mData"   :   'rolename'   },

                    {   "mData"   :   'statue'   },

                        //mData 表示发请求时候本列的列名，返回的数据中相同下标名字的数据会填充到这一列

                     {   "sDefaultContent"   :   ''   }

                ],

                   "oTableTools"   : {//导出文件

                        "sSwfPath"   :   "${request.contextPath}/plugin/cloudadmin/js/datatables/extras/TableTools/media/swf/copy_csv_xls_pdf.swf"   ,

                        "aButtons"   : [

                         {

                              "sExtends"   :   "xls"   ,

                              "sButtonText"   :   "导出Excel文件"   ,

                              "sFileName"   :   "*.xls"

                           },

                         ]

                },

                   "oLanguage" : { //国际化

                        "sLengthMenu" :   "每页显示 _MENU_ 条记录"   , 

                        "sZeroRecords" :   "抱歉， 没有找到"   , 

                        "sInfo" :   "从 _START_ 到 _END_ /共 _TOTAL_ 条数据" , 

                        "sInfoEmpty" :   "没有数据"   , 

                        "sInfoFiltered" :   "(从 _MAX_ 条数据中检索)"   , 

                        "oPaginate" : { 

                              "sFirst" :   "首页"   , 

                              "sPrevious" :   "前一页"   , 

                              "sNext" :   "后一页"   , 

                              "sLast" :   "尾页"    

                     }, 

                        "sZeroRecords" :   "没有检索到数据"   , 

                        "sProcessing" :   "<img src='./loading.gif' />"  

                }, 

             "fnRowCallback"   :   function (nRow, aData,iDisplayIndex) {//设置列从0开始

                     $(   'td:eq(0)' , nRow).html(iDisplayIndex + 1);

                        if (aData.id ==   "${userid}"   ){

                              if (aData.statue ==   "Y"   ){

                                $(   'td:eq(3)' , nRow).html( &#