You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
91 lines
2.7 KiB
91 lines
2.7 KiB
5 years ago
|
<!DOCTYPE html>
|
||
|
|
<html lang="en">
|
||
|
|
<head>
|
||
|
|
<meta charset="UTF-8">
|
||
|
|
<style type="text/css">
|
||
|
|
body{background: url(D:/SQL/ky1.jpg) no-repeat center 0;
|
||
|
|
background-size: 100%};
|
||
|
|
font{color="darkgray"};
|
||
|
|
tr{height:60px}
|
||
|
|
</style>
|
||
|
|
<title>武汉协和医院</title>
|
||
|
|
</head>
|
||
|
|
<body>
|
||
|
|
<body style="background-color:lightgoldenrodyellow">
|
||
|
|
<div align="center">
|
||
|
|
<h1>武汉协和医院</h1>
|
||
|
|
|
||
|
|
<table width="800px" border="1" cellspacing="0" cellpadding="0">
|
||
|
|
<h3>病人信息表</h3>
|
||
|
|
<tr>
|
||
|
|
<td>ID</td>
|
||
|
|
<td>名字</td>
|
||
|
|
<td>性别</td>
|
||
|
|
<td>出生年</td>
|
||
|
|
<td>主治医师</td>
|
||
|
|
<td>负责护士</td>
|
||
|
|
</tr>
|
||
|
|
{% for patient in patient_list %}
|
||
|
|
<tr>
|
||
|
|
<td>{{ patient. id }}</td>
|
||
|
|
<td>{{ patient.name }}</td>
|
||
|
|
<td>{{ patient. sex}}</td>
|
||
|
|
<td>{{ patient. year_birth}}</td>
|
||
|
|
<td>{{ patient.doctor }}</td>
|
||
|
|
<td>{{ patient. nurse}}</td>
|
||
|
|
</tr>
|
||
|
|
{% endfor %}
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
</table>
|
||
|
|
<table width="800px" border="1" cellspacing="0" cellpadding="0">
|
||
|
|
<h3>医生信息表</h3>
|
||
|
|
<tr>
|
||
|
|
<td>ID</td>
|
||
|
|
<td>名字</td>
|
||
|
|
<td>性别</td>
|
||
|
|
<td>出生年</td>
|
||
|
|
<td>工龄</td>
|
||
|
|
<td>所属部门</td>
|
||
|
|
<td>是否感染</td>
|
||
|
|
<td>联系方式</td>
|
||
|
|
<td>工作单位</td>
|
||
|
|
</tr>
|
||
|
|
{% for doctor in doctor_list %}
|
||
|
|
<tr>
|
||
|
|
<td>{{ doctor. id }}</td>
|
||
|
|
<td>{{ doctor.name }}</td>
|
||
|
|
<td>{{ doctor. sex}}</td>
|
||
|
|
<td>{{ doctor. year_birth}}</td>
|
||
|
|
<td>{{ doctor. year_of_work}}</td>
|
||
|
|
<td>{{ doctor. deptname}}</td>
|
||
|
|
<td>{{ doctor. infection}}</td>
|
||
|
|
<td>{{ doctor. contact}}</td>
|
||
|
|
<td>{{ doctor. workunit}}</td>
|
||
|
|
</tr>
|
||
|
|
{% endfor %}
|
||
|
|
</table>
|
||
|
|
<br>
|
||
|
|
<br>
|
||
|
|
<table width="800px" border="1" cellspacing="0" cellpadding="0">
|
||
|
|
<h3>护士信息表</h3>
|
||
|
|
<tr>
|
||
|
|
<td>ID</td>
|
||
|
|
<td>名字</td>
|
||
|
|
<td>性别</td>
|
||
|
|
<td>出生年</td>
|
||
|
|
<td>工龄</td>
|
||
|
|
</tr>
|
||
|
|
{% for nurse in nurse_list %}
|
||
|
|
<tr>
|
||
|
|
<td>{{ nurse. id }}</td>
|
||
|
|
<td>{{ nurse.name }}</td>
|
||
|
|
<td>{{ nurse. sex}}</td>
|
||
|
|
<td>{{ nurse. year_birth}}</td>
|
||
|
|
<td>{{ nurse. year_of_work}}</td>
|
||
|
|
</tr>
|
||
|
|
{% endfor %}
|
||
|
|
</table>
|
||
|
|
<a href="/jianghan">返回主页</a>
|
||
|
|
</body>
|
||
|
|
</html>
|