models.py
from django.db import models class Person(models.Model): name=models.CharField(max_length=30) age=models.IntegerField() def __unicode__(self): return
./manage.py shell
Person.objects.order_by("id")
[<Person: lanny>, <Person: mxl>, <Person: wang>, <Person: zhang>, <Person: zhao>, <Person: li>]
#切片打印出列表
Person.objects.order_by("id")[:1]
[<Person: lanny>]
Person.objects.order_by("id")[:2]
[<Person: lanny>, <Person: mxl>]#倒序排列
Person.objects.order_by("-id")[:2]
[<Person: li>, <Person: zhao>]
Person.objects.all()
[<Person: lanny>, <Person: mxl>, <Person: wang>, <Person: zhang>, <Person: zhao>, <Person: li>]创建、查询
Person.objects.create(name=lanny,age=23) Person.objects.get(name="lanny")
实际使用:
views.py
from django.shortcuts import render
from polls.models import Question
def index(request):
latest_question_list = Question.objects.order_by('-pub_date')[:5]
context = {'latest_question_list': latest_question_list}
return render(request, 'polls/index.html', context)html:
question.id #从数据库中取ID,django同步的时候默认给model中的每个表创建ID
question.question_text #从数据库中取question_text
{% if latest_question_list %}
<ul>
{% for question in latest_question_list %}
<li><a href="/polls/{{ question.id }}/">{{ question.question_text }}</a></li>
{% endfor %}
</ul>
{% else %}
<p>No polls are available.</p>
{% endif %}
















