08-数据库信息展示

数据信息展示

# 知识点:
  # 1. 获取数据库所有内容
   list = PersonInfo.objects.all() 
  
  # 2. html中的 for 循环
   {% for ls in list %}
    <tr>
        <td>{{ ls.id }}</td>
        <td>{{ ls.name }}</td>
        <td>{{ ls.sex }}</td>
    </tr>
    {% endfor %}

流程

# 1. 创建表(models.py)
    from django.db import models
    from django.db.models import Model

    class BookInfo(Model):
        # 主键自增会自动生成
        name = models.CharField(max_length=20)


    class PersonInfo(Model):
        name = models.CharField(max_length=20)
        sex = models.CharField(max_length=20)
        # 外键
        book = models.ForeignKey(BookInfo, on_delete=models.CASCADE)

# 2. 创建视图函数(views.py)
  def shou_list(request):
    # 调用model类查询所有数据
    list = PersonInfo.objects.all()
    print(list) # 获取的是对象

    # 返回一个http模板
    return render(request, template_name="book/shou_list.html", context={"list":list})

# 3. 绑定路由(book.urls.py)
   re_path(r'^shou_list/$',shou_list),

# 4. 编辑html页面(templates.book.show_list.html)
  <table width="60%" border="1" cellspacing="0" cellpadding="0" align="center">
    <tr>
        <td>编号</td>
        <td>姓名</td>
        <td>性别</td>
    </tr>
    {% for ls in list %}
    <tr>
        <td>{{ ls.id }}</td>
        <td>{{ ls.name }}</td>
        <td>{{ ls.sex }}</td>
    </tr>
    {% endfor %}
</table>

# 5. 浏览器访问
  http://127.0.0.1:8000/shou_list/