TimeManage.jsp
这是查询全部的页面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import ="bean.AddMessageBean" %>
<%@ page import ="java.util.List" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="css/daohanglan1.css"/>
<title>工时管理</title>
<style>
input {
margin-left:20px;}
tr {
}
th{
text-align: center;
width:100px;
}
td{
text-align: center;
width:100px;
}
</style>
</head>
<body>
<div>
<ul class="nav">
<li><a href="AddMessage.jsp">学生录入</a></li>
<li><a href="AddWorkTime.jsp">工时录入</a></li>
<li><a href="TimeManage.jsp">工时管理</a></li>
</ul>
</div>
<div>
<ul class="nav">
<li><a href="TimeManage.jsp" id="btn1">全部信息</a></li>
<li><a href="SearchName.jsp" id="btn2">按姓名查询</a></li>
<li><a href="SearchSex.jsp" id="btn3">按性别查询</a></li>
<li><a href="SearchYear.jsp" id="btn4">按年份查询</a></li>
<li><a href="SearchID.jsp" id="btn5">按学号查询</a></li>
<li><a href="SearchIns.jsp" id="btn6">按学院查询</a></li>
<li><a href="SearchPro.jsp" id="btn7">按专业查询</a></li>
<li><a href="SearchLevel.jsp" id="btn8">按贫困等级查询</a></li>
</ul>
</div>
<div>
<form action="TimeManage" method="post">
<input type="submit" value="查询">
</form>
<hr/>
</div>
<div>
<div>
<table border="1.5" bordercolor="black" style="border-collapse:collapse;margin-left: auto; margin-right: auto;">
<tr><th>学号</th><th>学生姓名</th><th>性别</th><th>入学年份</th><th>学院</th><th>专业</th><th>贫困等级</th><th>详细信息</th><th>其他操作</th></tr>
<% List<AddMessageBean> TimeManage = (List<AddMessageBean>) request.getAttribute("TimeManage");
if(TimeManage!=null && !TimeManage.isEmpty()){
for(AddMessageBean times : TimeManage){
%>
<tr>
<td><%=times.getNum() %></td>
<td><%=times.getName() %></td>
<td><%=times.getSex() %></td>
<td><%=times.getYear() %></td>
<td><%=times.getCollege() %></td>
<td><%=times.getMajor() %></td>
<td><%=times.getPoor() %></td>
<td>
<a href="Detail?num=<%=times.getNum() %>">查看</a>
</td>
<td>
<a href="Delete?num=<%=times.getNum() %>">删除</a>
</td>
</tr>
<%}
}%>
</table>
</div>
</div>
</body>
</html>
------------------------------------------------------------------
按学号查询
SearchID.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import ="bean.AddMessageBean" %>
<%@ page import ="java.util.List" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<link rel="stylesheet" type="text/css" href="css/daohanglan1.css"/>
<link rel="stylesheet" type="text/css" href="css/tablecss.css"/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>按学号查询</title>
</head>
<body>
<div>
<ul class="nav">
<li><a href="AddMessage.jsp">学生录入</a></li>
<li><a href="AddWorkTime.jsp">工时录入</a></li>
<li><a href="TimeManage.jsp">工时管理</a></li>
</ul>
</div>
<div>
<ul class="nav">
<li><a href="TimeManage.jsp" id="btn1">全部信息</a></li>
<li><a href="SearchName.jsp" id="btn2">按姓名查询</a></li>
<li><a href="SearchSex.jsp" id="btn3">按性别查询</a></li>
<li><a href="SearchYear.jsp" id="btn4">按年份查询</a></li>
<li><a href="SearchID.jsp" id="btn5">按学号查询</a></li>
<li><a href="SearchIns.jsp" id="btn6">按学院查询</a></li>
<li><a href="SearchPro.jsp" id="btn7">按专业查询</a></li>
<li><a href="SearchLevel.jsp" id="btn8">按贫困等级查询</a></li>
</ul>
</div>
<div>
<form action="SearchID" method="post">
请输入学号:<input type="text" name="num" >
<input type="submit" value="查询" />
</form>
<hr/>
</div>
<div>
<table border="1.5" bordercolor="black" style="border-collapse:collapse;margin-left: auto; margin-right: auto;">
<tr><th>学号</th><th>学生姓名</th><th>性别</th><th>入学年份</th><th>学院</th><th>专业</th><th>贫困等级</th><th>详细信息</th><th>其他操作</th></tr>
<%
List<AddMessageBean> SearchID=(List<AddMessageBean>)request.getAttribute("SearchID");
if(SearchID!=null&&!SearchID.isEmpty()){
for(AddMessageBean times : SearchID){
%>
<tr>
<td><%=times.getNum() %></td>
<td><%=times.getName() %></td>
<td><%=times.getSex() %></td>
<td><%=times.getYear() %></td>
<td><%=times.getCollege() %></td>
<td><%=times.getMajor() %></td>
<td><%=times.getPoor() %></td>
<td>
<a href="Detail?num=<%=times.getNum() %>">查看</a>
</td>
<td>
<a href="Delete?num=<%=times.getNum() %>">删除</a>
</td>
<%
}
}
%>
</table>
</div>
</body>
</html>
-------------------------------------------------------
按学院查询
SearchIns.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import ="bean.AddMessageBean" %>
<%@ page import ="java.util.List" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<link rel="stylesheet" type="text/css" href="css/daohanglan1.css"/>
<link rel="stylesheet" type="text/css" href="css/tablecss.css"/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>按学院查询</title>
<link rel="stylesheet" type="text/css" href="css/CSS1.css"/>
</head>
<body>
<div>
<ul class="nav">
<li><a href="AddMessage.jsp">学生录入</a></li>
<li><a href="AddWorkTime.jsp">工时录入</a></li>
<li><a href="TimeManage.jsp">工时管理</a></li>
</ul>
</div>
<div>
<ul class="nav">
<li><a href="TimeManage.jsp" id="btn1">全部信息</a></li>
<li><a href="SearchName.jsp" id="btn2">按姓名查询</a></li>
<li><a href="SearchSex.jsp" id="btn3">按性别查询</a></li>
<li><a href="SearchYear.jsp" id="btn4">按年份查询</a></li>
<li><a href="SearchID.jsp" id="btn5">按学号查询</a></li>
<li><a href="SearchIns.jsp" id="btn6">按学院查询</a></li>
<li><a href="SearchPro.jsp" id="btn7">按专业查询</a></li>
<li><a href="SearchLevel.jsp" id="btn8">按贫困等级查询</a></li>
</ul>
</div>
<div>
<form action="SearchIns" method="post">
请输入学院:<input type="text" name="college" >
<input type="submit" value="查询" />
</form>
<hr/>
</div>
<div>
<table border="1.5" bordercolor="black" style="border-collapse:collapse;margin-left: auto; margin-right: auto;">
<tr><th>学号</th><th>学生姓名</th><th>性别</th><th>入学年份</th><th>学院</th><th>专业</th><th>贫困等级</th><th>详细信息</th><th>其他操作</th></tr>
<%
List<AddMessageBean> SearchIns=(List<AddMessageBean>)request.getAttribute("SearchIns");
if(SearchIns!=null&&!SearchIns.isEmpty()){
for(AddMessageBean times : SearchIns){
%>
<tr>
<td><%=times.getNum() %></td>
<td><%=times.getName() %></td>
<td><%=times.getSex() %></td>
<td><%=times.getYear() %></td>
<td><%=times.getCollege() %></td>
<td><%=times.getMajor() %></td>
<td><%=times.getPoor() %></td>
<td>
<a href="Detail?num=<%=times.getNum() %>">查看</a>
</td>
<td>
<a href="Delete?num=<%=times.getNum() %>">删除</a>
</td>
<%
}
}
%>
</table>
</div>
</body>
</html>
-------------------------------------------------------------------
按贫困等级查询
SearchLevel.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import ="bean.AddMessageBean" %>
<%@ page import ="java.util.List" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<link rel="stylesheet" type="text/css" href="css/daohanglan1.css"/>
<link rel="stylesheet" type="text/css" href="css/tablecss.css"/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>按贫困等级查询</title>
</head>
<body>
<div>
<ul class="nav">
<li><a href="AddMessage.jsp">学生录入</a></li>
<li><a href="AddWorkTime.jsp">工时录入</a></li>
<li><a href="TimeManage.jsp">工时管理</a></li>
</ul>
</div>
<div>
<ul class="nav">
<li><a href="TimeManage.jsp" id="btn1">全部信息</a></li>
<li><a href="SearchName.jsp" id="btn2">按姓名查询</a></li>
<li><a href="SearchSex.jsp" id="btn3">按性别查询</a></li>
<li><a href="SearchYear.jsp" id="btn4">按年份查询</a></li>
<li><a href="SearchID.jsp" id="btn5">按学号查询</a></li>
<li><a href="SearchIns.jsp" id="btn6">按学院查询</a></li>
<li><a href="SearchPro.jsp" id="btn7">按专业查询</a></li>
<li><a href="SearchLevel.jsp" id="btn8">按贫困等级查询</a></li>
</ul>
</div>
<div>
<form action="SearchLevel" method="post">
请输入贫困等级:<input type="text" name="poor" >
<input type="submit" value="查询" />
</form>
<hr/>
</div>
<div>
<table border="1.5" bordercolor="black" style="border-collapse:collapse;margin-left: auto; margin-right: auto;">
<tr><th>学号</th><th>学生姓名</th><th>性别</th><th>入学年份</th><th>学院</th><th>专业</th><th>贫困等级</th><th>详细信息</th><th>其他操作</th></tr>
<%
List<AddMessageBean> SearchLevel=(List<AddMessageBean>)request.getAttribute("SearchLevel");
if(SearchLevel!=null&&!SearchLevel.isEmpty()){
for(AddMessageBean times : SearchLevel){
%>
<tr>
<td><%=times.getNum() %></td>
<td><%=times.getName() %></td>
<td><%=times.getSex() %></td>
<td><%=times.getYear() %></td>
<td><%=times.getCollege() %></td>
<td><%=times.getMajor() %></td>
<td><%=times.getPoor() %></td>
<td>
<a href="Detail?num=<%=times.getNum() %>">查看</a>
</td>
<td>
<a href="Delete?num=<%=times.getNum() %>">删除</a>
</td>
<%
}
}
%>
</table>
</div>
</body>
</html>
-----------------------------------------------
按姓名查询
SearchName.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import ="bean.AddMessageBean" %>
<%@ page import ="java.util.List" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>按姓名查询</title>
<link rel="stylesheet" type="text/css" href="css/daohanglan1.css"/>
<link rel="stylesheet" type="text/css" href="css/tablecss.css"/>
</head>
<body>
<div>
<ul class="nav">
<li><a href="AddMessage.jsp">学生录入</a></li>
<li><a href="AddWorkTime.jsp">工时录入</a></li>
<li><a href="TimeManage.jsp">工时管理</a></li>
</ul>
</div>
<div>
<ul class="nav">
<li><a href="TimeManage.jsp" id="btn1">全部信息</a></li>
<li><a href="SearchName.jsp" id="btn2">按姓名查询</a></li>
<li><a href="SearchSex.jsp" id="btn3">按性别查询</a></li>
<li><a href="SearchYear.jsp" id="btn4">按年份查询</a></li>
<li><a href="SearchID.jsp" id="btn5">按学号查询</a></li>
<li><a href="SearchIns.jsp" id="btn6">按学院查询</a></li>
<li><a href="SearchPro.jsp" id="btn7">按专业查询</a></li>
<li><a href="SearchLevel.jsp" id="btn8">按贫困等级查询</a></li>
</ul>
</div>
<div>
<form action="SearchName" method="post"> <!-- Servlet名字为SearchName -->
请输入姓名:<input type="text" name="name" >
<input type="submit" value="查询" />
</form>
<hr/>
</div>
<div>
<table border="1.5" bordercolor="black" style="border-collapse:collapse;margin-left: auto; margin-right: auto;">
<tr><th>学号</th><th>学生姓名</th><th>性别</th><th>入学年份</th><th>学院</th><th>专业</th><th>贫困等级</th><th>详细信息</th><th>其他操作</th></tr>
<%
//新建一个AddMessageBean类的列表,名字为SearchName
//getAttribute:将SearchName信息的值给SearchName
List<AddMessageBean> SearchName=(List<AddMessageBean>)request.getAttribute("SearchName");
if(SearchName!=null&&!SearchName.isEmpty()){
for(AddMessageBean times : SearchName){
%>
<tr>
<td><%=times.getNum() %></td> <!-- 用对应的get方法,将times类的值返回 -->
<td><%=times.getName() %></td>
<td><%=times.getSex() %></td>
<td><%=times.getYear() %></td>
<td><%=times.getCollege() %></td>
<td><%=times.getMajor() %></td>
<td><%=times.getPoor() %></td>
<td>
<a href="Detail?num=<%=times.getNum() %>">查看</a> <!-- 调用servlet类Detail,并且num是等于getNum返回的值 -->
</td>
<td>
<a href="Delete?num=<%=times.getNum() %>">删除</a> <!-- 调用servlet类Delete,并且num是等于getNum返回的值 -->
</td>
<%
}
}
%>
</table>
</div>
</body>
</html>
--------------------------------------------------------
按专业查询
SearchPro.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import ="bean.AddMessageBean" %>
<%@ page import ="java.util.List" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>按专业查询</title>
<link rel="stylesheet" type="text/css" href="css/daohanglan1.css"/>
<link rel="stylesheet" type="text/css" href="css/tablecss.css"/>
</head>
<body>
<div>
<ul class="nav">
<li><a href="AddMessage.jsp">学生录入</a></li>
<li><a href="AddWorkTime.jsp">工时录入</a></li>
<li><a href="TimeManage.jsp">工时管理</a></li>
</ul>
</div>
<div>
<ul class="nav">
<li><a href="TimeManage.jsp" id="btn1">全部信息</a></li>
<li><a href="SearchName.jsp" id="btn2">按姓名查询</a></li>
<li><a href="SearchSex.jsp" id="btn3">按性别查询</a></li>
<li><a href="SearchYear.jsp" id="btn4">按年份查询</a></li>
<li><a href="SearchID.jsp" id="btn5">按学号查询</a></li>
<li><a href="SearchIns.jsp" id="btn6">按学院查询</a></li>
<li><a href="SearchPro.jsp" id="btn7">按专业查询</a></li>
<li><a href="SearchLevel.jsp" id="btn8">按贫困等级查询</a></li>
</ul>
</div>
<div>
<form action="SearchPro" method="post">
请输入专业:<input type="text" name="major" >
<input type="submit" value="查询" />
</form>
<hr/>
</div>
<div>
<table border="1.5" bordercolor="black" style="border-collapse:collapse;margin-left: auto; margin-right: auto;">
<tr><th>学号</th><th>学生姓名</th><th>性别</th><th>入学年份</th><th>学院</th><th>专业</th><th>贫困等级</th><th>详细信息</th><th>其他操作</th></tr>
<%
List<AddMessageBean> SearchPro=(List<AddMessageBean>)request.getAttribute("SearchPro");
if(SearchPro!=null&&!SearchPro.isEmpty()){
for(AddMessageBean times : SearchPro){
%>
<tr>
<td><%=times.getNum() %></td>
<td><%=times.getName() %></td>
<td><%=times.getSex() %></td>
<td><%=times.getYear() %></td>
<td><%=times.getCollege() %></td>
<td><%=times.getMajor() %></td>
<td><%=times.getPoor() %></td>
<td>
<a href="Detail?num=<%=times.getNum() %>">查看</a>
</td>
<td>
<a href="Delete?num=<%=times.getNum() %>">删除</a>
</td>
<%
}
}
%>
</table>
</div>
</body>
</html>
-------------------------------------------------------
按性别查询
SearchSex.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import ="bean.AddMessageBean" %>
<%@ page import ="java.util.List" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>按性别查询</title>
<link rel="stylesheet" type="text/css" href="css/daohanglan1.css"/>
<link rel="stylesheet" type="text/css" href="css/tablecss.css"/>
</head>
<body>
<div>
<ul class="nav">
<li><a href="AddMessage.jsp">学生录入</a></li>
<li><a href="AddWorkTime.jsp">工时录入</a></li>
<li><a href="TimeManage.jsp">工时管理</a></li>
</ul>
</div>
<div>
<ul class="nav">
<li><a href="TimeManage.jsp" id="btn1">全部信息</a></li>
<li><a href="SearchName.jsp" id="btn2">按姓名查询</a></li>
<li><a href="SearchSex.jsp" id="btn3">按性别查询</a></li>
<li><a href="SearchYear.jsp" id="btn4">按年份查询</a></li>
<li><a href="SearchID.jsp" id="btn5">按学号查询</a></li>
<li><a href="SearchIns.jsp" id="btn6">按学院查询</a></li>
<li><a href="SearchPro.jsp" id="btn7">按专业查询</a></li>
<li><a href="SearchLevel.jsp" id="btn8">按贫困等级查询</a></li>
</ul>
</div>
<div>
<form action="SearchSex" method="post">
请输入性别:<input type="text" name="sex" >
<input type="submit" value="查询" />
</form>
<hr/>
</div>
<div>
<table border="1.5" bordercolor="black" style="border-collapse:collapse;margin-left: auto; margin-right: auto;">
<tr><th>学号</th><th>学生姓名</th><th>性别</th><th>入学年份</th><th>学院</th><th>专业</th><th>贫困等级</th><th>详细信息</th><th>其他操作</th></tr>
<%
List<AddMessageBean> SearchSex=(List<AddMessageBean>)request.getAttribute("SearchSex");
if(SearchSex!=null&&!SearchSex.isEmpty()){
for(AddMessageBean times : SearchSex){
%>
<tr>
<td><%=times.getNum() %></td>
<td><%=times.getName() %></td>
<td><%=times.getSex() %></td>
<td><%=times.getYear() %></td>
<td><%=times.getCollege() %></td>
<td><%=times.getMajor() %></td>
<td><%=times.getPoor() %></td>
<td>
<a href="Detail?num=<%=times.getNum() %>">查看</a>
</td>
<td>
<a href="Delete?num=<%=times.getNum() %>">删除</a>
</td>
<%
}
}
%>
</table>
</div>
</body>
</html>
------------------------------------------------------------
按入学年份查询
SearchYear.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import ="bean.AddMessageBean" %>
<%@ page import ="java.util.List" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>按年份查询</title>
<link rel="stylesheet" type="text/css" href="css/daohanglan1.css"/>
<link rel="stylesheet" type="text/css" href="css/tablecss.css"/>
</head>
<body>
<div>
<ul class="nav">
<li><a href="AddMessage.jsp">学生录入</a></li>
<li><a href="AddWorkTime.jsp">工时录入</a></li>
<li><a href="TimeManage.jsp">工时管理</a></li>
</ul>
</div>
<div>
<ul class="nav">
<li><a href="TimeManage.jsp" id="btn1">全部信息</a></li>
<li><a href="SearchName.jsp" id="btn2">按姓名查询</a></li>
<li><a href="SearchSex.jsp" id="btn3">按性别查询</a></li>
<li><a href="SearchYear.jsp" id="btn4">按年份查询</a></li>
<li><a href="SearchID.jsp" id="btn5">按学号查询</a></li>
<li><a href="SearchIns.jsp" id="btn6">按学院查询</a></li>
<li><a href="SearchPro.jsp" id="btn7">按专业查询</a></li>
<li><a href="SearchLevel.jsp" id="btn8">按贫困等级查询</a></li>
</ul>
</div>
<div>
<form action="SearchYear" method="post">
请输入入学年份:<input type="text" name="year" >
<input type="submit" value="查询" />
</form>
<hr/>
</div>
<div>
<table border="1.5" bordercolor="black" style="border-collapse:collapse;margin-left: auto; margin-right: auto;">
<tr><th>学号</th><th>学生姓名</th><th>性别</th><th>入学年份</th><th>学院</th><th>专业</th><th>贫困等级</th><th>详细信息</th><th>其他操作</th></tr>
<%
List<AddMessageBean> SearchYear=(List<AddMessageBean>)request.getAttribute("SearchYear");
if(SearchYear!=null&&!SearchYear.isEmpty()){
for(AddMessageBean times : SearchYear){
%>
<tr>
<td><%=times.getNum() %></td>
<td><%=times.getName() %></td>
<td><%=times.getSex() %></td>
<td><%=times.getYear() %></td>
<td><%=times.getCollege() %></td>
<td><%=times.getMajor() %></td>
<td><%=times.getPoor() %></td>
<td>
<a href="Detail?num=<%=times.getNum() %>">查看</a>
</td>
<td>
<a href="Delete?num=<%=times.getNum() %>">删除</a>
</td>
<%
}
}
%>
</div>
</body>
</html>