1. 加载当前数据的 JS
$(document).ready(function() {
var table = $('#YKenanTable').DataTable({
"ajax": {
"url": "YKenan_YKenan",
"type": "GET",
"dataType": "json",
"dataSrc": ""
},
"destroy": "true",
"columns": [{
"data": 'data1',
"sClass": "text-center"
},
{
"data": 'data2',
"sClass": "text-center"
},
{
"data": 'data3',
"sClass": "text-center"
},
{
"data": 'data4',
"sClass": "text-center"
},
{
"data": 'data5',
"sClass": "text-center"
},
{
"data": 'data6',
"sClass": "text-center"
},
{
"data": 'data7',
"sClass": "text-center"
}
],
"dom": 'Bfrtip',
"buttons": ['copy', 'excel', 'pdf', 'csv', 'print']
});
$('#YKenanTable tbody').on('click', 'tr', function() {
if($(this).hasClass('selected')) {
$(this).removeClass('selected');
} else {
table.$('tr.selected').removeClass('selected');
$(this).addClass('selected');
}
});
});
2. 更改加载数据的 JS
function changeYKenan(YKenan1, YKenan2, YKenan3, YKenan4) {
console.log(YKenan1);
$.ajax({
url: "http://localhost:8080/YKenan",
type: "GET",
data: {"YKenan1": YKenan1, "YKenan2": YKenan2, "YKenan3": YKenan3, "YKenan4": YKenan4},
contentType: "application/json;charsetset=UTF-8",
datatype: "json",
async: true,
success: function(data) {
var data = eval(JSON.stringify(data));
console.log(data);
$(".YKenan #YKenanTable").DataTable().clear().draw();
$(".YKenan #YKenanTable").DataTable({
"data": data,
"destroy": "true",
"columns": [{
"data": "data1",
"sClass": "text-center"
},
{
"data": "data2",
"sClass": "text-center"
},
{
"data": 'data3',
"sClass": "text-center"
},
{
"data": 'data4',
"sClass": "text-center"
},
{
"data": 'data5',
"sClass": "text-center"
},
{
"data": 'data6',
"sClass": "text-center"
},
{
"data": 'data7',
"sClass": "text-center"
}
]
});
},
error:function(){
alert("Error");
}
});
}
3. 注意
需要添加允许从新加载数据
"destroy": "true"
清空数据
$(".YKenan #YKenanTable").DataTable().clear().draw();