先上代码和运行效果:
from tkinter import *
from tkinter.messagebox import *
import sqlite3
import re
win=Tk()
win.title("国债逆回购")
win.resizable(False,False)
win.geometry("310x220")
def yzgs(rq):#验证输入日期的格式
p=r'^\d\d\d\d+-\d\d-+\d\d$'
t=str(rq)
m=re.search(p,t)
return m
def dr(dz):
if dz=="":
showwarning("提示","请输入文件地址!")
else:
jl1=open(dz,"r")
while True:
jl2=jl1.readline()#逐行读取内容到jl2
if jl2=="":#如果读出数据为空就终止
break
else:
l=jl2.split(",")#拆分hdsj
conn = sqlite3.connect('D:\\nhg\\sy.db')
cursor = conn.cursor()
sql_dr="INSERT INTO nhk(rq,bj,sy)VALUES(\""+l[0]+"\",\""+l[1]+"\",\""+l[2]+"\")"
cursor.execute(sql_dr)
cursor.close()
conn.commit()
conn.close()
jl1.close
showwarning("提示","导入完成!")
def cr(rq1,rq2):
if rq1=="":
showwarning("提示","请输入日期!")
elif rq2=="":
showwarning("提示","请输入日期!")
else:
rq1_y=yzgs(rq1)
rq2_y=yzgs(rq2)
if rq1_y and rq2_y:
conn = sqlite3.connect('D:\\nhg\\sy.db')
cursor = conn.cursor()
sql_dr="select sum(sy) from nhk where rq>'"+rq1+"' and rq<='"+rq2+"'"
p=cursor.execute(sql_dr)
for pp in p:
jr.set(pp)
cursor.close()
conn.commit()
conn.close()
else:
showwarning("提示","请输入日期有误!")
def zhrq():
conn = sqlite3.connect('D:\\nhg\\sy.db')
cursor = conn.cursor()
sql_dr="select max(rq) from nhk"
p=cursor.execute(sql_dr)
for pp2 in p:
rq3.set(pp2)
cursor.close()
conn.commit()
conn.close()
dz=StringVar()
l1=Label(win,text="数据源位置:").grid(row=0,column=0)
e1=Entry(win,textvariable=dz).grid(row=0,column=1)
b1=Button(win,text="导入",command=lambda:dr(dz.get())).grid(row=0,column=2,sticky=W)#lambda临时函数绑定需要插入的参数
f1=LabelFrame(win,text="查询收益",height=120,width=300).grid(row=1,column=0,rowspan=4,columnspan=3,padx=5)
l2=Label(f1,text="起始日期:").grid(row=2,column=0,stick=E)
l3=Label(f1,text="终止时间:").grid(row=3,column=0,stick=E)
rq_1=StringVar()
rq_2=StringVar()
e2=Entry(f1,textvariable=rq_1).grid(row=2,column=1)
e3=Entry(f1,textvariable=rq_2).grid(row=3,column=1)
b2=Button(f1,text="查询",command=lambda:cr(rq_1.get(),rq_2.get()),height=3).grid(row=2,column=2,rowspan=3,sticky=W)
l4=Label(f1,text="时间段收益:").grid(row=4,column=0,stick=E)
jr=StringVar()
e4=Entry(f1,textvariable=jr).grid(row=4,column=1)
win.grid_rowconfigure(3, minsize=1)
f2=LabelFrame(win,text="查询记录最后日期",height=60,width=300).grid(row=5,column=0,rowspan=2,columnspan=3,padx=5)
l5=Label(f2,text="记录最后日期为:").grid(row=6,column=0,stick=E)
rq3=StringVar()
e5=Entry(f2,textvariable=rq3,).grid(row=6,column=1)
b3=Button(f2,text="查询",command=zhrq).grid(row=6,column=2,sticky=W)
win.mainloop()
从运行结果来看,显示的结果是对的,只是因为python浮点显示的问题,没办法正常显示出来。