主要有以下几个文件，简单说明一下
1.db.py 处理sql 逻辑
2.login.py 作登录使用（现在还没有实现连接数据库，只是为了功能实现）
3.stjy.py 主体窗口
4.数据文件（sqlite3）
#db.py 主要代码，第一次执行时，把 “# create_table()”中的#去掉，执行完后，在加上import sqlite3def create_table(): conn = sqlite3.connect('test.db') cur=conn.cursor() # cur=conn.cursor() try: create_tb_cmd=''' CREATE TABLE IF NOT EXISTS student_info (id INTEGER PRIMARY KEY AUTOINCREMENT, name text, phone text, qq text, weixin text, prid_school text, cslt_course text, cslt_from text, dt text, provider text, note text ) ''' #create table # cur.execute(create_tb_cmd) cur.execute(create_tb_cmd) print('create table sucess') except Exception as e: print ("Create table failed" ) print(e) pass # return False conn.commit() cur.close() conn.close()def drop_table(): conn = sqlite3.connect('test.db') cur=conn.cursor() try: drop_cmd='''drop table student_info''' #create table cur.execute(create_tb_cmd) except: print ("drop table failed" ) pass # return False conn.commit() cur.close() conn.close() def select_data(): conn = sqlite3.connect('test.db') cur=conn.cursor() select_cmd=''' select * from student_info order by id desc''' cur.execute(select_cmd) res = cur.fetchall() conn.commit() cur.close() conn.close() return resdef edit_data(id): name_para={'id':id} conn = sqlite3.connect('test.db') cur=conn.cursor() select_cmd=''' select * from student_info where id=:id''' cur.execute(select_cmd,name_para) res = cur.fetchall() conn.commit() cur.close() conn.close() return resdef insert_data(name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note): name_para={'name':name,'phone':phone,'qq':qq,'weixin':weixin,'prid_school':prid_school,\ 'cslt_course':cslt_course,'cslt_from':cslt_from,'dt':dt,'provider':provider,'note':note} conn = sqlite3.connect('test.db') cur=conn.cursor() insert_dt_cmd=''' INSERT INTO student_info (name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note) VALUES (:name,:phone,:qq,:weixin,:prid_school,:cslt_course,:cslt_from,:dt,:provider,:note) ''' print(insert_dt_cmd) cur.execute(insert_dt_cmd,name_para) conn.commit() cur.close() conn.close()def delete_data(sdt_id,name): name_para={'sdt_id':sdt_id,'name':name} conn = sqlite3.connect('test.db') cur=conn.cursor() # cur=conn.cursor() del_cmd=''' delete from student_info where id=:sdt_id and name=:name ''' cur.execute(del_cmd,name_para) conn.commit() cur.close() conn.close()def update_data(std_id,name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note): name_para={'name':name,'phone':phone,'qq':qq,'weixin':weixin,'prid_school':prid_school, 'cslt_course':cslt_course,'cslt_from':cslt_from,'dt':dt,'provider':provider, 'note':note,'std_id':std_id } print(name_para) conn = sqlite3.connect('test.db') cur=conn.cursor() update_cmd=''' update student_info set name=:name,phone=:phone,qq=:qq, weixin=:weixin,prid_school=:prid_school, cslt_course=:cslt_course,cslt_from=:cslt_from,dt=:dt, provider=:provider,note=:note where id=:std_id ''' print(update_cmd) cur.execute(update_cmd,name_para) conn.commit() cur.close() conn.close()# drop_table()# create_table()# name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note# insert_data('jonsen3','15920056968','794554422','weixin','shenzhen_school','english','shanghai','2018-03-30','tom','note')# rs=select_data() # std = []# for idt,name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note in rs:# # print(idt,name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note)# std.append((idt,name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note))# # print(std)# for i in range(len(rs)):# print(std[i][0],std[i][1],std[i][2],std[i][3],std[i][4],std[i][5],std[i][6],std[i][7],std[i][8],std[i][9],std[i][10]) # pritn(dt)# print(rs)#login.pyfrom tkinter import * class Reg (Frame): def __init__(self,master): frame = Frame(master) frame.pack() self.lab1 = Label(frame,text = "账户:") self.lab1.grid(row = 0,column = 0,sticky = W) self.ent1 = Entry(frame) self.ent1.grid(row = 0,column = 1,sticky = W) self.lab2 = Label(frame,text = "密码:") self.lab2.grid(row = 1,column = 0) self.ent2 = Entry(frame,show = "*") self.ent2.grid(row = 1,column = 1,sticky = W) self.button = Button(frame,text = "登录",command = self.Submit) self.button.grid(row = 2,column = 1,sticky = W) self.lab3 = Label(frame,text = "") self.lab3.grid(row = 3,column = 1,sticky = W) self.button2 = Button(frame,text = "退出",command = frame.quit) self.button2.grid(row = 2,column = 1,sticky = E) def Submit(self): s1 = self.ent1.get() s2 = self.ent2.get() if s1 == 'admin' and s2 == '123': self.lab3["text"] = "登陆成功" root.destroy() import stjy as mf elif((s1.strip()=="" and s2.strip()==""))or ((s1.strip()=="" and s2.strip()=="")): self.lab3["text"] ="用户名或密码不能为空" else: self.lab3["text"] = "用户名或密码错误!" self.ent1.delete(0,len(s1)) self.ent2.delete(0,len(s2)) root = Tk() root.title("用户登录") app = Reg(root) root.mainloop() #stjy.py# import tkinter as tktfrom tkinter import *from tkinter import Tk, Scrollbar, Frame,ttkimport tkinterfrom tkinter.ttk import Treeviewimport timeimport db as sqlfrom tkinter import messageboxMENU_ITEMS = [ '常用', '帮助']MENU_CY_ITEMS = ['查看','录入','编辑','导出数据','exit']MENU_HELP_ITEMS=['about','help']def select_action(): frame=Frame(root) frame.place(x=0, y=10) # frame.grid(row=0,column=0) #滚动条 scrollBar = tkinter.Scrollbar(frame) scrollBar.pack(side=tkinter.RIGHT, fill=tkinter.Y) # scrollBar.grid(row=0,column=1) scrollBar_sp=tkinter.Scrollbar(frame,orient='horizontal') # scrollBar_sp.pack(side=tkinter.RIGHT,fill=tkinter.X) #Treeview组件，11列，显示表头，带垂直滚动条 tree = Treeview(frame,height=500, columns=('c1', 'c2', 'c3', 'c4', 'c5', 'c6','c7','c8','c9','c10','c11'), show="headings", yscrollcommand=scrollBar.set, # xscrollcommand=scrollBar_sp.set ) #设置每列宽度和对齐方式 tree.column('c1', width=20, anchor='center') tree.column('c2', width=100, anchor='center') tree.column('c3', width=100, anchor='center') tree.column('c4', width=120, anchor='center') tree.column('c5', width=100, anchor='center') tree.column('c6', width=100, anchor='center') tree.column('c7', width=100, anchor='center') tree.column('c8', width=100, anchor='center') tree.column('c9', width=100, anchor='center') tree.column('c10', width=100, anchor='center') tree.column('c11', width=100, anchor='center') #设置每列表头标题文本 tree.heading('c1',text='序号') tree.heading('c2', text='姓名') tree.heading('c3', text='手机号') tree.heading('c4', text='QQ') tree.heading('c5', text='微信') tree.heading('c6', text='提供分校') tree.heading('c7', text='咨询科目') tree.heading('c8',text='咨询来自') tree.heading('c9',text='提供日期') tree.heading('c10',text='提供人') tree.heading('c11',text='备注') tree.pack(side=tkinter.LEFT, fill=tkinter.Y) def treeviewClick(event): #获取行的索引值 iid=tree.identify_row(event.y) xy=tree.identify_element(event.x,event.y) s=tree.selection() # print(iid,xy ) print(s) pass tree.bind('', treeviewClick) #插入数据 res=sql.select_data() #for i in range(len(PrinterPywin32.get_enumjobs())): # self.tree.insert("", "end", values=(i + 1, PrinterPywin32.get_enumjobs()[i]["Submitted"], # PrinterPywin32.get_enumjobs()[i]["pPrinterName"], # PrinterPywin32.get_enumjobs()[i]["JobId"], # PrinterPywin32.get_enumjobs()[i]["Status"])) # for i in range(len(res)): # tree.insert('', i, values=[str(i)]*11) std=[] for idt,name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note in res: std.append((idt,name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note)) for i in range(len(res)): tree.insert("",i,values=(std[i][0],std[i][1],std[i][2],std[i][3],std[i][4],std[i][5],std[i][6],std[i][7],std[i][8],std[i][9],std[i][10])) def insert_action(): def save_student(): #name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note) user_name=ent_name.get() phone=ent_phone.get() qq=ent_qq.get() weixin=ent_weixin.get() cbl_fx.bind("<>") fenxiao=cbl_fx.get() cbl_km.bind("<>") kemu=cbl_km.get() comboxlist.bind("<>") laizi=comboxlist.get() riqi=ent_dt.get() provider=ent_pr.get() beizhu=tx.get() try: sql.insert_data(user_name,phone,qq,weixin,fenxiao,kemu,laizi,riqi,provider,beizhu) messagebox.showinfo("info","保存成功") except: print("写入数据失败") def cancel_student(): pass ins_dat=Tk() # ins_dat.geometry(400*400) # ins_dat.geometry('400*400') # ins_dat=Frame(ins_dat) # ins_dat.place(x=0, y=10) ins_dat.title('数据录入') #(ins_dat, '数据录入') # ins_dat.pack() #'姓名','手机号','QQ','微信', '提供分校', '咨询科目','咨询来自','提供日期', '提供人', '备注' lab_name =Label(ins_dat,text='姓名:') lab_phone =Label(ins_dat,text='手机号:') lab_qq =Label(ins_dat,text='QQ:') lab_wexin =Label(ins_dat,text='微信:') lab_fx =Label(ins_dat,text='提供分校:') lab_km =Label(ins_dat,text='咨询科目:') lab_lz =Label(ins_dat,text='咨询来自:') lab_dt =Label(ins_dat,text='提供日期:') lab_pr =Label(ins_dat,text='提供人:') lab_nt =Label(ins_dat,text='备注:') ent_name = Entry(ins_dat) ent_phone=Entry(ins_dat) ent_qq=Entry(ins_dat) ent_weixin=Entry(ins_dat) # ent_fx=Entry(ins_dat) # ent_km=Entry(ins_dat) # ent_lz=Entry(ins_dat) comval_fx=tkinter.StringVar() cbl_fx=ttk.Combobox(ins_dat,textvariable=comval_fx) #初ymf始化 cbl_fx["values"]=("西乡校区","布吉校区","车公庙校区","白石洲校区") cbl_fx.current(0) com_val = tkinter.StringVar() cbl_km=ttk.Combobox(ins_dat,textvariable=com_val) #初始化 cbl_km["values"]=("提升学历","代办入户","会计考证","网络考试") cbl_km.current(0) comvalue = tkinter.StringVar() comboxlist=ttk.Combobox(ins_dat,textvariable=comvalue) #初始化 comboxlist["values"]=("官网后台","在线调查后台","移动官网后台","地铁广告","百度金融"\ ,"EC离线留言","离线宝","微信客服","PC网站-百度推广") comboxlist.current(0) #选择第一个 # now = time.strftime("%H:%M:%S") # now_val=StringVar() # now_val.set(now) ent_dt=Entry(ins_dat) ent_pr=Entry(ins_dat) # ent_nt=Entry(ins_dat) tx=Entry(ins_dat) # tx=tkinter.Text(ins_dat,height=5) btn = Button(ins_dat,text = '保存',command = save_student) btn2 = Button(ins_dat,text = '取消',command = cancel_student) lab_name.grid(row = 0,column = 0,sticky =W) lab_phone.grid(row = 1,column = 0,sticky = W) lab_qq.grid(row = 2,column = 0,sticky = W) lab_wexin.grid(row = 3,column = 0,sticky = W) lab_fx.grid(row = 4,column = 0,sticky = W) lab_km.grid(row = 5,column = 0,sticky = W) lab_lz.grid(row = 6,column = 0,sticky = W) lab_dt.grid(row = 7,column = 0,sticky = W) lab_pr.grid(row = 8,column = 0,sticky = W) lab_nt.grid(row = 9,column = 0,sticky = W) ent_name.grid(row = 0,column = 1,sticky = W) ent_phone.grid(row = 1,column = 1,sticky = W) ent_qq.grid(row = 2,column =1 ,sticky = W) ent_weixin.grid(row =3 ,column = 1,sticky = W) # ent_fx.grid(row =4 ,column = 1,sticky = W) cbl_fx.grid(row=4,column=1,sticky=W) # ent_km.grid(row =5 ,column = 1,sticky = W) cbl_km.grid(row =5 ,column = 1,sticky = W) # ent_lz.grid(row =6 ,column = 1,sticky = W) comboxlist.grid(row=6,column=1,sticky=W) ent_dt.grid(row =7 ,column = 1,sticky = W) ent_pr.grid(row =8 ,column = 1,sticky = W) # ent_nt.grid(row =9 ,column = 1,sticky = W) tx.grid(row =9 ,column = 1,sticky = W) btn.grid(row =10,column = 1,sticky = W) btn2.grid(row =10,column = 2,sticky = W) ins_dat.mainloop()def delete_action(): passdef edit_action(): def edit_fd_info(): std_id=ent_id.get() res=sql.edit_data(std_id) for idt,name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note in res: ent_name_ed.insert(0,name) ent_phone_ed.insert(0,phone) ent_qq_ed.insert(0,qq) ent_weixin_ed.insert(0,weixin) ent_fx_ed.insert(0,prid_school) ent_km_ed.insert(0,cslt_course) ent_lz_ed.insert(0,cslt_from) ent_pr_ed.insert(0,provider) ent_dt_ed.insert(0,dt) ent_nt_ed.insert(0,note) # sql.update_data(id,name,phone,qq,weixin,prid_school,cslt_course,cslt_from,dt,provider,note) print(name,phone,weixin) # print(res) def save_info(): std_id=ent_id.get() uname=ent_name_ed.get() uphone=ent_phone_ed.get() uqq=ent_qq_ed.get() uweixin=ent_weixin_ed.get() ufx=ent_fx_ed.get() ukm=ent_km_ed.get() ulz=ent_lz_ed.get() upr=ent_pr_ed.get() udt=ent_dt_ed.get() ued=ent_nt_ed.get() if(uname and uphone): try: sql.update_data(std_id,uname,uphone,uqq,uweixin,ufx,ukm,ulz,udt,upr,ued) messagebox.showinfo("info","保存成功") except: messagebox.showerror("info","保存失败") pass print(uname,udt) def del_info(): std_id=ent_id.get() uname=ent_name_ed.get() if(uname and std_id): try: sql.delete_data(std_id,uname) messagebox.showinfo('infor','删除成功') except Exception as e: messagebox.showerror('info',e) pass edit_dat=Tk() edit_dat.title("信息维护") # edit_dat.geometry('','300*400') lab_id=Label(edit_dat,text='请输入编辑ID:') ent_id=Entry(edit_dat) btn_fd=Button(edit_dat,text='查询',command=edit_fd_info) lab_id.grid(row = 0,column = 0,sticky = W) ent_id.grid(row = 0,column = 1,sticky = W) btn_fd.grid(row = 0,column = 2,sticky = W) # vl_name=StringVar() lab_name =Label(edit_dat,text='姓名:') ent_name_ed=Entry(edit_dat,textvariable=edit_fd_info ) lab_name.grid(row = 2,column = 0,sticky = W) ent_name_ed.grid(row = 2,column = 1,sticky = W) # vl_phone=StringVar() lab_phone =Label(edit_dat,text='手机号:') ent_phone_ed=Entry(edit_dat,textvariable=edit_fd_info) lab_phone.grid(row = 3,column = 0,sticky = W) ent_phone_ed.grid(row = 3,column = 1,sticky = W) lab_qq_ed =Label(edit_dat,text='QQ:') ent_qq_ed=Entry(edit_dat,textvariable=edit_fd_info) lab_qq_ed.grid(row = 4,column = 0,sticky = W) ent_qq_ed.grid(row = 4,column = 1,sticky = W) lab_wexin_ed =Label(edit_dat,text='微信:') ent_weixin_ed=Entry(edit_dat,textvariable=edit_fd_info) lab_wexin_ed.grid(row = 5,column = 0,sticky = W) ent_weixin_ed.grid(row = 5,column = 1,sticky = W) # lab_fx_ed =Label(edit_dat,text='提供分校:') # ent_fx_ed=Entry(edit_dat) # lab_fx_ed.grid(row=11,column=0,sticky=W) # ent_fx_ed.grid(row=11,column=1,sticky=W) lab_fx_ed =Label(edit_dat,text='提供分校:') ent_fx_ed=Entry(edit_dat,textvariable=edit_fd_info) lab_fx_ed.grid(row = 6,column = 0,sticky = W) ent_fx_ed.grid(row = 6,column = 1,sticky = W) lab_km_ed =Label(edit_dat,text='咨询科目:') ent_km_ed=Entry(edit_dat,textvariable=edit_fd_info) lab_km_ed.grid(row = 7,column = 0,sticky = W) ent_km_ed.grid(row = 7,column = 1,sticky = W) lab_lz_ed =Label(edit_dat,text='咨询来自:') ent_lz_ed=Entry(edit_dat,textvariable=edit_fd_info) lab_lz_ed.grid(row = 8,column = 0,sticky = W) ent_lz_ed.grid(row = 8,column = 1,sticky = W) lab_dt_ed =Label(edit_dat,text='提供日期:') ent_dt_ed=Entry(edit_dat,textvariable=edit_fd_info) lab_dt_ed.grid(row = 9,column = 0,sticky = W) ent_dt_ed.grid(row = 9,column = 1,sticky = W) lab_pr_ed =Label(edit_dat,text='提供人:') ent_pr_ed=Entry(edit_dat,textvariable=edit_fd_info) lab_pr_ed.grid(row = 10,column= 0,sticky = W) ent_pr_ed.grid(row = 10,column = 1,sticky = W) lab_nt_ed =Label(edit_dat,text='备注:') ent_nt_ed=Entry(edit_dat,textvariable=edit_fd_info) lab_nt_ed.grid(row = 12,column = 0,sticky = W) ent_nt_ed.grid(row = 12,column = 1,sticky = W) btn_sv=Button(edit_dat,text='保存',command=save_info) btn_sv.grid(row=13,column=0) btn_del=Button(edit_dat,text='删除',command=del_info) btn_del.grid(row=13,column=1,sticky=W) edit_dat.mainloop() pass def export_data(): def exp_dt(): import pandas as pd # import openpyxl path=ent_path.get() # file_name=path+"abc.csv" rs=pd.DataFrame(res,columns=('id','姓名','手机号','QQ','微信','提供分校','咨询科目',\ '咨询来自','提供日期','提供人','备注')) rs.to_csv(path,index=True,header=True) # print(rs) # print(file_name) # xlsx_file=pd.ExcelFile(file_name) # x1=xlsx_file.parse(0) # pd.DataFrame(res).to_excel("abc.xlsx",sheet_name="123",index=False,header=True) exp_dat=Tk() exp_dat.title("导出数据") lab_path=Label(exp_dat,text='请输入导出路径:') ent_path=Entry(exp_dat) btn_exp=Button(exp_dat,text='导出',command=exp_dt) lab_path.grid(row=0,column=0,sticky=W) ent_path.grid(row=0,column=1,sticky=W) btn_exp.grid(row=1,column=1,sticky=W) res=sql.select_data() def get_tk(): '''获取一个Tk对象''' return Tk()def set_tk_title(tk, title): '''给窗口定义title''' if title is not None and title != '': tk.title(title) else: tk.title('xxx管理系统 v1.0')def set_tk_geometry(tk, size): '''设置窗口大小，size的格式为：width x height,如：size = '200x100'.''' if size is not None and size != '': tk.geometry(size) else: tk.geometry('1024x600') # tk.resizable(width=True,height=True) # 宽不可变 高可变 默认True def get_menu(tk): '''获取一个菜单条''' return Menu(tk) def menu_cy(menubar): '''定义菜单 常用''' #MENU_CY_ITEMS = ['查看','录入','编辑','删除','exit'] cymenu = Menu(menubar, tearoff=1) cymenu.add_command(label=MENU_CY_ITEMS[0],command=select_action) cymenu.add_command(label=MENU_CY_ITEMS[1],command=insert_action) cymenu.add_command(label=MENU_CY_ITEMS[2],command=edit_action) cymenu.add_command(label=MENU_CY_ITEMS[3],command=export_data) cymenu.add_separator() cymenu.add_command(label=MENU_CY_ITEMS[4],command=root.destroy) menubar.add_cascade(label=MENU_ITEMS[0], menu=cymenu)def meun_help(menber): '''定义菜单Help''' help_menu = Menu(menubar, tearoff=1) help_menu.add_command(label=MENU_HELP_ITEMS[0]) help_menu.add_command(label=MENU_HELP_ITEMS[1]) menubar.add_cascade(label=MENU_ITEMS[1], menu=help_menu) def init_menu_bar(menubar): '''初始化菜单条''' menu_cy(menubar) #常用 meun_help(menubar) #help # menubar.add_cascade(label=MENU_ITEMS[-1], menu=meun_help) #获得窗口对象root = get_tk()#设置窗口大小set_tk_geometry(root, '')#设置窗口titleset_tk_title(root, 'XXXXX信息管理系统v.1.0')#获取菜单对象menubar = get_menu(root)#初始化菜单init_menu_bar(menubar)#加载菜单配置root.config(menu=menubar)# root.iconbitmap('D:\\Users\he_zh\\PycharmProjects\\stjx\\logo.bmp')mainloop()# mainloop() # def main():# #获得窗口对象# root = get_tk()# #设置窗口大小# set_tk_geometry(root, '')# #设置窗口title# set_tk_title(root, 'Python 3.3.2 Shell')# #获取菜单对象# menubar = get_menu(root)# #初始化菜# init_menu_bar(menubar)# #加载菜单配置# root.config(menu=menubar)# mainloop() # if __name__ == "__main__":# main()
分享到:
閱讀更多 燈塔大數據 的文章
