Page 273 - MDP2020-3

················································································ 명장양성프로젝트 【MDP】 과제발표회 자료집 Ⅲ | 267

cursor.execute(sqlQ)
conn.commit()

result = cursor.fetchall()
return result

def sqlExecute(sqlQ):
cursor.execute(sqlQ)

conn.commit()

query = "SELECT * FROM data;"
query2 = ""
personNums = sqlExcute(query)

lPersonNums = personNums

def closeFrame():
global frame
frame.quit()

frame.destroy()
sys.exit(0)

def resetTime():
global resetToggle

resetToggle = True

def listClick(evt):
global NFCSignal, r4c, personNums, tImg, pngLabel, exitImage, statusFont,
statusButtonColor, imageEnter, imageExit, imageBusiness, imageSemiExit

e = evt.widget
num = int(e.curselection()[0])

if num != 0:
imgScr = ".\\img\\" + str(num) + ".png"

tImg = convTk(imgScr, 200, 200)

NFCSignal = False

examWindow = Toplevel(frame, bg=numsColor)

examWindow.title("출근 확인 창")
examWindow.overrideredirect(True)
examWindow.geometry("1280x720+0+0")
examWindow.lift()