MySQL登陆系统

准备：

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()

（编辑：晋中站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!