Python GUI实现SQLite数据库的增删改查操作

import sqlite3
import tkinter as tk
from tkinter import ttk
from tkinter import messagebox
db=sqlite3.connect("d:/chang.db")
sql = "create table if not exists  student (data  date,  score  integer ,jl  text)"
cur = db.cursor()
cur.execute(sql)
cur.close()
db.close()

win=tk.Tk()
win.geometry('800x600')
tk.Label(win, text="日期").grid(row=0, column=0)
date=tk.StringVar()
tk.Entry(win,textvariable=date).grid(row=0,column=1)
tk.Label(win, text="分数").grid(row=1, column=0)
score = tk.StringVar()
tk.Entry(win, textvariable=score).grid(row=1, column=1)
tk.Label(win, text="奖励与否").grid(row=2, column=0)
gave=tk.StringVar()
tk.Entry(win, textvariable=gave).grid(row=2, column=1)
def select():
   x=dataTreeview.get_children()
   for item in x:
       dataTreeview.delete(item)
   db = sqlite3.connect("d:/chang.db")
   cur = db.cursor()
   sql='select * from student'
   d=cur.execute(sql)