1.views.py
def scheduling(request):
cursor = connection.cursor()
cursor.execute("select staff_name from alarm_platform.TBL_STAFF where staff_number=any(select duty_staff_number1 from alarm_platform.TBL_DUTY);",None)
people_list = cursor.fetchall()
print(people_list)
return render(request, "people_list.html", {"people_list": people_list}) # 返回界面
-
模板文件
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Store</title> </head> <body> <table border="1"> <thead> <tr> <th>第一</th> </tr> </thead> <tbody> {% for people_list in people_list %} <tr> <td>{{ people_list.0 }}</td> </tr> {% endfor %} </tbody> </table>
你可以在模板把 {{ chika }} 打印出来:
(('wangxa',), ('wangcha',), ('liuli',), ('wangkke',))
{% for people_list in people_list %}
{{ people_list.0 }} {{ people_list.1}} {{ people_list.2 }}
{% endfor %}
转载于:https://blog.51cto.com/13675040/2129099