Django框架 models模块使用

#启动数据库（sqlite3）

　dos下：

　　python manage.py makemigrations

　　python manage.py migrate

　#views　

from django.shortcuts import render
from apppp.models import Book
from django.http import HttpResponse
# Create your views here.
def goindex(request):
    return render(request,'index.html')


#添加数据
def addBook(request):
    if request.POST:
        #接收数据
        name=request.POST.get('bname')
        #写入数据库
        book=Book(bname=name)
        book.save()
        return HttpResponse('<script>alert("添加成功")</script>')
    else:
        return render(request,'insert.html')

#查询数据
def chaxun(request):
    #查询数据
    res=Book.objects.all()
    content={}
    content['chaxunkey']=res
    return render(request,'chaxun.html',content)

#根据指定字段查询数据
#根据编号查询
def NOchaxun(request):
    #接收数据
    id=request.GET.get('id')
    #查询数据
    res=Book.objects.get(bid=id)
    content={}
    content['NOchaxunkey']=res
    return render(request,'NOchaxun.html',content)

#删除业务（根据条件）
def deletedemo(request,id):
    #删除数据
    Book.objects.filter(bid=id).delete()
    return HttpResponse('<script>alert("删除成功")</script>')

#修改
def xiugai(request,id,name):
    #修改数据    Book.objects.filter(bid=id).update(bname=name)    return HttpResponse('<script>alert("修改成功")</script>')




#models

from django.db import models

# Create your models here.
#继承models
class Book(models.Model):
    #设置数据表字段
    bid=models.AutoField(primary_key=True)
    bname=models.CharField(max_length=30)


#urls

from django.contrib import admin
from django.urls import path
from apppp.views import goindex,addBook,chaxun,NOchaxun,deletedemo,xiugai

urlpatterns = [
    path('admin/', admin.site.urls),
    path('index/',goindex),
    path('addBook/',addBook),
    path('chaxun/',chaxun),
    path('NOchaxun/',NOchaxun),
    path('deletedemo/<int:id>/',deletedemo),
    path('xiugai/<int:id>/<str:name>/',xiugai),
    ]

#index.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<h3>[1]数据库添加操作</h3>
<a href="/addBook/">添加</a>

<h3>[2]数据库查询操作</h3>
<a href="/chaxun/">查询</a>

<h3>[3]数据库条件查询操作</h3>
<a href="/NOchaxun/?id=4">条件查询</a>

<h3>[4]数据库条件删除操作</h3>
<a href="/deletedemo/1/">条件删除</a>

<h3>[5]数据库条件修改操作</h3>
<a href="/xiugai/8/中软卓越/">条件修改</a>
</body>
</html>

#insert.html

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

#chaxun.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>chaxun</title>
</head>
<body>
    {% for foo in chaxunkey %}
        {{ foo.bid }}-{{ foo.bname }}<br/>
    {% endfor %}
<br/>
<table border="1">
    <tr>
        <td>编号</td>
        <td>名称</td>
    </tr>
    {% for foo in chaxunkey %}
    <tr>
        <td>{{ foo.bid }}</td>
        <td>{{ foo.bname }}</td>
    </tr>
        {% empty %}
        <tr>
            <td colspan="2">暂无数据</td>
        </tr>
    {% endfor %}

</table>
</body>
</html>

#NOchaxun.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>按编号查询</title>
</head>
<body>
<h2>{{ NOchaxunkey }}</h2>
数据1:{{ NOchaxunkey.bid }}<br/>
数据2:{{ NOchaxunkey.bname }}
</body>
</html>