Python实现MySql、SqlServer增删改查操作

import pymssql

def connection_sql(way, sql, el, host, port, username, password, database, charset):
    conn = pymssql.connect(host=host, port=port, user=username, password=password, database=database, charset=charset)
    cur = conn.cursor()
    if way == "other":
        if (isinstance(el, list)):  #列表嵌套元组方式传入参数
            cur.executemany(sql, el)
        elif(isinstance(el,tuple)): #元组方式传入参数
            cur.execute(sql, el)
        else:
            cur.execute(sql)
        conn.commit()
        print("语句执行完成")
    elif way == "select":
        cur.execute(select_sql)
        result = cur.fetchall()
    cur.close()
    conn.close()
    if way == "select":
        return result

if __name__ == '__main__':
    way = 'other' #OR  'select'
    sql = "INSERT INTO databasename VALUES(%s, %s, %s)" # SELECT * FROM databasename
    el = [('a', 'b', 'c'),('1', '2', '3')] #OR ('a', 'b', 'c') OR None
    pass