python核心编程 第十三章 13.4

没有重载del来实现保存用户数据，尝试用python链接mysql

#coding=utf-8
from Tkinter import *
import MySQLdb
import tkMessageBox

class usrlogin(object):
    def __init__ (self):
        self.usrin = Tk()
        self.label = Label(self.usrin, text = '用户登录')
        self.label.grid(column = 2, row = 0)
        self.usr = Label(self.usrin, text='用户名')
        self.usr.grid(column = 2, row = 1)
        self.usrname = Entry(self.usrin)
        self.usr = Label(self.usrin, text = "用户名")                                 
        self.usr.grid(column = 1, row = 1)
        self.usrname = Entry(self.usrin)
        self.usrname.grid(column = 2, row = 1)
        self.paswd = Label(self.usrin, text = "密码")
        self.paswd.grid(column = 1, row = 2)
        self.password = Entry(self.usrin)
        self.password.grid(column = 2, row = 2)
        self.quit = Button(self.usrin, text = "退出",  command = self.usrin.quit)
        self.quit.grid(column = 2, row = 3)
        self.logup = Button(self.usrin, text = "登陆", command = self._confirm)
        self.logup.grid(column = 1, row = 3)
        self.usrin.mainloop()        
    def _confirm(self):
        conn = MySQLdb.connect(host = 'localhost', user = 'root',
                           passwd = 'fx', db = 'fangxu')
        cur = conn.cursor()
        name = self.usrname.get()
        cur.execute("select passwd from  userin where usr = %s", name)
        passwd = cur.fetchall()
        cur.close()
        conn.close()
        if len(passwd) == 0:
            tkMessageBox.showinfo("提示", "您是新用户，现在已经注册成功，可以尝试登陆")
            self._addusr()
        else:
            if unicode(self.password.get()) in passwd[0]:
                tkMessageBox.showinfo("提示", "登录成功")
            else:
                tkMessageBox.showwarning("警告", "密码错误")
                
    def _addusr(self):
        conn = MySQLdb.connect(host = 'localhost', user = 'root',
                                      passwd = 'fx', db = 'fangxu')
        cur = conn.cursor()
        name = self.usrname.get()
        passwd = self.password.get()
        values = []
        values.append(name)
        values.append(passwd)
        cur.execute('insert into userin values(%s, %s)', values)           
        conn.commit()
        cur.close()
        conn.close()
    
newusr = usrlogin()