📄 exam.jsp
字号:
<html>
<title>考试中…</title>
<body>
<%@page contentType = "text/html;charset=GB2312"
import = "java.sql.*"
%>
作答者：<font color="green"><%=session.getValue("name")%></font>
学号：
<font color="red"><%=session.getValue("number")%></font>
<hr>
<form action="grades.jsp" action="post">
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:test");
Statement smt = con.createStatement();
String sql;
int i=1; //题号
sql="select * from test1";
ResultSet rs = smt.executeQuery(sql); //取出是非题
out.println("<h3>一、是非题(每题6分)</h3>");
out.println("<table>");
while(rs.next()) //显示是非题
{
out.println("<tr><td>"+i+". ");
out.println(rs.getString(2)+"</td>");
out.println("<td>是<input type='radio' name='a"+i+"' value='1'></td><td>否<input type='radio' name='a"+i+"' value='0'></td></tr>");
i++;
}
out.println("</table>");
out.println("<h3>二、单选题(每题6分)</h3>");
i=1;
sql="select * from test2"; //取出单选题
rs = smt.executeQuery(sql);
out.println("<table>");
while(rs.next()) //显示单选题
{
out.println("<tr><td>"+i+". ");
out.println(rs.getString(2)+"</td></tr>");
out.println("<tr><td>(1)"+rs.getString(3)+
"<input type='radio' name='b"+i+"' value='1'>(2)"+
rs.getString(4)+"<input type='radio' name='b"+i+
"' value='2'>(3)"+rs.getString(5)+
"<input type='radio' name='b"+i+"' value='3'>(4)"+
rs.getString(6)+"<input type='radio' name='b"+i+
"' value='4'></td></tr>");
i++;
}
out.println("</table>");
out.println("<h3>三、多选题(每题8分)</h3>");
i=1;
sql="select * from test3"; //取出多选题
rs = smt.executeQuery(sql);
out.println("<table");
while(rs.next()) //显示多选题
{
out.println("<tr><td>"+i+". ");
out.println(rs.getString(2)+"</td></tr>");
out.println("<tr><td>");
for(int j=1;j<=4;j++)
out.println("("+j+")"+rs.getString(j+2)+
"<input type='checkbox' name='c"+i+"-"+j+
"' value='"+j+"'>");
i++;
}
out.println("</table>");
con.close();
%>
<hr>
<center><input type="submit" value="交卷">
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -