python flask （二）用flask写一个API

准备好数据，你可以将数据存数据库，或者文件形式

我这里把数据存数据库

#coding=utf-8
#!/usr/bin/python
from flask import *
import pymysql

app = Flask(__name__)
app.config['JSON_AS_ASCII'] = False

def searchtan(title):#搜索唐诗
    db = pymysql.connect("地址", "用户名", "密码","表")
    cursor = db.cursor()
    csql =  "SELECT * FROM `tan` WHERE `title` LIKE " + "'" + title + "'"
    #数据库命令
    cursor.execute(csql)
    # 获取所有记录列表
    # results = cursor.fetchone()
    results = cursor.fetchall()
    db.close()
    return results

@app.route("/", methods=["GET", "POST"])#获取URL参数
def hello_world():
    title = request.args.get("title")#获取数据
    text = searchtan(title)
    return jsonify(text)

if __name__ == '__main__':
    app.run()

这个是唐诗大全数据库搜索并且返回数据

数据库查看[wailian]https://yxqfx.cn/archives/1891[/wailian]