Python连接MSSQL数据库pyodbc方案

import pyodbc


def dblog(ip,
      port,
      user_agent,
      window_size,
      keyword,
      url,
      pageNum,
      posNum,
      success,
      message=''):
server = 'tcp:127.0.0.1'
database = 'PythonDB'
username = 'garson'
password = '288fs054@06'
conn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER=' +
                      server + ';DATABASE=' + database + ';UID=' +
                      username + ';PWD=' + password)
cur = conn.cursor()

sql = u"insert into data_log(logTime,keyword,url,pageNum,posNum,ip,port,useragent,windowsSize,cookie,success,Message) \
    values(getdate(),'%(keyword)s','%(url)s',%(pageNum)d,%(posNum)d,'%(ip)s','%(port)s','%(useragent)s','%(windowsSize)s','%(cookie)s',%(success)d,'%(message)s')" % {
    "keyword": keyword,
    "url": url,
    "pageNum": pageNum,
    "posNum": posNum,
    "ip": ip,
    "port": port,
    "useragent": user_agent,
    "windowsSize": ','.join(str(a) for a in window_size),
    "cookie": '',
    "success": success,
    "message": message
}
cur.execute(sql)
conn.commit()
conn.close()