python操作mysql数据库，一次性执行多条语句

背景：在构造测试场景的时候，往往会出现一次性要执行多条sql语句的情况，这时候为了避免每执行一条sql就连接一次数据库，可以加入 closeConn的参数，用以提高执行效率

1、前面的链接数据库，创建游标就不过多说明，下面直接放上代码：

    def __init__(self,dbName = None):
        self.currentConn = None
        self.host = "your host"
        self.user = "username"
        self.password = "password"
        self.dbName = dbName
        self.charset = "utf8mb4"
        self.resultlist = []

    def open(self):  # 创建连接
        try:
            conn = pymysql.connect(
                host = self.host,
                user = self.user,
                password = self.password,
                db = self.dbName,
                charset=self.charset,
            )
        except pymysql.err.OperationalError as e:
            logger.exception("数据库连接失败！")
            if "Errno 10060" in str(e) or "2003" in str(e):
                logger.error(