<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="userbean.w3User" %>
<%@ page import="dbmgr.*" %>
<%@ page import="java.util.*" %>
<%
request.setCharacterEncoding("gb2312");
%>  
 <%
       String sch=(String)request.getAttribute("sch");
  	   int end;
       w3UserMgr userdb=new w3UserMgr();
       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 _Show()
{document.forms[0].opraParam.value="showall";
 document.register.submit();
}
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/fileServlet"> 
 <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">&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" cellspacing="0">
 
 <tr bgcolor="#CCCCCC">
 <th width="100">編號</th>
 <th width="100">姓名</th>
 <th width="100">檔案編號</th>
 <th width="100">檔案名稱</th>
 <th width="100">檔案內容</th>
 <th width="100">備注</th>
 </tr>

 <%
   w3User user=null;
   int i=1;
   int n=1;
    while(it.hasNext()&&i<=8)
    {i++;
    user=(w3User)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.getFileid() %></td>
    <td><%=user.getFilename() %></td>
    <td><%=user.getContent() %></td>
    <td><%=user.getRemark1() %></td>
    
    <td><a href="/Myproject/w3usermgr/change.jsp?userid1=<%=user.getUserid()%>&empname1=<%=user.getEmpname()%>&fileid1=<%=user.getFileid()%>&filename1=<%=user.getFilename()%>&content1=<%=user.getContent()%>&remark11=<%=user.getRemark1()%>">修改</a>
    &nbsp;<a href="#" onClick="_delete(<%=user.getUserid()%>)">刪除</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/w3usermgr/add.jsp">
 <p align="center">
    <input type="submit" name="Submit2" value="添加新信息">
    <%if(sc!=0){ %>    
    <a href="/Myproject/w1usermgr/list.jsp">[返回]</a>  
    <%} %>
 </form>
 </center>