python 连接sql server

import pymssql
import os,re,sys


def Conn(host,user,password,database):
    # 服务器名,账户,密码,数据库名
    connect = pymssql.connect(host, user, password, database, charset='utf8')
    if connect:
        # print("数据库连接成功!")
        pass
    cursor = connect.cursor()  # 创建一个游标对象,python里的sql语句都要通过cursor来执行
    sql = "SELECT Name FROM SysObjects Where XType='U' ORDER BY Name"
    cursor.execute(sql)  # 执行sql语句
    row = cursor.fetchone()
    print(row)
    cursor.close()  # 关闭游标
    connect.close()  # 关闭连接


if __name__ == '__main__':
    host = "localhost"
    user = "sa"
    password = "yanh"
    database = "yanh"
    Conn(host,user,password,database)