Python-Mysql-SQL Server

# user/python3
# encoding:utf-8

import pymysql,json,pymssql

file = open("E:\\AutoTest\\Public_file\\control.json","r",encoding="UTF-8")
dict_load=json.load(file)


##################    Mysql    ####################

    def db_Query(self,database,sql):
        # 链接数据库
        self.db = pymysql.connect(
            host=dict_load['mysql']['host'],
            user=dict_load['mysql']['user'],
            password=dict_load['mysql']['pwd'],
            database=database
        )
        try:
            self.db
        except:
            print('数据库连接失败！请检查！')
        # 获取数据库列表
        self.cursor = self.db.cursor()
        self.cursor.execute('SHOW DATABASES')
        # 查询
        self.cursor.execute(sql)
        result = self.cursor.fetchall()
        self.db.close()
        return result


  def db_NotQuery(self,database,sql):
        # 链接数据库
        self.db = pymysql.connect(
            host=dict_load['mysql']['host'],
            user=dict_load['mysql']['user'],
            password=dict_load['mysql']['pwd'],
            database=database
        )
        try:
            self.db

        except:
            print('数据库连接失败！请检查！')
        # 获取数据库列表
        self.cursor = self.db.cursor()
        self.cursor.execute('SHOW DATABASES')
        # 查询
        self.cursor.execute(sql)
        self.db.commit()
        try:
            self.cursor.execute(sql)
        except:

            print('SQL执行失败，请检查！')
        self.db.close()


###################   SQL Server  ####################

def db_Query(self,database,sql):
    # 链接数据库
    self.db = pymssql.connect(
        host=dict_load['mysql']['host'],
        user=dict_load['mysql']['username'],
        password=dict_load['mysql']['password'],
        database=database
    )
    self.db.cursor()
    try:
        self.db
    except:
        print('数据库连接失败！请检查！')
    # 获取数据库列表
    self.cursor = self.db.cursor()
    # 查询
    self.cursor.execute(sql)
    result = self.cursor.fetchall()
    self.db.close()
    return result



def db_NotQuery(self,database,sql):
    # 链接数据库
    self.db = pymssql.connect(
        host=dict_load['mysql']['host'],
        user=dict_load['mysql']['username'],
        password=dict_load['mysql']['password'],
        database=database
    )
    try:
        self.db

    except:
        print('数据库连接失败！请检查！')
    # 获取数据库列表
    self.cursor = self.db.cursor()
    # 查询
    self.cursor.execute(sql)
    self.db.commit()
    try:
        self.cursor.execute(sql)
    except:

        print('SQL执行失败，请检查！')
    self.db.close()