📄 testadd.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page import="java.sql.ResultSet"%>
<script language=javascript>
function btngiveup()
{
window.navigate("test.jsp");
}
function btnadd()
{
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;
%>
<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);
ResultSet rs1=db.Query(sql2);
rs1.last();
rowcount=rs1.getRow();
%>
<p>
<p align="center"><font class=test1>试卷管理理</font></p>
<div align="center">
<center>
<form name=form1 method="post" action="yanzheng11.jsp">
<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="3"> （最新一期）考卷设置</td>
</tr>
<tr>
<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" ></td>
<td align="center">
<input type="text" name="pds" size="5" class="line" ></td>
</tr>
<tr>
<td align="center" bgcolor="#E9F8F0">选择题</td>
<td bgcolor="#E9F8F0" align="center">
<input type="text" name="xz" size="5" class="line"></td>
<td align="center" bgcolor="#E9F8F0">
<input type="text" name="xzs" size="5" class="line"></td>
</tr>
<tr>
<td align="center">填空题</td>
<td align="center"> <input type="text" name="tk" size="5" class="line"></td>
<td align="center">
<input type="text" name="tks" size="5" class="line"></td>
</tr>
<tr>
<td colspan="3" align="center">
考试时间 <input type="text" name="ttime" size="5" > 分钟</td>
</tr>
<tr>
<td colspan="3" align="center">
<input type="button" value="增加" name="B1" onclick="btnadd()">
<input type="button" value="放弃" name="B3" onclick="btngiveup()">
<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 + -