📄 test.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@page import="java.sql.*"%>
<%
String Lesson = request.getParameter("Lesson");
String No = request.getParameter("No");
String Name = request.getParameter("Name");
String SQL = "Select * From " + Lesson + " Order By 题号";
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>
<BODY BGCOLOR=BEIGE>
<CENTER>
<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())
{
leixing = rs.getString("类型");
tihao = rs.getString("题号");
out.print("<B>" + tihao + "." + rs.getString("题目") +
leixing + ":" + rs.getString("分数") + "分)</B>");
out.print("<div>");
for (int i=1; i<5; i++)
{
if (leixing.equals("单选"))
{
TestType = "Radio";
}
else
{
TestType = "CheckBox";
}
out.print("<INPUT Type=" + TestType + " Name=No" + tihao +
" Value=" + i +">" + (rs.getString("选项" + i)) + "<BR>");
}
out.print("</div>");
}
%>
<INPUT Type=Submit Value=" 交 卷 ">
</FORM>
<HR>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -