Python系列视频教程: Django【13讲】第八讲 数据库使用2
1.在Django里面如何实现对数据的基本操作
C:\Python27>mysql -uroot
在Django里面如何实现对数据的基本操作
首先是数据的添加动作
ipython manage.py shell
我只能使用python manage.py shell
D:\test\mysite\csvt03>python manage.py shell
Python 2.7.2 (default, Jun 24 2011, 12:21:10) [MSC v.1500 32 bit (Intel)] on win
32
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> from blog.models import Employee
>>> Employee
<class 'blog.models.Employee'>
>>> emp=Employee()
>>> emp.name='Alen'
>>> emp.save()
>>> emp=Employee(name='Tom');
>>> emp.save();
>>> Employee.objects.create(name='Max');
<Employee: Employee object>
>>> Employee.objects.create(name='Sumer');
<Employee: Employee object>
>>> emp
<Employee: Employee object>
>>> emps=Employee.objects.all()
>>> emps
[<Employee: Employee object>, <Employee: Employee object>, <Employee: Employee o
bject>, <Employee: Employee object>]
>>>
修改models.py
def __unicode__(self):
return self.name
退出刚才的mange.py
再重新进去
>>> emps=Employee.objects.all()
>>> emps
[<Employee: Alen>, <Employee: Tom>, <Employee: Max>, <Employee: Sumer>]
>>>
2.界面中如何显示数据
url(r'^index/$', 'blog.views.index'),
views.py
#from django.shortcuts import render
from blog.models import Employee
from django.shortcuts import render_to_response
# Create your views here.
def index(req):
emps=Employee.objects.all()
return render_to_response('index.html',{'emps':emps})
index.html
<body>
<h1>hello</h1>
{{emps}}
</body>
D:\test\mysite\csvt03>python manage.py runserver
hello
[<Employee: Alen>, <Employee: Tom>, <Employee: Max>, <Employee: Sumer>]
修改index.html
<body>
<h1>hello</h1>
{%for emp in emps %}
<div>
{{forloop.counter}} {{emp}}
</div>
{%endfor %}
<div>
共有 {{emps.length}}记录
</div>
</body>
hello
这里emps.length没有起到作用???