django中使用原生SQL語句

views中代碼；

# 有多個數(shù)據(jù)庫時
from django.db import connections

# 傳入游標(biāo),得到字典結(jié)果集
def dictfetchall(cursor):
    "將游標(biāo)返回的結(jié)果保存到一個字典對象中"
    desc = cursor.description
    return [
    dict(zip([col[0] for col in desc], row))
    for row in cursor.fetchall()
    ]

def seldata(request):
        sql ="SELECT TOP 100 * FROM EwData"
        conn = connections['MyDB']          #連接的數(shù)據(jù)庫
        cur = conn.cursor()                  #連接游標(biāo)
        cur.execute(sql)                    #執(zhí)行SQL語名
        data = dictfetchall(cur)               #把結(jié)果用字典返回
        return render(request, 'ewdata.html', {'ew': data,'fcol':data[0]})

html代碼：

<table class="gridtable">
            <tr>
               {% for k in fcol %}
                    <th>{{ k }}</th>
                {% endfor %}
            </tr>
                {% for i in ew %}
                    <tr>
                                        {#  根據(jù)SQL中的字段名顯示數(shù)據(jù) #}
                    <td>{{ i.McNo }}</td>
                    <td>{{ i.SN }}</td>
                    <td>{{ i.Model }}</td>
                    <td>{{ i.Block }}</td>
                    <td>{{ i.Floor }}</td>
                    <td>{{ i.Line }}</td>
                    <td>{{ i.Wight }}</td>
                    <td>{{ i.TestTime }}</td>
                    <td>{{ i.Abortive }}</td>
                    <td>{{ i.Checker }}</td>
                    <td>{{ i.Multiple }}</td>
                    <td>{{ i.PackSN }}</td>
                    </tr>
                {% endfor %}
        </table>