1)前端代码
<h3>新增用户<h3>
<form>
<input name='name' placeholder="username">
<input name='phone' placeholder="手机号">
<button type="button" οnclick="searchUser(searchKey.value)">查询</button>
<script>
$(function (){
queryAll()
$("#updateDiv").hide();
})
function searchUser(key) {
alert("waitings dev!"+key);
$.getJSON('/user/?key='+key,function (data) {
alert(data.msg);
if('data.state==ok'){
#('updateDiv').fadeIn(1000);
//将查明的结果显示
$('#updateForm > input[name='id'].val(data.data.id);
$('#updateForm > input[name='name'].val(data.data.name);
$('#updateForm > input[name='phone'].val(data.data.phone);
}
})
}
2)后端
from flask import request
from flask_restful import Api,Resource
from sqlalchemy import or_
api = Api()
def init_api(app):
api.init_app(app)
class UserApi(Resource):
def(self):
key = request.args.get('key')
if key:
result = {'state': 'fail', 'msg':'查无数据'}
qs = query(User).filter(or_(User.id == key,User.name ==key, User.phone==key))
if qs.count():
result['state'] = 'ok'
result['msg'] = '查询成功'
result['data'] = qs.first().json
users = queryAll(User)
return {'state':'ok', 'data': [user.json for user in users]}