datatables 过滤

logger.info("---------------" + criterias.getColumns().get(0).get(DataTableCriterias.ColumnCriterias.data));
logger.info("---------------" + criterias.getOrder().get(0).get(DataTableCriterias.OrderCriterias.column));
record.setSearchStr(URLDecoder.decode(criterias.getSearch().get(DataTableCriterias.SearchCriterias.value), "UTF-8"));

private String searchStr;

public String getSearchStr() {
    return searchStr;
}

public void setSearchStr(String searchStr) {
    this.searchStr = searchStr;
}

<if test="searchStr != null">
    AND name_ like concat(concat('%',#{searchStr}),'%')
</if>

data.search.value = encodeURI(data.search.value);

this.setPage_size(Integer.parseInt(length));
this.setPage_num((Integer.parseInt(start) / Integer.parseInt(length)) + 1);

$(document).ready(function () {
    var routeTable = $("#routeData").DataTable({
        processing: true,
        serverSide: true,
        lengthChange: true,//是否允许用户改变表格每页显示的记录数
        ordering: true,//是否允许用户排序
        paging: true,//是否分页
        pagingType: "full_numbers",//除首页、上一页、下一页、末页四个按钮还有页数按钮
        /* scrollX: true,//允许水平滚动
         scrollY: "200px",
         scrollCollapse: true, */
        searching: true,//是否开始本地搜索
        stateSave: false,//刷新时是否保存状态
        autoWidth: true,//自动计算宽度
        //deferRender : true,//延迟渲染
        displayLength: 15,
        lengthMenu: [10, 15, 30],//二组数组，第一组数量
        language: {
            "lengthMenu": "每页 _MENU_ 条记录",
            "zeroRecords": "没有您要搜索的内容",
            "processing": "正在获取数据，请稍后...",
            "info": "当前 _START_ 条到 _END_ 条 共 _TOTAL_ 条",
            "infoEmpty": "无记录",
            "infoFiltered": "(从 _MAX_ 条记录过滤)",
            "search": "搜索",
            // "processing": "载入中",
            "paginate": {
                "first": "首页",
                "previous": "上一页",
                "next": "下一页",
                "last": "尾页"
            }
        },
        ajax: {
            url: 'http://localhost:8801/manage/routes',
            type: 'GET',
            data: function (data) {
                planify(data);
            }
        },
        columns: [
            {data: "name"},
            {data: "location"},
            {data: "lastUpdate"}
        ]
    });

    routeTable.on('draw', function () {
        var body = $(routeTable.table().body());  //获得//如果之前有高亮把高亮部分去掉
        body.unhighlight();//需要高亮的容器部分
        body.highlight(routeTable.search());根据搜索框里的关键字 高亮显示
    });
});

转载于:https://my.oschina.net/u/1538767/blog/1595251