📄 grades.jsp
字号:
<html>
<title>显示成绩</title>
<body>
以下是
<font color="green" size="5">
<%=session.getValue("name")%></font>
的作答成绩与记录<hr>
<%@page contentType = "text/html;charset=GB2312"
import = "java.sql.*"
%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:test");
Statement smt = con.createStatement();
String sql;
String answer,realans;
String an1[] = new String[5]; //是非题正确答案的数组
String an2[] = new String[5]; //单选题正确答案的数组
String an3[] = new String[5]; //多选题正确答案的数组
String ex1[] = new String[5]; //是非题作答答案的数组
String ex2[] = new String[5]; //是非题作答答案的数组
String ex3[] = new String[5]; //是非题作答答案的数组
int i,j;
int grades=0;
sql="select 答案 from test1";
ResultSet rs=smt.executeQuery(sql);
for(i=1;i<=5;i++)
{
rs.next();
realans = rs.getString(1); //取得正确答案
try
{
answer = request.getParameter("a"+i);
if(answer.equals(realans)) //比较是否正确
grades = grades + 6; //正确加6分
}
catch(Exception e)
{
answer = "";
}
an1[i-1] = realans.equals("1")? "是":"否";
if(answer.equals("1"))
ex1[i-1] = "是";
else if(answer.equals("0"))
ex1[i-1] = "否";
else
ex1[i-1] = "无";
}
sql="select 答案 from test2";
rs = smt.executeQuery(sql);
for(i=1;i<=5;i++)
{
rs.next();
realans = rs.getString(1); //取得正确答案
try
{
answer = request.getParameter("b"+i);
if(answer.equals(realans)) //比较是否正确
grades = grades + 6; //正确加6分
}
catch(Exception e)
{
answer = "";
}
an2[i-1] = realans;
ex2[i-1] = answer.equals("")? "无":answer;
}
sql="select 答案 from test3";
rs=smt.executeQuery(sql);
for(i=1;i<=5;i++)
{
rs.next();
ex3[i-1]="";
an3[i-1]=rs.getString(1);
for(j=1;j<=4;j++)
{
answer = request.getParameter("c"+i+"-"+j);
if(answer == null)
answer="";
ex3[i-1]=ex3[i-1]+answer; //将各个选择组合成字符串
}
if(ex3[i-1].equals(""))
ex3[i-1] = "无";
if(ex3[i-1].equals(an3[i-1])) //比较是否正确
grades = grades +8; //正确加8分
}
con.close();
out.println("<h3>一、是非题答案(每题6分)</h3>");
out.println("<table border='1'><tr><th bgcolor='pink'>题号</th>");
for(i=1;i<=5;i++)
out.println("<th bgcolor='pink'>"+i+"</th>");
out.println("</tr><tr><th bgcolor='pink'>正确答案</th>");
for(i=0;i<=4;i++)
out.println("<td>"+an1[i]+"</td>");
out.println("</tr><tr><th bgcolor='pink'>输入答案</th>");
for(i=0;i<=4;i++)
out.println("<td>"+ex1[i]+"</td>");
out.println("</tr></table>");
out.println("<h3>二、单选题答案(每题6分)</h3>");
out.println("<table border='1'><tr><th bgcolor='pink'>题号</th>");
for(i=1;i<=5;i++)
out.println("<th bgcolor='pink'>"+i+"</td>");
out.println("</tr><tr><th bgcolor='pink'>正确答案</th>");
for(i=0;i<=4;i++)
out.println("<td>"+an2[i]+"</td>");
out.println("</tr><tr><th bgcolor='pink'>输入答案</th>");
for(i=0;i<=4;i++)
out.println("<td>"+ex2[i]+"</td>");
out.println("</tr></table>");
out.println("<h3>三、多选题答案(每题8分)</h3>");
out.println("<table border='1'><tr><th bgcolor='pink'>题号</th>");
for(i=1;i<=5;i++)
out.println("<th bgcolor='pink'>"+i+"</td>");
out.println("</tr><tr><th bgcolor='pink'>正确答案</th>");
for(i=0;i<=4;i++)
out.println("<td>"+an3[i]+"</td>");
out.println("</tr><tr><th bgcolor='pink'>输入答案</th>");
for(i=0;i<=4;i++)
out.println("<td>"+ex3[i]+"</td>");
out.println("</tr></table>");
%>
<hr><center>总分：<font color="red" size="5">
<%=grades%></font></center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -