基于Python+MySQL的飞机大战游戏包含用户登录
2021/11/16 19:11:50
本文主要是介绍基于Python+MySQL的飞机大战游戏包含用户登录，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！
文章目录
- 前言
- 一、创建数据库
- 二、项目运行结果
- 二、新建python项目
- 1.项目结构
- 2.新建Login.py
- 总结
前言
提示：这里可以添加本文要记录的大概内容：
例如：随着人工智能的不断发展，机器学习这门技术也越来越重要，很多人都开启了学习机器学习，本文就介绍了机器学习的基础内容。
一、创建数据库
用Navicat创建如图所示数据库
二、新建python项目
1.项目结构
2.新建Login.py
Login.py
# -*- coding: UTF-8 -*-
"""
@author:林枫
@file:3.py
@time:2021/06/07
"""
import pymysql
from tkinter import *
from tkinter import messagebox
from tkinter import ttk
from tkinter.messagebox import *
from game import *
import pygame
class My_Gui():
def __init__(self, main_screen):
self.main_screen = main_screen
def set_init_window(self):
self.main_screen.geometry("1442x700")
self.main_screen.title("登陆界面")
self.bg = PhotoImage(file='background.png')
Label(image=self.bg).place(x=0, y=0)
Label(text="欢迎登录飞机大战游戏", font=("宋体", 20)).place(x=580, y=100)
Label(text="账号", font=("宋体", 15)).place(x=450, y=250)
Label(text="密码", font=("宋体", 15)).place(x=450, y=350)
self.username_verify = StringVar()
self.password_verify = StringVar()
self.username_login_entry = Entry(self.main_screen, textvariable=self.username_verify, width=45,
font=("宋体", 15))
self.username_login_entry.place(x=500, y=250)
self.password_login_entry = Entry(self.main_screen, textvariable=self.password_verify, show='*', width=45,
font=("宋体", 15))
self.password_login_entry.place(x=500, y=350)
Button(text="用户登录", width="10", font=("宋体", 15), command=self.login_verify).place(x=650, y=400)
Button(text="管理员登录", width="10", font=("宋体", 15), command=self.Admin_login_verify).place(x=450, y=400)
Button(text="用户注册", width="10", font=("宋体", 15), command=self.register).place(x=840, y=400)
self.main_screen.mainloop()
def login_verify(self):
self.username1 = self.username_verify.get()
self.password1 = self.password_verify.get()
conn = pymysql.connect(host='localhost', user='root', passwd='123456', db='testdb', port=3306,
charset='utf8')
cur = conn.cursor()
select_sql = "select pw from user WHERE un=%s"
cur.execute(select_sql, [self.username1])
result = cur.fetchone()
if len(self.username1) == 0:
messagebox.showinfo("错误", "请输入账号！")
cur.close()
conn.close()
elif result is None:
cur.close()
conn.close()
messagebox.showinfo("失败", "该账号未注册！")
self.password_login_entry.delete(0, END)
self.username_login_entry.delete(0, END)
else:
if result[0] == self.password1:
cur.close()
conn.close()
messagebox.showinfo("成功", "登录成功")
self.username_login_entry.delete(0, END)
self.password_login_entry.delete(0, END)
self.login_sucess()
elif result[0] != self.password1:
cur.close()
conn.close()
messagebox.showinfo("失败", "密码错误！")
self.password_login_entry.delete(0, END)
def login_sucess(self):
self.main_screen.destroy()
conn = pymysql.connect(host='localhost', user='root', passwd='123456', db='testdb', port=3306,
charset='utf8')
cur = conn.cursor()
select_sql = "select id from user WHERE un=%s"
cur.execute(select_sql, [self.username1])
i = cur.fetchone()[0]
select_sql = "select code, time from code_lable WHERE userid=%s"
cur.execute(select_sql, [i])
data = cur.fetchall()
data = list(data)
data = list(reversed(data))
print(data)
max_list = []
data_list = []
for x in data:
max_list.append(int(x[0]))
self.user_screen1 = Tk()
self.user_screen1.geometry("1442x700")
self.user_screen1.title("用户界面")
self.bg = PhotoImage(file='background.png')
Label(self.user_screen1, image=self.bg).place(x=0, y=0)
Label(self.user_screen1, text="亲爱的玩家：" + self.username1 + ' 你好', font=("宋体", 20)).place(x=565, y=30)
self.columns = ("序号", "得分", "时间", "序号1", "得分1", "时间1", "序号2", "得分2", "时间2")
self.tree = ttk.Treeview(self.user_screen1, height=20, show="headings", columns=self.columns) # 隐藏首列
self.tree.column("序号", width=60) # 表示列,不显示
self.tree.column("得分", width=170) # 表示列,不显示
self.tree.column("时间", width=170) # 表示列,不显示
self.tree.column("序号1", width=60) # 表示列,不显示
self.tree.column("得分1", width=170) # 表示列,不显示
self.tree.column("时间1", width=170) # 表示列,不显示
self.tree.column("序号2", width=60) # 表示列,不显示
self.tree.column("得分2", width=170) # 表示列,不显示
self.tree.column("时间2", width=170) # 表示列,不显示
self.tree.place(x=130, y=150)
self.tree.heading("序号", text='序号', anchor=CENTER)
self.tree.heading("得分", text='得分', anchor=CENTER)
self.tree.heading("时间", text='时间', anchor=CENTER)
self.tree.heading("序号1", text='序号', anchor=CENTER)
self.tree.heading("得分1", text='得分', anchor=CENTER)
self.tree.heading("时间1", text='时间', anchor=CENTER)
self.tree.heading("序号2", text='序号', anchor=CENTER)
self.tree.heading("得分2", text='得分', anchor=CENTER)
self.tree.heading("时间2", text='时间', anchor=CENTER)
if len(max_list) == 0:
Label(self.user_screen1, font=("宋体", 15), text="您暂无游戏数据，快开始游戏吧！").place(x=560, y=100)
elif len(max_list) > 0 and len(max_list) <= 20:
Label(self.user_screen1, font=("宋体", 15), text="您的最高分为：" + str(max(max_list)) + '分').place(x=580, y=100)
for i in range(0, len(max_list)):
self.tree.insert("", i, values=(i + 1, data[i][0], data[i][1]))
elif len(max_list) > 20 and len(max_list) <= 40:
Label(self.user_screen1, font=("宋体", 15), text="您的最高分为：" + str(max(max_list)) + '分').place(x=580, y=100)
for i in range(0, len(max_list) - 20):
self.tree.insert("", i,
values=(i + 1, data[i][0], data[i][1], i + 21, data[i + 20][0], data[i + 20][1]))
for x in range(i + 1, 21):
self.tree.insert("", x, values=(x + 1, data[x][0], data[x][1]))
elif len(max_list) > 40 and len(max_list) <= 60:
Label(self.user_screen1, font=("宋体", 15), text="您的最高分为：" + str(max(max_list)) + '分').place(x=580, y=100)
for i in range(0, len(max_list) - 40):
self.tree.insert("", i, values=(
i + 1, data[i][0], data[i][1], i + 21, data[i + 20][0], data[i + 20][1], i + 41, data[i + 40][0],
data[i + 40][1]))
for x in range(i + 1, 21):
self.tree.insert("", x,
values=(x + 1, data[x][0], data[x][1], x + 21, data[x + 20][0], data[x + 20][1]))
else:
Label(self.user_screen1, font=("宋体", 15), text="您的最高分为：" + str(max(max_list)) + '分').place(x=580, y=100)
for i in range(20):
self.tree.insert("", i, values=(
i + 1, data[i][0], data[i][1], i + 21, data[i + 20][0], data[i + 20][1], i + 41, data[i + 40][0],
data[i + 40][1]))
cur.close()
conn.close()
Button(self.user_screen1, text="开始游戏", width=10, font=("宋体", 15), command=self.Destroy3).place(x=200, y=600)
Button(self.user_screen1, text="返回首页", width=10, font=("宋体", 15), command=self.Destroy2).place(x=1120, y=600)
self.user_screen1.mainloop()
def register_user(self):
self.username_info = self.username_entry.get()
self.password_info = self.password_entry.get()
conn = pymysql.connect(host='localhost', user='root', passwd='123456', db='testdb', port=3306,
charset='utf8')
cur = conn.cursor()
select_sql = "select un from user WHERE un=%s"
cur.execute(select_sql, [self.username_info])
result = cur.fetchone()
if len(self.username_info) == 0:
messagebox.showinfo("错误", "请输入账号！")
cur.close()
conn.close()
elif len(self.password_info) == 0:
messagebox.showinfo("错误", "请输入密码！")
cur.close()
conn.close()
elif result is None:
sql = 'insert into user(un,pw)' \
'values("%s","%s")' % \
(self.username_info, self.password_info)
try:
cur.execute(sql)
conn.commit()
cur.close()
conn.close()
except:
conn.rollback()
self.username_entry.delete(0, END)
self.password_entry.delete(0, END)
messagebox.showinfo("成功", "注册成功！")
else:
cur.close()
conn.close()
messagebox.showinfo("失败", "该账号已被注册！")
self.password_entry.delete(0, END)
self.username_entry.delete(0, END)
def register(self):
self.username = StringVar()
self.password = StringVar()
self.main_screen.destroy()
self.register_screen = Tk()
self.register_screen.geometry("1442x700")
self.register_screen.title("注册界面")
self.bg = PhotoImage(file='background.png')
Label(self.register_screen, image=self.bg).place(x=0, y=0)
Label(self.register_screen, text="欢迎来到注册界面", font=("宋体", 20)).place(x=580, y=100)
self.username_lable = Label(self.register_screen, font=("宋体", 15), text="账号")
self.username_lable.place(x=450, y=250)
self.username_entry = Entry(self.register_screen, textvariable=self.username, width=45, font=("宋体", 15))
self.username_entry.place(x=500, y=250)
self.password_lable = Label(self.register_screen, font=("宋体", 15), text="密码")
self.password_lable.place(x=450, y=350)
self.password_entry = Entry(self.register_screen, textvariable=self.password, show='*', width=45,
font=("宋体", 15))
self.password_entry.place(x=500, y=350)
Button(self.register_screen, text="注册", width=10, font=("宋体", 15), command=self.register_user).place(x=550,
y=400)
Button(self.register_screen, text="返回首页", width=10, font=("宋体", 15), command=self.Destroy).place(x=750, y=400)
self.register_screen.mainloop()
def AdLogin(self):
self.cheek_username = StringVar()
self.main_screen.destroy()
self.admin_screen = Tk()
self.admin_screen.geometry("1442x700")
self.admin_screen.title("查询界面")
self.bg = PhotoImage(file='background.png')
Label(self.admin_screen, image=self.bg).place(x=0, y=0)
Label(self.admin_screen, text="欢迎来到查询界面", font=("宋体", 20)).place(x=600, y=30)
Label(self.admin_screen, font=("宋体", 15), text="账号").place(x=500, y=100)
self.username3 = Entry(self.admin_screen, textvariable=self.cheek_username, width=40, font=("宋体", 15))
self.username3.place(x=550, y=100)
self.columns = ("序号", "得分", "时间", "序号1", "得分1", "时间1", "序号2", "得分2", "时间2")
self.tree = ttk.Treeview(self.admin_screen, height=20, show="headings", columns=self.columns) # 隐藏首列
self.tree.column("序号", width=60) # 表示列,不显示
self.tree.column("得分", width=170) # 表示列,不显示
self.tree.column("时间", width=170) # 表示列,不显示
self.tree.column("序号1", width=60) # 表示列,不显示
self.tree.column("得分1", width=170) # 表示列,不显示
self.tree.column("时间1", width=170) # 表示列,不显示
self.tree.column("序号2", width=60) # 表示列,不显示
self.tree.column("得分2", width=170) # 表示列,不显示
self.tree.column("时间2", width=170) # 表示列,不显示
self.tree.place(x=130, y=150)
Button(self.admin_screen, text="查询", width=10, font=("宋体", 15), command=self.serach).place(x=200, y=600)
Button(self.admin_screen, text="查询所有玩家最高分", width=20, font=("宋体", 15), command=self.serach_best).place(x=620,
y=600)
Button(self.admin_screen, text="返回首页", width=10, font=("宋体", 15), command=self.Destroy1).place(x=1120, y=600)
self.admin_screen.mainloop()
def serach(self):
x = self.tree.get_children()
for item in x:
self.tree.delete(item)
conn = pymysql.connect(host='localhost', user='root', passwd='123456', db='testdb', port=3306,
charset='utf8')
cur = conn.cursor()
select_sql = "select un from user WHERE un=%s"
cur.execute(select_sql, [self.username3.get()])
result = cur.fetchone()
if len(self.username3.get()) == 0:
messagebox.showinfo("错误", "请输入账号！")
cur.close()
conn.close()
elif result is None:
messagebox.showinfo("错误", "该账号不存在！")
cur.close()
conn.close()
else:
self.tree.heading("序号", text='序号', anchor=CENTER)
self.tree.heading("得分", text='得分', anchor=CENTER)
self.tree.heading("时间", text='时间', anchor=CENTER)
self.tree.heading("序号1", text='序号', anchor=CENTER)
self.tree.heading("得分1", text='得分', anchor=CENTER)
self.tree.heading("时间1", text='时间', anchor=CENTER)
self.tree.heading("序号2", text='序号', anchor=CENTER)
self.tree.heading("得分2", text='得分', anchor=CENTER)
self.tree.heading("时间2", text='时间', anchor=CENTER)
select_sql = "select id from user WHERE un=%s"
cur.execute(select_sql, [self.username3.get()])
select_sql = "select code, time from code_lable WHERE userid=%s"
cur.execute(select_sql, [cur.fetchone()[0]])
lists = cur.fetchall()
lists = list(lists)
lists = list(reversed(lists))
print(len(lists))
if len(lists) == 0:
self.tree.insert("", 0, values=(1, '暂无数据'))
elif len(lists) > 0 and len(lists) <= 20:
for i in range(0, len(lists)):
self.tree.insert("", i, values=(i + 1, lists[i][0], lists[i][1]))
elif len(lists) > 20 and len(lists) <= 40:
for i in range(0, len(lists) - 20):
self.tree.insert("", i, values=(
i + 1, lists[i][0], lists[i][1], i + 21, lists[i + 20][0], lists[i + 20][1]))
for x in range(i + 1, 21):
self.tree.insert("", x, values=(x + 1, lists[x][0], lists[x][1]))
elif len(lists) > 40 and len(lists) <= 60:
for i in range(0, len(lists) - 40):
self.tree.insert("", i, values=(
i + 1, lists[i][0], lists[i][1], i + 21, lists[i + 20][0], lists[i + 20][1], i + 41,
lists[i + 40][0], lists[i + 40][1]))
for x in range(i + 1, 21):
self.tree.insert("", x, values=(
x + 1, lists[x][0], lists[x][1], x + 21, lists[x + 20][0], lists[x + 20][1]))
else:
for i in range(20):
self.tree.insert("", i, values=(
i + 1, lists[i][0], lists[i][1], i + 21, lists[i + 20][0], lists[i + 20][1], i + 41,
lists[i + 40][0], lists[i + 40][1]))
cur.close()
conn.close()
def serach_best(self):
self.tree.heading("序号", text='玩家ID', anchor=CENTER)
self.tree.heading("得分", text='最高得分', anchor=CENTER)
self.tree.heading("时间", text='时间', anchor=CENTER)
self.tree.heading("序号1", text='玩家ID', anchor=CENTER)
self.tree.heading("得分1", text='最高得分', anchor=CENTER)
self.tree.heading("时间1", text='时间', anchor=CENTER)
self.tree.heading("序号2", text='玩家ID', anchor=CENTER)
self.tree.heading("得分2", text='最高得分', anchor=CENTER)
self.tree.heading("时间2", text='时间', anchor=CENTER)
x = self.tree.get_children()
for item in x:
self.tree.delete(item)
self.username3.delete(0, END)
conn = pymysql.connect(host='localhost', user='root', passwd='123456', db='testdb', port=3306,
charset='utf8')
cur = conn.cursor()
select_sql = "select un from user"
cur.execute(select_sql)
result = cur.fetchall()
datas = []
for i in range(0, len(result)):
ID = result[i]
select_sql = "select id from user WHERE un=%s"
cur.execute(select_sql, [ID[0]])
id = cur.fetchone()
select_sql = "select code, time from code_lable WHERE userid=%s"
cur.execute(select_sql, [id[0]])
data = cur.fetchall()
max_list = []
data_list = []
for x in data:
max_list.append(int(x[0]))
print(max_list)
if len(max_list) > 0:
data_list.append(ID[0])
data_list.append(max(max_list))
data_list.append(data[max_list.index(max(max_list))][1])
else:
data_list.append(ID[0])
data_list.append('暂无数据')
datas.append(data_list)
# print(datas)
if len(datas) == 0:
messagebox.showinfo("错误", "暂无注册用户！")
cur.close()
conn.close()
elif len(datas) > 0 and len(datas) <= 20:
for i in range(len(datas)):
if len(datas[i]) == 2:
self.tree.insert("", i, values=(datas[i][0], datas[i][1]))
else:
self.tree.insert("", i, values=(datas[i][0], datas[i][1], datas[i][2]))
elif len(datas) > 20 and len(datas) <= 40:
for i in range(len(datas) - 20):
if len(datas[i]) == 2 and len(datas[i + 20]) == 2:
self.tree.insert("", i, values=(datas[i][0], datas[i][1], '', datas[i + 20][0], datas[i + 20][1]))
elif len(datas[i]) == 2 and len(datas[i + 20]) == 3:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], '', datas[i + 20][0], datas[i + 20][1], datas[i + 20][2]))
elif len(datas[i]) == 3 and len(datas[i + 20]) == 3:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], datas[i][2], datas[i + 20][0], datas[i + 20][1], datas[i + 20][2]))
elif len(datas[i]) == 3 and len(datas[i + 20]) == 2:
self.tree.insert("", i,
values=(datas[i][0], datas[i][1], datas[i][2], datas[i + 20][0], datas[i + 20][1]))
for x in range(i + 1, 21):
if len(datas[x]) == 2:
self.tree.insert("", x, values=(datas[x][0], datas[x][1]))
else:
self.tree.insert("", x, values=(datas[x][0], datas[x][1], datas[x][2]))
elif len(datas) > 40 and len(datas) <= 60:
for i in range(len(datas) - 40):
if len(datas[i]) == 2 and len(datas[i + 20]) == 2 and len(datas[i + 40]) == 2:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], '', datas[i + 20][0], datas[i + 20][1], '', datas[i + 40][0],
datas[i + 40][1]))
elif len(datas[i]) == 2 and len(datas[i + 20]) == 2 and len(datas[i + 40]) == 3:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], '', datas[i + 20][0], datas[i + 20][1], '', datas[i + 40][0],
datas[i + 40][1], datas[i + 40][2]))
elif len(datas[i]) == 2 and len(datas[i + 20]) == 3 and len(datas[i + 40]) == 2:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], '', datas[i + 20][0], datas[i + 20][1], datas[i + 20][2],
datas[i + 40][0], datas[i + 40][1]))
elif len(datas[i]) == 3 and len(datas[i + 20]) == 2 and len(datas[i + 40]) == 2:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], datas[i][2], datas[i + 20][0], datas[i + 20][1], '', datas[i + 40][0],
datas[i + 40][1]))
elif len(datas[i]) == 3 and len(datas[i + 20]) == 3 and len(datas[i + 40]) == 2:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], datas[i][2], datas[i + 20][0], datas[i + 20][1], datas[i + 20][2],
datas[i + 40][0], datas[i + 40][1]))
elif len(datas[i]) == 3 and len(datas[i + 20]) == 2 and len(datas[i + 40]) == 3:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], datas[i][2], datas[i + 20][0], datas[i + 20][1], '', datas[i + 40][0],
datas[i + 40][1], datas[i + 40][2]))
elif len(datas[i]) == 2 and len(datas[i + 20]) == 3 and len(datas[i + 40]) == 3:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], '', datas[i + 20][0], datas[i + 20][1], datas[i + 20][2],
datas[i + 40][0], datas[i + 40][1], datas[i + 40][2]))
elif len(datas[i]) == 3 and len(datas[i + 20]) == 3 and len(datas[i + 40]) == 3:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], datas[i][2], datas[i + 20][0], datas[i + 20][1], datas[i + 20][2],
datas[i + 40][0], datas[i + 40][1], datas[i + 40][2]))
for x in range(i + 1, 21):
if len(datas[x]) == 2 and len(datas[x + 20]) == 2:
self.tree.insert("", x, values=(datas[x][0], datas[x][1], '', datas[x + 20][0], datas[x + 20][1]))
elif len(datas[x]) == 2 and len(datas[x + 20]) == 3:
self.tree.insert("", x, values=(
datas[x][0], datas[x][1], '', datas[x + 20][0], datas[x + 20][1], datas[x + 20][2]))
elif len(datas[x]) == 3 and len(datas[x + 20]) == 3:
self.tree.insert("", x, values=(
datas[x][0], datas[x][1], datas[x][2], datas[x + 20][0], datas[x + 20][1], datas[x + 20][2]))
elif len(datas[x]) == 3 and len(datas[x + 20]) == 2:
self.tree.insert("", x,
values=(datas[x][0], datas[x][1], datas[x][2], datas[x + 20][0], datas[x + 20][1]))
else:
for i in range(20):
if len(datas[i]) == 2 and len(datas[i + 20]) == 2 and len(datas[i + 40]) == 2:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], '', datas[i + 20][0], datas[i + 20][1], '', datas[i + 40][0],
datas[i + 40][1]))
elif len(datas[i]) == 2 and len(datas[i + 20]) == 2 and len(datas[i + 40]) == 3:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], '', datas[i + 20][0], datas[i + 20][1], '', datas[i + 40][0],
datas[i + 40][1], datas[i + 40][2]))
elif len(datas[i]) == 2 and len(datas[i + 20]) == 3 and len(datas[i + 40]) == 2:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], '', datas[i + 20][0], datas[i + 20][1], datas[i + 20][2],
datas[i + 40][0], datas[i + 40][1]))
elif len(datas[i]) == 3 and len(datas[i + 20]) == 2 and len(datas[i + 40]) == 2:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], datas[i][2], datas[i + 20][0], datas[i + 20][1], '', datas[i + 40][0],
datas[i + 40][1]))
elif len(datas[i]) == 3 and len(datas[i + 20]) == 3 and len(datas[i + 40]) == 2:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], datas[i][2], datas[i + 20][0], datas[i + 20][1], datas[i + 20][2],
datas[i + 40][0], datas[i + 40][1]))
elif len(datas[i]) == 3 and len(datas[i + 20]) == 2 and len(datas[i + 40]) == 3:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], datas[i][2], datas[i + 20][0], datas[i + 20][1], '', datas[i + 40][0],
datas[i + 40][1], datas[i + 40][2]))
elif len(datas[i]) == 2 and len(datas[i + 20]) == 3 and len(datas[i + 40]) == 3:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], '', datas[i + 20][0], datas[i + 20][1], datas[i + 20][2],
datas[i + 40][0], datas[i + 40][1], datas[i + 40][2]))
elif len(datas[i]) == 3 and len(datas[i + 20]) == 3 and len(datas[i + 40]) == 3:
self.tree.insert("", i, values=(
datas[i][0], datas[i][1], datas[i][2], datas[i + 20][0], datas[i + 20][1], datas[i + 20][2],
datas[i + 40][0], datas[i + 40][1], datas[i + 40][2]))
cur.close()
conn.close()
def Admin_login_verify(self):
self.username2 = self.username_verify.get()
self.password2 = self.password_verify.get()
conn = pymysql.connect(host='localhost', user='root', passwd='123456', db='testdb', port=3306,
charset='utf8')
cur = conn.cursor()
select_sql = "select passward from admin WHERE username=%s"
cur.execute(select_sql, [self.username2])
result = cur.fetchone()
if len(self.username2) == 0:
messagebox.showinfo("错误", "请输入账号！")
cur.close()
conn.close()
elif result is None:
cur.close()
conn.close()
messagebox.showinfo("失败", "该账号未注册！")
self.password_login_entry.delete(0, END)
self.username_login_entry.delete(0, END)
else:
if result[0] == self.password2:
cur.close()
conn.close()
messagebox.showinfo("成功", "登录成功")
self.username_login_entry.delete(0, END)
self.password_login_entry.delete(0, END)
self.AdLogin()
elif result[0] != self.password2:
cur.close()
conn.close()
messagebox.showinfo("失败", "密码错误！")
self.password_login_entry.delete(0, END)
def Destroy(self):
self.register_screen.destroy()
gui_start().set_init_window()
def Destroy1(self):
self.admin_screen.destroy()
gui_start().set_init_window()
def Destroy2(self):
self.user_screen1.destroy()
gui_start().set_init_window()
def Destroy3(self):
self.user_screen1.destroy()
go(self.username1)
def gui_start():
init_window = Tk() # 实例化出一个父窗口
return My_Gui(init_window)
# 设置根窗口默认属性
# ZMJ_PORTAL.set_init_window()
# init_window.mainloop() # 父窗口进入事件循环，可以理解为保持窗口运行，否则界面不展示
# if __name__ == '__main__':
# gui_start().set_init_window()
总结
提示：这里对文章进行总结：
例如：以上就是今天要讲的内容，本文仅仅简单介绍了pandas的使用，而pandas提供了大量能使我们快速便捷地处理数据的函数和方法。
这篇关于基于Python+MySQL的飞机大战游戏包含用户登录的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！
- 2024-11-16MySQL资料：新手入门教程
- 2024-11-16MySQL资料：新手入门教程
- 2024-11-15MySQL教程：初学者必备的MySQL数据库入门指南
- 2024-11-15MySQL教程：初学者必看的MySQL入门指南
- 2024-11-04部署MySQL集群项目实战：新手入门教程
- 2024-11-04如何部署MySQL集群资料：新手入门指南
- 2024-11-02MySQL集群项目实战：新手入门指南
- 2024-11-02初学者指南：部署MySQL集群资料
- 2024-11-01部署MySQL集群教程：新手入门指南
- 2024-11-01如何部署MySQL集群：新手入门教程
