对mysqldb做了一个简单的封装,以减少重复代码的书写
权当是一个适用于我的小工具类
小注意点:
import MySQLdb
class db_operation():
result=[]
conn = MySQLdb.connect(
host='localhost',
port=3306,
user='root',
passwd='password',
db='aaa',
charset='utf8'
)
def init(self,conn):
conn.set_character_set('utf8')
cur = conn.cursor()
cur.execute('SET NAMES utf8;')
cur.execute('SET CHARACTER SET utf8;')
cur.execute('SET character_set_connection=utf8;')
return cur
def sql(self,sql_str):
cur=self.init(db_operation.conn)
cur.execute(sql_str)
result =cur.fetchall()
db_operation.conn.commit()
return result
def close(self):
db_operation.conn.close()
def __init__(self,sql_str):
db_operation.result=self.sql(sql_str)
self.close()