制作单词查询网页

最新推荐文章于 2022-05-14 10:38:11 发布

居居是个麻瓜

最新推荐文章于 2022-05-14 10:38:11 发布

阅读量550

点赞数

分类专栏：前端文章标签： mysql html

本文链接：https://blog.csdn.net/qq_44509620/article/details/117770216

版权

前端专栏收录该内容

2 篇文章 0 订阅

订阅专栏

python+flask实现单词查询网页

词汇表
词汇搜索

词汇表

python

from flask import Flask
from flask import render_template,request
import pymysql
app = Flask(__name__)
@app.route('/english')
def english():
    db = pymysql.connect(host="localhost",user="root",password="hhxxttxs78",database="words1",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')
    return render_template('english.html',rs=rs)

html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>英语四六级词表</title>
</head>
<body>
<h1>英语四六级词表</h1>
{% for r in rs %}
{{r}}<br>
{% endfor %}
</body>
</html>

结果

在浏览器输入返回路径+@app.route()中的值
在这里插入图片描述

词汇搜索

python

from flask import Flask
from flask import render_template,request
import pymysql
app = Flask(__name__)
@app.route('/search')
def search():
    wanted = request.args.get("wanted", type=str)
    if wanted == None:
        wanted = 'pineapple'
    db = pymysql.connect(host="localhost",user="root",password="hhxxttxs78",database="words1",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(debug=True)

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>