pymysql

import pymysql

class MysqlBlock():
    config={
        "host": "localhost",
        "user": "root",
        "password": '123456',
        "database": "test1",
        "port": 3306,
        "charset": 'utf8'
    }
    def __init__(self):

        self.connection=None
        self.cursor=None

    def getOne(self, sql, *args):
        try:
            self.connection = pymysql.connect(**MysqlBlock.config)
            self.cursor = self.connection.cursor()
            self.cursor.execute(sql,args)
            return  self.cursor.fetchone()

        except Exception as erro:
            print(erro)

        finally:
                self.close()

    def getList(self, sql, *args):
        try:
            self.connection = pymysql.connect(**MysqlBlock.config)
            self.cursor = self.connection.cursor()
            self.cursor.execute(sql,args)
            return  self.cursor.fetchall()

        except Exception as erro:
            print(erro)

        finally:
                self.close()

    def executeDML(self,sql,*args):
        try:
            self.connection = pymysql.connect(**MysqlBlock.config)
            self.cursor = self.connection.cursor()
            q=self.cursor.execute(sql, args)
            self.connection.commit()
            return q

        except Exception as erro:
            self.connection.rollback()
            print(erro)

        finally:
            self.close()


    def close(self):

        if self.cursor:
            self.cursor.close()

        if self.connection:
            self.connection.close()


if __name__ == '__main__':
    test1=MysqlBlock()
    #sql="""insert into class values (9,"xoaiff","f",89975)"""
    #q=test1.executeDML(sql)
    q=test1.executeDML("delete from class where id=%s",3)

    print(q)