Python+Django+layer

开发工具

1.PyCharm
2.mysql

新建项目

微信截图_20240108171758.png

设计/创建表

1.app -》models

from django.db import models


# 创建表名
class Department(models.Model):
    """ 部门表 """
    title = models.CharField(max_length=32, verbose_name='标题')


class Employee(models.Model):
    """ 员工表 """
    gender_choices = (
        (1, "男"),
        (2, "女")
    )
    name = models.CharField(max_length=32, verbose_name='姓名')
    password = models.CharField(max_length=64, verbose_name='密码')
    age = models.IntegerField(verbose_name='年龄')
    gender = models.IntegerField(choices=gender_choices, verbose_name='性别')
    salary = models.FloatField(verbose_name='薪资', default=0)
    create_time = models.DateTimeField(auto_now_add=True, verbose_name='入职时间')
    # 级联删除，如果部门删除了 该条记录同时删除
    # department = models.ForeignKey(to="Department",to_field="id",on_delete=models.CASCADE,verbose_name='部门id')
    # to：与某个表关联 to_field：与表中那一列又关联 如果部门删除 部门ID 制空
    department = models.ForeignKey(to="Department", to_field="id", null=True, blank=True, on_delete=models.SET_NULL,
                                   verbose_name='部门id')

在Mysql 生成表

1.点击新建项目 -》工具栏 -》运行 manage.py

2. 输入数据库迁移命令 python manage.py makemigrations
3. 输入数据库生成 python manage.py migrate

静态文件管理

微信截图_20240108172401.png

Template 模板继承

微信截图_20240108172542.png 微信截图_20240108172615.png