七、各种查询的JSP页面

标签: java mysql web servlet jsp
11人阅读 评论(0) 收藏 举报
分类:

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>

查看评论

JSP页面查询显示常用模式

  • 2009年01月09日 11:36
  • 10KB
  • 下载

JSP基本要素

JSP指令和脚本元素  Directives   Declarations   Expressions   Code Fragment/Scriptlet   Comments   ...
  • adevotee
  • adevotee
  • 2007-06-27 16:50:00
  • 1122

MySql 查询一周内最近7天记录

本周内: select * from wap_content where week(created_at) = week(now) 查询一天: select * from table w...
  • u013483742
  • u013483742
  • 2014-01-25 14:57:05
  • 749

自定义View之LOL能力七星图

掌盟中能力七星图截图仿照完成的效果截图基本上模仿的与原控件一致了,就是文字与顶点的距离有一些小瑕疵,这块还需需要优化。本文目的 可以使读者: 1. 巩固自定义控件的基础知识以及正多边形的绘制...
  • fu908323236
  • fu908323236
  • 2017-10-26 17:20:19
  • 913

Oracle表的常用查询实验(七)

Oracle表的常用查询实验(七) 1.问题描述: 有一个商品信息表,该表反应了各种商品的销售情况,一个产品是按照gid和gname两个字段来区分的,一个产品可能会有多个型号。 create tabl...
  • u011715137
  • u011715137
  • 2013-11-28 10:35:44
  • 1568

struts2 直接JSON返回一个对象到JSP

action中: private Map dataMap;// 生成setget public String getUserById() {   dataMap = new H...
  • a281246240
  • a281246240
  • 2015-08-28 15:48:44
  • 328

火车系统查询

  • 2014年09月24日 11:20
  • 2KB
  • 下载

ssm整合JSP查询界面

String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServ...
  • wangbignwei1211
  • wangbignwei1211
  • 2017-06-28 20:44:23
  • 1005

jsp页面跳出保存成功调到查询

  • 2017年01月20日 17:33
  • 111KB
  • 下载

sql查询7天内的数据

select userId from login where DATE_SUB(NOW(),INTERVAL 7 DAY)
  • AbsenceOfTrace
  • AbsenceOfTrace
  • 2016-07-08 10:44:38
  • 228
    个人资料
    等级:
    访问量: 192
    积分: 101
    排名: 126万+
    文章存档