企业官网建设流程全解析

再谈Python使用PooledDB 难题，运行程序报DBUtils报错

运行报错

E:\demo>python -c “import DBUtils”
Traceback (most recent call last):
File “”, line 1, in
import DBUtils
ModuleNotFoundError: No module named ‘DBUtils’

查看版本

Found existing installation: DBUtils 3.1.2

报错原因是版本太高了

卸载

pip3 uninstall DBUtils
然后查看是否存在，不存在指定安装版本
pip install DBUtils==1.3

再次执行看看是否安装

python -c “import DBUtils”
没有报错，就是成功

找些代码运行试试

importpymysql from pymysqlimportError from DBUtils.PooledDBimportPooledDB# 需安装：pip install DBUtils# 配置连接池POOL=PooledDB(creator=pymysql,maxconnections=5,# 连接池最大连接数mincached=1,# 初始化时连接池至少创建的空闲连接数maxcached=2,# 连接池最大空闲连接数host="localhost",port=3306,user="root",password="root123456",database="test_mysql",charset="utf8mb4",cursorclass=pymysql.cursors.DictCursor)class MySQLHelper: @staticmethod def query(sql,args=None):"""查询数据""" conn=None cursor=None try: conn=POOL.connection()cursor=conn.cursor()cursor.execute(sql, args or())returncursor.fetchall()except Error as e: print(f"查询失败：{e}")return[]finally:ifcursor: cursor.close()ifconn: conn.close()@staticmethod def execute(sql,args=None):"""执行增/删/改""" conn=None cursor=None try: conn=POOL.connection()cursor=conn.cursor()cursor.execute(sql, args or())conn.commit()returncursor.rowcount except Error as e:ifconn: conn.rollback()print(f"执行失败：{e}")return0finally:ifcursor: cursor.close()ifconn: conn.close()# 调用示例if__name__=="__main__":# 查询res=MySQLHelper.query("SELECT * FROM users WHERE age < %s",(25,))print(res)# 插入count=MySQLHelper.execute("INSERT INTO users (name, age) VALUES (%s, %s)",("老二",23))print(f"插入 {count} 条")

运行python xx.py
能成功就ok