query.jsp

来自「07年做得人力资源管理系统」· JSP 代码 · 共 94 行

JSP
94
字号
<%@ page language="java" import="com.buat.hr.users.User,java.util.ArrayList,com.buat.hr.educate.EducateDAO,com.buat.hr.educate.Educate,com.buat.hr.share.Pagination" pageEncoding="GB18030"%>

<html>
  <head></head>  
  
  <body background="../bg.jpg">
  		<script language="javascript" src="..\\Functions.js"> 			
  		</script>
      <% 
	  	User user=null;                                 //权限判断
	    user=(User)session.getAttribute("userGrade");
	  	
	  	EducateDAO edu=new EducateDAO();
		Pagination pagination=new Pagination(edu.getCount("select count(*) from educate where summarize=''"),8);
		pagination.setPageNo(request.getParameter("pageNo"));		
		ArrayList eduList=edu.query(pagination.getStartNo(),8,"educate");	
		pagination.setTurn("Query.jsp");
		session.setAttribute("pageName","Query.jsp");
		String massage="";	
		if(eduList.size()!=0){		
		
	  %>
		  	<table width="100%"  border="1" align="center">
		  			<tr>
		  			    <td colspan="7"><font color="red">浏览培训计划</font></td>
   				    </tr>
		  		<tr align="center">

		  			<th>培训名称</th>
		  			<th>培训目的</th>
		  			<th>开始培训时间</th>
		  			<th>结束培训时间</th>		  			
		  			<th>培训人员</th>
		     <%
				if(user.getIsadmin().equals("educateAdmin") || user.getIsadmin().equals("superAdmin")){ 
			 %>
    			<th>执行操作</th>
    		<%
    			}
    		 %>	
		  		</tr>
		  	
	  		<% 	 
		  		for(int i=0;i<eduList.size();i++){
		  			Educate educate = (Educate) eduList.get(i);
	  		%>	
	  			<tr align="center">
	  				<td><%=educate.getName() %></td>
	  				<td><%=educate.getPurpose() %></td>
	  				<td><%=educate.getBegintime() %></td>
	  				<td><%=educate.getEndtime() %></td>
	  				<td><%=educate.getHuman() %></td>

	         <%
				if(user.getIsadmin().equals("educateAdmin") || user.getIsadmin().equals("superAdmin")){ 
			%>
    			    <td><a href="Detail.jsp?name=<%=educate.getName() %>&purpose=<%=educate.getPurpose() %>&begintime=<%=educate.getBegintime() %>&endtime=<%=educate.getEndtime() %>&teacher=<%=educate.getTeacher() %>&human=<%=educate.getHuman() %>&grade=<%=educate.getGrade() %>&material=<%=educate.getMaterial() %>">详细</a>
	  					<a onClick="del(<%=educate.getId() %>)" style="cursor:hand">删除</a> 
	  					<a href="Update.jsp?id=<%=educate.getId() %>&name=<%=educate.getName() %>&purpose=<%=educate.getPurpose() %>&begintime=<%=educate.getBegintime() %>&endtime=<%=educate.getEndtime() %>&teacher=<%=educate.getTeacher() %>&human=<%=educate.getHuman() %>&grade=<%=educate.getGrade() %>&material=<%=educate.getMaterial() %>">培训完成</a>
	  				</td>
	  			</tr>
    		<%
    			}
    		 %>		  			
	  	<% 
	  			}
	  	}else{massage="Sorry";}
	  	%>
	  		</table>
			       <br>
			   	      <center>
			   			  <font color="red">总共<%= pagination.getPageCount() %>页&nbsp;&nbsp;&nbsp;
			   					&nbsp;&nbsp;&nbsp;当前是第<%= pagination.getPageNo() %>页
			   			  </font>
			   		  </center>
			   		<br>
			   		 <%
	                    if(pagination.getPerCount()>=8){
	                 %>
			   		<form action=<%= pagination.getTurn() %>>
				   		<table width="90%"  border="0" align="center">
				   			<tr>
				   				<td align="right"><font color="red"><a href=<%= pagination.getTurn()%>?pageNo=0>第一页</a></font></td>
				   				<td align="right"><font color="red"><a href=<%= pagination.getTurn()%>?pageNo=<%= pagination.getPageNo()-1 %>>上一页</a></font></td>
				   				<td align="right"><font color="red"><a href=<%= pagination.getTurn()%>?pageNo=<%= pagination.getPageNo()+1 %>>下一页</a></font></td>
				   				<td align="right"><font color="red"><a href=<%= pagination.getTurn()%>?pageNo=<%= pagination.getPageCount()%>>最后一页</a></font></td>
				   				<td align="center">跳到第<input type="text" name="pageNo" size="3">页&nbsp;&nbsp;<input type="submit" value="跳转"></td>
				   			</tr>
				   		</table>
			   	   </form>
			   	   <%} %>
  </body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?