Python如何实现简易信息分类存储软件

Python如何实现简易信息分类存储软件，针对这个问题，这篇文章详细介绍了相对应的分析和解答，希望可以帮助更多想解决这个问题的小伙伴找到更简单易行的方法。

时间紧任务重，女神提出的要求有模棱两可，只能自己考虑各种情况，除了用python还有谁能这么短的时间搞出来。

程序界面，增删改查不能少，后悔药也需要给女神准备上，由于最后需要打包给女神用，所以选择了python的自带库，tkinter编写界面，我觉得也不是那么丑，数据存储用sqlite3数据库，可以导出成csv文件，完全用python自带库解决，这样打包起来兼容性会好一点。

查询界面，可以根据每个表的各个项目分类查询，如果不输入查询关键字，则当前类别全部输出。

汇总信息展示，这里也是程序初始界面。

废话不多说，直接上代码，由于也是业余时间搞得，代码简单粗暴，缝缝补补，各位大神见笑了。

import tkinter as tkimport sqlite3import csvfrom threading import Threadimport shutilimport osimport timefrom tkinter import  messageboxfrom tkinter import filedialogfrom tkinter import ttkclass App(tk.Frame):    def __init__(self,master,*args,**kwargs):        super().__init__(master,*args,**kwargs)        self.dirdict={            "新建":self.new,            "查询":self.search,            "修改":self.edit,            "删除":self.delete,            "汇总":self.totale,            "导出":self.export,            "后悔药":self.regret        }        self.newdict={                "咨询信息":self.customer_information,                "投标信息":self.bidding_information,                "合同信息" :self.contract_information,                "售后信息" :self.service_information,            }        self.newlabelsdict={            "咨询信息":["日期","公司名称","联系人","联系电话","备注"],            "投标信息":["招标单位","招标号","报名费","保证金","退保证金","开票信息",],            "合同信息":["合同号","签订日期","数量","总价","客户名称","货期","派工单号","发货地址","回款批次","发票信息","开票信息","合同扫描件"],            "售后信息":["产品型号","派工号","货期","技术人员","安装人员","验收","售后1","售后2"],        }               self.prmkey={            "咨询信息":('company',1),            "投标信息":('company',0),            "合同信息":('contract',0),            "售后信息":('jobnum',1),        }        self.new_zh_col={            "咨询信息":'consulting',            "日期":"date","公司名称":"company","联系人":"contacts","联系电话":"telephone","备注":"remarks",            "投标信息":'bid',            "招标单位":"company","招标号":"number","报名费":"enroll","保证金":"ensure","退保证金":"back","开票信息":"invoice",            "合同信息":'contractinfo',            "合同号":"contract","签订日期":"sdate","数量":"quantity","总价":"total","客户名称":"customer","货期":"delivery","派工单号":"oddnum","发货地址":"address","回款批次":"batch","发票信息":"cinfo","开票信息":"invoice","合同扫描件":"catpath",            "售后信息":'service',            "产品型号":"product","派工号":"jobnum","货期":"delivery","技术人员":"artisan","安装人员":"installer","验收":"check","售后1":"service1","售后2":"service2",        }        self.pack(expand=1,fill="both")        self.con=sqlite3.connect("treasure.db")        self.creat_widget()    def creat_widget(self):        self.frameleft = tk.Frame(self,bg='RoyalBlue',relief="groove",borderwidth=2)        self.frameleft.pack(side='left',expand='no',fill='y',anchor="n")                for i in self.dirdict.keys():            but=tk.Button(self.frameleft,text=i,width="10",)            but.pack(side="top",expand="no",fill="x",anchor="n",padx=4,pady=5,)            but.bind('', self.set_style)        self.frameright = tk.Frame(self,bg='RoyalBlue',relief="groove",borderwidth=2)        self.frameright.pack(side='right',expand='yes',fill='both',padx=3,pady=0)        self.lf2 = tk.LabelFrame(self.frameright,text="信息",relief="groove",borderwidth=1,bg="Wheat")        self.lf2.pack(side="top",expand=1,fill="both",pady=2,)        self.totale()    def set_style(self,event):        for i in self.frameleft.winfo_children():            if isinstance(i,tk.Button):                i.config(fg="black")        event.widget["fg"]="blue"        self.reset(self.frameright)        self.lf1 = tk.Frame(self.frameright,relief="groove",borderwidth=0,bg='RoyalBlue')        self.lf1.pack(side="top",expand=0,fill="x",pady=2,)        self.lf2 = tk.LabelFrame(self.frameright,text="信息",relief="groove",borderwidth=1,bg="Wheat")        self.lf2.pack(side="top",expand=1,fill="both",pady=2,)        self.dirdict.get(event.widget["text"],None)()        self.lf2["text"]=event.widget["text"]######################################新建内容###########################################################################    def new(self):#新建总类        def data_input(event):            self.lf2.config(text=event.widget['text'])            self.reset(self.lf2)            self.newdict.get(event.widget['text'],None)(self.newlabelsdict[event.widget['text']])        for i in self.newdict.keys():            bu=tk.Button(self.lf1,text=i,)            bu.pack(side="left",expand=1,fill="x",padx=5,pady=2,)            bu.bind('', data_input)            def customer_information(self,labellist):#新建客户信息        this="咨询信息"        for i in labellist:            if i == labellist[-1]:                tk.Label(self.lf2,text=i,bg="Wheat",width=10).pack(side="top",)                tk.Text(self.lf2,height=6).pack(side="top",expand=1,pady=1,padx=5,fill="both")            else:                e=tk.Entry(self.lf2,)                e.pack(side="top",expand=0,pady=1,padx=5,fill="x")                l=tk.Label(e,text=i,bg="Wheat",width=10)                l.pack(side="right",)        def getdict():            cusdict=self.super_get(labellist,self.lf2)            if self.save_data("INSERT INTO consulting VALUES (?,?,?,?,?)", list(cusdict.values())):                self.super_del(self.lf2)                   bu=tk.Button(self.lf2,text="确认提交",width=15,command=getdict)        bu.pack(side="bottom",expand=0,padx=5,pady=2,)    def bidding_information(self,labellist):#新建招标信息        this="投标信息"        for i in labellist:            if i == labellist[-1]:                tk.Label(self.lf2,text=i,bg="Wheat",width=10).pack(side="top",)                tk.Text(self.lf2,height=6).pack(side="top",expand=1,pady=1,padx=5,fill="both")            else:                e=tk.Entry(self.lf2,)                e.pack(side="top",expand=0,pady=1,padx=5,fill="x")                l=tk.Label(e,text=i,bg="Wheat",width=10)                l.pack(side="right",)        def getdict():            cusdict=self.super_get(labellist,self.lf2)            if self.save_data("INSERT INTO bid VALUES (?,?,?,?,?,?)", list(cusdict.values())):                self.super_del(self.lf2)        bu=tk.Button(self.lf2,text="确认提交",width=15,command=getdict)        bu.pack(side="bottom",expand=0,padx=5,pady=2,)           def contract_information(self,labellist):#新建合同信息        this="合同信息"        def filenames():            names=filedialog.askopenfilenames(title="上传合同扫描件")              if names:                filenamesentry.insert(0,",".join(names))                    for i in labellist:            if i==labellist[0]:                connum=tk.Entry(self.lf2,)                connum.pack(side="top",expand=0,pady=1,padx=5,fill="x")                tk.Label(connum,text=i,bg="Wheat",width=10).pack(side="right",)            elif i == labellist[-2]:                tk.Label(self.lf2,text=i,bg="Wheat",width=10).pack(side="top",)                tk.Text(self.lf2,height=6).pack(side="top",expand=1,pady=1,padx=5,fill="both")            elif i==labellist[-1]:                filenamesentry=tk.Entry(self.lf2)                filenamesentry.pack(side="top",expand=0,pady=2,padx=5,fill="x")                filebut=tk.Button(filenamesentry,text="点击上传合同",height=1,command=filenames)                filebut.pack(side="right",expand=0,padx=0,pady=0,)            else:                e=tk.Entry(self.lf2,)                e.pack(side="top",expand=0,pady=1,padx=5,fill="x")                tk.Label(e,text=i,bg="Wheat",width=10).pack(side="right",)        def getdict():            files=filenamesentry.get()            if files:                number=connum.get() if connum.get() else "无合同号"                newcat=os.path.join(os.getcwd(),"mydata\{}{}".format(number,time.strftime(r"-%Y-%m-%d %H-%M-%S",time.localtime()),))                os.mkdir(newcat)                for i in files.split(","):                    shutil.move(os.path.join(i),newcat)                filenamesentry.delete(0, "end")                filenamesentry.insert(0,newcat)            cusdict=self.super_get(labellist,self.lf2)            if self.save_data("INSERT INTO contractinfo VALUES (?,?,?,?,?,?,?,?,?,?,?,?)", list(cusdict.values())):                self.super_del(self.lf2)        bu=tk.Button(self.lf2,text="确认提交",width=15,command=getdict)        bu.pack(side="bottom",expand=0,padx=5,pady=2,fill="x")           def service_information(self,labellist):#新建售后信息        this="售后信息"        for i in labellist:            e=tk.Entry(self.lf2,)            e.pack(side="top",expand=0,pady=1,padx=5,fill="x")            l=tk.Label(e,text=i,bg="Wheat",width=10)            l.pack(side="right",)         def getdict():            cusdict=self.super_get(labellist,self.lf2)            # check=self.check(self.new_zh_col.get(this,None),self.prmkey.get(this,None)[0],cusdict.get())            if self.save_data("INSERT INTO service VALUES (?,?,?,?,?,?,?,?)", list(cusdict.values())):                self.super_del(self.lf2)        bu=ttk.Button(self.lf2,text="确认提交",width=15,command=getdict)        bu.pack(side="bottom",expand=0,padx=5,pady=2,)#################################################################################################################    def save_data(self,sqldoc,somedata,flag=False):#数据库存储存储客户信息        cur = self.con.cursor()        try:            cur.execute(sqldoc,somedata)            self.con.commit()            messagebox.showinfo("禀报女王","女王万岁，您又赢了")            return True        except Exception as e:            messagebox.showwarning("急报女王","女王我出错了:{}".format(e))            return False    def check(self,this,col,value):        sqldoc="SELECT * FROM {} WHERE {} = '{}' ".format(this,col,value)        cur = self.con.cursor()        cur.execute(sqldoc)        data=cur.fetchone()        return data    def find_data(self,sqldoc):        cur = self.con.cursor()        try:            cur.execute(sqldoc)            datas=cur.fetchall()            if datas:                return datas            else:                messagebox.showwarning("禀报女王","女王大人，小的什么也没搜到")        except Exception as e:            messagebox.showwarning("禀报女王","女王大人这是一次失误{}".format(e))            return None    def del_data(self,sqldoc):        cur = self.con.cursor()        cur.execute(sqldoc)        self.con.commit()        messagebox.showinfo("喜报","女王无敌，敌人已消灭")    def add_top(self,title):#创建顶级窗口        top = tk.Toplevel(width=self.master.winfo_screenwidth()//4,height=self.master.winfo_screenheight()//4,)        top.title(title)        return top    def reset(self,widget):#重置该组件，销毁该组件所有子组件        for i in widget.winfo_children():            i.destroy()    def super_get(self,labellist,wids):#获取entry和text类得内容        cusdict={}        for i ,k in zip(labellist,[i for i in wids.winfo_children() if isinstance(i, (tk.Entry,tk.Text))]):            if isinstance(k,tk.Entry):                cusdict[i] = k.get()            elif isinstance(k, tk.Text):                cusdict[i] = k.get(1.0,'end')            else:                pass        return cusdict    def super_del(self,wids):#删除entry和text类的内容        for wid in wids.winfo_children():            if isinstance(wid,tk.Text):                wid.delete(1.0,"end")            elif isinstance(wid, tk.Entry):                wid.delete(0,"end")            else:                pass    def super_insert(self,wids,text):#为entry或text类组件插入内容        ins=[i for i in wids.winfo_children() if isinstance(i, (tk.Entry,tk.Text))]        for wid,value in zip(ins,text):            wid.insert("end",value)               def creat_tree(self,wid,headers,height=4):#建立treeview组件                tree=ttk.Treeview(wid,columns=headers,show='headings',height=height)        for n,i in enumerate(headers):            tree.column(i,width=60,)            tree.heading(column=i,text=i)        sc=ttk.Scrollbar(wid,)        sc['command']=tree.yview        sc.pack(side='right',fill='both')        tree["yscrollcommand"]=sc.set        tree.pack(side="top",fill="both",expand=1)        return tree    def tree_insert(self,table,datas):#插入数值        # 插入数据        if datas:            for index, data in enumerate(datas):                table.insert('', index, values=data)          def tree_del(self,obj):#清除组件内内容        child=obj.get_children()        for i in child:            obj.delete(i)    def create_lf1_children(self,parent,):#为一下项目提供筛选，搜索选项        def change(event):            cominfo["values"]=self.newlabelsdict[com.get()]            cominfo.current(0)        com=ttk.Combobox(parent,values=tuple(self.newlabelsdict.keys()),state="readonly",)        com.pack(side="left",padx=2,pady=2)        com.current(0)        com.bind('<>', change)        cominfo=ttk.Combobox(parent,state="readonly",values=self.newlabelsdict[com.get()])        cominfo.pack(side="left",padx=2,pady=2)        cominfo.current(0)        e=ttk.Entry(parent,)        e.pack(side="left",expand=1,pady=1,padx=5,fill="x")                return com,cominfo,e    def start_find(self,arc,colname,e):#便捷函数，为以下项目提供支持        tablename, col = self.new_zh_col.get(arc,None),self.new_zh_col.get(colname,None)        self.lf2.config(text=arc)        headers=self.newlabelsdict.get(arc,None)        table=self.creat_tree(self.lf2,headers)        par=e.get()        sqldoc="SELECT * FROM {} WHERE {} LIKE '%{}%' ".format(tablename,col,par) if par else "SELECT * FROM {} ".format(tablename)        datas=self.find_data(sqldoc)        return table ,datas        def search(self):#查找数据        def find():            self.reset(self.lf2)            arc=com.get()            colname = cominfo.get()            table,datas=self.start_find(arc,colname,e)            self.tree_insert(table,datas)        com, cominfo, e= self.create_lf1_children(self.lf1, )        tk.Button(self.lf1,text="开始查找",command=find).pack(side="left",expand=0,padx=5,pady=2,)            def edit(self):#编辑数据        def tree_selected(event):            name=com.get()            value_e=event.widget.item(event.widget.selection()[0])['values']            self.reset(self.lf2)            self.newdict.get(name,None)(self.newlabelsdict[name])            self.super_insert(self.lf2,value_e)                                def find():            self.reset(self.lf2)            arc=com.get()            colname = cominfo.get()            table,datas=self.start_find(arc,colname,e)            self.tree_insert(table,datas)            table.bind("<>", tree_selected)        com, cominfo, e = self.create_lf1_children(self.lf1, )        tk.Button(self.lf1,text="开始查找",command=find).pack(side="left",expand=0,padx=5,pady=2,)               def delete(self):        def tree_selected(event):            name=com.get()            value_e=event.widget.item(event.widget.selection()[0])['values']            flag=messagebox.askokcancel('爱之深恨之切',"女王大人，确定要放弃它嘛")            if flag:                sqldoc="DELETE FROM {} WHERE {} = '{}' ".format(self.new_zh_col.get(name,None),self.prmkey.get(name,None)[0],value_e[self.prmkey.get(name,None)[1]])                self.del_data(sqldoc)                find()            else:                pass        def find():            self.reset(self.lf2)            arc=com.get()            colname = cominfo.get()            table,datas=self.start_find(arc, cominfo, e)            self.tree_insert(table,datas)            table.bind("<>", tree_selected)        com, cominfo, e = self.create_lf1_children(self.lf1, )        tk.Button(self.lf1,text="开始查找",command=find).pack(side="left",expand=0,padx=5,pady=2,)    def export(self):#导出数据，存为csv文件        def ex():            cur = self.con.cursor()            file=os.path.join(os.getcwd(),"{}{}.csv".format("数据汇总",time.strftime(r"-%Y-%m-%d %H-%M",time.localtime()),))            print(file)            with open(file,"w",newline="") as dd:                wter=csv.writer(dd)                for i in self.newlabelsdict.keys():                    sqldoc="SELECT * FROM {} ".format(self.new_zh_col.get(i,None))                    cur.execute(sqldoc)                    datas=cur.fetchall()                    wter.writerow(self.newlabelsdict[i])                    wter.writerows(datas)                    wter.writerow("")            messagebox.showinfo("喜报","女王陛下，数据已导出完成\n存储位置{}".format(file))        def beifen():            t = Thread(target=ex)            t.run()        cur = self.con.cursor()        for i, k in self.newlabelsdict.items():            lf21=tk.LabelFrame(self.lf2,text=i,bg="Wheat")            lf21.pack(side="top",fill="both",expand=1,pady=1)            sqldoc="SELECT * FROM {} ".format(self.new_zh_col.get(i,None))            cur.execute(sqldoc)            datas=cur.fetchall()            tk.Label(lf21,text="{}数据总数: {}条".format(i,len(datas)),font=("bold",15),bg="Wheat").pack(side="top",expand=1,fill="x")                tk.Button(self.lf2,text="导出数据",command=beifen,width=15).pack(side="bottom",expand=0,padx=5,pady=2,)    def totale(self):        cur = self.con.cursor()        for i, k in self.newlabelsdict.items():            lf21=tk.LabelFrame(self.lf2,text=i)            lf21.pack(side="top",fill="both",expand=1,pady=1)            table=self.creat_tree(lf21,k)            sqldoc="SELECT * FROM {} ".format(self.new_zh_col.get(i,None))            cur.execute(sqldoc)            datas=cur.fetchall()            self.tree_insert(table,datas)    def regret(self):        def eat():            self.con.rollback()            messagebox.showinfo("回到从前","女王大人，我们再次回到了从前")        tk.Label(self.lf2,text="女王陛下，该吃药了！！",font=("bold",30,),bg="Wheat").pack(side="top",expand=1,fill="x")        tk.Button(self.lf2,text="立即嗑药",command=eat,width=15).pack(side="bottom",expand=0,padx=5,pady=2,)                              if __name__ == "__main__":    if not os.path.exists("mydata"):        os.mkdir("mydata")    root  = tk.Tk()    # root.option_add("*Font", "微软雅黑")    root.iconbitmap('crown.ico')    root.title("女王的宝库")    # root.attributes("-alpha", 0.9)透明度设置，奈何女神不需要    root.geometry("{}x{}+{}+{}".format(root.winfo_screenwidth()//2,root.winfo_screenheight()//2,root.winfo_screenwidth()//4,root.winfo_screenheight()//4))    app=App(root)    app.mainloop()

关于Python如何实现简易信息分类存储软件问题的解答就分享到这里了，希望以上内容可以对大家有一定的帮助，如果你还有很多疑惑没有解开，可以关注行业资讯频道了解更多相关知识。