留言板连接mysql

from flask import Flask, request, render_template
import mysql.connector

app = Flask(__name__)

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

@app.route('/')
def index():
    cursor = db.cursor()
    cursor.execute("SELECT * FROM messages")
    messages = cursor.fetchall()
    return render_template('index.html', messages=messages)

@app.route('/submit', methods=['POST'])
def submit():
    name = request.form['name']
    message = request.form['message']
    cursor = db.cursor()
    sql = "INSERT INTO messages (name, message) VALUES (%s, %s)"
    val = (name, message)
    cursor.execute(sql, val)
    db.commit()
    return 'Message submitted!'

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