📄 stupaper.jsp

📁 一个很详细的考试管理系统。有源文件。还有毕业论文。大家可以仔细参考。
💻 JSP
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>预览试卷</title>
<link rel="stylesheet" href="_notes/ddd.css" type="text/css">
</HEAD>
<BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" ">
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="db" scope="page" class="exam.exam"/>
<jsp:useBean id="db1" scope="page" class="exam.exam"/>
<jsp:useBean id="db2" scope="page" class="exam.exam"/>
<jsp:useBean id="db3" scope="page" class="exam.exam"/>
<jsp:useBean id="db4" scope="page" class="exam.exam"/>
<jsp:useBean id="db5" 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,sbnum from subject where dep='"+dep+"'";
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 rsPap=db1.executeQuery(sql1);
rsPap.next();
String phead=rsPap.getString("phead");
int wproper=rsPap.getInt("wproper");
String wnum=rsPap.getString("wnum");
rsPap.close();
String sql2="select tname from administrators where wnum='"+wnum+"'";
ResultSet rs2=db2.executeQuery(sql2);
rs2.next();
String tname=rs2.getString("tname");
rs2.close();
String sql3="select depname from departmen where dep='"+dep+"'";
ResultSet rs3=db3.executeQuery(sql3);
rs3.next();
String depname=rs3.getString("depname");
rs3.close();
%>
<br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="396">
  <tr>
    <td>
      <table width="731" height="422" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td align="center" valign="top"> 
            <table width="725" height="15" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td width="420" height="15"><img src="images/temp_01.jpg" width="420" height="15"></td>
                <td width="305"><img src="images/temp_02.jpg" width="330" height="15"></td>
              </tr>
            </table>
            <table width="747" height="57" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td width="223" background="images/left_top.jpg">&nbsp;</td>
                <td width="524" background="images/main_bg.jpg"><img src="images/blank_banner.gif" width="468" height="60"></td>
              </tr>
            </table>
            <table width="747" height="89" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td height="89"> 
                  <table width="271" border="1" cellspacing="1" cellpadding="0">
                    <tr> 
                      <td width="40" align="center" valign="middle" class="ccc">系别</td>
                      <td> 
                        <div align="center" class="ccc"><font color="#ffff00"><%=depname%></font></div>
                      </td>
					   <td width="40" align="center" valign="middle" class="ccc">学号</td>
					   <td> 
                        <div align="center" class="ccc"><font color="#ffff00">20030101528</font></div>
                      </td>
                    </tr>
                    <tr> 
                      <td align="center" valign="middle"> 
                        <div align="center" class="ccc">科目</div>
                      </td>
                      <td> 
                        <div align="center" class="ccc"><font color="#ffff00"><%=sbname%></font></div>
                      </td>
					  <td width="40" align="center" valign="middle" class="ccc">姓名</td>
					   <td> 
                        <div align="center" class="ccc"><font color="#ffff00">陈燕平</font></div>
                      </td>
                    </tr>
                    <tr> 
                      <td align="center" valign="middle"> 
                        <div align="center" class="ccc">性质</div>
                      </td>
                      <td> 
                        <div align="center" class="ccc"> 
                          <% if(wproper==1) {%>
                          <font color="#ffff00">标准考试 </font>
                          <%} else {%>
                          <font color="#ffff00">补考 </font>
                          <%}%>
                        </div>
                      </td>
					  <td width="40" align="center" valign="middle" class="ccc">班级</td>
					   <td> 
                        <div align="center" class="ccc"><font color="#ffff00">JAVA班</font></div>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
            <table width="709" height="62" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td align="center" valign="middle"> 
                  <div align="center" class="aaa"><font color="#ffff00"><%=phead%></font></div>
                </td>
              </tr>
            </table>
            <% 
