models.py 文件
views.py 简单增删改查
# # 数据库mytext表数据的添加
# ob = Users() # users映射数据的模板的类
# ob.name = "李四"
# ob.age = 20
# ob.phone = "123456789"
# ob.save()
# # 数据库mytext表数据的删除
# ob = Users.objects
# user_name = ob.get(id=2)
# user_name.delete()
# # 修改操作
# db = Users.objects.get(id=6)#
# db.name = "小秀"
# db.age = 100
# db.save()
# 数据库中查找所有数据
# mod = Users.objects
# ulist = mod.all()
# for u in ulist:
# print(u.id,u.name,u.age,u.phone,u.addtime)
# 数据库中过滤查单个有数据
# mod = Users.objects
# ulist = mod.filter(name="王五")# 查询出名字叫王五的整条数据
# ulist = mod.filter(age__gt=50)# 查询出年龄大于50岁的
# ulist = mod.filter(age__gte=50)# 查询出年龄大于等于50岁的
# ulist = mod.filter(age__lte=50)# 查询出年龄小于等于50岁的
# ulist = mod.filter(age__lt=50)# 查询出年龄小于50岁的
# ulist = mod.order_by("age")# 按照年龄默认升序排序
# ulist = mod.order_by("age")[:2 ]# 按照年龄默认升序排序,取前两行
# for u in ulist:
# print(u.id,u.name,u.age,u.phone,u.addtime)
# # cmd终端查看所有数据



