root@pc:/home/uu# mkdir work     建立一个文件夹，用于存放工程

root@pc:/home/uu# cd work

root@pc:/home/uu/work# django-admin.py startproject csct06     建立一个工程csct06

root@pc:/home/uu/work# cd csct06/

root@pc:/home/uu/work/csct06# django-admin.py startapp blog     建立一个应用

root@pc:/home/uu/work/csct06# ls

blog  csct06  manage.py

root@pc:/home/uu/work/csct06# vim csct06/settings.py 

INSTALLED_APPS = (

    'django.contrib.admin',

    'django.contrib.auth',

    'django.contrib.contenttypes',

    'django.contrib.sessions',

    'django.contrib.messages',

    'django.contrib.staticfiles',

    'blog',                               注册自己定义的应用

)

DATABASES = {

    'default': {

        'ENGINE': 'django.db.backends.sqlite3',           这里如果用MySQL或类似数据库，只需要更改这里的相关参数就行了

        'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),      参数有6个：'ENGINE'为数据库的类型，'NAME'为使用的数据库名,'USER'为管理员名字

    }                                                                ‘HOST'一般为localhost，’PORT'为数据库的端口,'PASSWORD'为数据库密码

}

root@pc:/home/uu/work/csct06# vim blog/models.py             这里用于操作数据库

from django.db import models

class Author(models.Model):                            生成两个对象：作者和书

    name = models.CharField(max_length=30)

    def __unicode__(self):

        return self.name

class Book(models.Model):

    name = models.CharField(max_length=30)

    authors = models.ManyToManyField(Author)            作者和书是多对多关系

    def __unicode__(self):

        return self.name

root@pc:/home/uu/work/csct06# ls

blog  csct06  manage.py

root@pc:/home/uu/work/csct06# python manage.py syncdb

。。。。。

Creating tables ...

Creating table django_admin_log

Creating table auth_permission

Creating table auth_group_permissions

Creating table auth_group

Creating table auth_user_groups

Creating table auth_user_user_permissions

Creating table auth_user

Creating table django_content_type

Creating table django_session

Creating table blog_author

Creating table blog_book_authors

Creating table blog_book

You just installed Django's auth system, which means you don't have any superusers defined.

Would you like to create one now? (yes/no): yes

Username (leave blank to use 'root'): uu

Email address: uu@qw.com

Password:

Password (again):

Superuser created successfully.

Installing custom SQL ...

Installing indexes ...

Installed 0 object(s) from 0 fixture(s)

root@pc:/home/uu/work/csct06# ls

blog  csct06  db.sqlite3  manage.py

sqlite> .tables

auth_group                  blog_author

auth_group_permissions      blog_book

auth_permission             blog_book_authors

auth_user                   django_admin_log

auth_user_groups            django_content_type

auth_user_user_permissions  django_session

sqlite> 

root@pc:/home/uu/work/csct06# python manage.py shell

Python 2.7.6 (default, Mar 22 2014, 22:59:56)

。。。。

下面开始执行操作：

In [1]: from blog.models import Author,Book

In [2]: Author.objects.create(name='Tom1')    用create方法插入数据

Out[2]: <Author: Tom1>

In [3]: Author.objects.create(name='Tom2')

Out[3]: <Author: Tom2>

In [4]: Author.objects.create(name='Bob1')

Out[4]: <Author: Bob1>

In [5]: Author.objects.create(name='Bob2')

Out[5]: <Author: Bob2>

In [8]: auhtors = Author.objects.all()   这里出错了

In [9]: authors

---------------------------------------------------------------------------

NameError                                 Traceback (most recent call last)

<ipython-input-9-07dd264ecf4d> in <module>()

----> 1 authors

NameError: name 'authors' is not defined

按照下面的步骤走，可以解决
直接查询所有作者：

In [11]: Author.objects.all()

Out[11]: [<Author: Tom1>, <Author: Tom2>, <Author: Bob1>, <Author: Bob2>]

通过赋值查询所有结果：

In [12]: author = Author.objects.all()

In [13]: author

Out[13]: [<Author: Tom1>, <Author: Tom2>, <Author: Bob1>, <Author: Bob2>]

In [14]: b1 = Book()       获取b1对象

In [15]: b1.name = 'Java'     添加第一本书:Java

In [16]: b1.save()                 用sava方法保存

为书Java添加作者：

In [20]: tom1 = Author.objects.get(name_exact='Tom1')

---------------------------------------------------------------------------

FieldError                                Traceback (most recent call last)

