python操作MsSQL

python操作MsSQL

所需模块 pymssql

连接数据库

创建数据库

插入数据

删除数据

修改数据

数据库查询

from time import sheep
import pymssql

class MSSQL:
    def __init__(self, host, user, pwd,db):
        self.host = host
        self.user = user
        self.pwd = pwd
        self.db = db


    # 连接数据库    
    def connect_db(self):
        if not self.db:
            raise(NameError, "没有目标数据库")
        else:
            self.connect = pymssql.connect(host=self.host, user=self.user, pwd=self.pwd, db=self.db, chartset='utf8')
            cursor = self.connect.cursor()
        if not cur:
            raise(NameError, "数据库访问失败")\
        else:
            return cursor

    # 数据库操作
    def exec_sql(self, sql):
        cursor = self.connet_db()
        cursor.execute(sql)
        self.connect.commit()
        self.connect.close()

    # 数据库查询
    def execQuery(self, sql):
        cursor = self.connet_db()
        cursor.execute(sql)
        res_list = corsor.fetchall()
        self.connet.colse()
        return res_list

    # 　带参更新
    def updata_by_param(self, sql, param):
        try:
            cursor = self.connect_db()
            cursor.execute(sql,param)
            self.connent.commit()
        except:
            cursor.rookback()
        self.connent.close()