22,209
社区成员
# 向SQL Server数据库中添加数据
import warnings
warnings.filterwarnings('ignore', category=DeprecationWarning)
from pymssql import *
conn=connect(host='localhost', user='sa', password='SQL2008r2', database='stuinfo5')
conn.autocommit(True)
cursor=conn.cursor()
operation='INSERT INTO students VALUES (%s, %s, %s, %s, %s)'
params=('2020182001', '王强', '男', '2002-03-21', 'wangqiang@163.com')
cursor.execute(operation, params)
print('成功添加1行数据!')
params=[
('2020182002', '王曜', '男', '2002-05-11', 'wangyao@163.com')
('2020182003', '李思思', '女', '2002-03-02', 'lisisig@shou.com')
('2020182004', '刘千梅', '女', '2001-09-20', 'liumei@sina.com')
('2020182005', '马亮', '男', '2002-05-11', 'maliangg@qq.com')
('2020182006', '肖嘉莉', '女', '2002-09-21', 'xiaolig@sina.com')
]
print('成功添加5行数据!')
cursor.executemany(operation, params)
cursor.execute('SELECT * FROM students')
rows=cursor.fetchall()
print('表数据如下:')
for row in rows:
print(f'{row[0]}\t{row[1]}\t{row[2]}\t{row[3]}\t{row[4]}')
cursor.close()
conn.close()
程序执行后出现错误,提示如下:
E:\Python程序设计微课版\10.13 向SQL Server数据库中添加数据示例.py:14: SyntaxWarning: 'tuple' object is not callable; perhaps you missed a comma?
('2020182002', '王曜', '男', '2002-05-11', 'wangyao@163.com')
Traceback (most recent call last):
File "src\pymssql\_pymssql.pyx", line 646, in pymssql._pymssql.connect
File "src\pymssql\_mssql.pyx", line 2106, in pymssql._mssql.connect
File "src\pymssql\_mssql.pyx", line 698, in pymssql._mssql.MSSQLConnection.__init__
File "src\pymssql\_mssql.pyx", line 1815, in pymssql._mssql.maybe_raise_MSSQLDatabaseException
File "src\pymssql\_mssql.pyx", line 1832, in pymssql._mssql.raise_MSSQLDatabaseException
pymssql._mssql.MSSQLDatabaseException: (18456, b"\xe7\x94\xa8\xe6\x88\xb7 'sa' \xe7\x99\xbb\xe5\xbd\x95\xe5\xa4\xb1\xe8\xb4\xa5\xe3\x80\x82DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\n")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "E:\10.13 向SQL Server数据库中添加数据.py", line 6, in <module>
conn=connect(host='localhost', user='sa', password='SQL2008r2', database='stuinfo5')
File "src\pymssql\_pymssql.pyx", line 652, in pymssql._pymssql.connect
pymssql._pymssql.OperationalError: (18456, b"\xe7\x94\xa8\xe6\x88\xb7 'sa' \xe7\x99\xbb\xe5\xbd\x95\xe5\xa4\xb1\xe8\xb4\xa5\xe3\x80\x82DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\n")
[Finished in 546ms]
请问这问题怎么解决?
求大佬,问题解决了吗