Python db_execute示例

示例#1

文件： views.py 项目： ocker/actual_07_homework

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))

示例#2

文件： views.py 项目： ocker/actual_07_homework

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))

示例#3

文件： views.py 项目： 51reboot/actual_07_homework

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))

示例#4

文件： views.py 项目： ocker/actual_07_homework

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))

示例#5

文件： views.py 项目： 51reboot/actual_07_homework

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))

示例#6

文件： views.py 项目： ocker/actual_07_homework

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))

示例#7

文件： views.py 项目： 51reboot/actual_07_homework

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))

示例#8

文件： views.py 项目： 51reboot/actual_07_homework

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))