python链接sqlserver操作数据库

最新推荐文章于 2024-04-18 09:40:15 发布

微笑的菜鸟

最新推荐文章于 2024-04-18 09:40:15 发布

阅读量647

点赞数

分类专栏： python 文章标签： python sqlserver 数据库

本文链接：https://blog.csdn.net/qq_32165065/article/details/53155830

版权

python 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

# coding:utf-8
import pymssql
import sys


class MSSQL:
    def __init__(self, host, port, user, pwd, db):
        reload(sys)
        sys.setdefaultencoding('utf8')
        if not db:
            raise(NameError, u"没有设置数据库信息")
        self.conn = pymssql.connect(host=host, port=port, user=user, password=pwd, database=db, charset="utf8")
        self.cur = self.conn.cursor()
        if not self.cur:
            raise(NameError, u"连接数据库失败")

    # 执行查询等有返回的sql
    def ExecQuery(self,sql):
        cur = self.cur
        cur.execute(sql)
        resList = cur.fetchall()
        return resList

    # 执行删除等无返回的sql
    def ExecNonQuery(self,sql):
        cur = self.cur
        cur.execute(sql)
        self.conn.commit()

    def colseDB(self):
        self.conn.close()

if __name__ == '__main__':
    ms = MSSQL(host="172.16.0.xx", port='3433', user="uername", pwd="password", db="db_test")
    insertSql = "INSERT INTO Stu_Info ([NO], [Name], [Sex]) VALUES (1001,'张三','男');"
    selectSql = "select NO,Name from Stu_Info where No=1001;"
    ms.ExecNonQuery(insertSql)
    resList = ms.ExecQuery(selectSql)
    for (id, name) in resList:
        print str(name)