1、创建靓号数据库
class PrettyNum(models.Model):
"靓号表"
mobile=models.CharField(verbose_name="手机号",max_length=11)
# 允许为空 null=True,blank= True
price=models.IntegerField(verbose_name="价格",default=0)
level_choices=(
(1, '1级'),
(2, '2级'),
(3, '3级'),
(4, '4级'),
)
level=models.SmallIntegerField(verbose_name="级别",choices=level_choices,default=1)
staus_choices=(
(1,"已占用"),
(2,"未使用")
)
status=models.SmallIntegerField(verbose_name="状态",choices=staus_choices,default=2)
2、创建url路径
path('num/list/',views.num_list)
3、创建函数
from django.shortcuts import render, redirect
from app01 import models
def num_list(request):
# prettynum = models.PrettyNum.objects.all()
# 按照level排序,不加负号为从小到大,加上为从大到小
prettynum = models.PrettyNum.objects.all().order_by("-level")
return render(request, "num_list.html", {"prettynum": prettynum})
4、构建html页面
{% extends 'header.html' %}
{% block css %}
{% endblock %}
{% block content %}
<div>
<div class="container">
<div style="margin-bottom: 10px">
<a class="btn btn-success" href="/user/model/form/add/" target="_blank">
<span class="glyphicon glyphicon-plus-sign" aria-hidden="true"></span>
新建靓号
</a>
</div>
<div class="panel panel-default">
<div class="panel-body">
<span class="glyphicon glyphicon-th-list" aria-hidden="true"></span>
靓号列表
</div>
<table class="table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>号码</th>
<th>价格</th>
<th>级别</th>
<th>状态</th>
<th>操作</th>
</tr>
</thead>
<tbody>
{% for obj in prettynum %}
<tr>
<td>{{ obj.id }}</td>
<td>{{ obj.mobile }}</td>
<td>{{ obj.price }}</td>
<td>{{ obj.get_level_display }}</td>
<td>{{ obj.get_status_display }}</td>
<td>
<a class="btn btn-primary btn-xs" href="#">编辑</a>
<a class="btn btn-danger btn-xs" href="#">删除</a>
</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
</div>
{% endblock %}
{% block js %}
{% endblock %}
</body>
</html>
注意:<td>{{ obj.get_level_display }}</td>可以将选项的所代表的内容显示出来
效果图如下: