# DButils 为了解决多客户端都需要操作数据库的问题.# import pymysql# from DBUtils.PooledDB import PooledDB## POOL = PooledDB(creator=pymysql,# mincached=2,# maxcached=5,# maxshared=3,# maxconnections=6,# blocking=True,# maxusage=None,# ping=4,# host=‘172.16.2.106‘,# port=3306,# user=‘root‘,# password=‘123456‘,# database=‘anec‘,# charset=‘utf8‘# )## coon = POOL.connection()# cursor = coon.cursor(cursor=pymysql.cursors.DictCursor)# info_msg = {# ‘cx‘:‘select * from text where id=1‘,# ‘cr‘:‘insert into text(id,name,phone,enail) values(2,"alex","123123213","123@qewq.com")‘# }# 查询数据# cursor.execute(‘select * from text ‘)# ret = cursor.fetchall()# 增加数据# cursor.execute(‘insert into text(id,name,phone,enail) values(2,"alex","123123213","123@qewq.com")‘)# coon.commit()## 删除一条数据# cursor.execute(‘delete from text where id=2‘)# coon.commit()# 修改数据# cursor.execute(‘update text set phone = 18711068587 where id=1‘)# coon.commit()# cursor.execute(‘select * from text‘)# ret = cursor.fetchall()# coon.close()# print(ret)