def user_list(request):
users = User.objects.all() #将User表中的所有对象赋值给users这个变量,它是一个列表
return render(request, 'home.html', {'users': users}) 生成一个user变量,这个变量可以给templates中的html文件使用
def viewtbs(req):
conn= MySQLdb.connect(
host='127.0.0.1',
port = 3306,
user='root',
passwd='1234567',
db ='DEVOPS',
charset="UTF8"
)
cursor = conn.cursor()
a = cursor.execute("select sn,ip,info,env,script from publish_info;" )
info = cursor.fetchall()
print info
print type(info)
return render(req,'viewtbs.html',{'aabbcc':info})
node2:/exam/mysite/polls#cat templates/viewtbs.html
<html>
<head>
<title>运维平台</title>
<link rel="stylesheet" type="text/css" href="/static/Css/Equipment/modifyBtn.css">
<link rel="stylesheet" type="text/css" href="/static/Css/Public/header.css">
<link rel="stylesheet" type="text/css" href="/static/Css/Public/menu.css">
</head>
<table border="8">
<tr>{{aabbcc}}</tr>
</table>
<table border="10">
{% for x in aabbcc %}
<tr>
<th>{{x.0}}</th>
<th>{{x.1}}</th>
<td>{{x.2}}</td>
<td>{{x.3}}</td>
<td>{{x.4}}</td>
</tr>
{% endfor %}
</table>