Python连接SQLServer数据库

#!/usr/bin/python
# -*- coding: UTF-8 -*-
import sys  
  
reload(sys)  
sys.setdefaultencoding('utf8')   

database=u'\u534E\u7535\u4E0B\u6C99'
print(database)
#数据库远程连接
## conn = pymssql.connect(host="127.0.0.1",user="admin",password="1q2w3e4r.",database="test",charset="utf8")
conn = pymssql.connect(host="****",user="****",password="****",database=database,charset="utf8")

import pymssql
import pprint

server = "127.0.0.1\\sql2000"
port = '1434'
user = "sa"
password = "123456"
database = 'master'
conn = pymssql.connect(server=server, user=user, password=password, database=database, port=port, charset="utf8")
cursor = conn.cursor()

sql = "use %s " % 'S3中文名' #注意%s后面有一个空格
sql += "select top 5 * from d_goods "
cursor.execute(sql)

rows = cursor.fetchall()
print(rows)

conn.close() 

#!/usr/bin/python
# -*- coding: utf-8 -*-
"""
Created on Mon Dec  2 15:11:35 2019

@author: ph
"""

import pymssql

import sys
import io
sys.setdefaultencoding('utf8')
    
# setup_io()


class LinkDB():
	def linkdb(self):
		#数据库远程连接
		conn = pymssql.connect(host="****(无端口)",user="****",password="****",database="****",charset="utf8")
		# 使用cursor()方法获取操作游标
		cursor = conn.cursor()
		#查询语句
		# sql = "SELECT * FROM [dbo].[test]"
		# sql="SELECT * FROM [dbo].[V_client]"
		try:
			cursor.execute(sql)  #游标
			result = cursor.fetchone() #查询
			print(result)
		except:
			print("error")
         
        #cursor.close()
		#关闭数据库连接
		conn.close()   
			
if __name__ == '__main__':
	link=LinkDB()
	link.linkdb()