安装pyodbc,打开命令提示符,输入:pip install pyodbc
import pyodbc
# 连接Microsoft SQL Server数据库
conn = pyodbc.connect('Driver={SQL Server};Server=localhost;Database=UTdata;Trusted_Connection=yes;')
# 获取游标
cursor = conn.cursor()
# 插入数据
sql = "DELETE FROM JJMXB"
cursor.execute(sql)
cursor.execute("INSERT INTO JJMXB (JJDM, JJMC, JJRQ, JJJZ) VALUES (?, ?, ?,? )", 00, 00, '2023-09-19', 1.8235)
# 提交事务
conn.commit()
# 关闭连接
conn.close()
print("插入完成!")