在列表框中显示前从access查询记录计算百分比

from flask import Flask, render_template
import pyodbc

app = Flask(__name__)

@app.route('/')
def display_percentage():
    # 连接到Access数据库
    conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path/to/your/access/database.accdb;')
    cursor = conn.cursor()

    # 执行查询语句
    cursor.execute('SELECT COUNT(*) FROM your_table')
    total_records = cursor.fetchone()[0]

    cursor.execute('SELECT COUNT(*) FROM your_table WHERE some_condition')
    selected_records = cursor.fetchone()[0]

    # 计算百分比
    percentage = (selected_records / total_records) * 100

    # 关闭数据库连接
    cursor.close()
    conn.close()

    # 将百分比数据传递给前端模板进行显示
    return render_template('index.html', percentage=percentage)

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