- 这个是我的一次课程设计，写了236行代码，都是最简单的函数和图形化界面。特别简单。
- 首先你应该确保你的SQL数据库可以在Pycham中连接成功。不会SQL连接的的可以去其他博客写看一看。
- 在Pycham中需要安装 Tkinter win32com.client 第三方库。
- 序言
- 界面截图展示
- 数据库展示
- 代码
- 序言：下面的代码是模块化的，拼起来就是一个完整的小系统。如果你不想自己拼或者拼起来有问题，可以私聊我。
- 我其实也是个小菜。
-
停车界面 def Menu1():root = tkinter.Tk(className='界面')root.title='界面'label = tkinter.Label(root, text="Hello Hello欢迎进入智能停车收费停车场", bg='yellow')root.geometry('300x300+260+160')label.pack()def click1():park()def click2():find()def click3():dispcust()def click5():root.destroy()ased()def click4():dis()def click6():sum()def click7():exit(0)button1 = tkinter.Button(root, text='1)停车', bg='blue', width=20, command=click1)button1.pack()button2 = tkinter.Button(root, text='2)查询', bg='blue', width=20, command=click2)button2.pack()button3 = tkinter.Button(root, text='3)显示', bg='blue', width=20, command=click3)button3.pack()button4 = tkinter.Button(root, text='4)帮助', bg='blue', width=20, command=click4)button4.pack()button5 = tkinter.Button(root, text='5)取车', bg='blue', width=20, command=click5)button5.pack()button6 = tkinter.Button(root, text='6)统计', bg='blue', width=20, command=click6)button6.pack()button7 = tkinter.Button(root, text='7)退出', bg='blue', width=20, command=click7)button7.pack()root.mainloop()def park(): #操作1 添加用户rt1 = tkinter.Tk(className='测试')rt1.geometry('380x200+650+150')t1 = Entry(rt1,show=None )t1.place(x=120, y=10)t2 = Label(rt1, text='车号:')t2.place(x=60, y=10)t3 = Entry(rt1, show=None)t3.place(x=120, y=60)t4 = Label(rt1, text='车主:')t4.place(x=60, y=60)t5 = Label(rt1, text='颜色:')t5.place(x=60, y=100)t6 = Entry(rt1, show=None)t6.place(x=120, y=100)def queding():v1 = t1.get()v2 = t3.get()v3 = t6.get()if v1=='' or v2=='' or v3=='':tkinter.messagebox.showinfo(title='添加失败',message="输入无效！！！")else:cn = win32com.client.Dispatch('ADODB.Connection')cnstr = 'Provider = SQLOLEDB.1;Integrated Security = SSPI;Data Source=DESKTOP-KHP9P0M'cn.Open(cnstr, 'sa', 'sa')cn.DefaultDatabase = 'sst'cn.Execute("USE sst")cn.Execute("INSERT INTO sst1 VALUES('%s','%s','%s')" % (v1, v2, v3))tkinter.messagebox.showinfo(title='添加成功', message="%s用户停车成功！" % v1)rt1.destroy()def quxiao():rt1.destroy()bt1 = Button(rt1, text='确认', width=10, height=1, command=queding)bt1.place(x=80,y=140)bt2 = Button(rt1, text='取消', width=10, height=1,command=quxiao)bt2.place(x=160, y=140)rt1.mainloop()
-
-
-
-
def find(): #查询函数rt1 = tkinter.Tk(className='查询界面')rt1.geometry('380x240+580+250')lb=Label()t2 = Label(rt1, text='车号:')t2.place(x=60, y=10)t1 = Entry(rt1, show=None)t1.place(x=100, y=10)def queding1():global manfratno = t1.get()if tno=='':tkinter.messagebox.showinfo(title='查询成功', message="请重新输入" )else:cn = win32com.client.Dispatch('ADODB.Connection')cnstr = 'Provider = SQLOLEDB.1;Integrated Security = SSPI;Data Source=DESKTOP-KHP9P0M'cn.Open(cnstr, 'sa', 'sa')cn.DefaultDatabase = 'sst'cn.Execute("USE sst")rs = win32com.client.Dispatch('ADODB.RecordSet')rs.Open('sst1', cn)i=1if not rs.EOF:while not rs.EOF:if (rs.Fields(0).Value).strip() == tno:s1 = rs.Fields(0).Values2 = rs.Fields(1).Values3 = rs.Fields(2).Valuet3 = Label(rt1, text='车号:')t3.place(x=60, y=120)t4 = Entry(rt1, show=None)t4.insert(INSERT, s1)t4.place(x=100, y=120)t5 = Label(rt1, text='车主:')t5.place(x=60, y=140)t6 = Entry(rt1, show=None)t6.insert(INSERT, s2)t6.place(x=100, y=140)t7 = Label(rt1, text='颜色:')t7.place(x=60, y=160)t8 = Entry(rt1, show=None)t8.insert(INSERT, s3)i=2t8.place(x=100, y=160)t9 = Label(rt1, text='查询结果:', font=('微软雅黑', 15, 'bold'))t9.place(x=60, y=80)rs.MoveNext()else:tkinter.messagebox.showinfo(title='查询失败', message="该车库无%s车号信息"%tno)if i==1:tkinter.messagebox.showinfo(title='查询失败', message="该车库无%s车号信息"%tno)def ass():rt1.destroy()bt1 = Button(rt1, text='确认', width=10, height=1, command=queding1)bt1.place(x=80, y=200)bt2 = Button(rt1, text='取消', width=10, height=1, command=ass)bt2.place(x=200, y=200)rt1.mainloop()
-
def dispcust(): #显示客户cn = win32com.client.Dispatch('ADODB.Connection')cnstr = 'Provider = SQLOLEDB.1;Integrated Security = SSPI;Data Source=DESKTOP-KHP9P0M'cn.Open(cnstr, 'sa', 'sa')cn.DefaultDatabase = 'sst'cn.Execute("USE sst")rt8=Tk(className='显示客户')tr2 = Label(rt8, text='车号信息:',font=('微软雅黑', 15, 'bold'))tr2.place(x=10, y=10)rt8.geometry('300x300+600+200')text1=Text(rt8,width=30,height=15)text1.place(x=10,y=80)tr3 = Label(rt8, text='车号')tr3.place(x=10, y=50)tr4 = Label(rt8, text='车主')tr4.place(x=86, y=50)tr5 = Label(rt8, text='颜色')tr5.place(x=150, y=50)rs=win32com.client.Dispatch('ADODB.RecordSet')rs.Open('sst1',cn)if not rs.EOF:#text1.insert(INSERT,'车号 \t车主 \t颜色 ')while not rs.EOF:text1.insert(INSERT,rs.Fields(0).Value)text1.insert(INSERT,rs.Fields(1).Value)text1.insert(INSERT,rs.Fields(2).Value)rs.MoveNext()else:tkinter.messagebox.showinfo(title='车库', message="车库空空如也！！！！")rt8.mainloop()
-
-
-
def ased():rt6 = Tk()rt6.geometry('600x400+400+200')rt6.title('出车界面')rt6.iconbitmap('pro.ico')idat = PhotoImage(file='Prou.gif', width=850, height=450)lab1 = Label(image=idat)lab1.place(x=0, y=0)def as1():v6 = t3.get()cn = win32com.client.Dispatch('ADODB.Connection')cnstr = 'Provider = SQLOLEDB.1;Integrated Security = SSPI;Data Source=DESKTOP-KHP9P0M'cn.Open(cnstr, 'sa', 'sa')cn.DefaultDatabase = 'sst'cn.Execute("USE sst")cn.Execute("delete from sst1 where cno=%s" % v6)tkinter.messagebox.showinfo(title='出车', message="%s用户出车成功！\n 您需要支付3元的停车费" % v6)def as2():rt6.destroy()Menu1()def as3():def as4():rt7.destroy()rt7 = Tk('5x5+200+200')rt7.title('支付界面')bt1 = Button(rt7, text='完成支付', width=10, height=1,command=as4)bt1.place(x=10, y=20)lab3 = Label(text='请扫描下方二维码完成支付')lab3.pack()idat1 = PhotoImage(file='Prou1.png', width=420, height=318)lab3 = Label(image=idat1)lab3.place(x=0, y=0)rt7.mainloop()bt1 = Button(rt6, text='确认', width=10, height=1, command=as1)bt1.place(x=430, y=200)bt2 = Button(rt6, text='取消', width=10, height=1, command=as2)bt2.place(x=510, y=200)bt3 = Button(rt6, text='扫码支付', width=20, height=1, command=as3)bt3.place(x=430, y=260)t2 = Label(rt6, text='请输入您的车号:')t2.place(x=430, y=120)t2 = Label(rt6, text='车号:')t2.place(x=430, y=160)t3 = Entry(rt6, show=None,width=15)t3.place(x=460, y=160)label = Label(rt6, text="期待您的下次光临！！！！", bg='blue', width=85, height=3)label.place(x=0, y=350)manfra = LabelFrame()manfra.pack()rt6.mainloop()
-
def sum():cn = win32com.client.Dispatch('ADODB.Connection')cnstr = 'Provider = SQLOLEDB.1;Integrated Security = SSPI;Data Source=DESKTOP-KHP9P0M'cn.Open(cnstr, 'sa', 'sa')cn.DefaultDatabase = 'sst'cn.Execute("USE sst")rs = win32com.client.Dispatch('ADODB.RecordSet')rs.Open('sst1', cn)s=0while not rs.EOF:s=s+1rs.MoveNext()rs.Close()tkinter.messagebox.showinfo(title='统计信息', message="停车车场共有%d辆车！" %s)
-
def dis(): #帮助信息tkinter.messagebox.showinfo(title='帮助',message='这么简单的界面要什么帮助！\n是不是不想掏钱！\n 想跑！！！\n门都没有')数据库展示，这里只用了数据库的一张表，比较简单。如果想要多表操作，你可以修改上面的SQL语句，然后在调用模块函数。
-
