python连接数据库

import pymysql
def connect_to_database(host, user, password, database):
    conn = pymysql.connect(host=host, user=user, password=password, database=database)
    return conn
def execute_sql_query(conn, sql_query):
    cursor = conn.cursor()
    cursor.execute(sql_query)
    result = cursor.fetchall()
    cursor.close()
    return result
if __name__ == '__main__':
    db_conn = connect_to_database('localhost', 'root', '123456', 'shoppingmall')
    result = execute_sql_query(db_conn, 'SELECT * FROM chewei')
    print(result)
    db_conn.close()

'localhost'、'root'、'123456' 和 'shoppingmall' 为你的实际数据库连接信息。

需要安装pymysql,如果一直出现安装失败报错可能是连接超时建议切换镜像

阿里云镜像：pip install pymysql -i https://mirrors.aliyun.com/pypi/simple/

清华大学：pip install pymysql -i https://pypi.tuna.tsinghua.edu.cn/simple