pymysql类
import pymysql
class EditDatabase():
def __init__(self):
self.conn=None
self.cursor=None
def connect(self):
self.conn = pymysql.connect(
host="127.0.0.1",
user="root",
password="321",
database="db1",
charset="utf8"
)
self.cursor=self.conn.cursor()
def close(self):
self.cursor.close()
self.conn.close()
self.conn=None
self.cursor=None
def query(self,sql):
self.connect()
row=self.cursor.execute(sql)
if row:
res=self.cursor.fetchall()
print("查询成功")
else:
print("查询失败")
self.close()
return res
def change(self,sql,data):
self.connect()
try:
self.cursor.executemany(sql,data)
except Exception:
self.conn.rollback()
print("修改失败")
else:
self.conn.commit()
print("修改成功")
self.close()
if __name__ == "__main__":
c=EditDatabase()
result=c.query("select * from person;")
print(result)
sql="insert into heros(name,age) values(%s,%s);"
import random
import time
t0=time.time()
data=[]
for i in range(2000000):
name=random.choice(["刘备","关羽","张飞","黄忠","马超"])
age=random.randint(20,80)
data_yuanzu=(name,age)
data.append(data_yuanzu)
c.change(sql,data)
print("use time is %.2f:"%(time.time()-t0))