Django操作数据库

直接跳过ORM的方式，ORM方式过于繁琐，对于复杂查询更是无力

HelloWorld/HelloWorld/是我建立的项目

 

vim settings #HelloWorld/HelloWorld目录下修改如下代码

DATABASES = {

    'default': {

        'ENGINE': 'django.db.backends.mysql',  # 或者使用 mysql.connector.django

        'NAME': 'test',

        'USER': 'root',

        'PASSWORD': '123456',

        'HOST':'127.0.0.1',

        'PORT':'3306',

    },

    'db1': {

        'ENGINE': 'django.db.backends.mysql',  # 或者使用 mysql.connector.django

        'NAME': 'test2',

        'USER': 'root',

        'PASSWORD': '123456',

        'HOST':'127.0.0.1',

        'PORT':'3306',

    }

}

vim views.py #blog目录下添加个函数

from django.db import connection

from django.db import connections

def db_handle(request):

    t = loader.get_template('db_handle.html')

    #cursor = connection.cursor()

    #cursor.execute("select * from test")

    #rows = cursor.fetchall()   

    cursor = connections['db1'].cursor()

    cursor.execute("select * from Poem")

    rows = cursor.fetchall()

    d = {"name":"lidonghai","age":29,"sex":"mail","user":rows}

    return HttpResponse(t.render(d))

 

vim urls.py #blog目录下，内容如下

from django.conf.urls import url

from blog import views

urlpatterns = [

    url(r'^hello/$', views.hello),

    url(r'^search/$', views.search),

    url(r'^post_search/$', views.post_search),

    url(r'^search_submit$', views.search_submit),

    url(r'^post_search_submit$', views.post_search_submit),

    url(r'^db_handle/$', views.db_handle),

]

vim db_handle.html #blog目录下templates目录下

{{ user }}

 

 

启动server后，浏览器访问测试：http://10.1.8.34:8000/blog/db_handle/