python_sql，,import pym

python_sql，,import pym

import pymssql#如果是linux系统建议用sudo apt-get install freetds-dev更新一下conn = pymssql.connect(host=‘10.12.60.34‘, user=‘sa‘, password=‘h3c.com!‘,database=‘cloudos‘)# 如果和本机数据库交互，只需修改链接字符串# conn=pymssql.connect(host=‘.‘,database=‘cloudos‘)cur = conn.cursor()cur.execute(‘SELECT * FROM dbo.vm_infor‘)print(cur.fetchall())cur.close()conn.close()

python_sql