ORM:Object Relational Mapping(关系对象映射)
1.UserInfo.objects.all()
2.UserInfo.objects.get(id=2)
3.UserInfo.objects.filter(user_name__contains='王')
这条语句会被django转换成这样的SQL:
1.select * from user_userinfo
2.select * from user_userinfo where id=2
3.select user_name from user_userinfo where name like '王' ;
PS:
select * :是查询表中所有字段内容
select 字段 :是查询表中指定字段内容