Teach you how to connect to sql server with python

# server defaults to 127.0.0.1, if you open the TCP dynamic port you need to add the port number, such as '127.0.0.1:1433'.
# user defaults to sa
# password is the password you set for yourself
# database is the name of the database
server = '127.0.0.1'
user = "sa"
password = "123456"
database = "pubs"
conn = (server, user, password, database)
# can be simplified to conn = (host='localhost', user='sa', password='123456', database='pubs')
cursor = ()
('SELECT * FROM titles')
print( () ) 

# If you read the database with pandas
import pymssql
import pandas as pd
conn = ('IP address','Account Number','Password','Database')
sql_1 = "SELECT Id,create_time from table name"
#Use pandas to get data directly"
data = pd.read_sql(sql_1, conn)
()
print(data)

#coding=utf-8 
# sqlserver connection
import pymssql

class MSSQL:
    def __init__(self,host,user,pwd,db):
         = host
         = user
         = pwd
         = db

    def __GetConnect(self):
        """
        Get connection information
        come (or go) back: ()
        """
        if not :
            raise(NameError,"No database information set")
         = (host=,user=,password=,database=,charset="utf8")
        cur = ()
        if not cur:
            raise(NameError,"Failed to connect to database.")
        else:
            return cur

    def ExecQuery(self,sql):
        """
        Execute the query statement
        What is returned is a list containing tuples, where the elements of the list are the rows of records and the elements of the tuples are the fields for each row of records

        """
        cur = self.__GetConnect()
        (sql)
        resList = ()

        #Must close the connection after the query is complete
        ()
        return resList

    def ExecNonQuery(self,sql):
        """
        Executing Non-Query Statements

        Recall Example：
            cur = self.__GetConnect()
            (sql)
            ()
            ()
        """
        cur = self.__GetConnect()
        (sql)
        ()
        ()

def main():
	# host is 127.0.0.1 by default, if you open the TCP dynamic port you need to add the port number, such as '127.0.0.1:1433'.
    # user defaults to sa
    # pwd is the password you set for yourself
    # db is the database name
    ms = MSSQL(host='127.0.0.1',user="sa",pwd="123456",db="pubs")
    resList = ("SELECT * FROM titles")
    print(resList)

if __name__ == '__main__':
    main()