def save_info(user, args): c = data.SQLconn() conn = MySQLdb.connect(host=c["host"], user=c["user"], passwd=c["passwd"], charset=c["charset"], db=c["db"]) cursor = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor) cursor.execute("update ACCOUNT SET \ account_username='******', \ account_sex = '%s',\ account_phone='%s', \ account_email='%s', \ account_address = '%s'\ WHERE account_id = %s\ ;"% (args.username, args.account_sex,args.phone,\ args.email,str(args.account_address).encode('utf-8'), args.id)) conn.commit() if args.get('oldpasswd'): if args.get('newpassword1') == args.get('newpassword2'): passwd = data.checkin(user) newpassword1 = data.md5(args.get('newpassword1')) oldpasswd = data.md5(args.get('oldpasswd')) if oldpasswd == passwd[0]['account_password']: cursor.execute("update ACCOUNT SET \ account_password = '******'\ WHERE account_id = '%s'"\ %(newpassword1, args.get('id'))) conn.commit() else: return False else: return False conn.close() return True
def account_save(account_name, account_sex, account_username, account_work, account_position, account_phone,account_address,account_email,account_department, account_power): #存储账号信息 #设置默认密码user:123456, admin: admin if account_name == 'user': account_password = data.md5('123456') elif account_name == 'admin': account_password = data.md5('admin') c = data.SQLconn() conn = MySQLdb.connect(host=c["host"], user=c["user"], passwd=c["passwd"], charset=c["charset"], db=c["db"]) cursor = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor) cursor.execute("insert into account \ (account_password, account_name, account_sex, account_username, account_work, account_position, account_phone,account_address,account_email,account_department, account_power)\ value ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');\ "%(account_password, account_name.encode('utf-8'), account_sex.encode('utf-8'), account_username.encode('utf-8'), account_work.encode('utf-8'), account_position.encode('utf-8'), account_phone.encode('utf-8'),account_address.encode('utf-8'),account_email.encode('utf-8'),account_department.encode('utf-8'),account_power)) conn.commit() conn.close()
def POST(self): user = web.input().user #md5加密存储密码 passwd = data.md5(web.input().passwd) ident = data.checkin(user) checkcode = web.input().checkcode try: if checkcode != session.checkcode: session.login = 0 return render_template(type=0,template_name='login.html',error="验证码错误") elif len(ident)==0 : session.login = 0 return render_template(type=0,template_name='login.html',error="用户名不存在") elif passwd == ident[0]['account_password']: session.login = 1 session.user = user session.type = ident[0]['account_name'] return json.dumps({"statusCode":"200", "message":"登录成功", "callbackType":"closeCurrent"}) else: session.login = 0 return render_template(type=0,template_name='login.html',error="密码错误") except: session.login = 0 return render_template(type=0,template_name='login.html',error="系统错误")
def POST(self): user = web.input().user #md5加密存储密码 passwd = data.md5(web.input().passwd) ident = data.checkin(user) checkcode = web.input().checkcode try: if checkcode != session.checkcode: session.login = 0 return render_template(type=0,template_name='login.html',error="验证码错误") elif len(ident)==0 : session.login = 0 return render_template(type=0,template_name='login.html',error="用户名不存在") elif passwd == ident[0]['account_password']: session.login = 1 session.user = user session.type = ident[0]['account_name'] return render_template(type=session.type,template_name='index.html',user=session.user) else: session.login = 0 return render_template(type=0,template_name='login.html',error="密码错误") except Exception, e: print 'login error', e session.login = 0 return render_template(type=0,template_name='login.html',error="系统错误")
def account_save(account_name, account_sex, account_username, account_work, account_position, account_phone,account_address,account_email,account_department, account_power): #存储账号信息 #设置默认密码user:123456, admin: admin if account_name == 'user': account_password = data.md5('123456') elif account_name == 'admin': account_password = data.md5('admin') c = data.SQLconn() conn = MySQLdb.connect(host=c["host"], user=c["user"], passwd=c["passwd"], charset=c["charset"], db=c["db"]) cursor = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor) cursor.execute("insert into ACCOUNT \ (account_password, account_name, account_sex, account_username, account_work, account_position, account_phone,account_address,account_email,account_department, account_power)\ value ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');\ "%(account_password, account_name.encode('utf-8'), account_sex.encode('utf-8'), account_username.encode('utf-8'), account_work.encode('utf-8'), account_position.encode('utf-8'), account_phone.encode('utf-8'),account_address.encode('utf-8'),account_email.encode('utf-8'),account_department.encode('utf-8'),account_power)) conn.commit() conn.close()