当我需要在url中使用params时，如何从数据库获取数据？

import mysql.connector

# 建立与数据库的连接
conn = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name"
)

# 解析URL中的params参数
params = {
    "id": 1,
    "name": "example"
}

# 构建SQL查询语句
query = "SELECT * FROM table_name WHERE "
conditions = []
for key, value in params.items():
    conditions.append(f"{key} = '{value}'")
query += " AND ".join(conditions)

# 执行SQL查询语句
cursor = conn.cursor()
cursor.execute(query)

# 获取查询结果
results = cursor.fetchall()

# 处理查询结果
data = []
for row in results:
    # 进行数据转换、格式化等操作
    data.append({
        "id": row[0],
        "name": row[1]
    })

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

# 返回数据给前端
return data