📄 list.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="userbean.w1User" %>
<%@ page import="dbmgr.*" %>
<%@ page import="java.util.*" %>
<%
request.setCharacterEncoding("gb2312");
%>
<%
String sch=(String)request.getAttribute("sch");
int end;
w1UserMgr userdb=new w1UserMgr();
Collection rs=null;
Collection sall=userdb.getAll();
if(request.getAttribute("rss")==null)
{
rs=sall;
}
else
rs=(Collection)request.getAttribute("rss");
Iterator it=rs.iterator();
if(sch==null)
{end=sall.size();
sch="0";
}
else end=rs.size();
int cout=(end%8==0)?(end/8):(end/8+1);
int endpage=(end%8==0)?(end-7):(end-end%8+1);
int sc=Integer.parseInt(sch);
String startPage=(String)request.getAttribute("stat");
//System.out.println(startPage);
if(startPage==null)startPage="1";
int currentPage=Integer.parseInt(startPage);
int currentcout=(currentPage%8==0)?(currentPage/8):(currentPage/8+1);
%>
<br><br>
<script language="javascript">
function _search()
{if(document.register.name.value=="")
{
alert("请输入你要查询员工编号!!");
window.register.name.focus();
}
else{
document.forms[0].opraParam.value="show";
document.register.sqlCondition.value=document.register.name.value;
document.register.submit();
}
}
function _delete(id)
{
if(confirm("你确定要删除吗?"))
{
document.register.sqlCondition.value=id;
document.forms[0].opraParam.value="delete";
document.register.submit();
}
else
return false;
}
function _goto(n)
{document.forms[0].opraParam.value="page";
document.register.chpage.value=n;
document.register.submit();
}
</script>
<style type="text/css">
<!--
.style1 {color:#FF9966}
-->
</style>
<center>
<form name="register" method="POST" action="/Myproject/inServlet">
<input type="hidden" name="opraParam" value=""/>
<input type="hidden" name="sqlCondition" value=""/>
<input type="hidden" name="chpage" value=""/>
<input type="hidden" name="size" value="8"/>
<%
//System.out.println(currentPage);
int next=currentPage+8;
int last=currentPage-8;
if(last<=0)last=1;
if(next>=endpage)next=endpage;
%>
<p align="center" class="style1"><b> <font size="6" color="HEI">员工基本信息</font></b></p>
员工编号:<input type="text" name="name"> <input type="button" name="Submit1" value="查询" onClick="_search()">
<hr>
<%if(cout<2){%>
<br>第一页 上一页
下一页 最后一页
<%}else if(currentcout==1){%>
<br>第一页 上一页
<a href="#" onClick="_goto(<%=next%>)">下一页</a>
<a href="#" onClick="_goto(<%=endpage%>)">最后一页</a>
<%
}else if(currentcout<cout){
%>
<br><a href="#" onClick="_goto(1)">第一页</a>
<a href="#" onClick="_goto(<%=last%>)">上一页</a>
<a href="#" onClick="_goto(<%=next%>)">下一页</a>
<a href="#" onClick="_goto(<%=endpage%>)">最后一页</a>
<%
}else{
%>
<br><a href="#" onClick="_goto(1)">第一页</a>
<a href="#" onClick="_goto(<%=last%>)">上一页</a>
下一页 最后一页
<%
}
%>
<table border="" bordercolor="#9AE4E9" cellspacing="0">
<tr bgcolor="#CCCCCC">
<th width="80">编号</th>
<th width="80">姓名</th>
<th width="50">性别</th>
<th width="80">职务</th>
<th width="80">部门</th>
<th width="80">学历</th>
<th width="80">婚姻</th>
<th width="100">在职状态</th>
</tr>
<%
w1User user=null;
int i=1;
int n=1;
while(it.hasNext()&&i<=8)
{i++;
user=(w1User)it.next();
%>
<%if(n==0){ n=1;%>
<tr bgcolor="#FFFFCC" align="center">
<%}else{%>
<tr align="center">
<%n=0;} %>
<td><%=user.getUserid() %></td>
<td><%=user.getEmpname() %></td>
<td><%=user.getSex() %></td>
<td><%=user.getDuty() %></td>
<td><%=user.getDepartment() %></td>
<td><%=user.getSchoolage() %></td>
<td><%=user.getMarriage() %></td>
<td><%=user.getIncumbency() %></td>
<td><a href="/Myproject/w1usermgr/change.jsp?userid1=<%=user.getUserid()%>&empname1=<%=user.getEmpname()%>&department1=<%=user.getDepartment()%>&duty1=<%=user.getDuty()%>&schoolage1=<%=user.getSchoolage()%>&sex1=<%=user.getSex()%>&marriage1=<%=user.getMarriage()%>&incumbency1=<%=user.getIncumbency()%>&nation1=<%=user.getNation()%>°ree1=<%=user.getDegree()%>&speciality1=<%=user.getSpeciality()%>&gratime1=<%=user.getGratime()%>&graschool1=<%=user.getGraschool()%>&idcard1=<%=user.getIdcard()%>&natinveplace1=<%=user.getNatinveplace()%>&mobile1=<%=user.getMobile()%>&hometel1=<%=user.getHometel()%>&emptime1=<%=user.getEmptime()%>&empplace1=<%=user.getEmpplace()%>&payaccount1=<%=user.getPayaccount()%>&homeaddress1=<%=user.getHomeaddress()%>&remark1=<%=user.getRemark()%>">修改</a>
<a href="#" onClick="_delete(<%=user.getUserid()%>)">删除</a>
</td>
</tr>
<%}%>
</table>
<%if(sc==1){%>
<font size="4" color="#FF00FF">没有找到符合条件的记录</font><br>
<%}else{%>
当前是第<%=currentcout %>页 一共<%=cout %>页
<%} %>
</form>
<form name="form2" method="post" action="/Myproject/w1usermgr/add.jsp">
<p align="center">
<input type="submit" name="Submit2" value="添加新信息">
<%if(sc!=0){ %>
<a href="/Myproject/w1usermgr/list.jsp">[返回]</a>
<%} %>
</form>
</center>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -