媒体大数据词汇表查询（Python+Flask+MySQL）

最新推荐文章于 2024-04-21 19:16:47 发布

PPPPPPPPeng

最新推荐文章于 2024-04-21 19:16:47 发布

阅读量161

点赞数

文章标签： mysql python flask html

本文链接：https://blog.csdn.net/weixin_45755223/article/details/117754055

版权

Python+Flask+MySQL词汇表查询

MySQL导入词汇表

在这里插入图片描述

代码实现Python的Flask应用

import pymysql
from flask import Flask,render_template,request

app=Flask(__name__)

@app.route('/')
def english():
    db = pymysql.connect(host="127.0.0.1",user="root",password="Ppyh0615",database="engword",port=3306,charset="utf8")
    cursor = db.cursor()
    try:
        sql="select * from map_enword limit 200"
        cursor.execute(sql)
        rs = cursor.fetchall()
        rs = list(rs)
        print(rs)
    except:
        rs = 'db-error'
        print('py-db-error')
    db.close()
    return render_template('english.html', rs=rs)

@app.route('/search')
def search():
    wanted = request.args.get("wanted", type=str)
    if wanted == None:
        wanted = 'pineapple'
    db = pymysql.connect(host="127.0.0.1",user="root",password="Ppyh0615",database="engword",port=3306,charset="utf8")
    cursor = db.cursor()
    try:
        sql = "select * from map_enword where english like '%" + wanted + "%'"
        cursor.execute(sql)
        rs = cursor.fetchall()
        rs = list(rs)
        print(rs)
    except:
        rs = 'db-error'
        print('py-db-error')

    db.close()
    return render_template('english.html',rs=rs)

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

HTML前端代码

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>英语四六级词表</title>
</head>
<body>
<h1>英语四六级词表</h1>

<form action="/search">
        <input type="text" name="wanted" value="" default="apple">
        <input type="submit" value="搜索">
</form>

{% for r in rs %}
{{r}}<br>
{% endfor %}
</body>
</html>

运行结果

在这里插入图片描述

PPPPPPPPeng

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
2
评论
媒体大数据词汇表查询（Python+Flask+MySQL）

Python+Flask+MySQL词汇表查询MySQL导入词汇表代码实现Python的Flask应用HTML前端代码运行结果MySQL导入词汇表代码实现Python的Flask应用import pymysqlfrom flask import Flask,render_template,requestapp=Flask(__name__)@app.route('/')def english(): db = pymysql.connect(host="127.0.0.1",use
复制链接

扫一扫