Djiango连接mysql增删查改操作 第一步、创建Djiango项目，具体操作 https://blog.csdn.net/weixin_43843911/article/details/90346021 第二步、编写操作代码 1.在项目下找到views.py编写
from django.shortcuts import render, redirect from web.models import User # 页面查询用户信息 def queryUsers(request): # 到数据库查询用户信息 us = User.objects.all() # 将数据发给页面 context = {"ls": us} return render(request, "users.html", context) # 打开添加页面 def openAdd(request): return render(request, "userAdd.html") # 保存数据 def saveUser(request): username = request.GET.get('username') password = request.GET.get('password') User.objects.create(username=username, password=password) return redirect("/web/queryUsers") # 打开修改页面 def openEdit(request): id = request.GET.get('id') # 到数据库查询用户信息 m = User.objects.filter(id=id).first() # 将数据发给页面 context = {"m": m} return render(request, "userEdit.html", context) # 更新数据 def updateUser(request): id = request.GET.get('id') username = request.GET.get('username') password = request.GET.get('password') User.objects.filter(id=id).update(username=username, password=password) return redirect("/web/queryUsers") # 删除数据 def deleteUser(request): id = request.GET.get('id') User.objects.filter(id=id).delete() return redirect("/web/queryUsers")第三步、在templates下新建下列html文件 userAdd.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>注册</title> </head> <body> <form action="/web/saveUser" method="GET"> {% csrf_token %} username：<input name="username"><br> password：<input name="password"><br> <input type="submit" value="添加"> </form> </body> </html>userEdit.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>注册</title> </head> <body> <form action="/web/updateUser" method="GET"> {% csrf_token %} <input type="hidden" name="id" value="{{ m.id }}"> 姓名：<input name="username" value="{{ m.username }}"><br> 密码：<input name="password" value="{{ m.password }}"><br> <input type="submit" value="提交"> </form>users.html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Users</title> </head> <body> <a href="/web/openUserAdd">添加</a> <table border="1"> <thead> <tr> <th>ID</th> <th>姓名</th> <th>密码</th> <th>操作</th> </tr> </thead> <tbody> {% for row in ls %} <tr> <td>{{ row.id }}</td> <td>{{ row.username }}</td> <td>{{row.password}}</td> <a href="/web/deleteUser?id={{ row.id }}">删除</a> | <a href="/web/userEdit?id={{ row.id }}">编辑</a> </td> </tr> {% endfor %} </tbody> </table> </body> </html>第四步、设置路由 在目录下编写urls.py
from django.contrib import admin from django.urls import path,include urlpatterns = [ path('admin/', admin.site.urls), path('web/',include('web.adminurls')), ]1.在项目下新建adminurls.py
from django.urls import path from web import views urlpatterns = [ path('', views.queryUsers), path('queryUsers/', views.queryUsers), path('openUserAdd/', views.openAdd), path('saveUser/', views.saveUser), path('openEdit/', views.openEdit), path('updateUser/', views.updateUser), path('deleteUser/', views.deleteUser), ]2.运行项目 项目运行成功 3.在浏览器输入localhost:8000/web/
