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'
sql = "INSERT INTO databasename VALUES(%s, %s, %s)"
el = [('a', 'b', 'c'),('1', '2', '3')]
pass
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)