05.model的增删改

  1. 数据保存
def add_users():
    user = UserProfile()
    user.nike_name = 'hy'
    user.save()
  1. 数据删除
models.UserInfo.objects.filter(user='yangmv').delete()
  1. 数据读取
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')
  1. 数据增加
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)
  1. 数据修改
models.UserInfo.objects.filter(user='yangmv').update(pwd='520')
或者
obj = models.UserInfo.objects.get(user='yangmv')
obj.pwd = '520'
obj.save()
  1. 查看数据库是否存在某数据

注:UserProfile这块一定是model类名称

if UserProfile.objects.filter(email=user_name):
        return render(request, "register.html", {"register_form": register_form, "msg": "用户邮箱已存在"})