JAVA：datatable使用小记

1. sql 语句加入分页可大幅提高查询速率,180S–>0.56S;
2. 网络限制,因查询结果过多,传输过慢导致.
   SELECT * FROM pat_patent WHERE MATCH (aa,ad,agc,an,pn,in,pa,ti,co) AGAINST ('三星' IN NATURAL LANGUAGE MODE) LIMIT 10, 10;

• jsp中修改dataTable中参数

    "fnServerParams": function (aoData) {  //查询条件
             alert($("#name").val()),
             aoData.push(
                 { "name": "monGroup", "value": $("#name").val()}
             )
         },
  

• controller中获取参数

    String name = request.getParameter("monGroup");