需求:ajax區域重繪表格資料
所用:python flask+jq ajax+分頁
問題:前臺成功接收到后臺傳的json資料,但不知道怎么實作“替換表格原有的資料,而且保持原來分頁的狀態(20條/頁)”
teacher.html:
$(function b() {
$.ajax({
url: "http://127.0.0.1:5000/teacher_info/delete_many/",
type: "POST",
data: k,
dataType:"json",
success: function (resp) {
if (resp) {
... // 這里就不知道怎么寫了(原本想拼接出新表格str, 再用$("#table").html(str);替換原表格,但發現由于還有分頁功能,替換后所有記錄都只在第一頁,而且表格樣式有所改變
demo.py:
# 洗掉
@app.route('/teacher_info/delete_many/',methods=['GET','POST'])
def delete_many_teacher():
result = request.form.get('data', '')
for i in json.loads(result):
id = int(i)
teacher = Teacher_info.query.filter(Teacher_info.id == id).first()
db.session.delete(teacher)
db.session.commit()
item = []
teachers = Teacher_info.query.all()
for teacher in teachers:
obj = teacher.to_json() # 呼叫了該類的自定義方法(將實體物件轉化為json)
item.append(obj)
return json.dumps(item) # item是 [ {},{},...{} ]。如[{'id':1,'name': '張三', 'age':18}, {'id':2,'name': '李四', 'age': 21,...]
# 分頁:
@app.route('/teacher_info/',methods=['GET','POST'])
def teacher_info(page=None):
paginate = Teacher_info.query.order_by(Teacher_info.id).paginate(page=page, per_page=20, error_out=False)
teachers = paginate.items
return render_template('teacher_info.html', paginate=paginate, teachers=teachers)
teacher.html:
{% for teacher in teachers %}
<tr >
<td height="20" bgcolor="#FFFFFF"><div align="center"><input type="checkbox" name="checkbox2" value="https://bbs.csdn.net/topics/checkbox"/></div></td> // 選擇方框
<td height="20" bgcolor="#FFFFFF"><div align="center" class="STYLE1"><div id="id" align="center">{{ teacher.id }}</div></div></td> // id列
<td height="20" bgcolor="#FFFFFF"><div id="username" align="center"><span class="STYLE1">{{ teacher.name }}</span></div></td> // name列
<td height="20" bgcolor="#FFFFFF"><div id="username" align="center"><span class="STYLE1">{{ teacher.age}}</span></div></td> // age列
</tr>
{% endfor %}
轉載請註明出處,本文鏈接:https://www.uj5u.com/qianduan/92689.html
標籤:Ajax
上一篇:第一天來到這里發帖子
下一篇:apache2.4反向代理tomcat8,apache配置的用http連接tomcat,洗掉tomcat的ajp連接器竟然不能訪問了,有什么原因?
