?? preview1.jsp
字號:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="_notes/aaa.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
function update(a)
{
window.open("update.jsp?qnum="+a,"body","toolbar=no,scrollbars=yes,width=540,top=30,left=20,menubar=no,systemMenu=no");
}
function submit01()
{
self.location.replace("preview1.jsp")
}
</script>
<style type="text/css">
<!--
@import url("_notes/ccc");
-->
</style>
<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 sbnum;
String pnum;
if (request.getParameter("sbnum")==null){
sbnum=(String) session.getValue("sbnum");
pnum=(String) session.getValue("pnum");
}
else {
sbnum=request.getParameter("sbnum");
pnum=request.getParameter("pnum");
}
session.putValue("sbnum",sbnum);
session.putValue("pnum",pnum);
String sql="select sbname,dep from subject where sbnum='"+sbnum+"'";
ResultSet rs=db.executeQuery(sql);
rs.next();
String sbname=rs.getString("sbname");
String dep=rs.getString("dep");
rs.close();
String sql1="select * from pap where sbnum='"+sbnum+"' and pnum='"+pnum+"'";
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%" height="392" border="0">
<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"> </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="51" align="center" valign="middle" class="ccc">系別</td>
<td><div align="center" class="ccc"><%=depname%></div></td>
</tr>
<tr>
<td align="center" valign="middle"> <div align="center" class="ccc">科目</div></td>
<td> <div align="center" class="ccc"><%=sbname%></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) {%>
標準考試
<%} else {%>
補考
<%}%>
</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"><%=phead%></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%>);"><span class="ddd" >|修改|</span></a><a href="javascript:update(<%=qnum%>);"><span class="ddd" >|刪除|</span></a><%=qnum%>.</div></td>
<td width="540" class="ccc" height="5" valign="top"><%=question%>
（難度:
<% if (diff==1){%>
易
<%} if (diff==2){%>
中
<%} if (diff==3){%>
難
<%}%>
) </td>
<td width="62" class="ccc" height="5">(<%=mark%>分)</td>
</tr>
<tr>
<td height="18"> </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">
<%if (keys==1){%>
<input type="radio" name="<%=question%>" value="radiobutton" checked>
<%}else { %>
<input type="radio" name="<%=question%>" value="radiobutton">
<%}%>
(<%=knum%>)<%=answer1%> </td>
<td> </td>
</tr>
<tr>
<td height="18"> </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">
<%if (keys==1){%>
<input type="checkbox" name="checkbox" value="checkbox" checked>
<%}else { %>
<input type="checkbox" name="checkbox2" value="checkbox">
<%}%>
(<%=knum%>)<%=answer1%></td>
<td> </td>
</tr>
<tr>
<td height="16"> </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">
<%if(key==1){%>
正確
<%}else{%>
錯誤
<%}%>
</td>
<td> </td>
</tr>
<tr>
<td height="16"> </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" ><%=key%></textarea>
</td>
<td> </td>
<%}rs6.close();}}rs4.close(); %>
</tr>
</table>
<table width="717" height="46" border="0" cellpadding="0" cellspacing="0">
<tr>
<td> <div align="center">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,2,0" width="100" height="20">
<param name=movie value="button2.swf">
<param name=quality value=high>
<param name="BASE" value=".">
<param name="BGCOLOR" value="#006666">
<embed src="button2.swf" base="." quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="100" height="20" bgcolor="#006666">
</embed> </object>
</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></td>
</tr>
</table>
<p> </p>
<div align="center"></div>
</BODY>
</HTML>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -