1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
| from flask import Flask, render_template, request
import pymysql
app = Flask(__name__)
@app.route("/add/user", methods=["GET", "POST"])
def add_user():
if request.method == 'GET':
return render_template("add_user.html")
conn = get_conn()
insert(conn, request)
conn.close()
return "添加成功"
@app.route("/show/user")
def show_user():
conn = get_conn()
all_info = get_all(conn)
conn.close()
print(all_info)
return render_template("show_user.html", data_list=all_info)
def get_conn():
conn = pymysql.connect(host="127.0.0.1",
port=3306,
user='root',
password='123456',
charset='utf8',
db='pyconn')
return conn
def insert(conn, request):
info = {
"user": request.form.get("user"),
"pwd": request.form.get("pwd"),
"mobile": request.form.get("mobile"),
}
cursor = conn.cursor()
sql = "insert into admin(username, password, mobile) values (%s, %s, %s)"
cursor.execute(sql, [info["user"], info["pwd"], info["mobile"]])
conn.commit()
def get_all(conn):
cursor = conn.cursor(pymysql.cursors.DictCursor)
sql = "select * from admin"
cursor.execute(sql)
return cursor.fetchall()
if __name__ == '__main__':
app.run()
|