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() %>页
当前是第<%= 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">页 <input type="submit" value="跳转"></td>
</tr>
</table>
</form>
<%} %>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?