def hello(request):
now = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
name = '%s' % ('show')
users = User.objects.all().filter(user_name='admin').values()
# 获取model执行的sql语句
sql = users.query
'''
SELECT
`mysite_user`.`id`,
`mysite_user`.`user_id`,
`mysite_user`.`user_name`,
`mysite_user`.`email`,
`mysite_user`.`cellphone`
FROM
`mysite_user`
WHERE
`mysite_user`.`user_name` = username
'''
user = User()
user.user_name = 'admin'
user.user_id = 'admin001'
user.email = '*****@*****.**'
user.cellphone = '13500008888'
user.password = md5('password')
md5str = md5('123456')
# user.save()
# request =' %s', % (request)
host = request.get_host()
return TemplateResponse(request, 'hello.html', locals())
def userReg(request):
if request.method == 'POST':
verify_code = request.session['verify_code']
input_verify = request.POST['verify']
returndata = {}
# 检查验证码
if verify_code.lower() != input_verify.lower():
returndata = {'code': 100, 'msg': '验证码错误'}
# 检查用户名是否存在
userinfo = User.objects.filter(
user_name=request.POST['username']).exists()
if userinfo:
returndata = {'code': 101, 'msg': '用户名已存在'}
if returndata:
return HttpResponse(json.dumps(returndata), 'application/json')
user = User()
user.user_name = request.POST['username']
user.password = md5(request.POST['password'])
user.save()
returndata = {'code': 200, 'msg': '注册成功'}
return HttpResponse(json.dumps(returndata), 'application/json')
else:
return TemplateResponse(request, 'reg.html')
