经常用到python操作mysql数据库,于是自己封装了基本操作mysql数据库的类,持续更新
# -*- coding:utf-8 -*-
import MySQLdb
import datetime
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
#封装MySQLdb类基本操作mysqldb
class mysqldb:
conn = ''
cursor = ''
def __init__(self,host1='localhost',user1='root',passwd1='www',database1='test',charset1='utf8'):
try:
print 'init_ ok'
self.conn=MySQLdb.connect(host=host1,user=user1,passwd=passwd1,db=database1,port=3306,charset=charset1);
self.cursor = self.conn.cursor(MySQLdb.cursors.DictCursor)
except MySQLdb.Error,e:
error = 'Connect failed! ERROR (%s): %s' %(e.args[0],e.args[1])
print error
sys.exit()
#针对读操作返回结果集
def _exeCute(self,sql=''):
try:
self.cursor.execute(sql)
records = self.cursor.