Django 数据库操作

查询

models.UserInfo.objects.all()
models.UserInfo.objects.all().values('user') #只取user列
models.UserInfo.objects.all().values_list('id','user') #取出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='zj').update(pwd='520')

obj = models.UserInfo.objects.get(user='zj')
obj.pwd = '520'
obj.save()

删除

models.UserInfo.objects.filter(user='yangmv').delete()