共享单车管理系统（新手摸索）

day1
pt1 主要页面编写进行中

import tkinter
from tkinter import *
from denglu import db1
import pymysql
import time
#来自 teamlycjzyhjh
db = pymysql.connect(host='localhost',user='root',password='123',database='zhihuidanche')
cusor = db.cursor()
#创建初始页面
from tkinter import messagebox

window_01=Tk()
window_01.geometry('600x600+500+100')
window_01.title('智慧单车')
title01 = Label(window_01,text='您好，欢迎来到智慧单车')
title01.pack()

#创建一个按钮
button01=Button(window_01)
button01['text'] = '感谢您的支持'
button01.pack()
def dednglu01(e):
    messagebox.showinfo('messege','WELCOME')
button01.bind('<Button-1>',dednglu01)

#布局整个页面的按钮以及用处
userids = StringVar()
password = StringVar()
pagezhu = Frame(window_01)
pagezhu.pack()
Label(pagezhu).grid(row=4,column=4)
Label(pagezhu,text='账户(ID)').grid(row=5,column=6)
Entry(pagezhu,textvariable=userids).grid(row=5,column=7)
Label(pagezhu,text='密码(PW)').grid(row=5,column=9)
Entry(pagezhu,textvariable=password).grid(row=5,column=10)
Label(pagezhu).grid(row=6,column=6)


#定义一个登陆的程序以及页面，也可以在后台收到提示
def loginsucc():
    userid = userids.get()
    passwords = password.get()
    mesage=db1.check_login(userid,passwords)
    print(mesage)
    if mesage == 1:
        print('该用户登陆成功')
        def zuche():
            bikeid = Variable()
            windowzuche = Tk()
            window_03.geometry('600x600+500+100')
            pagezhuche = Frame(window_03)
            pagezhuche.pack()
            Label(pagezhuche).grid(row=4, column=4)
            Label(pagezhuche, text='请输入你所需要的车辆编号').grid(row=5, column=6)
            Entry(pagezhuche, textvariable=bikeid).grid(row=5, column=7)
            buttonzuche = Button(window_03)
            buttonzuche['text'] = '确定租车'
            buttonzuche.pack()
            def zuche01(e):
                bid = bikeid.get()#接收我们输入的bikeid到该方法中
                sql = 'update bike set bikecondition = 1 where bikeid == bid'
                cusor.execute(sql)#更改状态，0代表未使用，现在改为1.则该车可在可使用查询车的界面被删除

                #更改被租用的车的信息，更新
            buttonzuche.bind('<Button-1>', zuche01)
        window_03 = Tk()
        window_03.geometry('600x600+500+100')
        window_03.title('欢迎您的使用')
        menu1 = Menu(window_03, tearoff=0)
        menu1.add_command(label="租车",command=zuche)
        menu1.add_separator()
        menu1.add_command(label="还车")
        menu1.add_separator()
        menu1.add_command(label="投诉与反馈")
        menu1.add_separator()
        menu1.add_command(label="关于我们")
        mebubar = Menu(window_03)
        mebubar.add_command(label="你好")
        mebubar.add_cascade(label="功能", menu=menu1)  # 原理：先在主菜单中添加一个菜单，与之前创建的菜单进行绑定。
        mebubar.add_command(label="退出", command=window_03.quit)
        window_03.config(menu=mebubar)
        window_03.mainloop()
    else:
        messagebox.showinfo('请检查账号和密码','用户不存在或者账号密码错误')




