mysql-python工具
import pymysql
from DBUtils.PooledDB import PooledDB
class mysqlClinet(object):
def __init__(self):
self.POOL = PooledDB(
creator=pymysql,
maxconnections=6,
mincached=2,
maxcached=5,
maxshared=1,
blocking=True,
maxusage=None,
setsession=[],
ping=0,
host='127.0.0.1',
port=3306,
user='root',
password='',
database='ziji',
charset='utf8'
)
def create_conn(self):
conn = self.POOL.connection()
cursor = conn.cursor(pymysql.cursors.DictCursor)
return conn, cursor
def close_conn(self, conn, cursor):
conn.close()
cursor.close()
def select_one(self, sql, args):
conn, cur = self.create_conn()
cur.execute(sql, args)
result = cur.fetchone()
self.close_conn(conn, cur)
return result
def select_all(self, sql, args):
conn, cur = self.create_conn()
cur.execute(sql, args)
result = cur.fetchall()
self.close_conn(conn, cur)
return result
def insert_one(self, sql, args):
conn, cur = self.create_conn()
result = cur.execute(sql, args)
conn.commit()
self.close_conn(conn, cur)
return result
def delete_one(self, sql,args):
conn,cur = self.create_conn()
result = cur.execute(sql,args)
conn.commit()
self.close_conn(conn,cur)
return result
def update_one(self, sql,args):
conn,cur = self.create_conn()
result = cur.execute(sql,args)
conn.commit()
self.close_conn(conn,cur)
return result