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)
selectButton = tk.Button(win, text='查询', width=10,
height=1, command=select).grid(row=3, column=0, pady=5)
def delete():
db = sqlite3.connect("d:/chang.db")
cur = db.cursor()
sql='select * from student'
d=cur.execute(sql)
s=dataTreeview.selection()[0]
print(s)
dataTreeview.delete(s)
db = sqlite3.connect("d:/chang.db")
cur=db.cursor()
sql='delete from student where date=?',
deleteButton = tk.Button(win, text='删除', width=10,
height=1, command=delete).grid(row=3, column=2, pady=5)
#增加利用树查询数据的功能
dataTreeview = ttk.Treeview(win, show='headings', column=(
'date', 'score', 'give'))
dataTreeview.column('date', width=150, anchor="center")
dataTreeview.column('score', width=150, anchor="center")
dataTreeview.column('give', width=150, anchor="center")
dataTreeview.heading('date', text='时间')
dataTreeview.heading('score', text='分数')
dataTreeview.heading('give', text='奖励')
dataTreeview.grid(row=4,columnspan=3)
win.mainloop()