def addUser(): if session.get('username'): name = request.form.get('username') password = request.form.get('password') password2 = request.form.get('password2') mobile = request.form.get('mobile') email = request.form.get('email') age = request.form.get('age') # 账号密码不为空 if not name or not password: return render_template('create.html', error=u'账号或密码不能为空') # 密码要一致 if password != password2: return render_template('create.html', error=u'两次密码输入不一致') # 账号存在判断 cmd_name = "SELECT * FROM member WHERE username = %s" if models.db_select(cmd_name, name): return render_template('create.html', error=u'账号已存在') # 年龄判断 if not age.isdigit(): return render_template('create.html', error=u'年龄必须为整数') # 插入数据 try: cmd_insert = "INSERT INTO member (username,password,mobile,email,age) VALUES (%s, md5(%s), %s, %s, %s)" models.db_execute(cmd_insert, name, password, mobile, email, int(age)) return redirect('/listUser/') except Exception, e: return render_template('login.html', error=str(e))
def updateUser(): if not session.get('username'): return redirect(url_for('login')) if request.method == 'POST': name = request.form.get('username') password = request.form.get('password') mobile = request.form.get('mobile') email = request.form.get('email') age = request.form.get('age') if not password: return render_template('update.html', username=name, error=u'密码必须填写') # 年龄判断 if not age.isdigit(): return render_template('update.html', username=name, error=u'年龄必须为整数') try: cmd_insert = "UPDATE member SET password=md5(%s),mobile=%s,email=%s,age=%s WHERE username=%s" models.db_execute(cmd_insert, password, mobile, email, int(age), name) return render_template('list.html') except Exception, e: return render_template('update.html', username=name, error=str(e))
def addUser(): if session.get('username'): name = request.form.get('username') password = request.form.get('password') password2 = request.form.get('password2') mobile = request.form.get('mobile') email = request.form.get('email') age = request.form.get('age') # 账号密码不为空 if not name or not password: return render_template('create.html', error=u'账号或密码不能为空') # 密码要一致 if password != password2: return render_template('create.html', error=u'两次密码输入不一致') # 账号存在判断 cmd_name = "SELECT * FROM member WHERE username = %s" if models.db_select(cmd_name,name): return render_template('create.html', error=u'账号已存在') # 年龄判断 if not age.isdigit(): return render_template('create.html', error=u'年龄必须为整数') # 插入数据 try: cmd_insert = "INSERT INTO member (username,password,mobile,email,age) VALUES (%s, md5(%s), %s, %s, %s)" models.db_execute(cmd_insert,name, password, mobile, email, int(age)) return redirect('/listUser/') except Exception,e: return render_template('login.html', error=str(e))
def deleteUser(): name = request.args.get('username') cmd_delete = "DELETE FROM member WHERE username = %s" try: models.db_execute(cmd_delete, name) return render_template('list.html') except Exception, e: return render_template('list.html', info=str(e))
def deleteUser(): name = request.args.get('username') cmd_delete = "DELETE FROM member WHERE username = %s" try: models.db_execute(cmd_delete,name) return render_template('list.html') except Exception,e: return render_template('list.html',info=str(e))
def deleteUser(): if not session.get('username'): return redirect(url_for('login')) name = request.args.get('username') cmd_delete = "DELETE FROM member WHERE username = %s" try: models.db_execute(cmd_delete, name) return render_template('list.html') except Exception, e: return render_template('list.html', error=str(e))
def deleteUser(): if not session.get('username'): return redirect(url_for('login')) name = request.args.get('username') cmd_delete = "DELETE FROM member WHERE username = %s" try: models.db_execute(cmd_delete,name) return render_template('list.html') except Exception,e: return render_template('list.html',error=str(e))
def updateUser(): if request.method == 'POST': name = request.form.get('username') password = request.form.get('password') mobile = request.form.get('mobile') email = request.form.get('email') age = request.form.get('age') # 年龄判断 if not age.isdigit(): return render_template('update.html', info=u'年龄必须为整数') try: cmd_insert = "UPDATE member SET password=md5(%s),mobile=%s,email=%s,age=%s WHERE username=%s" models.db_execute(cmd_insert, password,mobile,email,int(age),name) return render_template('list.html') except Exception,e: return render_template('update.html', info=str(e))