test.jsp
来自「可在线考试JSP等课程」· JSP 代码 · 共 67 行
JSP
67 行
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*"%>
<%
String Lesson = request.getParameter("Lesson");
String Name = request.getParameter("Name");
String No = request.getParameter("No");
String SQL = "Select * From " + Lesson + " Order By th";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce){
out.println(ce.getMessage());
}
try{
conn=DriverManager.getConnection("jdbc:odbc:test");
stmt=conn.createStatement();
rs=stmt.executeQuery(SQL);
}
catch(SQLException e){
System.out.println(e.getMessage());
}
%>
<HTML>
<title>考试界面</title>
<BODY BGCOLOR=BEIGE>
<CENTER><BODY background="test.jpg">
<H1><FONT COLOR=#6699DD>在线考试系统</FONT></H1>
</CENTER>
<H2>考试科目 -- <%=Lesson%><HR></H2>
<FORM Action="score.jsp" Method="GET">
<INPUT Type="Hidden" Name="Lesson" Value=<%=Lesson%>>
<INPUT Type="Hidden" Name="No" Value=<%=No%>>
<INPUT Type="Hidden" Name="Name" Value=<%=Name%>>
<%
String TestType = "";
String leixing = "";
String tihao = "";
while (rs.next()) //while循环,显示所有该科目的题目
{
leixing = rs.getString("lx");
tihao = rs.getString("th");
out.print("<B>" + tihao + "." + rs.getString("tm") + leixing + ":" + rs.getString("fs") + "分</B>");
out.print("<div>");
for (int i=1; i<5; i++) //for循环,显示所有该题的选项
{
if (leixing.equals("单选"))
{
TestType = "Radio";
}
else
{
TestType = "CheckBox";
}
out.print("<INPUT Type=" + TestType + " Name=No" + tihao + " Value=" + i +">" + rs.getString("xx" + String.valueOf(i)) + "<BR>");
}
out.print("</div>");
}
%>
<INPUT Type=Submit Value=" 交卷">
</FORM>
<HR>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?