📄 score.jsp

📁 石志国著《JSP应用教程》
💻 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 = "";
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	ResultSet rsScore = 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("Select * from " + Lesson);
	}
	catch(SQLException e){
		System.out.println(e.getMessage());
	}
%>
<HTML>
	<BODY BGCOLOR="BEIGE">
	<H2>成绩单<HR></H2>
<%
	int Score = 0;
	while (rs.next())
	{	
		String tihao = rs.getString("题号");
		if (request.getParameter("No" + tihao)!=null)
		{
			String Sel = request.getParameter("No" + tihao);
			String Ans = rs.getString("解答");
			//out.print(Sel + Ans + "<br>");
			if (Ans.equals(Sel))
			{
				Score = Score + rs.getInt("分数");
                //out.print( "OK");
			}
		}
	}
    stmt.close();
	conn.close();
	SQL = "Select * From 成绩单 ";
	SQL = SQL + "Where 学号=" + "'" + No + "'" + " And 姓名='" + Name + "'";
	int iJSP = 0;
	int iXML = 0;
		try{
		conn=DriverManager.getConnection("jdbc:odbc:test");
		stmt=conn.createStatement();
		rsScore=stmt.executeQuery(SQL);
		rsScore.next();
		String kaoshi = rsScore.getString(Lesson);
		//out.print(kaoshi);
		if (!Lesson.equals("JSP"))
		iJSP = rsScore.getInt("JSP");
		else
		iJSP = Score;
		if (!Lesson.equals("XML"))
		iXML = rsScore.getInt("XML");
		else
		iXML = Score;
		if (kaoshi.equals("-1"))
		{
			SQL = "update 成绩单 set " + Lesson + " = "  + Score + 
				" where 学号=" + "'" + No + "'" +
				" And 姓名='" + Name + "'";
			stmt.executeUpdate(SQL);
		}
		else
		{
			out.print("<script>{alert('你已经考过了')}</script>");
		}
	}
	catch(SQLException e){
		System.out.println(e.getMessage());
	}
%>
	<%=Name%>同志你好，你的考试成绩统计为：<BR>
	<CENTER>
	  <TABLE BORDER=2 BGCOLOR="#F1F1F1" WIDTH=80%>
	  <TR BGCOLOR="#DDDDDD"><TD>你参加的科目</TD><TD>你的分数</TD></TR>
	  <TR><TD>JSP</TD><TD Align=Right><%=iJSP%></TD></TR>
	  <TR><TD>XML</TD><TD Align=Right><%=iXML%></TD></TR>
	  </TABLE></center>
	<HR>
	<A HREF="login.jsp?No=<%=No%>+Name=<%=Name%>">参加其他科目考试</A>
	</BODY>

</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -