- 数据保存
def add_users():
user = UserProfile()
user.nike_name = 'hy'
user.save()
- 数据删除
models.UserInfo.objects.filter(user='yangmv').delete()
- 数据读取
models.UserInfo.objects.all()
#只取user列
models.UserInfo.objects.all().values('user')
#取出id和user列,并生成一个列表
models.UserInfo.objects.all().values_list('id','user')
models.UserInfo.objects.get(id=1)
models.UserInfo.objects.get(user='yangmv')
- 数据增加
models.UserInfo.objects.create(user='yangmv',pwd='123456')
或者
obj = models.UserInfo(user='yangmv',pwd='123456')
obj.save()
或者
dic = {'user':'yangmv','pwd':'123456'}
models.UserInfo.objects.create(**dic)
- 数据修改
models.UserInfo.objects.filter(user='yangmv').update(pwd='520')
或者
obj = models.UserInfo.objects.get(user='yangmv')
obj.pwd = '520'
obj.save()
- 查看数据库是否存在某数据
注:UserProfile这块一定是model类名称
if UserProfile.objects.filter(email=user_name):
return render(request, "register.html", {"register_form": register_form, "msg": "用户邮箱已存在"})