📄 scan.jsp
字号:
<%@ page language="java" import="java.sql.Date,java.util.ArrayList,java.util.*,com.buat.hr.employee.*,com.buat.hr.share.*, java.sql.ResultSet;" pageEncoding="gbk"%>
<script type="text/javascript" src="Functions.js">
</script>
<%
EmployeeDAO dao=new EmployeeDAO();
String pageNo=request.getParameter("pageNo");
int count=dao.getCount("employee");
int perCount=8;
if(request.getParameter("inputPagePer")!=null)
{
String temp=request.getParameter("inputPagePer");
try{
perCount=Integer.parseInt(temp);
if(perCount<=0){
perCount=1;
}
session.setAttribute("percount",temp);
}catch(Exception e){perCount=8;}
}
if(session.getAttribute("percount")!=null){
perCount=(Integer.parseInt(String.valueOf(session.getAttribute("percount"))));
if(perCount<=0){
perCount=1;
}
}
Pagination pagination=new Pagination(dao.queryEmployeeCount(),perCount);
pagination.setPageNo(request.getParameter("pageNo"));
ArrayList arraylist=dao.query(pagination.getStartNo(),pagination.getPerCount(),"employee");
pagination.setTurn("Scan.jsp");
session.setAttribute("pageName","Scan.jsp");
%>
<html>
<head>
<script type="text/javascript">
function isDelete(){
return window.confirm("是否要删除这条记录?");
}
</script>
</head>
<body background="../bg.jpg">
<table border="1" width="90%" align="center">
<tr>
<td colspan="8"><font color="red">浏览员工信息</font></td>
</tr>
<tr>
<td>ID</td>
<td>员工姓名</td>
<td>专 业</td>
<td>员工性别</td>
<td>出生日期</td>
<td>入职时间</td>
<td>所在部门</td>
<td>删 除</td>
<td>修 改</td>
</tr>
<%
for(int i=0;i<arraylist.size();i++){
Employee employee=(Employee)arraylist.get(i);
%>
<tr>
<td><%=employee.getEmployeeId() %></td>
<td><%=employee.getName() %></td>
<td><%=employee.getMajor() %></td>
<td><%=employee.getGender() %></td>
<td><%=employee.getBirthday() %></td>
<td><%=employee.getJointime() %></td>
<td><%=employee.getDepartmentId() %></td>
<td><a onClick="del(<%=employee.getEmployeeId()%>)" style="cursor:hand">删除</a></td>
<td><a href =Update.jsp?employeeId=<%=employee.getEmployeeId()%>>修改</a></td>
</tr>
<%
}
%>
</table>
<p>
<center>
<font color="red">总共<%= pagination.getPageCount() %>页
当前是第<%= pagination.getPageNo() %>页
</font>
</center>
<br>
<form name="login" action=<%= pagination.getTurn() %>>
请输入您要查看本页的前几条记录:<input type="text" name="inputPagePer"> <input type="submit" name="submit" value="提交" onclick="isNumber()">
<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>
<script language="javaScript">
function isNumber()
{
perCount=window.document.all.inputPagePer.value;
if(isNaN(perCount)==true || perCount<=0)
{
alert("输入只能为数字,且最小值为一！！！");
window.document.forms[0].action="Scan.jsp";
window.document.forms[0].submit();
}
}
</script>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -