下面通过一个简单的例子来说明如何连接SQL Server并进行一些常见的操作。Python通过pymssql第三方模块连接SQL Server,并对其进行增删改查相关操作。
pymssql项目地址:https://github.com/pymssql/pymssql
https://www.cndba.cn/Expect-le/article/3220https://www.cndba.cn/Expect-le/article/3220https://www.cndba.cn/Expect-le/article/3220https://www.cndba.cn/Expect-le/article/3220
https://www.cndba.cn/Expect-le/article/3220https://www.cndba.cn/Expect-le/article/3220https://www.cndba.cn/Expect-le/article/3220
import pymssql
class sqlserverapi:
def __init__(self,server='127.0.0.1',user='sa',password='123',dbname='tempdb'):
self._server = server
self._user = user
self._password = password
self._dbname = dbname
# 这里主要是通过用户名和密码来连接数据库,也可以通过操作系统认证来连接。
def ExcuteDMLSQL(self,sql):
"""
执行DML操作
:return: