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)
python 连接sql server
最新推荐文章于 2024-06-11 11:47:32 发布