问题遇到的现象和发生背景
django和mySQL数据库已关联,数据管理通过使用Navicat操作,目前碰到的情况是,navicat数据库也已关联django(pycharm中可查看到数据信息),但是运行后前端不显示。
已连接数据库(数据库在pycharm内可读到)
网页前端无数据
models.py内代码
class PhoneInfo(models.Model):
Tnum = models.CharField(verbose_name='Tnum', max_length=6)
DeviceName = models.CharField(verbose_name="DeviceName", max_length=50)
DeviceType = models.CharField(verbose_name="DeviceType", max_length=50)
DeviceCategory = models.CharField(verbose_name="DeviceCategory", max_length=50)
Brand = models.CharField(verbose_name="Brand", max_length=50)
Model = models.CharField(verbose_name="Model", max_length=50)
Market = models.CharField(verbose_name='Market', max_length=50)
Picture = models.CharField(verbose_name='Picture', max_length=50)
Location = models.CharField(verbose_name='Location', max_length=50)
LaunchDate = models.DateField(verbose_name='LaunchDate', blank=True, null=True)
IMEI = models.CharField(verbose_name="IMEI", max_length=50)
SN = models.CharField(verbose_name="SN", max_length=50)
WLANMac = models.CharField(verbose_name="WLANMac", max_length=50)
ArrivalDate = models.DateField(verbose_name='ArrivalDate', blank=True, null=True)
Firmware = models.CharField(verbose_name="Firmware", max_length=50)
OS = models.CharField(verbose_name="OS", max_length=10)
OSVersion = models.CharField(verbose_name='OSVersion', max_length=10)
Network = models.CharField(verbose_name='Network', max_length=10)
Operator = models.CharField(verbose_name='Operator', max_length=10)
Parameter = models.CharField(verbose_name="Parameter", max_length=50)
BTVersion = models.CharField(verbose_name="BTVersion", max_length=5)
DeviceOwner = models.CharField(verbose_name='DeviceOwner', max_length=50)
DeviceStatus = models.CharField(verbose_name='DeviceStatus', max_length=10)
UsageStatus = models.CharField(verbose_name='UsageStatus', max_length=50)
AssetDef = models.CharField(verbose_name="AssetDef", max_length=5)
AssetNum = models.CharField(verbose_name="AssetNum", max_length=20)
AssetValue = models.CharField(verbose_name='AssetValue', max_length=5)
DualSIM = models.CharField(verbose_name='DualSIM', max_length=5)
ExMemSupport = models.CharField(verbose_name="ExMemSupport", max_length=5)
MemSize = models.CharField(verbose_name="MemSize", max_length=20)
USBVersion = models.CharField(verbose_name='USBVersion', max_length=50)
PortType = models.CharField(verbose_name='PortType', max_length=50)
CANSpeed = models.CharField(verbose_name="CANSpeed", max_length=50)
MenuLink = models.CharField(verbose_name='MenuLink', max_length=50)
Comments = models.CharField(verbose_name='Comments', max_length=128)
html内代码
<table class="table table-bordered table-hover table-condensed table-sm align-middle ">
<thead class="table-light">
<tr>
<th>ID</th>
<th>Tnum</th>
<th>DeviceName</th>
<th>DeviceType</th>
<th>DeviceCategory</th>
<th>Brand</th>
<th>Model</th>
<th>Market</th>
<th>Picture</th>
<th>Location</th>
<th>LaunchDate</th>
<th>IMEI</th>
<th>SN</th>
<th>WLANMac</th>
<th>ArrivalDate</th>
<th>Firmware</th>
<th>OS</th>
<th>OSVersion</th>
<th>Network</th>
<th>Operator</th>
<th>Parameter</th>
<th>BTVersion</th>
<th>DeviceOwner</th>
<th>DeviceStatus</th>
<th>UsageStatus</th>
<th>AssetDef</th>
<th>AssetNum</th>
<th>AssetValue</th>
<th>DualSIM</th>
<th>ExMemSupport</th>
<th>MemSize</th>
<th>USBVersion</th>
<th>PortType</th>
<th>CANSpeed</th>
<th>MenuLink</th>
<th>Comments</th>
</tr>
</thead>
<tbody>
{% for phone in queryset_phone %}
<tr class="align-bottom">
<td>{{ phone.id }}</td>
<td>{{ phone.Tnum }}</td>
<td>{{ phone.DeviceName }}</td>
<td>{{ phone.DeviceType }}</td>
<td>{{ phone.DeviceCategory }}</td>
<td>{{ phone.Brand }}</td>
<td>{{ phone.Model }}</td>
<td>{{ phone.Market }}</td>
<td>{{ phone.Picture }}</td>
<td>{{ phone.Location }}</td>
<td>{{ phone.LaunchDate|date:"Y-m-d" }}</td>
<td>{{ phone.IMEI }}</td>
<td>{{ phone.SN }}</td>
<td>{{ phone.WLANMac }}</td>
<td>{{ phone.ArrivalDate|date:"Y-m-d" }}</td>
<td>{{ phone.Firmware }}</td>
<td>{{ phone.OS }}</td>
<td>{{ phone.OSVersion }}</td>
<td>{{ phone.Network }}</td>
<td>{{ phone.Operator }}</td>
<td>{{ phone.Parameter }}</td>
<td>{{ phone.BTVersion }}</td>
<td>{{ phone.DeviceOwner }}</td>
<td>{{ phone.DeviceStatus }}</td>
<td>{{ phone.UsageStatus }}</td>
<td>{{ phone.AssetDef }}</td>
<td>{{ phone.AssetNum }}</td>
<td>{{ phone.AssetValue }}</td>
<td>{{ phone.DualSIM }}</td>
<td>{{ phone.ExMemSupport }}</td>
<td>{{ phone.MemSize }}</td>
<td>{{ phone.USBVersion }}</td>
<td>{{ phone.PortType }}</td>
<td>{{ phone.CANSpeed }}</td>
<td>{{ phone.MenuLink }}</td>
<td>{{ phone.Comments }}</td>
</tr>
{% endfor %}
</tbody>
</table>
操作环境、软件版本等信息
win10, pycharm, python 3.7, navicat
我想要达到的结果
请教前端显示数据的方法