📄 begin.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>
<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 dep=(String)session.getValue("dep");
String pnum=request.getParameter("pnum");
String sbnum=request.getParameter("sbnum");
String sql="select sbname from subject where dep='"+dep+"' and sbnum='"+sbnum+"'";
ResultSet rs=db.executeQuery(sql);
rs.next();
String sbname=rs.getString("sbname");
//String sbnum=rs.getString("sbnum");
rs.close();
String sql1="select * from pap where dep='"+dep+"' and pnum='"+pnum+"' and sbnum='"+sbnum+"'";
ResultSet rs1=db.executeQuery(sql1);
rs1.next();
int wproper=rs1.getInt("wproper");
String wnum=rs1.getString("wnum");
int pstate=rs1.getInt("pstate");
rs1.close();
String sql2="select tname from administrators where wnum='"+wnum+"'";
ResultSet rs2=db.executeQuery(sql2);
rs2.next();
String tname=rs2.getString("tname");
rs2.close();
String sql3="select depname from departmen where dep='"+dep+"'";
ResultSet rs3=db.executeQuery(sql3);
rs3.next();
String depname=rs3.getString("depname");
rs3.close();
%>
<table width="310" height="194" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<table width="288" height="96" border="1" cellpadding="1" cellspacing="1">
<tr>
<td height="22">
<div align="right" class="ccc">系别</div></td>
<td><div align="center" class="ccc"><%=depname%></div></td>
</tr>
<tr>
<td height="22">
<div align="right" class="ccc">科目</div></td>
<td><div align="center" class="ccc"><%=sbname%></div></td>
</tr>
<tr>
<td width="53" height="20">
<div align="right" class="ccc">性质</div></td>
<% if(wproper==1) {%>
<td><div align="center" class="ccc">标准考试</div></td>
<%}
else {
%>
<td width="35"><div align="center" class="ccc">补考</div></td>
<%}%>
</tr>
<tr>
<td height="27"><div align="right" class="ccc">命题人</div></td>
<td><div align="center" class="ccc"><%=tname%></div></td>
</tr>
</table>
<% if (pstate==1) {%>
<form name="form1" method="post" action="begin1.jsp">
<input type="hidden" name="sbnum" value="<%=sbnum%>">
<input type="submit" name="Submit" value="开始考试">
<input type="hidden" name="pnum" value="<%=pnum%>">
</form>
<%} if (pstate==2){%>
<form name="form2" method="post" action="end.jsp">
<input type="hidden" name="sbnum" value="<%=sbnum%>">
<input type="submit" name="Submit2" value="结束考试">
<input type="hidden" name="pnum" value="<%=pnum%>">
</form><%}%></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -