import pymysql
class DBUtil():
config = {
"host": "localhost",
"user": "root",
"password": "123456",
"db": "tes06",
"charset": "utf8"
}
def __init__(self):
self.connection = pymysql.connect(config, **DBUtil)
self.cursor = self.connection.cursor()
def close(self):
if self.cursor:
self.cursor.close()
if self.connection:
self.connection.close()
def exeDML(self, sql, *args):
try:
count = self.cursor.execute(sql, args)
self.connection.commit()
return count
except Exception as e:
print(e)
if self.connection:
self.connection.rollback()
finally:
self.close()
if __name__ == '__main__':
dbutil = DBUtil()
# 调用exeDML方法
sql = "insert into emp(empno,ename,sal) values(%s,%s,%s)"
count = dbutil.exeDML(sql, 9997, 'lili', 12000)
print(count)
老师我这里报错AttributeError: 'DBUtil' object has no attribute 'exeDML'