## ORM的增刪改查 ### 添加數據 ``` views.py -------------------------------------------------------------------- from django.shortcuts import render from django.db import connection from .models import Book from django.http import HttpResponse def add_book(request): book = Book(name="Python",author="JR",price=78) book.save() return HttpResponse("書籍添加成功") ``` ### 查詢數據 ``` 1.根據主鍵進行查找 book = Book.objects.get(pk=1) print(book) 2.根據其他條件來查找 book = Book.objects.filter(name="Python") print(book) 3.查詢所有 book = Book.objects.all() ``` ### 刪除數據 ``` book = Book.objects.get(pk=1) book.delete() ``` ### 修改數據 ``` book = Book.objects.get(pk=2) book.price = 200 book.save() ```