from flask import Flask, render_template,request,make_response
import sqlite3
app = Flask(__name__)

@app.route('/')
def home():
    return render_template('home.html')

@app.route('/search', methods=['GET'])
def search_word():
    print("search word")
    word = request.args.get('word')
    print(word)
    # 连接到 SQLite 数据库
    conn = sqlite3.connect('word.db')
    cursor = conn.cursor()
    sql = 'SELECT * FROM mdx where entry = "'+word.encode('utf-8').decode('utf-8')+'"'
    print(sql)
    cursor.execute(sql)
    rows = cursor.fetchall()
    rs = ''
    for row in rows:
        rs = row
        break
    cursor.close()
    conn.close()
    print(rs)
    if len(rs) < 2:
        rs = ['','没查到该单词']
    return make_response(rs[1])

if __name__ == '__main__':
    app.run(host='0.0.0.0', port=9004)