一. 设计表结构(在models.py中创建类)
1. 设计表
class PrettyNum(models.Model):
""" 靓号表 """
mobile = models.CharField(verbose_name="手机号", max_length=11) # 属性 = 字符串类型(表头名,型最大长度11)
# 想要允许为空 null=True, blank=True
price = models.IntegerField(verbose_name="价格", default=0) # 属性 = int类型(表头名,默认为0)
# 在django中做的约束
level_choices = (
(1, "1级"),
(2, "2级"),
(3, "3级"),
(4, "4级"),
)
level = models.SmallIntegerField(verbose_name="级别", choices=level_choices, default=1) # 属性 = 小int类型(表头名,关联级别,默认为1级)
# 在django中做的约束
status_choices = (
(1, "已占用"),
(2, "未使用")
)
status = models.SmallIntegerField(verbose_name="状态", choices=status_choices, default=2) # 属性 = 小int类型(表头名,关联级别,默认为未使用)
2. 在pycharm生成表
4. 在下面先输入makemigrations回车再输入migrate回车
5. 登录数据库模拟一些数据
insert into app01_prettynum(mobile,price,level,status)values("111111111",19,1,1)
6. 查看一下
二. 编写URL和视图函数对应关系
# 靓号管理
path('pretty/list/', views.pretty_list),
path('pretty/add/', views.pretty_add),
path('pretty/<int:nid>/edit/', views.pretty_edit),
path('pretty/<int:nid>/delete/', views.pretty_delete)
三. 编写视图函数
1. 靓号列表
########################### 手机靓号 ####################################
# def pretty_list(request):
# """ 靓号列表 """
# queryset = models.PrettyNum.objects.all().order_by("-level") # 获取全部靓号.排序(级别高的在上边)
# return render(request, 'pretty_list.html', {"queryset": queryset})
2. 增加靓号
from django.core.validators import RegexValidator
from django.core.exceptions import ValidationError
# form import UserModelForm, PrettyModelForm, PrettyEditModelForm
class PrettyModelForm(forms.ModelForm):
# # 对提交的字段验证方式1:
mobile = forms.CharField(
# 字段
label="手机号",
# 正则表达式(1开头,再只能3-9里面选择,后面只能9个数,报错)
validators=[RegexValidator(r'^1[3-9]\d{9}$', '手机号格式错误')]
)
class Meta:
model = models.PrettyNum
fields = ["mobile", "price", "level", "status"] # 获取字段
# fields = "--__all__" # 全部字段
# exclude = ['level'] # 排除 level字段
def __init__(self, *args, **kwargs): # 重新定义类的初始属性
super().__init__(*args, **kwargs) # 只要重新执行就继承复类的初始属性
# 循环找到所有的插件,添加了class="form-control"
for name, field in self.fields.items(): # 循环找到所有字段的插件
# if name == "password": # 不想让x字段不加样式
# continue # 绕过去
# 字段.插件 = (每个插件添加上样式)
field.widget.attrs = {"class": "form-control", "placeholder": field.label}
# 对提交的字段验证方式2:
# def clean_mobile(self):
# txt_moble = self.cleaned_data["mobile"]
# if len(txt_moble) != 11:
# # 验证不通过
# raise ValidationError('格式错误')
# # 验证通过
# return txt_moble
def pretty_add(request):
""" 添加靓号 """
if request.method == "GET": # 如果请求方式是GET
form = PrettyModelForm() # 创建对象
return render(request, 'pretty_add.html', {"form": form}) # 返回(请求,页面,把数据渲染到页面
form = PrettyModelForm(data=request.POST) # 把POST提交数据传给UserModelForm就拿到数据
if form.is_valid(): # 如果校验成功
form.save() # 自动保存的数据库
return redirect('/pretty/list/') # 返回页面
return render(request, 'pretty_add.html', {"form": form}) # 校验失败(返回页面在页面上显示错误信息)
class PrettyEditModelForm(forms.ModelForm):
mobile = forms.CharField(disabled=True, label="手机号") # mobile字段不可编辑
class Meta:
model = models.PrettyNum
fields = ["mobile", "price", "level", "status"] # 获取字段
3. 编辑靓号
class PrettyEditModelForm(forms.ModelForm):
mobile = forms.CharField(disabled=True, label="手机号") # mobile字段不可编辑
class Meta:
model = models.PrettyNum
fields = ["mobile", "price", "level", "status"] # 获取字段
def __init__(self, *args, **kwargs): # 重新定义类的初始属性
super().__init__(*args, **kwargs) # 只要重新执行就继承复类的初始属性
# 循环找到所有的插件,添加了class="form-control"
for name, field in self.fields.items(): # 循环找到所有字段的插件
# if name == "password": # 不想让x字段不加样式
# continue # 绕过去
# 字段.插件 = (每个插件添加上样式)
field.widget.attrs = {"class": "form-control", "placeholder": field.label}
def pretty_edit(request, nid):
""" 编辑靓号 """
row_object = models.PrettyNum.objects.filter(id=nid).first() # # 获取当前靓号
if request.method == "GET":
form = PrettyEditModelForm(instance=row_object)
return render(request, 'pretty_edit.html', {"form": form})
form = PrettyEditModelForm(data=request.POST, instance=row_object)
if form.is_valid():
form.save()
return redirect('/pretty/list/')
return render(request, 'pretty_edit.html', {"form": form})
4. 删除靓号
def pretty_delete(request, nid):
models.PrettyNum.objects.filter(id=nid).delete()
return redirect('/pretty/list/')
四. template编写HTML文件
1. 靓号列表pretty_list.html
{% extends 'layout.html' %} <!-- 继承模板 -->
{% block content %} <!-- django导入语法 -->
<div class="container">
<div style="margin-bottom: 10px" class="clearfix">
<a class="btn btn-success" href="/pretty/add/">
<span class="glyphicon glyphicon-plus-sign" aria-hidden="true"></span>
新建靓号
</a>
<div style="float: right;width: 300px;"> <!-- 搜索框宽300,右飘 -->
<form method="get"> <!-- 表单提交 -->
<div class="input-group"> <!-- name属性="q" -->
<input type="text" name="q" class="form-control" placeholder="Search for..."
value="{{ search_data }}">
<span class="input-group-btn">
<button class="btn btn-default" type="submit">
<span class="glyphicon glyphicon-search" aria-hidden="true"></span> <!-- 加个图标 -->
</button>
</span>
</div>
</form>
</div>
</div>
<div class="panel panel-default">
<!-- 面板内容 -->
<div class="panel-heading">
<span class="glyphicon glyphicon-th-list" aria-hidden="true"></span>
靓号列表
</div>
<!-- Table -->
<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 queryset %}
<tr>
<th>{{ obj.id }}</th>
<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="/pretty/{{ obj.id }}/edit/">编辑</a>
<a class="btn btn-danger btn-xs" href="/pretty/{{ obj.id }}/delete/">删除</a>
</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
{% endblock %} <!-- 模板结束 -->
2. 添加靓号pretty_add.html
{% extends 'layout.html' %}
{% block content %}
<div class="container">
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title"> 新建靓号 </h3>
</div>
<div class="panel-body">
<form method="post" novalidate> <!-- novalidate=禁止浏览器校验 -->
{% csrf_token %}
{% for field in form %}
<div class="form-group">
<label>{{ field.label }}</label>
{{ field }}
<span style="color: red;">{{ field.errors.0 }}</span>
</div>
{% endfor %}
<button type="submit" class="btn btn-primary">提 交</button>
</form>
</div>
</div>
</div>
{% endblock %}
3.编辑靓号pretty_edit.html
{% extends 'layout.html' %}
{% block content %}
<div class="container">
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title"> 编辑靓号 </h3>
</div>
<div class="panel-body">
<form method="post" novalidate>
{% csrf_token %}
{% for field in form %}
<div class="form-group">
<label>{{ field.label }}</label>
{{ field }}
<span style="color: red;">{{ field.errors.0 }}</span>
</div>
{% endfor %}
<button type="submit" class="btn btn-primary">提 交</button>
</form>
</div>
</div>
</div>
{% endblock %}
五. 效果图