。。。

  name_exact方法出错，处理：

In [21]: tom1 = Author.objects.get(name='Tom1')
In [22]: tom1
Out[22]: <Author: Tom1>
添加第一个作者：
In [23]: b1.authors.add(tom1)
添加成功：
In [24]: b1.authors.all()
Out[24]: [<Author: Tom1>]

添加第二个作者：
In [26]: b1.authors.add(author[2])
In [27]: b1.authors.all()
Out[27]: [<Author: Tom1>, <Author: Bob1>]
第三个作者，注意一下下标：
In [28]: b1.authors.add(author[1])
In [29]: b1.authors.all()
Out[29]: [<Author: Tom1>, <Author: Tom2>, <Author: Bob1>] 
删除一个作者，调用remove方法：
In [30]: b1.authors.remove(tom1)
用all方法进行全部查询：
In [31]: b1.authors.all()
Out[31]: [<Author: Tom2>, <Author: Bob1>]
用filter方法进行局部查询：
In [31]: b1.authors.all()
Out[31]: [<Author: Tom2>, <Author: Bob1>]
这里已经删除了Tom1这个作者，所以查询不到：
In [32]: b1.authors.filter(name='Tom1')
Out[32]: []

In [33]: b1.authors.filter(name='Tom2')
Out[33]: [<Author: Tom2>]

In [34]: tom1                  tom1对象前面已经获取了

Out[34]: <Author: Tom1>

In [35]: tom1.book_set.all()    set是一个集合，也可以看成一个对象

Out[35]: []

In [36]: tom1.book_set.add(b1)    同样用add方法为作者添加一本书，就是前面的书Java

In [40]: tom1.book_set.create(name="python")  添加第二本书
Out[40]: <Book: python>

In [41]: tom1.book_set.all()                   共为tom1添加了两本书
Out[41]: [<Book: Java>, <Book: python>]

In [42]: book = Book.objects.all()    查看书的集合
In [43]: book
Out[43]: [<Book: Java>, <Book: python>]

In [44]: tom1.book_set.remove(book[0])   移除一本书

In [45]: tom1.book_set.all()
Out[45]: [<Book: python>]

In [2]: from blog.models import Author,Book 首先导入两个对象作者和书

In [4]: authors = Author.objects.all()     赋值

In [5]: authors                       间接查询

Out[5]: [<Author: Tom1>, <Author: Tom2>, <Author: Bob1>, <Author: Bob2>]

In [6]: a1 = authors[0]               特定查询第一个作者的信息

In [7]: a1.book_set

Out[7]: <django.db.models.fields.related.ManyRelatedManager at 0x7f7f46e53c10>

In [9]: a1.book_set.all()[0]    详细查看作者a1出版的书的信息

Out[9]: <Book: python>

In [11]: for author in Author.objects.all():    这里通过一个复杂的结构完成类似功能 
   ....:     for book in author.book_set.all():
   ....:         print book
   ....:         
python
Java
Java
各种模块学习大全：

#coding=utf-8

from django.shortcuts import render,render_to_response

from blog.models import Author,Book    首先导入数据库里的对象

def show_author(req):

    authors = Author.objects.all()     遍历作者信息

    return render_to_response('show_author.html',{'authors':authors})  将作者信息渲染到模板文件中

root@pc:/home/uu/work/csct06# python manage.py runserver

......

Django version 1.6.5, using settings 'csct06.settings'

Starting development server at http://127.0.0.1:8000/

{%for author in authors%}
<li>{{author}}</li>
{%endfor%}              注意括号哪里是单括号，哪里是双括号

{%for author in authors%}
<h1>{{author.name}}</h1>
{%endfor%}

{%for author in authors%}

<div>

 <h1>{{author.name}}</h1>                 这里小结一下：变量用双括号：{{变量}}

   {%for book in author.book_set.all%}               for循环这里用但括号，且要加上%

    <li> {{book}}</li>

   {%endfor%}

</div>

{%endfor%}

In [13]: tom1 = Author.objects.filter(name='Tom1')

In [14]: tom1

Out[14]: [<Author: Tom1>]http://blog.csdn.net/lcyangcss/article/details/7249961
下面这里出错了，还未解决，整理中。。。。。。
In [22]: tom1.book_set.create(name='django')
。。。。

AttributeError: 'QuerySet' object has no attribute 'book_set'

In [23]: tom1.book_set.create(name="django")
。。。。

AttributeError: 'QuerySet' object has no attribute 'book_set'