我是使用pymssql完成的sqlserver，首先下載符合版本的pymssql的whl，然后安裝，在pycharm的default setting->project Interpreter中確定項(xiàng)目的Interpreter有pymssql，然后就開始了~

` # -*- coding:utf-8 -*-import hashlibimport hmacimport jsonimport pymssqlfrom requests import Responsefrom rest_framework import status, genericsfrom rest_framework.decorators import api_viewfrom rest_framework.views import APIViewfrom django.http import HttpResponse, HttpRequest@api_view([’GET’, ’POST’])def userlogin(req,format=None): ms = MSSQL(host='你的IP地址', user='你的數(shù)據(jù)庫(kù)賬號(hào)', pwd='你的數(shù)據(jù)庫(kù)密碼', db='你的數(shù)據(jù)庫(kù)名') if req.method == ’GET’: username = req.GET[’username’] password = req.GET[’password’] elif req.method == ’POST’: username= req.POST[’username’] password = req.POST[’password’] newsql = 'select * from System_Users where Mobile = ’'+username+'’' print(newsql) reslist = ms.ExecQuery(newsql.encode(’utf-8’)) # //驗(yàn)證password加密后==LoginPwd print(password) print(reslist[0].get('LoginKey')) if Encrypt(password,reslist[0].get('LoginKey'))==reslist[0].get('LoginKey'): reslist =json_success(reslist) else: reslist =json_error(reslist) # meizis = System_Users.objects.all() # serializer = MeiziSerializer(reslist, many=True) # return Response(serializer.data) return HttpResponse(json.dumps(reslist, default=lambda obj: obj.__dict__), content_type=’application/json’) # return reslistdef Encrypt(password='',salt = ''): clearBytes=[] hasheByte=[] # # encoding = unicode # clearBytes= bytes(salt.lower().strip()+password.strip(),encoding=’Unicode’) # salt = crypt.mksalt(crypt.METHOD_SHA512) # 然后再進(jìn)行數(shù)據(jù)加密: # hasheByte = crypt.crypt('helloworld', salt) # hasheByte =crypt.crypt(clearBytes, salt) # password = hmac.new(key=clearBytes, msg=password) # 待加密信息 str =salt.lower().strip()+password.strip() # 創(chuàng)建md5對(duì)象 hl = hashlib.md5() # Tips # 此處必須聲明encode # 若寫法為hl.update(str) 報(bào)錯(cuò)為： Unicode-objects must be encoded before hashing print(’MD5加密前為 ：’ + str) hl.update(str.encode(encoding=’utf-16’)) print(’MD5加密后為 ：’ + hl.hexdigest()) hl.update(str.encode(encoding=’UTF-8’)) print(’MD5加密后為 ：’ + hl.hexdigest()) hl.update(str.encode(encoding=’GBK’)) print(’MD5加密后為 ：’ + hl.hexdigest()) hl.update(str.encode(encoding=’GB2312’)) print(’MD5加密后為 ：’ + hl.hexdigest()) print(password) return passworddef json_success(data, code=200, foreign_penetrate=False, **kwargs): data = { 'status': code, 'msg': '成功', 'data': data, } print(data) return datadef json_error(error_string='失敗', code=500, **kwargs): data = { 'status': code, 'msg': error_string, 'data': {} } data.update(kwargs) return dataclass MSSQL: def __init__(self, host, user, pwd, db): self.host = host self.user = user self.pwd = pwd self.db = dbdef __GetConnect(self): if not self.db: raise (NameError, '沒(méi)有設(shè)置數(shù)據(jù)庫(kù)信息') self.conn = pymssql.connect(host=self.host, user=self.user, password=self.pwd, database=self.db, charset='GBK') cur = self.conn.cursor() if not cur: raise (NameError, '連接數(shù)據(jù)庫(kù)失敗') else: return curdef ExecQuery(self, sql): cur = self.__GetConnect() cur.execute(sql) resList = cur.fetchall() col_names = [desc[0] for desc in cur.description] result = [] for row in resList: objDict = {} # 把每一行的數(shù)據(jù)遍歷出來(lái)放到Dict中 for index, value in enumerate(row): index, col_names[index], value objDict[col_names[index]] = value result.append(objDict) # 查詢完畢后必須關(guān)閉連接 self.conn.close() return resultdef ExecNonQuery(self, sql): cur = self.__GetConnect() cur.execute(sql) self.conn.commit() self.conn.close()

然后設(shè)置好url就ok了，這是在Django框架下，fask框架下鏈接數(shù)據(jù)庫(kù)模塊依然可以使用

補(bǔ)充知識(shí)：使用pycharm連接數(shù)據(jù)庫(kù)---Sqlalchemy

初識(shí)sqlalchemy

from sqlalchemy import create_enginefrom sqlalchemy.ext.declarative import declarative_basefrom sqlalchemy import Column,String,INTEGER#1.創(chuàng)建引擎eng = create_engine('mysql+pymysql://root:admin@localhost/homework?charset=utf8')print(eng)#2.創(chuàng)建基類Base = declarative_base()#3.創(chuàng)建類（模型）class Student(Base):__tablename__='student1'#指定表格名稱id = Column(INTEGER,primary_key=True,autoincrement=True)name = Column(String(32),nullable=False)#非空約束email = Column(String(32),unique=True)#唯一約束

#4.創(chuàng)建表格Base.metadata.create_all(eng)#5刪除表格Base.metadata.drop_all(eng)

創(chuàng)建出來(lái)的student1表

使用Sqlalchemy四部曲：

1、使用create_engine()#連接數(shù)據(jù)庫(kù)

2、Base = declarative_base()# 生成orm基類，用于創(chuàng)建classes

3、Base.metadata.create_all(engine) #關(guān)聯(lián)engine使用metadata創(chuàng)建數(shù)據(jù)庫(kù)表

4、使用 session = Session(engine) #創(chuàng)建一個(gè)會(huì)話，便于后面對(duì)數(shù)據(jù)庫(kù)進(jìn)行實(shí)際操作

from sqlalchemy import create_enginefrom sqlalchemy.ext.declarative import declarative_basefrom sqlalchemy import Column,String,INTEGERfrom sqlalchemy.orm import sessionmaker#1.創(chuàng)建引擎eng = create_engine('mysql+pymysql://root:admin@localhost/homework?charset=utf8')#2.創(chuàng)建基類Base = declarative_base()#3.創(chuàng)建類（模型）class Student(Base): __tablename__ = 'student2' id = Column(INTEGER,primary_key=True,autoincrement=True) name = Column(String(32), nullable=False) # 非空約束 email = Column(String(32), unique=True) # 唯一約束#4.創(chuàng)建表格Base.metadata.create_all(eng)#5.創(chuàng)建sessionSession = sessionmaker(bind=eng)session = Session()#創(chuàng)建session對(duì)象，相當(dāng)于pymysql中的conn#增加記錄# student = Student(name=’劉備’,email=’120@qq.com’)#創(chuàng)建student的對(duì)象# session.add(student)#添加記錄# #批量增加# session.add_all(# [# Student(name=’張飛’,email=’110@qq.com’),# Student(name=’悟空’,email=’111@qq.com’),# Student(name=’宮本’,email=’112@qq.com’),# Student(name=’趙云’,email=’113@qq.com’),# ]# )#查詢操作#first方法查詢出第一條記錄# ret = session.query(Student).first()# print(ret.id,ret.name,ret.email)# #get方法查詢指定記錄# student = session.query(Student).get(ident=2)#使用唯一標(biāo)識(shí)ident不寫也行查詢第幾條記錄# print(student.id,student.name,student.email)## student = session.query(Student).filter(Student.id>2)#filter過(guò)濾相當(dāng)于條件# for stu in student:#這里的student是個(gè)對(duì)象，所以需要把他遍歷出來(lái)顯示查詢出來(lái)的數(shù)據(jù)# print(stu.id,stu.name,stu.email)# #刪除操作# # student = session.query(Student).filter(Student.id<2).delete()# # #方式一此方法可刪除多個(gè)主要是因?yàn)閒ilter，他是條件嗎滿足他的都可以被刪除# student1 = session.query(Student).get(2)# session.delete(student1)#方式二# #修改操作#單條修改# student3 =session.query(Student).first()# student3.name=’百度’# student3.email=’www.baidu.com’#指定條件修改student4 =session.query(Student).filter(Student.id ==3).update({Student.name:’王炸’,Student.email:’666@qq.com’})session.commit()#提交事務(wù)session.close()

以上這篇python 鏈接sqlserver 寫接口實(shí)例就是小編分享給大家的全部?jī)?nèi)容了，希望能給大家一個(gè)參考，也希望大家多多支持好吧啦網(wǎng)。