from tkinter import * from tkinter import ttk import tkinter as tk import tkinter.messagebox as msgbox from tkinter import scrolledtext import os def Close(): reply=msgbox.askyesno('提示',"您确定退出系统吗？") if reply==True: root.destroy() def Help(): HelpGUI=Toplevel() HelpGUI.title('帮助') HelpGUI.geometry('350x350') HelpGUI.resizable(False,False) scr=scrolledtext.ScrolledText(HelpGUI,width=40,height=20,font=("Microsoft YaHei",12)) scr.insert(tk.INSERT,"""\ 用户须知： 1.本产品功能有限，仅支持这些操作： （1）录入书籍信息 （2）浏览书籍信息 （3）删除书籍信息 （4）修改书籍信息 （5）按书名统计书籍的数量 （6）按作者统计书籍的数量 （7）按出版社统计书籍的数量 （8）按类别统计书籍的数量 2.有关上述操作的说明： （1）1.1至1.4功能全部在基本功能菜单栏下，且每录入一条书籍信息或者修改书籍信息或者删除书籍信息，都会实时更新在文件中，用户无需进行点击保存的操作，如果用户想要浏览文件信息，需要选择菜单栏下的“浏览书籍信息”即可看到当前存入的所有书籍 （2）1.5至1.8功能在高级需求菜单栏下，这部分的功能会用一张表格输出 （3）有关排序的操作直接点击界面中的列名称即可，系统会自动根据选中的列信息进行排序 （4）退出的功能直接点击关闭即可 3.产品说明： ·开发者： 计算机20-2班 王思进 201002603 """) scr.configure(state='disabled') scr.pack() def CreateBookInfo(): CBIGUI=Toplevel() CBIGUI.title('录入书籍信息') CBIGUI.geometry('300x300') def IsEmpty(text): temp=0 for i in text: if not i.isspace(): temp=1 break if temp==1: return 0 else: return 1 def click(): num=addnuminput.get() name=addnameinput.get() author=addauthorinput.get() press=addpressinput.get() category=v.get() if IsEmpty(num) or IsEmpty(name) or IsEmpty(author) or IsEmpty(press) or IsEmpty(category): msgbox.showerror(title='提示',message="请填写所有信息！") else: f=open('图书.csv','r',encoding='utf-8-sig') for line in f.readlines(): info=line[:-1].split(",") if len(info)<5: break if info[0]==num: msgbox.showinfo(title='错误',message="序号已存在！") f.close() CBIGUI.destroy() return f.close() f=open('图书.csv','a',encoding='utf-8-sig') f.write('{},{},{},{},{}\n'.format(num,name,author,press,category)) f.close() reply=msgbox.showinfo(title='提示',message ="写入成功！") if reply: CBIGUI.destroy() addnum=Label(CBIGUI,text="序号",font=("Microsoft YaHei",10),anchor='w') addnum.place(x=30,y=30,height=20,width=80) addnuminput=Entry(CBIGUI,font=("Microsoft YaHei",10)) addnuminput.place(x=100,y=30,height=24,width=150) addname=Label(CBIGUI,text="书名",font=("Microsoft YaHei",10),anchor='w') addname.place(x=30,y=60,height=20,width=80) addnameinput=Entry(CBIGUI,font=("Microsoft YaHei",10)) addnameinput.place(x=100,y=60,height=24,width=150) addauthor=Label(CBIGUI,text="作者",font=("Microsoft YaHei",10),anchor='w') addauthor.place(x=30,y=90,height=20,width=80) addauthorinput=Entry(CBIGUI,font=("Microsoft YaHei",10)) addauthorinput.place(x=100,y=90,height=24,width=150) addpress=Label(CBIGUI,text="出版社",font=("Microsoft YaHei",10),anchor='w') addpress.place(x=30,y=120,height=20,width=80) addpressinput=Entry(CBIGUI,font=("Microsoft YaHei",10)) addpressinput.place(x=100,y=120,height=24,width=150) addcategory=Label(CBIGUI,text="类别",font=("Microsoft YaHei",10),anchor='w') addcategory.place(x=30,y=150,height=20,width=80) """addcategoryinput=Entry(CBIGUI,font=("Microsoft YaHei",10)) addcategoryinput.place(x=100,y=150,height=24,width=150)""" v=StringVar() v.set('其它') w1=Radiobutton(CBIGUI,text="专业书", value='专业书',variable=v) w2=Radiobutton(CBIGUI,text="工具书", value='工具书',variable=v) w3=Radiobutton(CBIGUI,text="报告", value='报告',variable=v) w4=Radiobutton(CBIGUI,text="小说", value='小说',variable=v) w5=Radiobutton(CBIGUI,text="其它", value='其它',variable=v) w1.place(x=100,y=150,height=20,width=60) w2.place(x=100,y=170,height=20,width=60) w3.place(x=95,y=190,height=20,width=60) w4.place(x=95,y=210,height=20,width=60) w5.place(x=95,y=230,height=20,width=60) Buttonadd=Button(CBIGUI,command=click,text="添加",font=("Microsoft YaHei",10)) Buttonadd.place(x=120,y=260,height=30,width=70) def DeleteBook(): DBGUI=Toplevel() DBGUI.title('删除书籍信息') DBGUI.geometry('400x400') def click(): num=addnuminput.get() fl=False def confirm(): reply=msgbox.askyesno('提示',"您确定要删除该图书信息吗？") if reply==True: with open("图书.csv","r",encoding="utf-8-sig") as f: lines=f.readlines() with open("图书.csv","w",encoding="utf-8-sig") as f_w: for line in lines: info=line[:-1].split(",") if info[0]==num: continue f_w.write(line) DBGUI.destroy() f=open('图书.csv','r',encoding='utf-8-sig') for line in f.readlines(): info=line[:-1].split(",") if len(info)<5: break if info[0]==num: fl=True name=info[1];author=info[2];press=info[3];category=info[4] f.close() if fl==False: msgbox.showinfo(title='错误',message="未找到该图书信息！") DBGUI.destroy() else: Info=Label(DBGUI,text="当前图书信息如下：") Info.place(x=50,y=60) addnum=Label(DBGUI,text="序号："+num,font=("Microsoft YaHei",10),anchor='w') addnum.place(x=50,y=90,height=15,width=80) addname=Label(DBGUI,text="书名："+name,font=("Microsoft YaHei",10),anchor='w') addname.place(x=50,y=120,height=15,width=80) addauthor=Label(DBGUI,text="作者："+author,font=("Microsoft YaHei",10),anchor='w') addauthor.place(x=50,y=150,height=15,width=80) addpress=Label(DBGUI,text="出版社："+press,font=("Microsoft YaHei",10),anchor='w') addpress.place(x=50,y=180,height=15,width=80) addcategory=Label(DBGUI,text="类别："+category,font=("Microsoft YaHei",10),anchor='w') addcategory.place(x=50,y=210,height=15,width=80) adddeletebutton=Button(DBGUI,command=confirm,text="确认删除",font=("Microsoft YaHei",10)) adddeletebutton.place(x=170,y=270,height=30,width=60) addnum=Label(DBGUI,text="序号",font=("Microsoft YaHei",10),anchor='w') addnum.place(x=50,y=30,height=20,width=80) addnuminput=Entry(DBGUI,font=("Microsoft YaHei",10)) addnuminput.place(x=100,y=30,height=24,width=150) addsearchbutton=Button(DBGUI,command=click,text="查询",font=("Microsoft YaHei",10)) addsearchbutton.place(x=270,y=30,height=24,width=40) def ModifyBook(): MBGUI=Toplevel() MBGUI.title('修改书籍信息') MBGUI.geometry('400x400') def click(): num=addnuminput.get() def IsEmpty(text): temp=0 for i in text: if not i.isspace(): temp=1 break if temp==1: return 0 else: return 1 def confirm(): name=addnameinput.get() author=addauthorinput.get() press=addpressinput.get() category=v.get() if IsEmpty(name) or IsEmpty(author) or IsEmpty(press) or IsEmpty(category): msgbox.showerror(title='提示',message="请填写所有信息！") else: reply=msgbox.askyesno('提示',"您确定要修改该图书信息吗？") if reply==True: with open("图书.csv","r",encoding="utf-8-sig") as f: lines=f.readlines() with open("图书.csv","w",encoding="utf-8-sig") as f_w: for line in lines: info=line[:-1].split(",") if info[0]==num: f_w.write('{},{},{},{},{}\n'.format(num,name,author,press,category)) continue f_w.write(line) MBGUI.destroy() fl=False f=open('图书.csv','r',encoding='utf-8-sig') i=1; for line in f.readlines(): info=line[:-1].split(",") if len(info)<5: break if info[0]==num: fl=True name=info[1];author=info[2];press=info[3];category=info[4] i=i+1 f.close() if fl==False: msgbox.showinfo(title='错误',message="未找到该图书信息！") MBGUI.destroy() else: Info=Label(MBGUI,text="当前图书信息如下：") Info.place(x=50,y=60) sv=StringVar() sv.set(name) addname=Label(MBGUI,text="书名：",font=("Microsoft YaHei",10),anchor='w') addname.place(x=50,y=90,height=15,width=80) addnameinput=Entry(MBGUI,textvariable=sv,font=("Microsoft YaHei",10)) addnameinput.place(x=150,y=90,height=24,width=150) sv=StringVar() sv.set(author) addauthor=Label(MBGUI,text="作者：",font=("Microsoft YaHei",10),anchor='w') addauthor.place(x=50,y=120,height=15,width=80) addauthorinput=Entry(MBGUI,textvariable=sv,font=("Microsoft YaHei",10)) addauthorinput.place(x=150,y=120,height=24,width=150) sv=StringVar() sv.set(press) addpress=Label(MBGUI,text="出版社：",font=("Microsoft YaHei",10),anchor='w') addpress.place(x=50,y=150,height=15,width=80) addpressinput=Entry(MBGUI,textvariable=sv,font=("Microsoft YaHei",10)) addpressinput.place(x=150,y=150,height=24,width=150) addcategory=Label(MBGUI,text="类别",font=("Microsoft YaHei",10),anchor='w') addcategory.place(x=50,y=180,height=20,width=80) """addcategoryinput=Entry(CBIGUI,font=("Microsoft YaHei",10)) addcategoryinput.place(x=100,y=150,height=24,width=150)""" v=StringVar() v.set(category) w1=Radiobutton(MBGUI,text="专业书", value='专业书',variable=v) w2=Radiobutton(MBGUI,text="工具书", value='工具书',variable=v) w3=Radiobutton(MBGUI,text="报告", value='报告',variable=v) w4=Radiobutton(MBGUI,text="小说", value='小说',variable=v) w5=Radiobutton(MBGUI,text="其它", value='其它',variable=v) w1.place(x=100,y=180,height=20,width=60) w2.place(x=100,y=200,height=20,width=60) w3.place(x=95,y=220,height=20,width=60) w4.place(x=95,y=240,height=20,width=60) w5.place(x=95,y=260,height=20,width=60) adddeletebutton=Button(MBGUI,command=confirm,text="确认修改",font=("Microsoft YaHei",10)) adddeletebutton.place(x=170,y=310,height=30,width=60) addnum=Label(MBGUI,text="序号",font=("Microsoft YaHei",10),anchor='w') addnum.place(x=50,y=30,height=20,width=80) addnuminput=Entry(MBGUI,font=("Microsoft YaHei",10)) addnuminput.place(x=100,y=30,height=24,width=150) addsearchbutton=Button(MBGUI,command=click,text="查询",font=("Microsoft YaHei",10)) addsearchbutton.place(x=270,y=30,height=24,width=40) def CountName(): CNGUI=Toplevel() CNGUI.title('按书名统计书籍的数量') CNGUI.geometry('500x500') def click(): name=addnameinput.get() f=open('图书.csv','r',encoding='utf-8-sig') fl=False for line in f.readlines(): info=line[:-1].split(",") if len(info)<5: break if info[1]==name: fl=True break f.close() if fl==False: msgbox.showinfo(title='错误',message="未找到该图书信息！") CNGUI.destroy() else: addnameinput.configure(state='disabled') def treeview_sort_column(tv,col,reverse): l=[(tv.set(k,col),k) for k in tv.get_children('')] try: l.sort(key=lambda t:int(t[0]),reverse=reverse) except: l.sort(reverse=reverse) for index,(val,k) in enumerate(l): tv.move(k,'',index) tv.heading(col,command=lambda:treeview_sort_column(tv,col,not reverse)) columns=("序号","书名","作者", "出版社", "类别") tree=ttk.Treeview(CNGUI,columns=columns) tree['show']='headings' tree.place(x=20,y=50,width=460,height=400) tree.column("序号",width=30,anchor='c') tree.column("书名",width=80,anchor='c') tree.column("作者",width=80,anchor='c') tree.column("出版社",width=80,anchor='c') tree.column("类别",width=80,anchor='c') tree.heading("序号",text="序号") tree.heading("书名",text="书名") tree.heading("作者",text="作者") tree.heading("出版社",text="出版社") tree.heading("类别",text="类别") f=open('图书.csv','r',encoding='utf-8-sig') i=0 for line in f.readlines(): info=line[:-1].split(",") if info[1]==name: tree.insert("",'end',values=(info[0],info[1],info[2],info[3],info[4])) i=i+1 f.close() for col in columns: tree.heading(col,text=col,command=lambda _col=col:treeview_sort_column(tree,_col,False)) i=str(i) addcount=Label(CNGUI,text="共有"+i+"条记录",font=("Microsoft YaHei",10)) addcount.place(x=400,y=460) addname=Label(CNGUI,text="书名",font=("Microsoft YaHei",10),anchor='w') addname.place(x=20,y=20,height=20,width=80) addnameinput=Entry(CNGUI,font=("Microsoft YaHei",10)) addnameinput.place(x=100,y=20,height=24,width=150) addsearchbutton=Button(CNGUI,command=click,text="查询",font=("Microsoft YaHei",10)) addsearchbutton.place(x=270,y=20,height=24,width=40) def CountAuthor(): CAGUI=Toplevel() CAGUI.title('按作者统计书籍的数量') CAGUI.geometry('500x500') def click(): author=addauthorinput.get() f=open('图书.csv','r',encoding='utf-8-sig') fl=False for line in f.readlines(): info=line[:-1].split(",") if len(info)<5: break if info[2]==author: fl=True break f.close() if fl==False: msgbox.showinfo(title='错误',message="未找到该作者信息！") CAGUI.destroy() else: addauthorinput.configure(state='disabled') def treeview_sort_column(tv,col,reverse): l=[(tv.set(k,col),k) for k in tv.get_children('')] try: l.sort(key=lambda t:int(t[0]),reverse=reverse) except: l.sort(reverse=reverse) for index,(val,k) in enumerate(l): tv.move(k,'',index) tv.heading(col,command=lambda:treeview_sort_column(tv,col,not reverse)) columns=("序号","书名","作者", "出版社", "类别") tree=ttk.Treeview(CAGUI,columns=columns) tree['show']='headings' tree.place(x=20,y=50,width=460,height=400) tree.column("序号",width=30,anchor='c') tree.column("书名",width=80,anchor='c') tree.column("作者",width=80,anchor='c') tree.column("出版社",width=80,anchor='c') tree.column("类别",width=80,anchor='c') tree.heading("序号",text="序号") tree.heading("书名",text="书名") tree.heading("作者",text="作者") tree.heading("出版社",text="出版社") tree.heading("类别",text="类别") f=open('图书.csv','r',encoding='utf-8-sig') i=0 for line in f.readlines(): info=line[:-1].split(",") if info[2]==author: tree.insert("",'end',values=(info[0],info[1],info[2],info[3],info[4])) i=i+1 f.close() for col in columns: tree.heading(col,text=col,command=lambda _col=col:treeview_sort_column(tree,_col,False)) i=str(i) addcount=Label(CAGUI,text="共有"+i+"条记录",font=("Microsoft YaHei",10)) addcount.place(x=400,y=460) addauthor=Label(CAGUI,text="作者",font=("Microsoft YaHei",10),anchor='w') addauthor.place(x=20,y=20,height=20,width=80) addauthorinput=Entry(CAGUI,font=("Microsoft YaHei",10)) addauthorinput.place(x=100,y=20,height=24,width=150) addsearchbutton=Button(CAGUI,command=click,text="查询",font=("Microsoft YaHei",10)) addsearchbutton.place(x=270,y=20,height=24,width=40) def CountPress(): CPGUI=Toplevel() CPGUI.title('按出版社统计书籍的数量') CPGUI.geometry('500x500') def click(): press=addpressinput.get() f=open('图书.csv','r',encoding='utf-8-sig') fl=False for line in f.readlines(): info=line[:-1].split(",") if len(info)<5: break if info[3]==press: fl=True break f.close() if fl==False: msgbox.showinfo(title='错误',message="未找到该出版社信息！") CPGUI.destroy() else: addpressinput.configure(state='disabled') def treeview_sort_column(tv,col,reverse): l=[(tv.set(k,col),k) for k in tv.get_children('')] try: l.sort(key=lambda t:int(t[0]),reverse=reverse) except: l.sort(reverse=reverse) for index,(val,k) in enumerate(l): tv.move(k,'',index) tv.heading(col,command=lambda:treeview_sort_column(tv,col,not reverse)) columns=("序号","书名","作者", "出版社", "类别") tree=ttk.Treeview(CPGUI,columns=columns) tree['show']='headings' tree.place(x=20,y=50,width=460,height=400) tree.column("序号",width=30,anchor='c') tree.column("书名",width=80,anchor='c') tree.column("作者",width=80,anchor='c') tree.column("出版社",width=80,anchor='c') tree.column("类别",width=80,anchor='c') tree.heading("序号",text="序号") tree.heading("书名",text="书名") tree.heading("作者",text="作者") tree.heading("出版社",text="出版社") tree.heading("类别",text="类别") f=open('图书.csv','r',encoding='utf-8-sig') i=0 for line in f.readlines(): info=line[:-1].split(",") if info[3]==press: tree.insert("",'end',values=(info[0],info[1],info[2],info[3],info[4])) i=i+1 f.close() for col in columns: tree.heading(col,text=col,command=lambda _col=col:treeview_sort_column(tree,_col,False)) i=str(i) addcount=Label(CPGUI,text="共有"+i+"条记录",font=("Microsoft YaHei",10)) addcount.place(x=400,y=460) addpress=Label(CPGUI,text="出版社",font=("Microsoft YaHei",10),anchor='w') addpress.place(x=20,y=20,height=20,width=80) addpressinput=Entry(CPGUI,font=("Microsoft YaHei",10)) addpressinput.place(x=100,y=20,height=24,width=150) addsearchbutton=Button(CPGUI,command=click,text="查询",font=("Microsoft YaHei",10)) addsearchbutton.place(x=270,y=20,height=24,width=40) def CountCategory(): CCGUI=Toplevel() CCGUI.title('按类别统计书籍的数量') CCGUI.geometry('500x500') def click(): category=addcategoryinput.get() f=open('图书.csv','r',encoding='utf-8-sig') fl=False for line in f.readlines(): info=line[:-1].split(",") if len(info)<5: break if info[4]==category: fl=True break f.close() if fl==False: msgbox.showinfo(title='错误',message="未找到该类别信息！") CCGUI.destroy() else: addcategoryinput.configure(state='disabled') def treeview_sort_column(tv,col,reverse): l=[(tv.set(k,col),k) for k in tv.get_children('')] try: l.sort(key=lambda t:int(t[0]),reverse=reverse) except: l.sort(reverse=reverse) for index,(val,k) in enumerate(l): tv.move(k,'',index) tv.heading(col,command=lambda:treeview_sort_column(tv,col,not reverse)) columns=("序号","书名","作者", "出版社", "类别") tree=ttk.Treeview(CCGUI,columns=columns) tree['show']='headings' tree.place(x=20,y=50,width=460,height=400) tree.column("序号",width=30,anchor='c') tree.column("书名",width=80,anchor='c') tree.column("作者",width=80,anchor='c') tree.column("出版社",width=80,anchor='c') tree.column("类别",width=80,anchor='c') tree.heading("序号",text="序号") tree.heading("书名",text="书名") tree.heading("作者",text="作者") tree.heading("出版社",text="出版社") tree.heading("类别",text="类别") f=open('图书.csv','r',encoding='utf-8-sig') i=0 for line in f.readlines(): info=line[:-1].split(",") if info[4]==category: tree.insert("",'end',values=(info[0],info[1],info[2],info[3],info[4])) i=i+1 f.close() for col in columns: tree.heading(col,text=col,command=lambda _col=col:treeview_sort_column(tree,_col,False)) i=str(i) addcount=Label(CCGUI,text="共有"+i+"条记录",font=("Microsoft YaHei",10)) addcount.place(x=400,y=460) addcategory=Label(CCGUI,text="类别",font=("Microsoft YaHei",10),anchor='w') addcategory.place(x=20,y=20,height=20,width=80) addcategoryinput=Entry(CCGUI,font=("Microsoft YaHei",10)) addcategoryinput.place(x=100,y=20,height=24,width=150) addsearchbutton=Button(CCGUI,command=click,text="查询",font=("Microsoft YaHei",10)) addsearchbutton.place(x=270,y=20,height=24,width=40) def Root(): root.title('个人书籍管理系统') root['width']=800 root['height']=600 menu=Menu(root) submenu=Menu(menu,tearoff=0) submenu.add_command(label="录入书籍信息",command=CreateBookInfo) #submenu.add_command(label="保存书籍信息") submenu.add_command(label="浏览书籍信息",command=Table) #submenu.add_command(label="查询书籍信息") submenu.add_command(label="删除书籍信息",command=DeleteBook) submenu.add_command(label="修改书籍信息",command=ModifyBook) menu.add_cascade(label="基本功能",menu=submenu) submenu=Menu(menu,tearoff=0) submenu.add_command(label="按书名统计书籍的数量",command=CountName) submenu.add_command(label="按作者统计书籍的数量",command=CountAuthor) submenu.add_command(label="按出版社统计书籍的数量",command=CountPress) submenu.add_command(label="按类别统计书籍的数量",command=CountCategory) #submenu.add_command(label="按书名对书籍进行排序") menu.add_cascade(label="高级需求",menu=submenu) submenu=Menu(menu,tearoff=0) submenu.add_command(label="帮助",command=Help) menu.add_cascade(label="工具",menu=submenu) root.config(menu=menu) addLabel=Label(root,text="点击“工具”->“帮助”即可查看本系统的相关操作",font=("Microsoft YaHei",10)) addLabel.place(x=20,y=560) root.protocol("WM_DELETE_WINDOW",Close) def Table(): def treeview_sort_column(tv,col,reverse): l=[(tv.set(k,col),k) for k in tv.get_children('')] try: l.sort(key=lambda t:int(t[0]),reverse=reverse) except: l.sort(reverse=reverse) for index,(val,k) in enumerate(l): tv.move(k,'',index) tv.heading(col,command=lambda:treeview_sort_column(tv,col,not reverse)) columns=("序号","书名","作者", "出版社", "类别") tree=ttk.Treeview(root,columns=columns) tree['show']='headings' tree.place(x=10,y=10,width=780,height=550) tree.column("序号",width=80,anchor='c') tree.column("书名",width=150,anchor='c') tree.column("作者",width=150,anchor='c') tree.column("出版社",width=150,anchor='c') tree.column("类别",width=150,anchor='c') tree.heading("序号",text="序号") tree.heading("书名",text="书名") tree.heading("作者",text="作者") tree.heading("出版社",text="出版社") tree.heading("类别",text="类别") f=open('图书.csv','r',encoding='utf-8-sig') for line in f.readlines(): info=line[:-1].split(",") tree.insert("",'end',values=(info[0],info[1],info[2],info[3],info[4])) f.close() for col in columns: tree.heading(col,text=col,command=lambda _col=col:treeview_sort_column(tree,_col,False)) if __name__ == '__main__': root=Tk() Root() open('图书.csv','a',encoding='utf-8-sig') Table() root.mainloop()