html
<table id="parkdata" class="table table-bordered table-hover">
<thead>
<tr>
<th>编号</th>
<th>名称</th>
<th>地址</th>
<th>联系人</th>
<th>类型</th>
<th>状态</th>
</tr>
</thead>
</table>
js
$(function () {
reloadDatatables()
});
var reloadDatatables = function () {
var tables = $('#parkdata').DataTable({
select: 'single',
destroy: true,
'bAutoWidth': false,
"pagingType": "full_numbers",
// language.json 这个文件是设置中文显示的,也可以直接写在初始化这里
"language": {"url": "{{ url_for('static', filename='plugins/datatables/language.json') }}"},
"serverSide": true, //开启服务器模式
"ajax": function (data, callback) { //data参数不太理解,为什么它会有data.draw,是datatables原本定义好的嘛吗?
var param = {};
param.draw = data.draw;
param.start = data.start;
param.length = data.length;
param.page = param.start / param.length + 1; //计算页码
var paramString = JSON.stringify(param);
console.log('paramString: ' + paramString);
$.ajax({
type: "POST",
url: "{{ url_for('testsys.test') }}", //写实际的路由
data: paramString,
dataType: 'json',
success: function (res) { //res后端返回的参数
var returnData = {};
returnData.draw = res.draw; // 计数器
returnData.recordsTotal = res.recordsTotal;//返回数据全部记录
returnData.recordsFiltered = res.recordsFiltered;//过滤后记录
returnData.data = res.data; // 数据对象
console.log(returnData.data);
callback(returnData);
},
error: function () {
alert('错误');
}
})
}
});
};
view.py
@testsys.route('/test', methods=['GET','POST'])
def test():
if request.method == 'POST':
testdata = json.loads(request.get_data()) #这边的话 用request.data拿到的是空的,还没明白
print(testdata)
print(type(testdata))
draw = testdata['draw']
start = testdata['start']
length = testdata['length']
# page = start // length + 1 # 计算页码
page = testdata['page']
# recordsTotal = Test.query.order_by(Test.create_on.desc()).count() # 未过滤记录数
recordsFiltered = Test.query.filter(Test.state==1).order_by(Test.create_on.desc()).count() # 过滤后的记录
recordsTotal = recordsFiltered
# 这边用paginate来获取请求页码的数据
pagination = Test.query.filter(Test.state==1).order_by(Test.create_on.desc()).paginate(
page=page, per_page=length, error_out=True)
objs = pagination.items
# 把页面对象变成数组,用数组作为数据源
data = []
for obj in objs:
list = [obj.id, obj.name, obj.address, obj.contact, obj.type, obj.state]
data.append(list)
res = {
# 看文档 这四个都是必要的参数,还有个error可传可不传
'draw': draw,
'recordsTotal' :recordsTotal,
'recordsFiltered': recordsFiltered,
'data': data,
}
print(jsonify(res))
return jsonify(res)
else:
return render_template('testsys/test.html')
目前只调通前端后端基础的数据接收发送,还没有做排序、搜索这些