Django 连接多个数据库-优快云博客

本文介绍使用 Django 框架配置 MySQL 数据库并执行查询的基本步骤，包括设置数据库连接、执行 SQL 查询及获取结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.setting.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
        'NAME': 'test',                      # Or path to database file if using sqlite3.
        'USER': 'root',                      # Not used with sqlite3.
        'PASSWORD': 'test',                  # Not used with sqlite3.
        'HOST': 'loclahost',                      # Set to empty string for localhost. Not used with sqlite3.
        'PORT': '',                      # Set to empty string for default. Not used with sqlite3.
    },
    'bbs': {
        'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
        'NAME': 'discuz',                      # Or path to database file if using sqlite3.
        'USER': 'root',                      # Not used with sqlite3.
        'PASSWORD': 'test',                  # Not used with sqlite3.
        'HOST': 'localhost',                      # Set to empty string for localhost. Not used with sqlite3.
        'PORT': '',                      # Set to empty string for default. Not used with sqlite3.
    }
}

2.调用函数

def get_bbs_info():
    from django.db import connections
    cursor = connections['bbs'].cursor()
    cursor.execute("SELECT * from pre_common_addon");
    a = cursor.fetchall()
    print a