Paython打卡Day20
——flask模块学习
![](https://i-blog.csdnimg.cn/blog_migrate/d5ae13154f09a71e61048964e927347b.png)
import flask
import pymysql
import json
server = flask.Flask(__name__)
def get_connect():
return pymysql.connect(host='101.200.82.237',port = 3306,db = 'content_center',user = 'root',password = 'abc.123')
def get_data(user_id):
connect = get_connect()
cursor = connect.cursor()
sql = 'SELECT id, title ,author, cover, summary, price FROM share WHERE user_id = ' + user_id + ''
cursor.execute(sql)
result = cursor.fetchall()
connect.close()
share_list = []
for item in result:
share = {
'id': item[0],
'title': item[1],
'author': item[2],
'cover': item[3],
'summary': item[4],
'price': item[5],
}
share_list.append(share)
return share_list
@server.route('/share/<user_id>', methods=['Get', 'Post'])
def get_course(user_id):
print(get_data(user_id))
return json.dumps(get_data(user_id), ensure_ascii=False)
if __name__ == "__main__":
server.run(port=7777, debug=True)