登陆可实现PC、移动端同步进度.
5. 项目实战后台之会员管理
- 本页面完成项目后台管理的用户模块操作
(1). 用户信息数据表:users
- 在数据库
shopdb
中创建users表,若此表已存在请跳过
CREATE TABLE `users`(
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(32) NOT NULL,
`name` varchar(16) DEFAULT NULL,
`password` char(32) NOT NULL,
`sex` tinyint(1) unsigned NOT NULL DEFAULT '1',
`address` varchar(255) DEFAULT NULL,
`code` char(6) DEFAULT NULL,
`phone` varchar(16) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`state` tinyint(1) unsigned NOT NULL DEFAULT '1',
`addtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
)ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
(2). 定义模型Model类
- 进入
common
应用目录中编辑:myobject/common/models.py
模型文件
from django.db import models
from datetime import datetime
#用户信息模型
class Users(models.Model):
username = models.CharField(max_length=32)
name = models.CharField(max_length=16)
password = models.CharField(max_length=32)
sex = models.IntegerField(default=1)
address = models.CharField(max_length=255)
code = models.CharField(max_length=6)
phone = models.CharField(max_length=16)
email = models.CharField(max_length=50)
state = models.IntegerField(default=1)
addtime = models.DateTimeField(default=datetime.now)
def toDict(self):
return {'id':self.id,'username':self.username,'name':self.name,'password':self.password,'address':self.address,'phone':self.phone,'email':self.email,'state':self.state,'addtime':self.addtime}
class Meta:
db_table = "users" # 更改表名
(3). 项目urls路由信息配置
- 打开根路由文件:myobject/myadmin/urls.py路由文件,编辑路由配置信息
from django.conf.urls import url
from myadmin.views import index,users
urlpatterns = [
# 后台首页
url(r'^$', index.index, name="myadmin_index"),
# 后台用户管理
url(r'^users$', users.index, name="myadmin_users_index"),
url(r'^users/add$', users.add, name="myadmin_users_add"),
url(r'^users/insert$', users.insert, name="myadmin_users_insert"),
url(r'^users/del/(?P<uid>[0-9]+)$', users.delete, name="myadmin_users_del"),
url(r'^users/edit/(?P<uid>[0-9]+)$', users.edit, name="myadmin_users_edit"),
url(r'^users/update/(?P<uid>[0-9]+)$', users.update, name="myadmin_users_update"),
]
(4). 编辑视图文件
- 创建:myobject/myadmin/views/users.py 视图文件,并进行编辑
from django.shortcuts import render
from django.http import HttpResponse
from common.models import Users
from datetime import datetime
# 浏览会员
def index(request):
# 执行数据查询,并放置到模板中
list = Users.objects.all()
context = {"userslist":list}
#return HttpResponse(list)
return render(request,'myadmin/users/index.html',context)
# 会员信息添加表单
def add(request):
return render(request,'myadmin/users/add.html')
#执行会员信息添加
def insert(request):
try:
ob = Users()
ob.username = request.POST['username']
ob.name = request.POST['name']
#获取密码并md5
import hashlib
m = hashlib.md5()
m.update(bytes(request.POST['password'],encoding="utf8"))
ob.password = m.hexdigest()
ob.sex = request.POST['sex']
ob.address = request.POST['address']
ob.code = request.POST['code']
ob.phone = request.POST['phone']
ob.email = request.POST['email']
ob.state = 1
ob.addtime = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
ob.save()
context = {'info':'添加成功!'}
except Exception as err:
print(err)
context = {'info':'添加失败!'}
return render(request,"myadmin/info.html",context)
# 执行会员信息删除
def delete(request,uid):
try:
ob = Users.objects.get(id=uid)
ob.delete()
context = {'info':'删除成功!'}
except:
context = {'info':'删除失败!'}
return render(request,"myadmin/info.html",context)
# 打开会员信息编辑表单
def edit(request,uid):
try:
ob = Users.objects.get(id=uid)
context = {'user':ob}
return render(request,"myadmin/users/edit.html",context)
except Exception as err:
print(err)
context = {'info':'没有找到要修改的信息!'}
return render(request,"myadmin/info.html",context)
# 执行会员信息编辑
def update(request,uid):
try:
ob = Users.objects.get(id=uid)
ob.name = request.POST['name']
ob.sex = request.POST['sex']
ob.address = request.POST['address']
ob.code = request.POST['code']
ob.phone = request.POST['phone']
ob.email = request.POST['email']
ob.state = request.POST['state']
ob.save()
context = {'info':'修改成功!'}
except Exception as err:
print(err)
context = {'info':'修改失败!'}
return render(request,"myadmin/info.html",context)
(5). 编写模板文件
- 5.1. 后台用户信息浏览模板:/templates/myadmin/users/index.html
{% extends "myadmin/base.html" %}
{% block mainbody %}
<h4>
会员信息管理
</h4>
<table class="table table-bordered table-striped">
<thead>
<tr>
<th>账号</th>
<th>真实姓名</th>
<th>性别</th>
<th>邮箱</th>
<th>注册时间</th>
<th>状态</th>
<th>操作</th>
</tr>
</thead>
<tbody>
{% for vo in userslist %}
<tr>
<td>{{ vo.username }}</td>
<td>{{ vo.name }}</td>
<td>{% if vo.sex == 1 %}男{% else %}女{% endif %}</td>
<td>{{ vo.email }}</td>
<td>{{ vo.addtime|date:'Y-m-d H:i:s' }}</td>
<td>{{ vo.state }}</td>
<td>
<a href="{% url 'myadmin_users_del' vo.id %}" class="view-link">删除</a>
<a href="{% url 'myadmin_users_edit' vo.id %}" class="view-link">编辑</a>
</td>
</tr>
{% endfor %}
</tbody>
</table>
<div class="pagination">
<ul>
<li class="disabled">
<a href="#">«</a>
</li>
<li class="active">
<a href="#">1</a>
</li>
<li>
<a href="#">2</a>
</li>
<li>
<a href="#">3</a>
</li>
<li>
<a href="#">4</a>
</li>
<li>
<a href="#">»</a>
</li>
</ul>
</div>
{% endblock %}
- 5.3. 后台用户信息添加模板:/templates/myadmin/users/add.html
{% extends "myadmin/base.html" %}
{% block mainbody %}
<h3>
会员信息管理
</h3>
<form id="edit-profile" action="{% url 'myadmin_users_insert' %}" class="form-horizontal" method="post">
{% csrf_token %}
<fieldset>
<legend>添加会员信息</legend>
<div class="control-group">
<label class="control-label" for="input01">账号:</label>
<div class="controls">
<input type="text" name="username" class="input-xlarge" id="input01" value="" />
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">密码:</label>
<div class="controls">
<input type="password" name="password" class="input-xlarge" id="input01"/>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">重复密码:</label>
<div class="controls">
<input type="password" name="repassword" class="input-xlarge" id="input01"/>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">真实姓名:</label>
<div class="controls">
<input type="text" name="name" class="input-xlarge" id="input01"/>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">性别:</label>
<div class="controls">
<input type="radio" name="sex" class="input-xlarge" id="input01" value="1" /> 男
<input type="radio" name="sex" class="input-xlarge" id="input01" value="0" /> 女
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">地址:</label>
<div class="controls">
<input type="text" name="address" class="input-xlarge" id="input01"/>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">邮编:</label>
<div class="controls">
<input type="text" name="code" class="input-xlarge" id="input01"/>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">电话:</label>
<div class="controls">
<input type="text" name="phone" class="input-xlarge" id="input01"/>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">email邮箱:</label>
<div class="controls">
<input type="text" name="email" class="input-xlarge" id="input01"/>
</div>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-primary">添加</button> <button type="reset" class="btn">重置</button>
</div>
</fieldset>
</form>
{% endblock %}
- 5.4. 后台用户信息编辑模板:/templates/myadmin/users/edit.html
{% extends "myadmin/base.html" %}
{% block mainbody %}
<h3>
会员信息管理
</h3>
<form id="edit-profile" action="{% url 'myadmin_users_update' user.id %}" class="form-horizontal" method="post">
{% csrf_token %}
<fieldset>
<legend>编辑会员信息</legend>
<div class="control-group">
<label class="control-label" for="input01">账号:</label>
<div class="controls">
{{ user.username }}
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">真实姓名:</label>
<div class="controls">
<input type="text" name="name" class="input-xlarge" id="input01" value="{{ user.name }}" />
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">性别:</label>
<div class="controls">
<input type="radio" name="sex" class="input-xlarge" id="input01" value="1"
{% if user.sex == 1 %}checked{% endif %} /> 男
<input type="radio" name="sex" class="input-xlarge" id="input01" value="0"
{% if user.sex == 0 %}checked{% endif %} /> 女
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">地址:</label>
<div class="controls">
<input type="text" name="address" class="input-xlarge" id="input01" value="{{ user.address }}" />
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">邮编:</label>
<div class="controls">
<input type="text" name="code" class="input-xlarge" id="input01" value="{{ user.code }}" />
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">电话:</label>
<div class="controls">
<input type="text" name="phone" class="input-xlarge" id="input01" value="{{ user.phone }}" />
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">email邮箱:</label>
<div class="controls">
<input type="text" name="email" class="input-xlarge" id="input01" value="{{ user.email }}" />
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">状态:</label>
<div class="controls">
<input type="radio" name="state" class="input-xlarge" id="input01" value="0"
{% if user.state == 0 %}checked{% endif %} /> 管理员
<input type="radio" name="state" class="input-xlarge" id="input01" value="1"
{% if user.state == 1 %}checked{% endif %} /> 启用会员
<input type="radio" name="state" class="input-xlarge" id="input01" value="2"
{% if user.state == 2 %}checked{% endif %} /> 禁用用户
</div>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-primary">保存</button> <button type="reset" class="btn">重置</button>
</div>
</fieldset>
</form>
{% endblock %}
⑥ 运行测试
- 在项目根目录下启动服务,并使用浏览器访问测试:http://localhost:8000/myadmin
[root@localhost myobject]# pwd
/python/myobject
[root@localhost myobject]# ls
manage.py myadmin myobject myweb static templates
[root@localhost myobject]# python3 manage.py runserver
Performing system checks...
System check identified no issues (0 silenced).
April 06, 2018 - 14:29:36
Django version 1.11, using settings 'myobject.settings'
Starting development server at http://127.0.0.1:8000/
Quit the server with CONTROL-C.
^C[root@localhost myobject]#
- 还没有人评论,欢迎说说您的想法!