python web开发1

 1 from flask import Flask,render_template
 2 from flask import request
 3 import pymysql
 4 
 5 
 6 
 7 #实例 flask这个类
 8 app = Flask(__name__)
 9 
10 #
11 @app.route(‘/‘)
12 def Index():
13     return render_template(‘index.html‘)
14 
15 @app.route(‘/creat‘)
16 def CreatDiary():
17     return render_template(‘creat.html‘)
18 
19 
20 
21 conn =pymysql.connect(
22         host=‘127.0.0.1‘,
23         user=‘root‘,
24         password=‘usbw‘,
25         port=3307,
26         database=‘diary‘,
27         charset=‘utf8‘
28     )
29 cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
30 
31 @app.route(‘/upload‘,methods=[‘GET‘,‘POST‘]) #默認請求方式只有get
32 def upload():
33     date=request.form.get(‘date‘)
34     key=request.form.get(‘key‘)
35     title=request.form.get(‘title‘)
36     content=request.form.get(‘content‘)
37     #files=request.files.get(‘file‘)
38     print(date,key,title,content)
39     sql="INSERT INTO `day`( `date`, `class`, `title`, `content`) VALUES (%s,%s,%s,%s)"
40     cursor.execute(sql,[date,key,title,content])
41     conn.commit()
42    # cursor.close()
43     conn.close()
44     return ‘提交成功！‘
45 
46 @app.route(‘/diarylist‘)
47 def DiaryList():
48     return render_template(‘diarylist.html‘)
49 
50 if __name__ == ‘__main__‘:
51     app.run()