程序目录
Project-->urls.py
from django.contrib import admin
from django.conf.urls import url,include
urlpatterns = [
url(r'^admin/', admin.site.urls),
url(r'^cmdb/',include('app01.urls')),
# url(r'^monitor/',include('app02.urls')),
]
App01--->urls.py
from django.contrib import admin
from django.conf.urls import url
from app01 import views
urlpatterns = [
url(r'^login/', views.login),
url(r'^index/', views.index),
url(r'^user_info/', views.user_info),
url(r'^userdetail-(?P<nid>d+)/', views.user_detail),
url(r'^userdel-(?P<nid>d+)/', views.user_del),
url(r'^useredit-(?P<nid>d+)/', views.user_edit),
url(r'^orm/', views.orm),
]
App01--->views.py
from django.shortcuts import render,HttpResponse,redirect
from app01 import models
def orm(reqbuest):
# 创建表
# models.UserInfo.objects.create(username='root',password='123')
# dic={'username':'eric','password':'666666'}
# models.UserInfo.objects.create(**dic)
# 查询表
# result= models.UserInfo.objects.all()
#删除
# models.UserInfo.objects.filter(id='2').delete()
# 更改
# models.UserInfo.objects.filter(id='3').update(password='666666')
#外键 一对多
user_list=models.UserInfo.objects.create(
username='lucy',
password='12345',
email='sdssf@126.com',
test="sss",
# user_group=models.UserGroup.objects.filter(id=1).first()
user_group_id='1',
)
return HttpResponse('orm')
def login(request):
models.UserGroup.objects.create(caption="BA")
# models.UserGroup.objects.filter(uid='1').update(caption="CEO") 这种方法不会更新uptime
# obj=models.UserGroup.objects.filter(uid='1').first() 更新uptime用这种方法
# obj.caption="DBA"
# obj.save()
if request.method=="GET":
return render(request,'login.html')
elif request.method=="POST":
# 数据库中执行 select * from user where username='x' and password='x'
u=request.POST.get('user')
p=request.POST.get('pwd')
obj= models.UserInfo.objects.filter(username=u,password=p).first()
# count = models.UserInfo.objects.filter(username=u, password=p).count()
if obj:
return redirect('/cmdb/index/')
else:
return render(request,'login.html')
else:
return redirect('/index/')
def index(request):
return render(request,'index.html')
def user_info(request):
if request.method=="GET":
user_list= models.UserInfo.objects.all()
group_list=models.UserGroup.objects.all()
# for row in user_list:
# print(row.id,row.user_group.uid)
# print(row.user_group.caption)
# print(user_list.query)
# QuerySet [obj(id,username,email,user_group_id,user_group(uid,caption)),obj]
return render(request,'user_info.html',{'User_List':user_list,'Group_List':group_list})
elif request.method=="POST":
u=request.POST.get('user')
p=request.POST.get('pwd')
models.UserInfo.objects.create(username=u,password=p)
return redirect('/cmdb/user_info/')
def user_detail(request,nid):
obj=models.UserInfo.objects.filter(id=nid).first()
# models.UserInfo.objects.get(id=nid) 如果没有数据会报错
return render(request,'user_detail.html',{'OBJ':obj})
def user_del(request,nid):
models.UserInfo.objects.filter(id=nid).delete()
return redirect('/cmdb/user_info/')
def user_edit(request,nid):
if request.method=="GET":
obj=models.UserInfo.objects.filter(id=nid).first()
return render(request,'user_edit.html',{'OBJ':obj})
elif request.method=="POST":
nid=request.POST.get('id')
u=request.POST.get('username')
p=request.POST.get('password')
models.UserInfo.objects.filter(id=nid).update(username=u,password=p)
return redirect('/cmdb/user_info/')
App01-->models.py
from django.db import models
#app01_userinfo
class UserInfo(models.Model):
# id列，自增，主键
# 用户名列，字符串类型，指定长度
# 数据类型:数字 时间 二进制
username=models.CharField(max_length=64,blank=True,verbose_name="姓名")
password=models.CharField(max_length=60,error_messages={'required':'密码'})
email=models.CharField(max_length=32,help_text="邮件")
test=models.GenericIPAddressField(max_length=32,null=True)
# gender=models.CharField(max_length=64,null=True)
user_type_choice=(
(1,'super user'),
(2,'normal user'),
(3,'normal normal user'),
)
user_type_id=models.IntegerField(choices=user_type_choice,default=1)
#user_group_id 数字
user_group=models.ForeignKey("UserGroup",to_field='uid',default=1,on_delete=models.CASCADE)
# 报 __init__() missing 1 required positional argument: 'on_delete'
# 在外键值的后面加上 on_delete = models.CASCADE
# user_group是UserGroup的一个对象
# uer_list=models.UserInfo.objects.all()
# for row in uer_list:
# print(row.user_group_id)
# print(row.user_group.uid)
# print(row.user_group.caption)
class UserGroup(models.Model):
uid=models.AutoField(primary_key=True)
caption=models.CharField(max_length=64)
ctime=models.DateTimeField(auto_now_add=True,null=True)
uptime=models.DateTimeField(auto_now=True,null=True)
App01-->admin.py
from django.contrib import admin
# Register your models here.
from app01 import models
admin.site.register(models.UserInfo)
# 在app的admin.py加上这两句具有admin功能
Templates-->login.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form action="/cmdb/login/" method="post" enctype="multipart/form-data">
<p>
<input type="text" name="user" placeholder="用户名">
</p>
<p>
<input type="password" name="pwd" placeholder="密码">
</p>
<p>
<input type="submit" value="提交">
</p>
</form>
</body>
</html>
Templates-->index.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<style>
body{
margin:0;
}
.menu{
display: block;
padding: 5px;
}
</style>
</head>
<body>
<div style="height: 48px;background-color: black;color: white;">
</div>
<div>
<div style="position: absolute;top:48px;bottom: 0;left: 0;width: 500px;background-color: brown">
<a class="menu" href="/cmdb/user_info/">用户管理</a>
<a class="menu" href="/cmdb/user_group/">用户组管理</a>
</div>
<div style="position: absolute;top:48px;left:520px;bottom: 0;right: 0;overflow: auto">
</div>
</div>
</body>
</html>
Templates-->user_info.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<style>
body{
margin:0;
}
.menu{
display: block;
padding: 5px;
}
</style>
</head>
<body>
<div style="height: 48px;background-color: black;color: white;">
</div>
<div>
<div style="position: absolute;top:48px;bottom: 0;left: 0;width: 500px;background-color: brown">
<a class="menu" href="/cmdb/user_info/">用户管理</a>
<a class="menu" href="/cmdb/user_group/">用户组管理</a>
</div>
<div style="position: absolute;top:48px;left: 520px;bottom: 0;right: 0;overflow: auto">
<h3>添加用户</h3>
<form method="POST" action="/cmdb/user_info/">
<input type="text" name="user">
<input type="text" name="pwd">
<select name="group_id">
{% for item in Group_List %}
<option value="{{ item.uid }}">{{ item.caption }}</option>
{% endfor %}
</select>
<input type="submit" value="添加">
</form>
<h3>用户列表</h3>
<ul>
{% for row in User_List %}
<li><a href="/cmdb/userdetail-{{ row.id }}/">{{ row.username }}</a> |
<span>用户组：{{ row.user_group.caption }}</span> |
<a href="/cmdb/userdel-{{ row.id }}/">删除</a> |
<a href="/cmdb/useredit-{{ row.id }}/">编辑</a> |
</li>
{% endfor %}
</ul>
<ul>
</ul>
</div>
</div>
</body>
</html>
Templates-->user_detail.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<style>
body{
margin:0;
}
.menu{
display: block;
padding: 5px;
}
</style>
</head>
<body>
<div style="height: 48px;background-color: black;color: white;">
</div>
<div>
<div style="position: absolute;top:48px;bottom: 0;left: 0;width: 500px;background-color: brown">
<a class="menu" href="/cmdb/user_info/">用户管理</a>
<a class="menu" href="/cmdb/user_group/">用户组管理</a>
</div>
<div style="position: absolute;top:48px;left: 520px;bottom: 0;right: 0;overflow: auto">
<h1>用户详细信息</h1>
<h5>id: {{ OBJ.id }}</h5>
<h5>username: {{ OBJ.username }}</h5>
<h5>password: {{ OBJ.password }}</h5>
</div>
</div>
</body>
Templates-->user_edit.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<style>
body{
margin:0;
}
.menu{
display: block;
padding: 5px;
}
</style>
</head>
<body>
<div style="height: 48px;background-color: black;color: white;">
</div>
<div>
<div style="position: absolute;top:48px;bottom: 0;left: 0;width: 500px;background-color: brown">
<a class="menu" href="/cmdb/user_info/">用户管理</a>
<a class="menu" href="/cmdb/user_group/">用户组管理</a>
{# <a class="menu"></a>#}
</div>
<div style="position: absolute;top:48px;left:520px;bottom: 0;right: 0;overflow: auto">
<h1>编辑用户</h1>
<form method="post" action="/cmdb/useredit-{{ OBJ.id }}/">
<input style="display: none" type="text" name="id" value="{{ OBJ.id }}"/>
<input type="text" name="username" value="{{ OBJ.username }}"/>
<input type="text" name="password" value="{{ OBJ.password }}"/>
<input type="submit" value="提交">
</form>
</div>
</div>
</body>
</html>