📄 tq2a.jsp
字号:
<html>
<head>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="adminBean" scope="page" class="exam.exam"/>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询学生</title>
<script language="JavaScript">
function detail(a,b)
{
c="tebegin.jsp?pnum="+a+"&sbnum="+b;
window.open(c,"body2","toolbar=no,status=no,scrollbars=no,menubar=no,location=no,top=240,resizable=no,left=300,width=350,height=260")
}
function submit01()
{
self.location.replace("tq2a.jsp")
}
</script>
<link href="_notes/ccc" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
a:visited {
text-decoration: none;
}
A:active {color: #000000}
A:link,A:visited {color:#000000; text-decoration: none}
A:hover {color:#003399;text-decoration:underline}
-->
</style>
</head>
<body background="images/bg.gif">
<table width="730" border=1 align="center" bordercolor="#008000" background="images/bj.gif">
<tr bgcolor="#99FFFF">
<td>
<%
String dep=request.getParameter("give");
if(dep==null){
dep=(String)session.getValue("dep");
}
session.putValue("dep",dep);
int pageLine=5;
int totalRec=0;
int intPage=1;
int i;
if (request.getParameter("page")!=null)
intPage=Integer.parseInt(request.getParameter("page"));
try{
ResultSet countrs=null;
countrs=adminBean.executeQuery("select count(*)as cnt from pap where dep='"+dep+"' and pstate <>'"+3+"'");
if(countrs.next())
totalRec=countrs.getInt("cnt");
countrs.close();
adminBean.closeStmt();
}
catch(Exception e){
e.printStackTrace();
}
int intPageCount=0;
intPageCount=(totalRec+pageLine-1)/pageLine;
ResultSet rs2=adminBean.executeQuery("select sbnum,pnum,phead,pstate from pap where dep='"+dep+"' and pstate <>'"+3+"' order by pnum ");
ResultSet rs0=adminBean.executeQuery("select count(*)as cnt from pap where dep='"+dep+"' and pstate <>'"+3+"'");
if (intPageCount==0)
{
out.println("<center><font color=red>查无此记录!!!</font></center>");
}
rs0.close();
int sbnum;
int pnum;
String phead;
int pstate;
if (intPageCount>0)
{
for(i=1;i<=(intPage-1)*pageLine;i++)
rs2.next();
for(i=1;i<=pageLine;i++)
{
if(rs2.next())
{
sbnum=rs2.getInt("sbnum");
pnum=rs2.getInt("pnum");
phead=rs2.getString("phead");
pstate=rs2.getInt("pstate");
%>
<p><a href="javascript:detail(<%=pnum%>,<%=sbnum%>);" class="ccc"><font size="3"><b><%=pnum%>.<%=phead%>(状态：<% switch(pstate){ case 1:%>
<font color="#3300FF">允许</font><font color="#3300FF">开始考试</font>
<%break; case 2:%>
<font color="#FF0000">正在考试</font>
<%break;}%>)</b></font></a></p>
<p><font color="#2DFFFF" class="ccc">
<%}
}
rs2.close();
}
%>
</td>
</tr>
</table>
<%
out.print("<center><table "+"width=600 "+" valign=bottom>");
out.print("<tr>");
if(intPageCount*pageLine<totalRec)
intPageCount++;
if(intPage>intPageCount)
intPage=intPageCount;
if(intPage<1)
intPage=1;
out.print("<form method='post' name=fPageNum action='tq2a.jsp'>");
if(intPage<2)
out.print("首页 上一页 ");
else{
out.print("<a href='tq2a.jsp?page=1' ><font color='#2DFFFF' size='2'>首页 </font></a>");
out.print("<a href='tq2a.jsp?page="+(intPage-1)+"' ><font color='#2DFFFF' size='2'>上一页 </font></a>");
}
if(intPage-intPageCount>=0)
out.print("下一页 尾页");
else{
out.print("<a href='tq2a.jsp?page="+(intPage+1)+"'><font color='#2DFFFF' size='2'>下一页 </font></a><a href='tq2a.jsp?page="+intPageCount+"'><font color='#2DFFFF' size='2'>尾页</font></a>");
}
out.print(" 页次:<b><font color=red>"+intPage+"</font>/<font color=red>"+intPageCount+"</font></b>页 ");
out.print("共<b><font color=red>"+totalRec+"</font></b>条记录 <b><font color=red>"+pageLine+"</font></b>条/页");
out.print(" 转到第<input type='text' name='page' size=2 maxlength=10 class=smallInput value="+intPage+">");
out.print("页<input class=buttonface type='submit' value='GO' name='cndok'></span></p></form>");
out.print("</tr>");
out.print("</table></center>");
%></font>
<div align="center"></div>
<center>
<form action="teindex.jsp" method="post" name="form1" target="_parent">
<p>
<input name="Submit" type="submit" value="结束查询">
</p>
</form>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -