Exemple #1
0
def listUser():
	if request.method == 'POST':
		try:
			name = request.form.get('query')
			if name:
				cmd_list = "SELECT * FROM member WHERE username = %s"
				userLst = models.db_select(cmd_list,name)
				return render_template('list.html', users=userLst)
			else:
				cmd_list = "SELECT * FROM member"
				userLst = models.db_select(cmd_list)
				return render_template('list.html', users=userLst)
		except Exception,e:
			return render_template('login.html', info=str(e))
Exemple #2
0
def listUser():
    if request.method == 'POST':
        try:
            name = request.form.get('query')
            if name:
                cmd_list = "SELECT * FROM member WHERE username = %s"
                userLst = models.db_select(cmd_list, name)
                return render_template('list.html', users=userLst)
            else:
                cmd_list = "SELECT * FROM member"
                userLst = models.db_select(cmd_list)
                return render_template('list.html', users=userLst)
        except Exception, e:
            return render_template('login.html', info=str(e))
Exemple #3
0
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))
Exemple #4
0
def modifyUser():
    if not session.get('username'):
        return redirect(url_for('login'))
    name = request.args.get('username')
    cmd_list = "SELECT * FROM member WHERE username = %s"
    user = models.db_select(cmd_list, name)
    return render_template('update.html', username=name)
Exemple #5
0
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))
Exemple #6
0
def modifyUser():
	if not session.get('username'):
		return redirect(url_for('login'))
	name = request.args.get('username')
	cmd_list = "SELECT * FROM member WHERE username = %s"
	user = models.db_select(cmd_list, name)
	return render_template('update.html',username=name)
Exemple #7
0
def loginvalidate():
	if request.method == 'GET':
		name = request.args.get('username')
		password = request.args.get('password')
		return render_template('login.html', username=name)
	else:
		name = request.form.get('username')
		password = request.form.get('password')
		try:
			cmd_valid = "SELECT * FROM member WHERE username = %s AND password = md5(%s)"
			valid_res = models.db_select(cmd_valid, name, password)
			if valid_res:
				return redirect('/listUser/')
			else:
				return render_template('login.html', info=u'账号或密码错误', username=name)
		except Exception,e:
			return render_template('login.html', info=str(e))
Exemple #8
0
def loginvalidate():
    if request.method == 'GET':
        name = request.args.get('username')
        password = request.args.get('password')
        return render_template('login.html', username=name)
    else:
        name = request.form.get('username')
        password = request.form.get('password')
        try:
            cmd_valid = "SELECT * FROM member WHERE username = %s AND password = md5(%s)"
            valid_res = models.db_select(cmd_valid, name, password)
            if valid_res:
                return redirect('/listUser/')
            else:
                return render_template('login.html',
                                       info=u'账号或密码错误',
                                       username=name)
        except Exception, e:
            return render_template('login.html', info=str(e))
Exemple #9
0
def modifyUser():
    name = request.args.get('username')
    cmd_list = "SELECT * FROM member WHERE username = %s"
    user = models.db_select(cmd_list, name)
    return render_template('update.html', user=user)
Exemple #10
0
def modifyUser():
	name = request.args.get('username')
	cmd_list = "SELECT * FROM member WHERE username = %s"
	user = models.db_select(cmd_list, name)
	return render_template('update.html',user=user)