importpymysqlimporttimefrom hashlib importmd5classmy_MySQL(object):__user = 'root' #__user 代表私有变量
__password = 'root'
__host = '127.0.0.1'
__port = 3306
__chatset = 'utf8'
__database='blog'
__obj=None__cur =Nonedef __init__(self):if not self.__obj:
self.__obj =pymysql.connect(
host=self.__host,
port=self.__port,
user=self.__user,
password=self.__password,
database=self.__database,
charset=self.__chatset)
self.__cur = self.__obj.cursor()#print(self.__obj)
defInsert(self,table,fileDict):"""插入数据
table 表名
fileDict 字典 插入字段"""
#cur = self.__obj.cursor()
try:
keys=''values=''
for key,value infileDict.items():#print(self