import mysql.connector
# 定义数据库连接参数
username = 'root'
password = '12345678'
host = 'localhost'
database = 'bydf'
# 建立数据库连接
cnx = mysql.connector.connect(
user=username,
password=password,
host=host,
database=database
)
def query_user_table():
# 创建一个游标对象来执行查询
cursor = cnx.cursor()
# 查询"user"表
query = "SELECT * FROM user"
cursor.execute(query)
# 获取查询结果的所有行
rows = cursor.fetchall()
# 关闭游标和连接
cursor.close()
cnx.close()
return rows
05-29
430
02-20
5952
03-08
4098