📄 select2.jsp

📁 Java网上考试系统
💻 JSP
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>
<BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
<%@ page contentType="text/html; charset=gb2312"%>
  <%@ page language="java" %>
  <%@ page import="java.sql.*" %>
  <%@ page import="java.io.*" %>
  <%@ page import="java.util.*" %>
  <jsp:useBean id="db" scope="page" class="exam.exam"/>
  <jsp:useBean id="db1" scope="page" class="exam.exam"/>
  <%
String question=(String) session.getValue("question");
String sbnum=(String) session.getValue("kname");
String[] answers=request.getParameterValues("answer");
for(int i=0;i<answers.length;i++){
String ans=new String(answers[i].getBytes("8859_1"));
int a=i+1;
String SQL="insert into  storer(question,sbnum,knum,answer)Values('"+question+"','"+sbnum+"','"+a+"','"+ans+"')";
ResultSet rs=db.executeQuery(SQL);
}
String pnum=request.getParameter("pnum");
session.putValue("pnum",pnum);
String[] keys=request.getParameterValues("keys");
for(int i=0;i<keys.length;i++){
String ans=new String(keys[i].getBytes("8859_1"));
int a=i+1;
String SQL1="update storer set keys='"+ans+"' where question='"+question+"' and sbnum='"+sbnum+"' and knum='"+a+"'";
ResultSet rs1=db1.executeQuery(SQL1);
}
%>
<br>
<br>
<TABLE WIDTH=750 BORDER=0 CELLPADDING=0 CELLSPACING=0 align="center">
  <TR> 
    <TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
  </TR>
  <TR> 
    <TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
    <TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
  </TR>
  <TR> 
    <TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
  </TR>
  <TR> 
    <TD> 
      <table width="231" border="0" cellspacing="0" cellpadding="0" height="226" background="images/left_top.jpg">
        <tr> 
          <td width="231"> 
            <div align="center"></div>
          </td>
        </tr>
      </table>
    </TD>
    <TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
    <TD COLSPAN=5 ROWSPAN=2> 
      <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
        <tr> 
          <td width="510"> 
            <table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
              <tr> 
                <td width="510" height="78"> 
                  <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
                </td>
              </tr>
              <tr> 
                <td> 
                  <div align="center"> 
                    <table width="480" height="346" border="0" cellpadding="0" cellspacing="0">
                      <tr> 
                        <td align="center" valign="middle"> 
                          <form name="form1" method="post" action="answer.jsp">
                            <input type="hidden" name="pnum" value="<%=pnum%>">
                            <input type="submit" name="Submit" value="继续制作问题">
                          </form>
                          <p>
                          <form name="form2" method="post" action="preview.jsp">
                            <div align="center"> 
                              <input type="hidden" name="sbnum" value="<%=sbnum%>">
                              <input type="submit" name="Submit2" value="完成试卷制作">
                            </div>
                          </form>
                          </td>
                      </tr>
                    </table>
                  </div>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </TD>
    <TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
  </TR>
  <TR> 
    <TD> 
      <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
        <tr> 
          <td width="231"> 
            <div align="center"></div>
          </td>
        </tr>
      </table>
    </TD>
  </TR>
  <TR> 
    <TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
  </TR>
  <TR> 
    <TD COLSPAN=8> <img src="images/temp_10.jpg" width=748 height=20></TD>
  </TR>
</TABLE>
</BODY>
</HTML>
⌨️ 快捷键说明

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