📄 test.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page import="java.sql.ResultSet"%>
<script language=javascript>
function btnadd()
{
window.navigate("testadd.jsp");
}
function btnedit()
{
if ((document.form1.pd.value=="" )||(document.form1.pds.value=="" ))
{alert("数据不全！");
document.form1.pds.focus();
return false;}
if ((document.form1.xz.value=="" )||(document.form1.xzs.value=="" ))
{alert("数据不全！");
document.form1.xzs.focus();
return false;}
if ((document.form1.tk.value=="" )||(document.form1.tks.value=="" ))
{alert("数据不全！");
document.form1.tks.focus();
return false;}
if (document.form1.ttime.value=="")
{alert("请输入考试时间");
document.form1.ttime.focus();
return false;
}
if (document.form1.ttime.value=="")
{if (isNaN(document.form1.ttime.value))
{alert("请输入数字！");
document.form1.ttime.focus();
return false;
}
}
document.form1.ctype.value="edit";
document.form1.submit();
}
</script>
<html>
<head>
<%!int id,id1,id2,id3,fenshu1,fenshu2,fenshu3;
String sj,data;
int rowcount =0;
ResultSet rs=null;
ResultSet rs1=null;
%>
<title>网上考试系统</title>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body topmargin="0" leftmargin="0">
<%DBConn db=new DBConn();
String sql="select * from test order by id desc ";
String sql2="select * from test ";
rs=db.Query(sql);
%>
<% rs1=db.Query(sql2);
if(rs1.last()){
rowcount=rs1.getRow();
id=rs1.getInt("id");
id1=rs1.getInt("id1");
id2=rs1.getInt("id2");
id3=rs1.getInt("id3");
fenshu1=rs1.getInt("fenshu1");
fenshu2=rs1.getInt("fenshu2");
fenshu3=rs1.getInt("fenshu3");
sj=rs1.getString("sj");
}else{
id=0;
id1=0;
id2=0;
id3=0;
fenshu1=0;
fenshu2=0;
fenshu3=0;
sj=null;
}
%>
<div>
<p>
<p align="center"><font class=test1>试卷管理理</font></p>
<div align="center">
<center>
<form name=form1 method="post" action="yanzheng10.jsp?id=<%=id%>">
<input type="hidden" name="ctype" >
<table border="1" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="400">
<tr>
<td align="center" colspan="4">第 <font color=red> <%=id %></font> 期 考卷设置（最新一期的）</td>
</tr>
<tr>
<td align="center" bgcolor="#CBEFDC">编号</td>
<td align="center" bgcolor="#CBEFDC">数目</td>
<td align="center" bgcolor="#CBEFDC">分数</td>
<td align="center" bgcolor="#CBEFDC">修改</td>
</tr>
<tr>
<td align="center">判断题</td>
<td align="center"> <input type="text" name="pd" size="5" class="line" value=<%=id1%>></td>
<td align="center">
<input type="text" name="pds" size="5" class="line" value=<%=fenshu1%>></td>
<td align="center">
<input type="checkbox" name="C1" value="on"></td>
</tr>
<tr>
<td align="center" bgcolor="#E9F8F0">选择题</td>
<td bgcolor="#E9F8F0" align="center">
<input type="text" name="xz" size="5" class="line" value=<%=id2%>></td>
<td align="center" bgcolor="#E9F8F0">
<input type="text" name="xzs" size="5" class="line" value=<%=fenshu2%>></td>
<td align="center" bgcolor="#E9F8F0">
<input type="checkbox" name="C2" value="on"></td>
</tr>
<tr>
<td align="center">填空题</td>
<td align="center">
<input type="text" name="tk" size="5" class="line" value=<%=id3%>></td>
<td align="center">
<input type="text" name="tks" size="5" class="line" value=<%=fenshu3%>></td>
<td align="center">
<input type="checkbox" name="C3" value="on"></td>
</tr>
<tr>
<td colspan="4" align="center">
考试时间 <input type="text" name="ttime" size="5" value=<%=sj%>> 分钟</td>
</tr>
<tr>
<td colspan="4" align="center">
<input type="button" value="增加" name="B1" onclick="btnadd()">
<input type="button" value="修改" name="B1" onclick="btnedit()">
<input type="reset" value="重置" name="B2">
</td>
</tr>
</table>
</form>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="400">
<%for(int i=1;i<=4;){%>
<% if(rowcount==0){%>
<tr><td colspan=5><center><font color=red>没有你查的试题信息</font></center></td></tr>
<%break;}%>
<%if(!rs.next()){
break;}%>
<% i++;
sj=rs.getString("sj");
id=rs.getInt("id");
id1=rs.getInt("id1");
id2=rs.getInt("id2");
id3=rs.getInt("id3");
fenshu1=rs.getInt("fenshu1");
fenshu2=rs.getInt("fenshu2");
fenshu3=rs.getInt("fenshu3");
%>
<tr>
<td>◆ 第 <%=id%> 期（判断题 <%=id1%> 道/ <%=fenshu1%> 分，选择题 <%=id2%> 道/ <%=fenshu2%> 分，填空题 <%=id3%> 道/ <%=fenshu3%> 分）</td>
</tr>
<%} %>
</table>
</center>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -