⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 tegzl1.jsp

📁 一个很详细的考试管理系统。有源文件。还有毕业论文。大家可以仔细参考。
💻 JSP
字号:
🔍 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="_notes/ddd.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
@import url("_notes/ccc");
-->
</style>
</head>

<body background="images/bg.gif" >
<jsp:useBean id="db" scope="page" class="exam.exam"/>
<%
String snum=request.getParameter("snum");
String sql="select * from student where snum='"+snum+"'";
ResultSet rs=db.executeQuery(sql);
if(rs.next()){
String sname=rs.getString("sname");
int ssex=rs.getInt("ssex");
int sno=rs.getInt("sno");
int grade=rs.getInt("grade");
int sclass=rs.getInt("sclass");
int dep=rs.getInt("dep");
int power=rs.getInt("power");
String sql1="select depname from departmen where dep='"+dep+"'";
ResultSet rs1=db.executeQuery(sql1);
rs1.next();
String depname=rs1.getString("depname");
rs1.close();

String sql2="select count(snum) as num from success where snum='"+snum+"'";
ResultSet rs2=db.executeQuery(sql2);
rs2.next();
String num=rs2.getString("num");
rs2.close();
%>
<table width="560" border="0" cellspacing="0" cellpadding="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="560" height="62" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td background="images/main_bg.jpg"><div align="right"><img src="images/blank_banner.gif" width="468" height="60"></div></td>
  </tr>
</table>
<table width="75" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<table width="560" height="73" border="1" cellpadding="1" cellspacing="1">
  <tr> 
    <td width="63" height="35" class="ccc">
<div align="center"><font color="#66ccff">准考证号</font></div></td>
    <td width="81" height="35" class="ccc"><%=snum%></td>
    <td width="61" height="35" class="ccc"> 
      <div align="center"><font color="#66ccff">姓　名</font></div></td>
    <td width="72" height="35" class="ccc"><%=sname%></td>
    <td width="61" height="35" class="ccc"> 
      <div align="center"><font color="#66ccff">所在系</font></div></td>
    <td height="35" colspan="3" class="ccc"><%=depname%></td>
  </tr>
  <tr> 
    <td width="63" height="35" class="ccc"> 
      <div align="center"><font color="#66ccff">性　别</font></div></td>
    <td height="35" class="ccc"><%if (ssex==1){%>男<%} else {%>女<%}%></td>
    <td width="61" height="35" class="ccc"> 
      <div align="center"><font color="#66ccff">年　级</font></div></td>
    <td height="35" class="ccc"><%=grade%></td>
    <td height="35" class="ccc">
<div align="center"><font color="#66ccff">班　级</font></div></td>
    <td width="68" height="35" class="ccc"><%=sclass%></td>
    <td width="53" class="ccc">
<div align="center"><font color="#66ccff">学　号</font></div></td>
    <td width="58" height="35" class="ccc"><%=sno%></td>
  </tr>
</table>
<form action="tegzl2.jsp" method="post" name="form1">
  <table width="560" height="35" border="1" cellpadding="1" cellspacing="1">
    <tr> 
      <td width="63" height="31" class="ccc"> 
        <div align="center"><font color="#66ccff">考试状态</font></div></td>
      <td width="94" height="35" class="ccc"><%if (power==2){%>允许考试<%} else {%>禁止考试<%}%></td>
      <td width="155" class="ccc"><div align="center"><font color="#66ccff">修改此考生的考试状态</font></div></td>
      <td width="132"><select name="select">
          <option value="2">允许考试</option>
          <option value="1">禁止考试</option>
        </select>
        <input type="submit" name="Submit" value="修改"></td>
      <td width="62" class="ccc"> 
        <div align="center"><font color="#66ccff">考试次数</font></div></td>
      <td width="21" class="ccc"><%=num%></td>
    </tr>
  </table>
  <input type="hidden" name="snum" value="<%=snum%>">
</form>
<table width="560" height="71" border="1">
  <tr>
    <td height="28">
<div align="center" class="ccc"><font color="#66ccff">历史最好成绩</font></div></td>
    <td><div align="center" class="ccc"><font color="#66ccff">历史最差成绩</font></div></td>
  </tr>
  <%
String sql3="select subject,success from success where success=(select max(success) from success where snum='"+snum+"' )";
ResultSet rs3=db.executeQuery(sql3);
while(rs3.next()){
String subject1=rs3.getString("subject");
int success1=rs3.getInt("success");%>
<tr>
    <td height="35" class="ccc"><div align="center"><%=subject1%>：<%=success1%>分</div></td>
        <%} rs3.close();
String sql4="select subject,success from success where success=(select min(success) from success where snum='"+snum+"' )";
ResultSet rs4=db.executeQuery(sql4);
while(rs4.next()){
String subject2=rs4.getString("subject");
int success2=rs4.getInt("success");	
%>
    <td height="35" class="ccc"><div align="center"><%=subject2%>：<%=success2%>分</div></td>
    <%} rs4.close();%>
  </tr>
</table>
<table width="75" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>&nbsp; </td>
  </tr>
</table>
<table width="560" height="70" border="1" cellpadding="1" cellspacing="1">
  <tr> 
    <td height="35" colspan="6" class="ccc"> 
      <div align="center"><font color="#66ccff">所有考试科目的成绩</font></div></td>
  </tr>
  <tr> 
    <td width="150" height="35" class="ccc"><div align="center"><font color="#66ccff">科　目</font></div></td>
    <td width="46" height="35" class="ccc"><div align="center"><font color="#66ccff">成绩</font></div></td>
    <td width="67" height="35" class="ccc"><div align="center"><font color="#66ccff">补考成绩</font></div></td>
    <td width="146" class="ccc"><div align="center"><font color="#66ccff">科　目</font></div></td>
    <td width="54" class="ccc"><div align="center"><font color="#66ccff">成绩</font></div></td>
    <td width="64" class="ccc"><div align="center"><font color="#66ccff">补考成绩</font></div></td>
  </tr>
</table>
<table width="560" height="35" border="1" cellpadding="1" cellspacing="1">
<%
String sql5="select subject,success,bsuccess from success where snum='"+snum+"'";
ResultSet rs5=db.executeQuery(sql5);
while(rs5.next()){
String subject3=rs5.getString("subject");
int success3=rs5.getInt("success");
int bsuccess3=rs5.getInt("bsuccess");
%>
<tr> 
    <td width="150" height="31" valign="top" class="ccc"><%=subject3%></td>
    <td width="46" align="center" valign="top" class="ccc"><%if(success3==0){%>&nbsp;<%}else {%><%=success3%><%}%></td>
    <td width="67" align="center" valign="top" class="ccc"><%if (bsuccess3==0){%>&nbsp;<%}else {%><%=bsuccess3%><%}%></td>

<%
if(rs5.next()){
subject3=rs5.getString("subject");
 success3=rs5.getInt("success");
bsuccess3=rs5.getInt("bsuccess");
%>
    <td width="146" height="31" valign="top" class="ccc"><%=subject3%></td>
    <td width="47" align="center" valign="top" class="ccc"><%if(success3==0){%>&nbsp;<%}else {%><%=success3%><%}%></td>
    <td width="67" align="center" valign="top" class="ccc"><%if (bsuccess3==0){%>&nbsp;<%}else {%><%=bsuccess3%><%}%></td>
<% }else {%>
	<td width="149" height="31" valign="top" class="ccc">&nbsp;</td>
    <td width="54" align="center" valign="top" class="ccc">&nbsp;</td>
    <td width="64" align="center" valign="top" class="ccc">&nbsp;</td>	
</tr>
<%}}%>
</table>
<%} else {%>
<table width="562" height="220" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td valign="bottom" class="ccc"><div align="center">本系统中没有准考证号为<%=snum%>的考生信息，请核对后重新输入！</div></td>
  </tr>
</table>
<%}%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -