MySql 連線設定

摘要:MySql 連線設定

settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'test',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '3306',
    }
}

views.py

from django.db import connection

def Test(request):
    assert isinstance(request,HttpRequest)      
    cursor=  connection.cursor()
    cursor.execute('select * from new_table')  
    abc=cursor.fetchall()         
    cursor.close()     
    return render(request,'app/test.html',RequestContext(request,{ 'mydata':abc}))




補充:urls.py , test.html 請參考 [Django] Template