list.jsp

采用Jsp,Javabean,Servlet等做的人力资源管理系统,后台管理用户及密码均是:admin

<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="userbean.Cuser" %>
<%@ page import="dbmgr.*" %>
<%@ page import="java.util.*" %>
<%
request.setCharacterEncoding("gb2312");
%>  
<%
     String sch=(String)request.getAttribute("sch");
     int end;
     CuserMgr userdb=new CuserMgr();
     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.pxid.value=="")
 {
   alert("请输入学员id号！！");
   window.register.pxid.focus();
 }
else{
 document.register.opraParam.value="show";
 document.register.sqlCondition.value=document.register.pxid.value;
 document.register.submit();
 }
 }
 
 function _delete(pxid)
 {
 if(confirm("你确定要删除吗？"))
 {
  document.register.sqlCondition.value=pxid;
  document.register.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/CuserServlet"> 
 <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="black">培训人员及成绩</font></b></p>
 学员ID：<input type="text" name="pxid">&nbsp;<input type="button" name="Submit1" value="查询" onClick="_search()"> 
 <hr>
  <%if(cout<2){%>
  <br>第一页&nbsp;&nbsp;&nbsp; &nbsp;上一页&nbsp;&nbsp;&nbsp;&nbsp;
下一页 &nbsp;&nbsp;&nbsp;&nbsp;最后一页
  <%}else if(currentcout==1){%> 
 <br>第一页&nbsp;&nbsp;&nbsp; &nbsp;上一页&nbsp;&nbsp;&nbsp;&nbsp;
<a href="#" onClick="_goto(<%=next%>)">下一页</a> &nbsp;&nbsp;&nbsp;&nbsp;
<a href="#" onClick="_goto(<%=endpage%>)">最后一页</a> 
<%
 }else if(currentcout<cout){
 %>
<br><a href="#" onClick="_goto(1)">第一页</a>&nbsp;&nbsp;&nbsp; &nbsp;
<a href="#" onClick="_goto(<%=last%>)">上一页</a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href="#" onClick="_goto(<%=next%>)">下一页</a> &nbsp;&nbsp;&nbsp;&nbsp;
<a href="#" onClick="_goto(<%=endpage%>)">最后一页</a>
<%
}else{
%>
<br><a href="#" onClick="_goto(1)">第一页</a>&nbsp;&nbsp;&nbsp; &nbsp;
<a href="#" onClick="_goto(<%=last%>)">上一页</a>&nbsp;&nbsp;&nbsp;&nbsp;
下一页 &nbsp;&nbsp;&nbsp;&nbsp;最后一页
<%
}
%>
 <table border="1"  bordercolor="#9AE4E9"  align="center" cellspacing="0">
 
 <tr bgcolor="#CCCCCC">
 <th width="80">学员ID</th>
 <th width="100">学员姓名</th>
 <th width="100">程序员培训</th>
 <th width="100">网页设计</th>
 <th width="100">CAD辅助设计</th>
 <th width="100">专业英语</th>
 <th width="50">C++</th>
 <th width="100">软件设计师</th>
 <th>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</th>
 
 </tr>

 <%
  Cuser user=null;
  int i=1;
  int n=1;
   while(it.hasNext()&&i<=8)
   {i++;
    user=(Cuser)it.next();
   %>
   <%if(n==0){ n=1;%>
   <tr bgcolor="#FFFFCC" align="center">
   <%}else{%>
   <tr  align="center">
   <%n=0;} %>
    <td><%=user.getPxid() %></td>
    <td><%=user.getXyname() %></td>
    <td><%=user.getCxypx() %></td>
     <td><%=user.getWysj() %></td>
    <td><%=user.getCad() %></td>
    <td><%=user.getEnglish() %></td>
     <td><%=user.getCjj() %></td>
    <td><%=user.getRuanshe() %></td>
    <td>
    <a href="/Myproject/cusermgr/change.jsp?pxid1=<%=user.getPxid()%>&xyname1=<%=user.getXyname()%>&cxypx1=<%=user.getCxypx()%>&wysj1=<%=user.getWysj()%>&cad1=<%=user.getCad()%>&english1=<%=user.getEnglish()%>&cjj1=<%=user.getCjj()%>&ruanshe1=<%=user.getRuanshe()%>">修改</a>
    &nbsp;<a href="#" onClick=" _delete(<%=user.getPxid()%>)">删除</a>
    </td>
   </tr>
   <%}%>
   </table>
  <%if(sc==1){%>
               <font size="4" color="#FF00FF">没有找到符合条件的记录</font><br>
     <%}else{%>
   当前是第<%=currentcout %>页&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;一共<%=cout %>页
  <%} %> 
   </form>    
 <form name="form2" method="post" action="/Myproject/cusermgr/add.jsp">
 <p align="center">
    <input type="submit" name="Submit2" value="添加">
  <%if(sc!=0){ %>    
    <a href="/Myproject/cusermgr/list.jsp">[返回]</a>  
    <%} %> 
</form>
 </center>