Django学习7:用户管理（连接数据库）

最新推荐文章于 2023-06-30 15:26:09 发布

<编程路上>

最新推荐文章于 2023-06-30 15:26:09 发布

阅读量200

点赞数

分类专栏： Django 文章标签： django 学习 python

本文链接：https://blog.csdn.net/weixin_43788986/article/details/125646900

版权

Django 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

数据库设置看：数据库连接

urls.py

from django.urls import path
from app1 import views

urlpatterns = [
    path('index/', views.index),
    path('something/', views.something),
    path('login/',views.login),
    # 案例：用户管理
    path('user/list/', views.user_list),
    path('user/add/', views.user_add),
    path('user/delete/', views.user_delete),

]

views.py

from django.shortcuts import render, HttpResponse, redirect
from app1 import models

def user_list(request):
    # 1.获取数据库中所有的用户信息
    data_list = models.User.objects.all()
    # 2.渲染，返回给用户
    return render(request, "user_list.html", {"data_list": data_list})


def user_add(request):
    if request.method == "GET":
        return render(request, 'user_add.html')
    # 获取用户提交的数据
    user = request.POST.get("user")
    pwd = request.POST.get("pwd")
    age = request.POST.get("age")
    sex = request.POST.get("sex")
    phone = request.POST.get("phone")
    # 添加到数据库
    models.User.objects.create(name=user, password=pwd, age=age,sex=sex,phone=phone)
    # 自动跳转
    # return redirect("http://127.0.0.1:8000/info/list/")
    return redirect("/user/list/")

def user_delete(request):
    id = request.GET.get('id')
    models.User.objects.filter(id=id).delete()
    return redirect("/user/list/")

user_list.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<h1>USER列表</h1>

<a href="/user/add/">用户添加</a>

<table border="1">
    <thead>
    <tr>
        <th>姓名</th>
        <th>密码</th>
        <th>年龄</th>
        <th>性别</th>
        <th>手机号</th>
        <th>删除</th>
    </tr>
    </thead>
    <tbody>
    {% for obj in data_list %}
        <tr>
            <td>{{ obj.name }}</td>
            <td>{{ obj.password }}</td>
            <td>{{ obj.age }}</td>
            <td>{{ obj.sex }}</td>
            <td>{{ obj.phone }}</td>
            <td>
                <a href="/info/delete/?id={{ obj.id }}">用户删除</a>
            </td>
        </tr>
    {% endfor %}
    </tbody>
</table>


</body>
</html>

user_add.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<h1>添加用户</h1>
<form method="post">
    {% csrf_token %}
    <input type="text" name="user" placeholder="用户名">
    <input type="text" name="pwd" placeholder="密码">
    <input type="text" name="age" placeholder="年龄">
    <input type="text" name="sex" placeholder="性别">
    <input type="text" name="phone" placeholder="手机号">
    <input type="submit" value="提交">
</form>

</body>
</html>