django增删改查

django对数据库进行增删改查

1.添加

	from django.shortcuts import render
	from django.http import HttpResponse
	from . import models
	
	def index(request):
	     s = models.School()
	     s.name = '吉利大学'
	     s.save()
	    return HttpResponse('OK')	

2.修改

	from django.shortcuts import render
	from django.http import HttpResponse
	from . import models
	
	def index(request):
	    s = models.School.objects.filter(name="吉利大学").first()
	    s.name = "吉利"
	    s.save()
	    return HttpResponse('OK')   

2.1 批量修改

	from django.shortcuts import render
	from django.http import HttpResponse
	from . import models
	
	def index(request):
		models.School.objects.filter().update(name='积云')
	    return HttpResponse('OK')   

3. 查询所有

	from django.shortcuts import render
	from django.http import HttpResponse
	from . import models
	
	def index(request):
		s = models.School.objects.all()
		print(s)
	    return HttpResponse('OK')   

3.1 条件查询

	from django.shortcuts import render
	from django.http import HttpResponse
	from . import models
	
	def index(request):
		# get获取一条数据
		s = models.School.objects.get(id=1)
		print(s)
		# filter 获取符合条件的数据
		s = models.School.objects.filter(name="吉利大学").first()
		print(s)
		return HttpResponse('OK')   

4. 删除

	from django.shortcuts import render
	from django.http import HttpResponse
	from . import models
	
	def index(request):
		# 删除一条数据
		s = models.School.objects.filter(name="吉利大学").first()
		s.delete()
		# 批量数据数据
		models.School.objects.filter().delete()
		return HttpResponse('OK')