首页
学习
活动
专区
工具
TVP
发布
精选内容/技术社群/优惠产品,尽在小程序
立即前往
  • 您找到你想要的搜索结果了吗?
    是的
    没有找到

    pycharm 连接数据库报错[通俗易懂]

    C:\Users\MACHENIKE\PycharmProjects\untitled9\venv\Scripts\python.exe C:/Users/MACHENIKE/PycharmProjects/untitled11/venv/Online-Bookstore-Management-System-master/v1.0/Book_informationUI.py Traceback (most recent call last): File “src\pymssql.pyx”, line 636, in pymssql.connect File “src_mssql.pyx”, line 1964, in _mssql.connect File “src_mssql.pyx”, line 682, in _mssql.MSSQLConnection.init File “src_mssql.pyx”, line 1690, in _mssql.maybe_raise_MSSQLDatabaseException _mssql.MSSQLDatabaseException: (18456, b”\xe7\x94\xa8\xe6\x88\xb7 ‘SA’ \xe7\x99\xbb\xe5\xbd\x95\xe5\xa4\xb1\xe8\xb4\xa5\xe3\x80\x82DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\n”)

    01

    Python 基于urllib.request封装http协议类

    测试环境: Python版本:Python 3.3 代码实践 #!/usr/bin/env python # -*- coding:utf-8 -*- __author__ = 'shouke' import urllib.request import http.cookiejar import urllib.parse class MyHttp: '''配置要测试请求服务器的ip、端口、域名等信息,封装http请求方法,http头设置''' def __init__(self, protocol, host, port, header = {}): # 从配置文件中读取接口服务器IP、域名,端口 self.protocol = protocol self.host = host self.port = port self.headers = header # http 头 #install cookie #自动管理cookie cj = http.cookiejar.CookieJar() opener = urllib.request.build_opener(urllib.request.HTTPCookieProcessor(cj)) urllib.request.install_opener(opener) def set_host(self, host): self.host = host def get_host(self): return self.host def get_protocol(self): return self.protocol def set_port(self, port): self.port = port def get_port(self): return self.port # 设置http头 def set_header(self, headers): self.headers = headers # 封装HTTP GET请求方法 def get(self, url, params=''): url = self.protocol + '://' + self.host + ':' + str(self.port) + url + params print('发起的请求为:%s' % url) request = urllib.request.Request(url, headers=self.headers) try: response = urllib.request.urlopen(request) response = response.read() return response except Exception as e: print('发送请求失败,原因:%s' % e) return None # 封装HTTP POST请求方法 def post(self, url, data=''): url = self.protocol + '://' + self.host + ':' + str(self.port) + url print('发起的请求为:%s' % url) request = urllib.request.Request(url, headers=self.headers) try: response = urllib.request.urlopen(request, data) response = response.read() return response except Exception as e: print('发送请求失败,原因:%s' % e) return None # 封装HTTP xxx请求方法 # 自由扩展 案例1: #!/usr/bin/env python # -*- coding:utf-8 -*- __author__

    03
    领券