Python 登陆接口小程序版本V1
Python
#!/usr/bin/env python#_*_coding:utf-8 _*___author__ = 'gaogd'import MySQLdb as mysqlimport datetimeclass Authon(object): def __init__(self): self.db = mysql.connect(user="root", passwd="XXXX@2015", db="logintest", host="192.168.10.12") # 数据库连接信息 self.db.autocommit(True) self.cur = self.db.cursor() self.cur.execute('set names utf8') def Login(self): username = raw_input(u'请输入你的用户名:') err_count = 0 Flag = True while Flag: password = raw_input(u'请输入密码:') if username.strip() == '': print u'用户名不能为空!' # sql = select user,passwd from loginuser where user='gao3'and passwd='gao3'; select_user_passwd_sql = "select user,passwd from loginuser where user='%s'and passwd='%s';" % (username,password) self.cur.execute(select_user_passwd_sql) select_user_passwd = self.cur.fetchall() if len(select_user_passwd) == 0: print u'用户名或密码不正确!!' err_count += 1 if err_count == 3: print u'错误输入密码超过三次,程序自动退出!!' Flag = False else: err_count = 0 print '欢迎您来%s到Python家族!!' % username return True def Register(self): username = raw_input(u'请输入你要申请的用户名:') password_one = raw_input(u'请输入密码:') password_two = raw_input(u'请再次输入密码:') addtime = datetime.datetime.now() if username.strip() == '': print u'用户名不能为空!' if not username.isalnum(): print u'用户名不能包含特殊字符' return False if password_one.strip() == '': print u'密码不能为空!' return False if not password_one.strip() == password_two.strip(): print u'你两次输入的密码不一致' return False ## sql = insert into loginuser(user,passwd,err_count,time) values('gaogd','gaogd','0','2016-09-02 14:40:22'); create_user_sql = "insert into loginuser(user,passwd,err_count,time) values('%s','%s','%s','%s')" % (username,password_one,0,addtime) try: print create_user_sql self.cur.execute(create_user_sql) except Exception as e: print e print u'创建用户失败!!' return False print u'创建用户成功:',username def Deleuser(self): username = raw_input(u'请输入你要删除的用户名:') password = raw_input(u'请输入密码:') if username.strip() == '': print u'用户名不能为空!' select_user_sql = "select user from loginuser;" self.cur.execute(select_user_sql) select_user = self.cur.fetchall() Flag = False for n in range(len(select_user)): if username == select_user[n][0]: # username,select_user[n][0] Flag = True if Flag : #select passwd from loginuser where user='gao';v select_passwd_sql = "select passwd from loginuser where user='%s';" % username self.cur.execute(select_passwd_sql) select_passwd = self.cur.fetchall() if password.strip() == select_passwd[0][0].strip(): ##删除用户 ##DELETE FROM loginuser WHERE user='gao1'; select_deluser_sql = "DELETE FROM loginuser WHERE user='%s';" % username self.cur.execute(select_deluser_sql) print '已经成功删除%s用户' % username else: print '用户名或密码不正确!!'def SelectFunction(): content=''' 1.登陆Python家族 2.注册用户 3.删除用户 ''' print content num = raw_input(u'请输入您的选择:') if num.strip() == '1': authon.Login() return True if num.strip() == '2': authon.Register() return True if num.strip() == '3': authon.Deleuser() return True print u'您的输入有误!!请输入您需要的功能对应的序号'if __name__ == "__main__": #pass authon = Authon() #authon.Register() #authon.Login() #authon.Deleuser() SelectFunction()"""数据数据库以及对应的表create database logintest ;use logintest;CREATE TABLE `loginuser` (`user` varchar(64) primary key,`passwd` varchar(128) ,`err_count` int ,`time` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8;mysql> desc loginuser;+-----------+--------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+-----------+--------------+------+-----+---------+-------+| user | varchar(64) | NO | PRI | NULL | || passwd | varchar(128) | YES | | NULL | || err_count | int(11) | YES | | NULL | || time | datetime | YES | | NULL | |+-----------+--------------+------+-----+---------+-------+4 rows in set (0.01 sec)mysql>注册用户登陆用户删除用户"""