字段的增删改查
# 增
pwd = models.IntegerField(verbose_name="密码",null=True) # verbose_name说明 ;null可以为空
is_delete = models.CharField(default=0) # 设置为默认值
# 改
直接改代码然后执行数据库迁移命令即可
# 删
注释掉代码然后执行数据库迁移命令即可
数据的增删改查
查询
# 查询1
res = User.objects.filter(name=username)
print(res) # <QuerySet [<User: User object (1)>]> # 可以看做列表套对象
# 对应的SQL语句: select * from user where name = username
# 查询2
obj = User.objects.filter(name=username,pwd=password).first()
# 对应的SQL语句是: select * from user where name = username and pwd = password
查询出来是列表的形式,first()是[0]的意思
新增
# insert user(name,pwd,age) values ("tom",123,20)
User.objects.create(name=username, pwd=password,age=age)
查看所有的数据
def home(request):
# select * from user
res = User.objects.all() # 查询所有[obj1,obj2,obj3...]
return render(request, "home.html",{'user_data':res})
附--HTML关键代码
<table class="table table-bordered table-striped">
<thead>
<tr>
<td>名字</td>
<td>年龄</td>
<td>密码</td>
</tr>
</thead>
<tbody>
{% for user_obj in user_data %}
<tr>
<td> {{ user_obj.name }} </td>
<td> {{ user_obj.age }} </td>
<td> {{ user_obj.pwd }} </td>
</tr>
{% endfor %}
</tbody>
效果:
参考资料:
样式参考:https://v3.bootcss.com/css/#tables
知识来源:https://www.cnblogs.com/Dominic-Ji/p/10881214.html