Django实战，小网站实现增删改查

直接上代码

视图：

 1 from django.shortcuts import render,render_to_response, redirect
 2 from submit import models
 3 
 4 # Create your views here.
 5 
 6 
 7 def submit(request):
 8     if request.method == "POST":
 9         username = request.POST.get("username", None)
10         password = request.POST.get("password", None)
11         models.UserInfo.objects.create(username=username, password=password)
12     user_list = models.UserInfo.objects.all()
13     return render(request, "submit.html", {"data": user_list})
14 
15 
16 def search(request):
17     #if request.method == "POST":
18     username = request.GET.get("username", None)
19     results = models.UserInfo.objects.filter(username__icontains=username)
20 
21     return render(request, "search.html", {"result": results})
22 
23 
24 def delete(request):
25     if request.method == "GET":
26         nid = request.GET.get("id")
27         models.UserInfo.objects.filter(id=nid).delete()
28     return render(request, "submit.html")
29 
30 
31 def edit(request):
32     if request.method == "GET":
33         id = request.GET.get("id", None)
34         username = request.GET.get("username", None)
35         password = request.GET.get("password", None)
36         models.UserInfo.objects.filter(id=id).delete()
37     return render(request, "edit.html", {"username": username, "password": password})
View Code

数据库设计

1 from django.db import models
2 
3 # Create your models here.
4 
5 
6 class UserInfo(models.Model):
7     username = models.CharField(max_length="50")
8     password = models.CharField(max_length="50")

模板

submit.html

 1 <!DOCTYPE html>
 2 <html>
 3 <head lang="en">
 4     <meta charset="UTF-8">
 5     <title></title>
 6 </head>
 7 <body>
 8 <h1>添加数据</h1>
 9     <form action="/submit/" method="post">
10         <input type="text" name="username"/>
11         <input type="password" name="password"/>
12         <input type="submit" value="提交"/>
13 
14     </form>
15 <h1>查询数据</h1>
16     <h1>请输入用户名</h1>
17         <form action="/search/" method="get">
18             <input type="text" name="username"/>
19             <input type="submit" value="查询"/>
20         </form>
21 <h1>输出数据</h1>
22     <form action="/submit/" method="get">
23         <table border="1">
24             <thead>
25                 <td>ID</td>
26                 <td>用户名</td>
27                 <td>密码</td>
28                 <td>操作</td>
29                 {% for line in data %}
30                     <tr>
31                         <td>{{ line.id }}</td>
32                         <td>{{ line.username }}</td>
33                         <td>{{ line.password }}</td>
34                         <td>
35 
36                                 <a href="/edit?id={{ line.id }}&username={{ line.username }}&password={{ line.password }}">编辑</a>
37                                 <a href="/delete?id={{ line.id }}">删除</a>
38                         </td>
39                     </tr>
40                 {% endfor %}
41 </body>
42 </html>
submit.html

edit.html

 1 <!DOCTYPE html>
 2 <html xmlns="http://www.w3.org/1999/html">
 3 <head lang="en">
 4     <meta charset="UTF-8">
 5     <title></title>
 6 </head>
 7 <body>
 8     <h1>edit</h1>
 9     <form  action="/submit/" method="post">
10 
11         <h6>用户名</h6><input type="text" name="username" value={{ username }}>
12         <br/>
13         <h6>密码</h6><input type="text" name="password" value={{ password }}>
14         <br/>
15             <input type="submit" value=" 确认修改"/>
16 
17     </form>
18 </body>
19 </html>
edit.html
search.html
 1 <!DOCTYPE html>
 2 <html>
 3 <head lang="en">
 4     <meta charset="UTF-8">
 5     <title></title>
 6 </head>
 7 <body>
 8     <h1>请输入用户名</h1>
 9         <form action="/search/" method="post">
10             <input type="text" name="username"/>
11             <input type="submit" value="查询"/>
12         </form>
13     <h1>查询结果</h1>
14     <form action="/search/" method="get">
15         <table border="1">
16             <thead>
17                 <td>ID</td>
18                 <td>用户名</td>
19                 <td>密码</td>
20                 <td>操作</td>
21                 {% for rts in result %}
22                     <tr>
23                         <td>{{ rts.id }}</td>
24                         <td>{{ rts.username }}</td>
25                         <td>{{ rts.password }}</td>
26                         <td>
27 
28                                 <a href="/edit?id={{ rts.id }}&username={{ rts.username }}&password={{ rts.password }}">编辑</a>
29                                 <a href="/delete?id={{ rts.id }}">删除</a>
30                         </td>
31                     </tr>
32                 {% endfor %}
33             </thead>
34         </table>
35     </form>
36 </body>
37 </html>
search.html

路由：

url.py

前台页面

 

posted @ 2017-12-28 21:08  秋寻草  阅读(412)  评论(0)  编辑  收藏  举报