django连接数据库sql serve

Question

第一次连接数据库，想问一下这个报错是为什么啊？

from django.http import HttpResponse
from django.shortcuts import render

import pymssql
import json
def login(request):
    return render(request, 'login.html')

def index(request):
    return render(request, 'index.html')

def check(request):
    data = request.GET
    
    account = data['account']
    password = data['password']

    db = pymssql.connect('127.0.0.1','sa','15036838685a','VCD_info')

    cursor = db.cursor()
    sql = 'select * from user_info where account="{}"'.format(account)
    cursor.execute(sql)
    result = cursor.fetchall()

    cursor.close()
    db.close()

    if result[0][0] == password:
        return HttpResponse(json.dumps({
            'status':'ok',
            'msg':'index/'
        }))
    else:
        return HttpResponse(json.dumps({
            'status':'error',
            'msg':'账号密码错误'
        }))
#下面是报错：

raceback (most recent call last):
  File "D:\python_path\Lib\site-packages\django\core\handlers\exception.py", line 34, in inner
    response = get_response(request)
               ^^^^^^^^^^^^^^^^^^^^^
  File "D:\python_path\Lib\site-packages\django\core\handlers\base.py", line 126, in _get_response
    response = self.process_exception_by_middleware(e, request)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\python_path\Lib\site-packages\django\core\handlers\base.py", line 124, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\vscode\html文件\html学习\login\login\view.py", line 22, in check
    cursor.execute(sql)
  File "src\pymssql\_pymssql.pyx", line 459, in pymssql._pymssql.Cursor.execute
  File "src\pymssql\_mssql.pyx", line 1087, in pymssql._mssql.MSSQLConnection.execute_query
  File "src\pymssql\_mssql.pyx", line 1118, in pymssql._mssql.MSSQLConnection.execute_query
  File "src\pymssql\_mssql.pyx", line 1238, in pymssql._mssql.MSSQLConnection.format_and_run_query
  File "src\pymssql\_mssql.pyx", line 237, in pymssql._mssql.ensure_bytes
AttributeError: 'builtin_function_or_method' object has no attribute 'encode'

Answer 1

    cursor1 = db.cursor()
    sql = 'select * from user_info where account="{}"'.format(account)
    cursor1.execute(sql)
    result = cursor1.fetchall()

cursor 换个名字看看