python数据库封装的办法

#导入pymysql框架，可以用pip下载
import pymysql
#数据库封装方法
class MysqlHelp(object):
    config={
        'host':'localhost',
        'user':'root',
        'password':'abc12345',
        'db':'test1',
        'charset':'utf8'

    }
    def __init__(self):
        self.connection=None
        self.cursor=None
    #该函数用来从数据库表中查询一行数据
    def getOne(self,sql,*args):
        try:
            self.connection = pymysql.connect(**MysqlHelp.config)
            self.cursor=self.connection.cursor()
            self.cursor.execute(sql,args)
            return self.cursor.fetchone()
        except Exception as ex:
            print(ex,ex)
        finally:
            self.close()
    def close(self):
        if(self.cursor):
            self.cursor.close()
        if(self.connection):
            self.connection.close()

    #该函数用来从数据库表中查询多行数据
    def getList(self,sql,*args):
        try:
            self.connection = pymysql.connect(**MysqlHelp.config)
            self.cursor=self.connection.cursor()
            self.cursor.execute(sql,args)
            return self.cursor.fetchall()
        except Exception as ex:
            print(ex,ex)
        finally:
            self.close()

    # 该函数用来从数据库表中查询多行数据
    def executeDML(self, sql, *args):
        try:
            self.connection = pymysql.connect(**MysqlHelp.config)
            self.cursor = self.connection.cursor()
            #返回sql语句执行以后影响的行数
            num = self.cursor.execute(sql, args)
            self.connection.commit()
            return num
        except Exception as ex:
            self.connection.rollback()
            print(ex, ex)
        finally:
            self.close()

    def close(self):
        if(self.cursor):
            self.cursor.close()
        if(self.connection):
            self.connection.close()
if __name__=='__main__':
    helper=MysqlHelp()
    #输入操作内容
    print(helper.executeDML('delete from t_student where id=%d'%6))