MySQL登陆系统
发布时间：2022-11-16 12:43:02 所属栏目：MySql教程 来源：
导读： 准备：
Pycharm
mysql
pymysql
代码：
###
###
import pymysql
from tkinter import *
db = pymysql.connect(
host = "local
Pycharm
mysql
pymysql
代码：
###
###
import pymysql
from tkinter import *
db = pymysql.connect(
host = "local
|
准备： Pycharm mysql pymysql 代码： ### ### import pymysql from tkinter import * db = pymysql.connect( host = "localhost", port = 3306, user = 'root', password = 'Lijian903', database = 'Alex') on = 0 cursor = db.cursor() class System: def __init__(self,master): self.master = master self.master.title('登陆') self.master.resizable(0, 0) self.master.geometry('320x420') #主界面 self.username = StringVar() self.password = StringVar() self.username.set(' ') self.password.set(' ') self.show_username = Label(self.master, bg='white', fg='black', font=('Arail', '16'), bd='0', textvariable=self.username, anchor='se') self.show_password = Label(self.master, bg='white', fg='black', font=('Arail', '20'), bd='0', textvariable=self.password, anchor='se') #显示框 self.button_ok = Button(self.master,text='end'mysql系统, bg='DarkGray', command=self.end) self.username = Entry(self.master, show=None, font=('Arial', 14)) self.password = Entry(self.master, show='*', font=('Arial', 14)) self.button_ok.place(x='230', y='260', width='80', height='50') self.password.place(x='10', y='190', width='300', height='50') self.username.place(x='10', y='140', width='300', height='50') def end(self): try: name = str(self.username.get()) password = str(self.password.get()) print('name:',name) print('password:',password) root.quit() try: sql = "select password from user " cursor.execute(sql) right_password = str(cursor.fetchone()) print('密码',right_password) sql = 'select name from user' cursor.execute(sql) right_name = str(cursor.fetchone()) print('账号',right_name) if name in right_name: if password in right_password: print('登陆成功') else: print('密码错误') else: print('账号错误') except Exception as e: print("登录失败的原因是：%s" % e) except: print('error') if __name__ == '__main__': root = Tk() main = System(root) root.mainloop() （编辑：PHP编程网 - 钦州站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐
浙公网安备 33038102330484号