Python连接SQL Server数据库

工具：pymssql库

1. 首先测试连接数据库

   import pymssql
   class CreateDB :
       def __init__(self):
           print("创建数据库类的初始化")
       def link(self):
           # 连接到数据库
           server = "DESKTOP-******"
           user = "sa"
           password = "************"
           print('Connecting to MSSQL...')
           conn = pymssql.connect(server, user, password, database="Register", charset='utf8')
           print('Connected')

   import sys
   import database
   if __name__ == "__main__" :
       DB = database.CreateDB()
       DB.link()
       sys.exit()

    

 测试结果如下，说明数据库连接已经成功！

 

  

import pymssql
class CreateDB :
    def __init__(self):
        print("创建数据库类的初始化")



    def link(self):
        # 连接到数据库
        print('Connecting to MSSQL...')
        #获取连接
        conn = pymssql.connect("DESKTOP-GGSD8AA","sa","wjy199912345","Register",charset='utf8')
        print('Connected')
        #获取游标
        cursor = conn.cursor()
        #查询记录
        cursor.execute("SELECT * FROM student")
        #获取一条记录
        row = cursor.fetchone()
        # 循环打印记录
        while row:
            print("Name = %s,Age = %s" % (row[0],row[1]))
            row = cursor.fetchone()
        #连接完释放资源
        conn.close()