1、Django 中使用Model進行數(shù)據(jù)庫的操作。

def index(request):
    articles = Article.objects.all()
    print(articles.query)
    context = {}
    context['articles'] = articles
    return render(request, 'index.html', context)

其中第三行可以在命令行打印出相應(yīng)的SQL語句。
通過articles = Article.objects.all()操作來解釋為SQL語句
在命令行中的打印結(jié)果是：

打印結(jié)果

SELECT 
    "zhidaily_article"."id", "zhidaily_article"."title", "zhidaily_article"."intro", "zhidaily_article"."abstract", "zhidaily_article"."category_id", "zhidaily_article"."content", "zhidaily_article"."publish_time", "zhidaily_article"."image", "zhidaily_article"."source_link", "zhidaily_article"."author_name", "zhidaily_article"."author_avatar", "zhidaily_article"."author_desc"
FROM
    "zhidaily_article"
ORDER BY
    "zhidaily_article"."publish_time"
DESC

其中FROM指從哪個表提取數(shù)據(jù)，ORDER BY指按哪組數(shù)據(jù)排序，這組數(shù)據(jù)只能是數(shù)字或者時間，DESC是排序方式。

2、Django中的搜索

def index(request):
    q = request.GET.get('q', '')
    articles = Article.objects.filter(title__contains=q)
    print(articles.query)
    context = {}
    context['articles'] = articles
    return render(request, 'index.html', context)

前端

        <div class="item">
            <form class="ui icon input">
              <input type="text" name="q" placeholder="搜索指定用戶文章">
              <i class="search icon"></i>
            </form>
        </div>

3、多表查詢