String sql4="select distinct qnum,question,mark,type,diff from question where sbnum='"+sbnum+"' and pnum='"+pnum+"'order by qnum";
ResultSet rs4=db4.executeQuery(sql4);
while(rs4.next()) 
{
   int qnum=rs4.getInt("qnum");
   String question=rs4.getString("question");
   int mark=rs4.getInt("mark");
   int type=rs4.getInt("type");
   int diff=rs4.getInt("diff");
   %>
   <table width="716" height="130" border="0" cellpadding="0" cellspacing="0">
   <tr> 
   <td width="114" height="5" valign="top"> 
	  <div align="right" class="ccc"><a href="javascript:update(<%=qnum%>);"></a><%=qnum%>.</div>
   </td>
    <td width="540" class="ccc" height="5" valign="top"><%=question%> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>题类:</strong> 
                  <% if (type==1)
					{%>
                  <font color="#FFCCCC">单选题</font> 
                  <%}
					if (type==2)
					{%>
                  <font color="#FFCCCC">多选题</font> 
                  <%} 
					if (type==3){%>
                  <font color="#FFCCCC">判断题</font> 
                  <%}
					if (type==4)
					{%>
                  <font color="#FFCCCC">填空题</font> 
                  <%}  %>
    </td>
    <td width="62" class="ccc" height="5">(<%=mark%>分)</td>
   </tr>

   <tr> 
     <td height="18">&nbsp;</td>
                <%
	if (type==1)
	{
		String sql5="select * from storer where question='"+question+"' and sbnum='"+sbnum+"' order by knum";
		ResultSet rs5=db5.executeQuery(sql5);
		while(rs5.next())
		{
			int knum=rs5.getInt("knum");
			String answer1=rs5.getString("answer");
			int keys=rs5.getInt("keys");
			%>
             <td valign="top" class="ccc"> 
					<input type="radio" name="<%=question%>" >
                  (<%=knum%>)<%=answer1%> 
			</td>
             <td>&nbsp;</td>
              </tr>
			  
              <tr> 
                <td height="18">&nbsp;</td>
                <%
		}rs5.close();
	}
	
	if(type==2)
	{
		String sql6="select * from storer where question='"+question+"' and sbnum='"+sbnum+"' order by knum";
		ResultSet rs6=db5.executeQuery(sql6);
		while(rs6.next())
		{
			int knum=rs6.getInt("knum");
			String answer1=rs6.getString("answer");
			int keys=rs6.getInt("keys");				  
			%>
            <td valign="top" class="ccc"> 
					 <input type="checkbox" name="checkbox2">
						
                 (<%=knum%>)<%=answer1%>
			</td>
            <td>&nbsp;</td>
              </tr>
            
			  <tr> 
                <td height="16">&nbsp;</td>
                <%
		}rs6.close();
	}
		
	if(type==3)
	{
		String sql6="select * from storer where question='"+question+"' and sbnum='"+sbnum+"'";
		ResultSet rs6=db5.executeQuery(sql6);
		while(rs6.next())
		{
			int key=rs6.getInt("keys");
				  %>
            <td class="ccc" valign="top"> 
				 <input type="radio" name="true1" value="1">&nbsp;正确&nbsp;
				 <input type="radio" name="true2" value="0">&nbsp;错误&nbsp;
            </td>
                <td>&nbsp;</td>

		    </tr>
            
			  <tr> 
                <td height="16">&nbsp;</td>
                <% 
		}rs6.close();
	}
	
	if (type==4)
	{
		String sql6="select * from storer where question='"+question+"' and sbnum='"+sbnum+"'";
		ResultSet rs6=db5.executeQuery(sql6);
		while(rs6.next())
		{
			String key=rs6.getString("keys");%>
            <td valign="top"> 
              <textarea name="textarea" cols="50" ></textarea>
            </td>
            <td>&nbsp;</td>
                <%
		}rs6.close();
	}
}rs4.close(); %>
              </tr>
            </table>
            <table width="717" height="46" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td> 
                  <div align="center"> 
                    <form name="form1" method="post" action="fb.jsp" >
                      <input type="hidden" name="sbnum" value="<%=sbnum%>">
                      <input type="submit" name="Submit" value="发布">
                      <input type="hidden" name="pnum" value="<%=pnum%>">
                    </form>
                  </div>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
      <table width="747" height="15" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td width="420"><img src="images/temp_01.jpg" width="420" height="15"></td>
          <td width="327"><img src="images/temp_02.jpg" width="330" height="15"></td>
        </tr>
      </table>
      <div align="center"></div>
    </td>
  </tr>
</table>
<p>&nbsp;</p>
<div align="center"></div>
</BODY>
</HTML>
💿 文件大小 4841 K
👤 上传用户 chengshengwu123
📂 所属分类 Java编程
🏷️ 相关标签

#管理系统 #有源 #家 #毕业论文
⌨️ 快捷键说明

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