python - sqlite3.ProgrammingError：无法对关闭的游标进行操作

Question

这是我的完整代码 idk 为什么我有这个错误，但是数据已经插入到 sqlite 数据库中，错误是 sqlite3.ProgrammingError：无法对关闭的游标进行操作。[警告：1] 全局 C:..\cap_msmf.cpp (674) SourceReaderCB::~SourceReaderCB 终止异步回调

import cv2 
import sqlite3 

connect = sqlite3.connect('C:///Users///Marvin///Desktop///Opencv-face-detection-python-master///SQL///sql.db')
cur = connect.cursor()

face_cascade = cv2.CascadeClassifier('C://Users/Marvin/Desktop/Opencv-face-detection-python-master/haarcascade_frontalface_default.xml')

cap = cv2.VideoCapture(0)
id = input("Please Input Your id: ")
name = input("Please Input Your name: ")
nums = 0
while True:
    ret, img = cap.read()
    gray = cv2.cvtColor(img, cv2.COLOR_BGR2GRAY)
    faces = face_cascade.detectMultiScale(gray, 1.3, 5)
    for (x, y, w, h) in faces:
        nums = nums+1
    cv2.imwrite("C:\\Users\Marvin\Desktop\Opencv-face-detection-python- 
    master\dataSet\."+str(id)+"."+str(nums)+".jpg", gray[y:y+h,x:x+w])
    cv2.rectangle(img, (x, y), (x + w, y + h), (255, 0, 0), 2)
    'cv2.waitKey(100)'

    cur.execute("INSERT INTO user(id,name) Values("+str(id)+",' "+str(name)+" ' )")
    connect.commit()
    cur.close()

标签： pythonsqlite