为app.POST服务器创建多个SQL语句查询

import mysql.connector

# 连接到数据库
cnx = mysql.connector.connect(user='username', password='password',
                              host='localhost', database='database_name')

# 创建SQL语句查询的函数
def execute_sql_query(query_type, params):
    cursor = cnx.cursor()

    if query_type == 'select':
        # 执行SELECT语句查询
        query = "SELECT * FROM table_name WHERE column_name = %s"
        cursor.execute(query, params)
        result = cursor.fetchall()
        # 处理查询结果
        for row in result:
            # 处理每一行数据

    elif query_type == 'insert':
        # 执行INSERT语句查询
        query = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"
        cursor.execute(query, params)
        cnx.commit()
        # 处理插入结果

    elif query_type == 'update':
        # 执行UPDATE语句查询
        query = "UPDATE table_name SET column1 = %s WHERE column2 = %s"
        cursor.execute(query, params)
        cnx.commit()
        # 处理更新结果

    elif query_type == 'delete':
        # 执行DELETE语句查询
        query = "DELETE FROM table_name WHERE column_name = %s"
        cursor.execute(query, params)
        cnx.commit()
        # 处理删除结果

    cursor.close()

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