MODELS,ORM
1.在创建表格时的__str__()方法
class UserInfo(models.Model): username=models.CharField(max_length=32) password=models.CharField(max_length=32) ut=models.ForeignKey(to='UserType',on_delete=True)
obj_list=models.UserInfo.objects.all() print(obj_list)
运行结果:
<QuerySet [<UserInfo: UserInfo object (1)>, <UserInfo: UserInfo object (2)>, <UserInfo: UserInfo object (3)>, <UserInfo: UserInfo object (4)>, <UserInfo: UserInfo object (5)>]>
1 class UserInfo(models.Model): 2 username=models.CharField(max_length=32) 3 password=models.CharField(max_length=32) 4 ut=models.ForeignKey(to='UserType',on_delete=True) 5 6 def __str__(self): 7 return "%s--%s" %(self.id,self.username)
1 obj_list=models.UserInfo.objects.all() 2 print(obj_list)
运行结果:
<QuerySet [<UserInfo: 1--杨国伟>, <UserInfo: 2--石恩光>, <UserInfo: 3--钱博文>, <UserInfo: 4--杨理想>, <UserInfo: 5--周腾飞>]>
1 obj_list=models.UserInfo.objects.all().order_by('-id') 2 print(obj_list)
.order_by("id","name")
按id排序,前面加“-”是倒序,有两个参数表示:先按id排序,id相同的在按name排序,以此类推。