#定义一个找回密码的函数，用于执行操作
def findpassword():

    window_02 = Tk()
    window_02.geometry('600x600+500+100')
    window_02.title('找回密码')
    title01 = Label(window_02, text='您好，请输入其他验证信息')
    title01.pack()
    username = StringVar()
    phonenumber = StringVar()
    pagezhaohui = Frame(window_02)
    pagezhaohui.pack()
    Label(pagezhaohui).grid(row=4, column=4)
    Label(pagezhaohui, text='账户(ID)').grid(row=5, column=6)
    Entry(pagezhaohui, textvariable=username).grid(row=5, column=7)
    Label(pagezhaohui, text='手机(ph)').grid(row=5, column=9)
    Entry(pagezhaohui, textvariable=phonenumber).grid(row=5, column=10)
    Label(pagezhaohui).grid(row=6, column=6)

    def zhaohui(e):
        flag = 0
        list1 = 'select * from yonghu'
        cusor.execute(list1)
        alluserlist = cusor.fetchall()
        print(alluserlist)
        name1 = username.get()
        phn1 = phonenumber.get()
        paswlist = []
        a = len(alluserlist)
        listname = []
        listphn = []
        for i in alluserlist:
            listname.append(i[-1])
            listphn.append(i[0])
            paswlist.append(i[1])
        if name1 in listname and phn1 in listphn:
            messagebox.showinfo('您的密码', paswlist[phn1.index(phn1)])
        else:
            messagebox.showinfo('请您注册', '请您先注册！')

    button02 = Button(window_02)
    button02['text'] = '找回'
    button02.pack()
    button02.bind('<Button-1>', zhaohui)
    window_02.mainloop()



Button(pagezhu,text='注册').grid(row=7,column=6)
Button(pagezhu,text='登录',command=loginsucc).grid(row=7,column=7)
Button(pagezhu,text='忘记密码',command=findpassword).grid(row=7,column=9)
Button(pagezhu,text='退出',command=pagezhu.quit).grid(row=7,column=10)
window_01.mainloop()#生成运营管理页面

pt2 denglu页面

from tkinter import *
from tkinter import messagebox
import pymysql
db = pymysql.connect(host='localhost',user='root',password='123',database='zhihuidanche')
cusor = db.cursor()

class mysqldabase:
    def __init__(self):
        findid = 'select * from yonghu'
        cusor.execute(findid)
        alluser = cusor.fetchall()
        self.users = alluser
        findadmin = 'select * from admin'
        cusor.execute(findid)
        allad = cusor.fetchall()
        self.admin = allad
        self.flag = 0
    def check_login(self,userid,passwords):
        for user in self.users:
            if userid == user[-2]:
                if passwords == user[-3]:
                    messagebox.showinfo('用户登陆成功')
                    flag = 1
                    break
                else:
                    messagebox.showinfo('密码错误')
                    flag = 2
            else:
                flag = 3

        return flag



db1 = mysqldabase()
if __name__ == '__main__':
   print(db1.check_login('101133334','1'))

pt3 找回密码部分`

from tkinter import *
from tkinter import messagebox
import pymysql
db = pymysql.connect(host='localhost',user='root',password='123',database='zhihuidanche')
cusor = db.cursor()
window_02 = Tk()
window_02.geometry('600x600+500+100')
window_02.title('找回密码')
title01 = Label(window_02, text='您好，请输入其他验证信息')
title01.pack()
username = StringVar()
phonenumber = StringVar()
pagezhaohui = Frame(window_02)
pagezhaohui.pack()
Label(pagezhaohui).grid(row=4, column=4)
Label(pagezhaohui, text='账户(ID)').grid(row=5, column=6)
Entry(pagezhaohui, textvariable=username).grid(row=5, column=7)
Label(pagezhaohui, text='手机(ph)').grid(row=5, column=9)
Entry(pagezhaohui, textvariable=phonenumber).grid(row=5, column=10)
Label(pagezhaohui).grid(row=6, column=6)
def zhaohui(e):
    flag = 0
    list1 = 'select * from yonghu'
    cusor.execute(list1)
    alluserlist = cusor.fetchall()
    print(alluserlist)
    name1 = username.get()
    phn1 = phonenumber.get()
    paswlist = []
    a=len(alluserlist)
    listname = []
    listphn = []
    for i in alluserlist:
        listname.append(i[-1])
        listphn.append(i[0])
        paswlist.append(i[1])
    if name1 in listname  and phn1 in listphn:
        messagebox.showinfo('您的密码',paswlist[phn1.index(phn1)])
    else:
        messagebox.showinfo('请您注册','请您先注册！')
button01 = Button(window_02)
button01['text'] = '找回'
button01.pack()
button01.bind('<Button-1>',zhaohui)
window_02.mainloop()