sqlite3.ProgrammingError:无法对关闭的游标进行操作

2024-06-17 16:00:20 发布

您现在位置:Python中文网/ 问答频道 /正文

这是我的全部代码 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()

Tags: namemasteridconnectcv2opencvuserssqlite3