主要有以下几个文件，简单说明一下
1.db.py 处理sql 逻辑
2.login.py 作登录使用（现在还没有实现连接数据库，只是为了功能实现）
3.stjy.py 主体窗口
4.test.db数据文件（使用sqlite3）
#db.py 主要代码，第一次执行时，把 “# create_table()”中的#去掉，执行完后，在加上
import sqlite3
def 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 res
def 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 res
def 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.py
from 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 tkt
from tkinter import *
from tkinter import Tk, Scrollbar, Frame,ttk
import tkinter
from tkinter.ttk import Treeview
import time
import db as sql
from tkinter import messagebox
MENU_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('<Button-1>', 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("<<ComboboxSelected>>")
fenxiao=cbl_fx.get()
cbl_km.bind("<<ComboboxSelected>>")
kemu=cbl_km.get()
comboxlist.bind("<<ComboboxSelected>>")
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():
pass
def 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, '')
#设置窗口title
set_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()
2555
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
