📄 maofield.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="userbean.Starff" %>
<%@ page import="dbmgr.*" %>
<%@ page import="java.util.*" %>
<% request.setCharacterEncoding("gb2312"); %>
<%response.setCharacterEncoding("gb2312"); %>
<%
String sch=(String)request.getAttribute("sch");
int end;
CsMgr qqdb=new CsMgr();
Collection rs=null;
Collection sall=qqdb.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.name1.value=="" && document.register.name2.value=="" )
window.alert("查询条件不能为空!!");
else{
if(document.register.name1.value!="")
document.register.sqlCondition.value+=" and pxid="+document.register.name1.value;
if(document.register.name2.value!="")
document.register.sqlCondition.value+=" and leibieid="+document.register.name2.value+"";
document.register.opraParam.value="show";
document.register.submit();
}
}
function _delete(leibieid)
{
if(confirm("你确定要删除吗?"))
{
document.register.sqlCondition.value=leibieid;
document.register.opraParam.value="delete";
document.register.submit();
}
else
return false;
}
function _goto(n)
{document.register.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/liuservlet">
<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>
<br>培训人ID:<input type="text" name="name1"> 培训类别ID<input type="text" name="name2"><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 height="12" bgcolor="#CCCCCC">
<th width="20%">培训ID</th>
<th width="20%">类别ID</th>
<th width="25%">证书名称</th>
<th width="20%">证书号</th>
<th width="25%">证书日期</th>
</tr>
<%
Starff starff=null;
int i=1;
int n=1;
while(it.hasNext()&&i<=8)
{i++;
starff=(Starff)it.next();
%>
<%if(n==0){ n=1;%>
<tr bgcolor="#FFFFCC" align="center">
<%}else{%>
<tr height="12" align="center" >
<%n=0;} %>
<td height="25"><%=starff.getPxid()%></td>
<td height="25"><%=starff.getLeibieid() %></td>
<td height="25"><%=starff.getCertiname() %></td>
<td heigth="25"><%=starff.getCertinum() %></td>
<td heigth="25"><%=starff.getCertidate() %></td>
</tr>
<%}%>
</table>
<%if(sc==1){%>
<font size="4" color="#FF00FF">没有找到符合条件的相关信息</font><br>
<%}else{%>
当前是第<%=currentcout %>页 一共<%=cout %>页
<%} %>
</form>
<form >
<%if(sc!=0){ %>
<a href="/Myproject/lyfmokuaifmgr/maofield.jsp">[返回]</a>
<%} %>
</form>
</center>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -