mysql 导出为html代码

import mysql.connector
from mysql.connector import Error

def export_to_html():
    try:
        # 连接到MySQL数据库
        connection = mysql.connector.connect(
            host='localhost',
            database='your_database',
            user='your_username',
            password='your_password'
        )

        if connection.is_connected():
            cursor = connection.cursor()
            cursor.execute("SELECT * FROM your_table")

            # 获取列名
            columns = [desc[0] for desc in cursor.description]

            # 生成HTML表格
            html = "<table border='1'>\n"
            html += "<tr>\n"
            for column in columns:
                html += f"<th>{column}</th>\n"
            html += "</tr>\n"

            # 获取数据并添加到HTML表格
            for row in cursor.fetchall():
                html += "<tr>\n"
                for item in row:
                    html += f"<td>{item}</td>\n"
                html += "</tr>\n"

            html += "</table>"

            # 将HTML保存到文件
            with open('output.html', 'w') as file:
                file.write(html)

            print("数据已成功导出为HTML文件")

    except Error as e:
        print(f"连接MySQL数据库时出错: {e}")
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

if __name__ == "__main__":
    export_to_html()