5django数据库-增删改查

最新推荐文章于 2024-07-28 19:10:22 发布

chiweimin3126

最新推荐文章于 2024-07-28 19:10:22 发布

阅读量80

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/u/4036782/blog/2963110

版权

开局运行-配置数据库

python manage.py makemigrations
python manage.py migrate

res=Book.objects.get(bid=id)  结果出来是对象

Book.objects.filter(bid=id).delete() 结果出来是列表+对象

res=Book.objects.exclude(bid=id)  结果出来是列表+对象

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<form method="post" action="/bookd/">
    {% csrf_token %}
    <input type="text" name="bname"><br>
    <button type="submit">添加书本</button>
</form>
<p> ***********************************</p>

<form method="post" action="/chaxun/">
{% csrf_token %}
<button type="submit" >查询全部</button>
{% for ii in booklist %}

    <br>{{ ii.bid }}
    {{ ii.bname }}<br>

{% endfor %}
</form>
<p> ***********************************</p>

<form method="post" action="/chaxun2/">
{% csrf_token %}
id：<input type="text" name="bid"><br>
    <button type="submit">条件查询</button>

    <br>{{  book.bid }}
    {{  book.bname }}<br>
</form>

<p> ***********************************</p>

<form method="post" action="/shanchu/">
{% csrf_token %}
ID:<input type="text" name="bid"><br>
    <button type="submit">删除</button>

</form>

<p> ***********************************</p>

<form method="post" action="/xiugai/">
{% csrf_token %}
ID：<input type="text" name="bid"><br>
   名字： <input type="text" name="name"><br>
    <button type="submit">修改名字</button>

</form>



</body>
</html>

def bookd(request):
    if request.POST:
        name=request.POST.get('bname')
        book=Book(bname=name)
        book.save()
        return HttpResponse("<script>alert('成功')</script>")
    else:
        return render(request,'bookd.html')
def chaxun(request):
    if request.POST:
        res=Book.objects.all()
        print(res)
        content={}
        content["booklist"]=res
        return render(request,'bookd.html',content)
    else:
        return render(request,'bookd.html')

def chaxun2(request):
    if request.POST:
        id=request.POST.get('bid')
        res=Book.objects.get(bid=id)
        content2 = {}
        content2["book"] = res
        return render(request, 'bookd.html', content2)
    else:
        return render(request,'bookd.html')

def shanchu(request):
    if request.POST:
        id=request.POST.get('bid')
        Book.objects.filter(bid=id).delete()

        return HttpResponse("<script>alert('删除成功')</script>")
    else:
        return render(request,'bookd.html')

def xiugai(request):
    if request.POST:
        id=request.POST.get('bid')
        name = request.POST.get('name')
        Book.objects.filter(bid=id).update(bname=name)

        return HttpResponse("<script>alert('修改成功')</script>")
    else:
        return render(request,'bookd.html')

def chaxun3(request):
    if request.POST:
        id=request.POST.get('bid')
        res=Book.objects.exclude(bid=id)
        print(res)
        content2 = {}
        content2["booklists"] = res
        return render(request, 'bookd.html', content2)
    else:
        return render(request,'bookd.html')

转载于:https://my.oschina.net/u/4036782/blog/2963110

chiweimin3126

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
5django数据库-增删改查

开局运行-配置数据库 python manage.py makemigrations python manage.py migrate res=Book.objects.get(bid=id) 结果出来是对象 Book.objects.filter(bid=id).delete(...
复制链接

扫一扫