从零开始学Python-day8
##flask逻辑端代码# cat demo.py
#!/usr/bin/python
#coding:utf-8
from flask import Flask ,render_template,redirect,request
import MySQLdb as mysql
from datetime import datetime
datas = mysql.connect(user='root',passwd='123456',db='reboot',charset='utf8')
datas.autocommit(True)
cur = datas.cursor()
fields = ["id","name","name_cn","password","email","mobile","role","status","create_time"]
app = Flask(__name__)
def getNow():
now = datetime.now().strptime("%Y-%m-%d %H:%M:%S")
return now
@app.route('/user/userlist')
def userlist():
sql = "select %s from %s" %(','.join(fields),'users')
cur.execute(sql)
res = cur.fetchall()
users = [ dict((v,row) for k ,v in enumerate(fields)) for row in res]
return render_template('userlist.html',users = users)
@app.route('/user/delete')
def delete():
id = request.args.get('id',None)
print id
d_sql = "No id error"
if id :
d_sql = "DELETE from users where id = %s" %id
cur.execute(d_sql)
return redirect('/user/userlist')
return render_template('test.html',errmes = d_sql)
@app.route('/user/update',methods=['GET','POST'])
def update():
if request.method == "POST":
user = dict(request.form)
user = dict((k,v) for k ,v in user.items())
#print user ==>{'mobile': u'CCC', 'name_cn': u'ccccccc', 'id': u'2', 'name': u'cc', 'email': u'CC@chinacache.com'}
#user.pop('id')
tmp_list = [ "%s='%s'"%(k,v) for k,vin user.items() if k != "id"]
#print tmp_list
update_sql = "UPDATE users set %swhere id=%s" %(','.join(tmp_list),user['id'])
cur.execute(update_sql)
return redirect('/user/userlist')
else:
id = request.args.get('id',None)
print id
select_sql = "No id error"
if id :
select_sql = "select %s from userswhere id = %s" %(','.join(fields),id)
print select_sql
cur.execute(select_sql)
res = cur.fetchone()
#print res ==>(2L, u'cc', u'cc', u'cC23 ', u'CC@chinacache.com', u'CCC', u'user', 0, datetime.datetime(2016, 11, 30, 16, 4, 33))
user = dict((v,res) for k ,v in enumerate(fields))
#return redirect('/user/userlist')
return render_template('userinfo.html',user = user)
if __name__ == "__main__":
app.run(host='0.0.0.0',port=888,debug=True)
#
##前端html代码
# cat templates/userlist.html
<html>
<p>userlist</p>
<table border='1px'>
<thead>
<tr><th>Name</th>
<th>Name_CN</th>
<th>Email</th>
<th>Mobile</th>
<th>Role</th>
<th>Status</th>
<th>Create_Time</th>
<th>Operate></th></tr>
</thead>
<tbody>
{% for user in users %}
<tr><input type='hidden' name='id' value={{ user.id }}><td>{{ user.name}}</td>
<td>`user`.`name_cn`</td>
<td>`user`.`email`</td>
<td>`user`.`mobile`</td>
<td>`user`.`role`</td>
<td>`user`.`status`</td>
<td>`user`.`create_time`</td>
<td><a href='/user/update?id=`user`.`id`'>更新</a><a href='/user/delete?id=`user`.`id`'>删除</a></tr>
{% endfor %}
</tbody>
</table>
</html>
#
# cat templates/userinfo.html
<html>
<p>userinfo</p>
<form action="/user/update" method="POST">
<table>
<tr>
<td><input type="hidden" name='id' value=`user`.`id` ></td>
</tr>
<tr>
<td>Name<input type='text' name='name' value=`user`.`name`></td>
</tr>
<tr>
<td>Name_CN<input type='text' name='name_cn' value =`user`.`name_cn`></td>
</tr>
<tr>
<td>Email<input type='text' name='email' value=`user`.`email`></td>
</tr>
<tr>
<td>Mobile<input type='text' name='mobile' value=`user`.`mobile`></td>
</tr>
<tr>
<td>Role<select >
{% if user.role == "admin" %}
<option value = 'admin'>管理员</option>
{% elif user.role == "sa" %}
<option value = 'sa'>运 维</option>
{% else %}
<option value = 'user'>普通用户</option>
{% endif %}
</select>
</td>
</tr>
<tr>
<td>status<select >
{% if user.status == 0 %}
<option value = 0>正常</option>
{% else %}
<option value = 1>锁定</option>
{% endif %}
</select>
</tr>
<tr><input type="submit" value='确认修改'></td></tr>
</form>
</html>
#
页:
[1]