📄 tejtx.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<script language="JavaScript" type="text/JavaScript">
function detail(a)
{
window.open("gzl1.jsp?snum="+a,"body3","toolbar=no,status=no,scrollbars=yes,menubar=no,location=no,top=10,resizable=no,left=20,width=600")
}
function submit01()
{
self.location.replace("tejtx.jsp")
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body background="images/bg.gif">
<jsp:useBean id="dep1" scope="page" class="exam.exam"/>
<jsp:useBean id="dep" scope="page" class="exam.exam"/>
<jsp:useBean id="dep2" scope="page" class="exam.exam"/>
<%
String depq;
String grade;
String sclass;
if(request.getParameter("select1")==null) {
depq= (String) session.getValue("depq");
grade= (String) session.getValue("grade");
sclass= (String) session.getValue("sclass");
}
else {
depq=request.getParameter("select1");
session.putValue("depq",depq);
grade=request.getParameter("select2");
session.putValue("grade",grade);
sclass=request.getParameter("select3");
session.putValue("sclass",sclass);
}
String sql1="select depname from departmen where dep='"+depq+"'";
ResultSet rs1=dep1.executeQuery(sql1);
rs1.next();
String depname=rs1.getString("depname");
rs1.close();
String sql="";
if (request.getParameter("sltName")==null)
{
sql="select * from student where dep='"+depq+"' and grade='"+grade+"' and sclass='"+sclass+"' order by snum";
}
else
{
String power=request.getParameter("sltName");
String sql2="update student set power='"+power+"' where dep='"+depq+"' and grade='"+grade+"' and sclass='"+sclass+"'";
dep1.executeUpdate(sql2);
sql="select * from student where dep='"+depq+"' and grade='"+grade+"' and sclass='"+sclass+"' order by snum";
}
System.out.println("tejtx.jsp ++++++++++++line: 58 ");
ResultSet rs=dep.executeQuery(sql);
ResultSet rs2=dep2.executeQuery(sql);
%>
<table width="686" height="18" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="672" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td background="images/temp_01.jpg"><div align="right"><img src="images/temp_02.jpg" width="330" height="15"></div></td>
</tr>
</table>
<table width="672" height="55" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="55" background="images/main_bg.jpg"><div align="right"><img src="images/blank_banner.gif" width="468" height="60"></div></td>
</tr>
</table>
<table width="672" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="16"> </td>
</tr>
</table>
<table width="672" height="46" border="1" align="center" cellpadding="1" cellspacing="1">
<%if(rs2.next())
{
%>
<tr>
<td background="images/index2.gif">
<div align="center" class="ccc"><font color="#333333" size="4"><%=depname%><%=grade%>级<%=sclass%>班考生信息表</font></div></td>
</tr>
</table>
<table width="672" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<table width="672" border="1" align="center" cellpadding="1" cellspacing="1">
<tr>
<td width="91" class="ccc"><div align="center"><font color="#66ccff">准考证号</font></div></td>
<td width="81" class="ccc"><div align="center"><font color="#66ccff">姓 名</font></div></td>
<td width="57" class="ccc"><div align="center"><font color="#66ccff">学 号</font></div></td>
<td width="75" class="ccc"><div align="center"><font color="#66ccff">性 别</font></div></td>
<td width="210" class="ccc"><div align="center"><font color="#66ccff">考试状态</font></div></td>
<td width="125"> </td>
</tr>
<%
while (rs.next())
{
String snum=rs.getString("snum");
String sname=rs.getString("sname");
int sex=rs.getInt("ssex");
int sno=rs.getInt("sno");
int power=rs.getInt("power");
System.out.println(" 3: snum:"+snum+"sname:"+sname+"sno:"+sno+"power"+power);
%>
<tr>
<td><div align="center" class="ccc"><%=snum%></div></td>
<td><div align="center" class="ccc"><%=sname%></div></td>
<td><div align="center" class="ccc"><%=sno%></div></td>
<td><div align="center" class="ccc"><%
if (sex==1){%>男
<%}
else {%>
女<%}%></div></td>
<td><div align="center" class="ccc"><%
if (power==2)
{%>允许考试
<%}else{%>
禁止考试<%}%></div></td>
<td><div align="center"><a href="javascript:detail(<%=snum%>);" class="ccc">|查看个人信息|</a></div></td>
</tr>
<%
}rs.close(); rs2.close(); %>
</table>
<table width="826" height="70" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="bottom"> <form action="tejtx.jsp" method="post" name="form1">
<input type="hidden" name="select1" value="<%=depq%>">
<input type="hidden" name="select2" value="<%=grade%>">
<input type="hidden" name="select3" value="<%=sclass%>">
<table width="333" height="27" border="1" align="right" cellpadding="1" cellspacing="1">
<tr>
<td width="155" class="ccc"><div align="center"><font color="#66ccff">请设置此班的考试状态</font></div></td>
<td width="165"><select name="sltName">
<option value="2">允许考试</option>
<option value="1">禁止考试</option>
</select>
<input type="submit" name="Submit" value="提交"></td>
</tr>
</table>
</form></td>
</tr>
</table>
<%
}
else
{
%>
<tr><td><div align="center" class="ccc"><%=depname%><%=grade%>级<%=sclass%>班考生信息不存在，请核实后<font color="#FF9900">再</font>查询！</div></td></tr>
</table>
<%
}%>
</body>
<center>
<form action="tesmessage.htm" method="post" name="form2" target="_parent">
<div align="center">
<input type="submit" name="Submit2" value="结束查询">
</div>
</form>
</center>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -