viwes
def addbook(req):
# b=Book(name='小王子', price=55, author='mistory',pub_data='2020-02-02')
# b.save()
Book.objects.create(name='王子', price=5, author='myself', pub_data='2020-2-02')
# Book.objects.create(**dic)
return HttpResponse('添加成功')
def update(req):
#Book.objects.filter(name='小王子').update(price=123)
b=Book.objects.get(name='王子')
b.price=789
b.save()
#update是filter返回的组调用的方法
return HttpResponse('修改成功')
def delete(req):
Book.objects.filter(name='nicai').delete()
return HttpResponse('删除成功')
def select(req):
book_list=Book.objects.all()
#book_list=Book.objects.all()[::-1]
# book_list=Book.objects.get(id=2)#只能去除一条记录时才不报错
ret=Book.objects.filter(author='wxq').values('name','price')
#ret=Book.objects.filter(author='wxq').values_list('name','price')#列表类型
print(ret)
#bool_list=Book.objects.fileter(price__gt=50).values(name','price')#价格大于50
#(name_contain='p')#包含
return render(req,'index.html',{'book_list':book_list})
html
<body>
<div class="outer">
<div class="head">标题</div>
<div class="content"></div>
<a href="/addbook/">添加</a>
<a href="/update/">修改</a>
<a href="/delete/">删除</a>
<a href="/select/">查询</a>
</div>
<hr>
<div class="queryresult">
{% for book in book_list%}
<div>
<P>{{ book.name }}{{ book.author }}{{ book.price }}</P>
</div>
{% endfor %}
</div>
</body>