mssql部分封装使用
import pymssql
import sys
class MyConectSQL():
def __init__(self, database):
self.database = database
self.db: pymssql.Connection = pymssql.connect(host="192.168.2.101", user="sa", password="123",
database=database, charset="utf8")
self.cur: pymssql.Cursor = self.db.cursor()
if not self.cur:
print("连接失败")
sys.exit(0)
else:
print("连接成功")
def __del__(self):
self.db.commit()
self.cur.close()
print("已关闭")
def main():
mydb = MyConectSQL("test")
mydb.cur.execute(
"""
use test
create table info
(
姓名 nvarchar(10),
学号 nvarchar(8),
成绩 int
)
"""
)
mydb.cur.execute(
"""
insert into dbo.info
values('lili', '565649',265)
"""
)
mydb.cur.execute("select * from dbo.info")
for item in mydb.cur:
print(item)
if __name__ == '__main__':
main()