Django操作数据库——增删改查

做数据库操作前，需要将视图创建好，这里就不再赘述

数据库的操作写在views.py中，首先要导入创建好的ORM模型

# views.py
from django.http import HttpResponse
from .models import Book

增加数据

# views.py
def add_book(request):
	book = Book(name='xxx', author='xxx', price='xxx')
	book.save()
	return HttpResponse('add success')

查找数据

# views.py
def search_book(request):
	# get返回的是一条具体数据
	book1 = Book.objects.get(id=1)
	book2 = Book.objects.get(pk=1)   # 当不知道主键时，可以指定pk来获取主键
	
	# filter返回的是一个数据集合
	book3 = Book.objects.filter(id=1)
	book4 = Book.objects.filter(id=1)[0]
	
	# 获取所有的数据
	book5 = Book.objects.all()
	print(book2)
	return HttpResponse('Search success')

删除数据

要先查后删

# views.py
def delete_book(request):
	# 先查后删
	book = Book.objects.get(id=1)
	book.delete()
	return HttpResponse('Delete success')

更新数据

# views.py
def update_book(request):
	# 先查后更
	book = Book.objects.get(id=1)
	book.price = 32.44
	book.save()
	return HttpResponse('Update success')