import pymysqldef get_list(sql, args=None):
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root',
passwd='root', db='classes',
charset='utf8')
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor.execute(sql, args)
reslt = cursor.fetchall()
cursor.close()
conn.close()return resltdef get_one(sql, args=None):
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root',
passwd='root', db='classes',
charset='utf8')
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor.execute(sql, args)
reslt = cursor.fetchone()
cursor.close()
conn.close()return resltdef modify(sql, args):
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root',
passwd='root', db='classes',
charset='utf8')
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor.execute(sql, args)
conn.commit()
cursor.close()
conn.close()def create(sql, args):
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root',
passwd='root', db='classes',
charset='utf8')
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor.execute(sql, args)
conn.commit()
last_row_id = cursor.lastrowid
cursor.close()
conn.close()return last_row_id
class SqlHeper(object):def __init__(self):# 读配置文件，后进行connect复制连接更好 self.connect()def connect(self):
self.conn = pymysql.connect(host='127.0.0.1', port=3306, user='root',
passwd='root', db='classes',
charset='utf8')
self.cursor = self.conn.cursor(cursor=pymysql.cursors.DictCursor)def get_list(self,sql,args=None):
self.cursor.execute(sql, args)
result = self.cursor.fetchall()return resultdef get_one(self,sql,args=None ):
self.cursor.execute(sql, args)
result = self.cursor.fetchone()return resultdef modify(self,sql,args):
self.cursor.execute(sql, args)
self.conn.commit()#批量插入值,def multiple_modify(self,sql,args):#这里的args可以传入一个列表中包含多个元祖的一个序列# self.cursor.executemany('insert into a(id,name) values(%s,%s)',[(1,'alex'),(2,'eric')]) self.cursor.executemany(sql,args)
self.conn.commit()def create(self,sql, args):
self.cursor.execute(sql, args)
self.conn.commit()# last_row_id = self.cursor.lastrowidreturn self.cursor.lastrowiddef close(self):
self.cursor.close()
self.conn.close()
