📄 jisuan.java

📁 实现在线考试功能. ?迪衷谙呖际怨δ?
💻 JAVA
字号:
//Jisuan.java
//计算考试成绩的servlet

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;
import java.util.*;

public class Jisuan extends HttpServlet
{
	//初始化数据库类
	static Connection conn;
	DBConnectionBean dbcb = new DBConnectionBean();

    //定义doPost方法用来接受数据
	public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
	{
		int AllFenS = 0;
	    int AllFenF = 0;
		//定义输出流
		req.setCharacterEncoding("gb2312");
		res.setContentType("text/html;charset=gb2312");
		PrintWriter out = res.getWriter();


        //提取表单数据
        String BID = req.getParameter("BID");

		String select1 = req.getParameter("select1");
		String select2 = req.getParameter("select2");
		String select3 = req.getParameter("select3");
		String select4 = req.getParameter("select4");
		String select5 = req.getParameter("select5");
		String select6 = req.getParameter("select6");
		String select7 = req.getParameter("select7");
		String select8 = req.getParameter("select8");
		String select9 = req.getParameter("select9");
		String select10 = req.getParameter("select10");

		String yesDanan1 = req.getParameter("yesDanan1");
		String yesDanan2 = req.getParameter("yesDanan2");
		String yesDanan3 = req.getParameter("yesDanan3");
		String yesDanan4 = req.getParameter("yesDanan4");
		String yesDanan5 = req.getParameter("yesDanan5");
		String yesDanan6 = req.getParameter("yesDanan6");
		String yesDanan7 = req.getParameter("yesDanan7");
		String yesDanan8 = req.getParameter("yesDanan8");
		String yesDanan9 = req.getParameter("yesDanan9");
		String yesDanan10 = req.getParameter("yesDanan10");
        //计算分数
		if(select1.equals(yesDanan1))
		{

			AllFenS = AllFenS + 10;
		}
		if(select2.equals(yesDanan2))
				{
					AllFenS = AllFenS + 10;
				}
		if(select3.equals(yesDanan3))
				{
					AllFenS = AllFenS + 10;
				}
		if(select4.equals(yesDanan4))
				{
					AllFenS = AllFenS + 10;
				}
		if(select5.equals(yesDanan5))
				{
					AllFenS = AllFenS + 10;
				}
		if(select6.equals(yesDanan6))
				{
					AllFenS = AllFenS + 10;
				}
		if(select7.equals(yesDanan7))
				{
					AllFenS = AllFenS + 10;
				}
		if(select8.equals(yesDanan8))
				{
					AllFenS = AllFenS + 10;
				}
		if(select9.equals(yesDanan9))
				{
					AllFenS = AllFenS + 10;
				}
		if(select10.equals(yesDanan10))
				{
					AllFenS = AllFenS + 10;
				}
		AllFenF = AllFenS;

		try
		{
			//桥接连接数据库,保存考生成绩

			conn = dbcb.openConnection();

            System.out.println("数据库连接成功....");
			PreparedStatement s = conn.prepareStatement
			        ("UPDATE allStuday SET Score=?  WHERE SID=?");

			s.setInt(1,AllFenF);
			s.setString(2,BID);
			int rows = s.executeUpdate();

            System.out.println("发送SQL命令成功....");
            				if(rows==1)
							{
								System.out.println("用户 " + BID + "成绩为" + AllFenF + "保存成功!");
							}

                out.println("<html>");
                out.println("<head>");
                out.println("<meta http-equiv='Content-Type' content='text/html; charset=gb2312'>");
                out.println("<title>");
                out.println("已答题完毕");
                out.println("</title>");
 				                out.println
				                 ("<script language='JavaScript' type='text/JavaScript' src='/myside/examin/img/youno.js'>");
				                out.println("</script>");
                out.println("<link href='/myside/examin/img/cssexamin.css' rel='stylesheet' type='text/css'>");
                out.println("</head>");
                out.println("<body>");
                out.println("<div align='center'>");
                out.println("您的成绩已经存在，请输入您的用户名，以便查询您的成绩!");
                out.println("<form name='form1' method='post' action='/myside/examin/loginC.jsp'>");
                out.println("I D:");
                out.println("<input name='textfield' type='text' value=" + BID + " size='15'>");
                out.println("<input type='submit' name='Submit' value='提交'>");
                out.println("<p>");
                out.println("</p>");
                out.println("<font color='#666666' class='banquan'>");
                out.println("&copy;Copyright&nbsp; RUSCN (dot) NET China & copy 2001-2003 &#8482;");
                out.println("<a href='mailto:galaxy@ruscn.net'>");
                out.println("<font color='#0033FF'>");
                out.println("银河工作室");
                out.println("</font>");
                out.println("</a>");
                out.println("版权所有");
                out.println("</font>");
                out.println("</div>");
                out.println("</body>");
                out.println("</html>");
                out.close();

		}
		//三个常见异常
		catch(SQLException e)
		{
			System.out.println(e.toString());
		}
		catch(Exception e)
		{
			System.out.println(e.toString());
		}
	}

}
💿 文件大小 808 K
👤 上传用户 yl810406
📂 所属分类 Jsp/Servlet
⌨️ 快捷键说明

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