6django-数据库增删改查

最新推荐文章于 2024-07-29 14:37:54 发布

chiweimin3126

最新推荐文章于 2024-07-29 14:37:54 发布

阅读量74

点赞数

文章标签： python 数据库

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

版权

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<h2><a href="/show/">部门管理</a></h2>
</body>
</html>
****************************************************************
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>部门表</title>
    <style>

    </style>

</head>
<body>

<h2>部门表</h2>
<table border="1" width="600">
    <tr>
        <td>部门编号</td>
        <td>部门名称</td>
        <td>部门简介</td>
        <td>操作</td>
    </tr>
    {% for ii in deptlist %}
    <tr>
        <td>{{ ii.deptno }}</td>
        <td>{{ ii.dname }}</td>
        <td>{{ ii.djianjie }}</td>
        <td><a href="/xiugai/{{ ii.deptno }}">修改</a>/<a href="/shanchu/{{ ii.deptno }}">删除</a></td>
    </tr>
        {% empty %}
        <tr>
        <td colspan="4">内容为空</td>

    </tr>

    {% endfor %}
</table>
<br>
<form method="get" action="/app/">
    {% csrf_token %}
    <button type="submit">添加数据</button>
</form>

</body>
</html>
***********************************************************************************
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<h2>添加部门</h2>
<form method="post" action="/app/">
    {% csrf_token %}

    部门名称：<input type="text" name="names"><br>
    部门简介：<input type="text" name="jianjie"><br>
    <button type="submit">提交</button>
</form>
</body>
</html>
***************************************************************************************
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<form method="post" action="/xiugai/{{ xiu.deptno }}">
    {% csrf_token %}

    部门名称：<input type="text" name="names" value="{{ xiu.dname }}"><br>
    部门简介：<input type="text" name="jianjie" value="{{ xiu.djianjie }}"><br>
    <button type="submit">提交</button>
</form>
</body>
</html>

from django.shortcuts import render
from app.models import Bumen
from django.http import HttpResponseRedirect

# Create your views here.
def index(request):
    return render(request,'index.html')

def show(request):
    ref=Bumen.objects.all()
    content={}
    content['deptlist']=ref
    return render(request,'bumen.html',content)

def app(request):
    if request.POST:
        name = request.POST.get('names')
        jianjie = request.POST.get('jianjie')
        Bumen.objects.create(dname=name,djianjie=jianjie)
        print('添加成功')
        return HttpResponseRedirect('/show/')
    else:
        return render(request,'app.html')

def shanchu(request,deptno):
    #Bumen.objects.filter(deptno=deptno).delete()
    Bumen.objects.get(deptno=deptno).delete()
    return HttpResponseRedirect('/show/')


def xiugai(request,deptno):
    if request.POST:
        name=request.POST.get('names')
        jianjie=request.POST.get('jianjie')
        Bumen.objects.filter(deptno=deptno).update(dname=name,djianjie=jianjie)
        return HttpResponseRedirect('/show/')
    else:
        print(deptno)
        bumen=Bumen.objects.get(deptno=deptno)
        print(bumen)
        content={}
        content['xiu']=bumen
        return render(request,'xiugai.html',content)





*******************************************
from django.db import models

# Create your models here.
class Bumen(models.Model):
    deptno=models.AutoField(primary_key=True)
    dname=models.CharField(max_length=30)
    djianjie = models.CharField(max_length=50)
***********************************************
from app.views import show,index,app,shanchu,xiugai

urlpatterns = [
    path('admin/', admin.site.urls),
path('index/', index),
path('show/', show),
path('app/', app),
path('shanchu/<str:deptno>', shanchu),
path('xiugai/<str:deptno>', xiugai),

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