<%@ page import="san.Thesql" %>
<%@ page import="san.Pd_stu" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>信息查询</title>
<style type="text/css">
html,body{
width: 99%;
height: 99%;
}
h1 {
color: #333;
text-align: center;
margin-top: 50px;
}
table {
margin-top: 20px;
border-collapse: collapse;
box-shadow: 0 0 20px rgba(0, 0, 0, 0.1);
background-color: #fff;
}
th, td {
padding: 20px;
text-align: center;
border: 1px solid #ddd;
font-size: 17px;
}
th {
background-color: #8b8989;
color: #fff;
font-size: 24px;
}
tr:nth-child(even) {
background-color: #f2f2f2;
}
input{
border: none;
border-radius: 10px;
height: 27px;
}
.submit{
background-color: rgb( 21, 218, 218);
color: aliceblue;
height: 50px;
width: 60%;
}
.submit:active{
background-color: rgb(166, 172, 175);
}
a{
text-decoration: none;
font-size: 20px;
color: #3bc9e2;
}
.content {
height: calc(95% - 0px);
overflow-y: scroll;
}
</style>
</head>
<%
Thesql thesql=new Thesql();
Pd_stu pdStu[] = thesql.show_stu();
int student_num = pdStu.length;
%>
<body>
<div align="center"><h1>学生联系方式</h1></div>
<div align="center"><a href="add.jsp">添加学生</a></div>
<table width="90%" align="center">
<tr>
<th height="25%" width="25%">工号</th>
<th width="25%">姓名</th>
<th width="25%">手机号码</th>
<th width="25%">管理</th>
</tr>
<tr><td colspan="5">
<div class="content">
<table border="1" style="font-size:18px;width: 100%;height: 100% ;margin-top: 0px">
<%for(int i=0;i<student_num;i++){%>
<tr>
<td height="10%" width="25%"><%=pdStu[i].id%></td>
<td width="25%"><%=pdStu[i].name%></td>
<td width="25%"><%=pdStu[i].phone%></td>
<td width="25%" align="center"><a href="person_information.jsp?id_=<%=pdStu[i].id%>" style="margin-right: 20%">查看</a>
<a href="#">删除</a></td>
</tr>
<%} %>
</table>
</div>
</td></tr>
</table>
<script type="text/javascript">
</script>
</body>
</html>