addobject.java

实现在线考试功能. ?迪衷谙呖际怨δ?

//AddObject.java
//添加注册资料的servlet

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



public class AddObject extends HttpServlet
{
	//初始化数据库类
	static Connection conn;
	static Connection connn;
	static Connection fconn;

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

		String Q = "";
		String daanA = "";
		String daanB = "";
		String daanC = "";
		String daanD = "";
		String Rdaan = "";
		int thistileiID = 1;

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

		String Q1 = req.getParameter("Q1");
		String daanA1 = req.getParameter("daanA1");
		String daanB1 = req.getParameter("daanB1");
		String daanC1 = req.getParameter("daanC1");
		String daanD1 = req.getParameter("daanD1");
		String Rdaan1 = req.getParameter("Rdaan1");

		String Q2 = req.getParameter("Q1");
		String daanA2 = req.getParameter("daanA2");
		String daanB2 = req.getParameter("daanB2");
		String daanC2 = req.getParameter("daanC2");
		String daanD2 = req.getParameter("daanD2");
		String Rdaan2 = req.getParameter("Rdaan2");

		String Q3 = req.getParameter("Q3");
		String daanA3 = req.getParameter("daanA3");
		String daanB3 = req.getParameter("daanB3");
		String daanC3 = req.getParameter("daanC3");
		String daanD3 = req.getParameter("daanD3");
		String Rdaan3 = req.getParameter("Rdaan3");

		String Q4 = req.getParameter("Q4");
		String daanA4 = req.getParameter("daanA4");
		String daanB4 = req.getParameter("daanB4");
		String daanC4 = req.getParameter("daanC4");
		String daanD4 = req.getParameter("daanD4");
		String Rdaan4 = req.getParameter("Rdaan4");

		String Q5 = req.getParameter("Q5");
		String daanA5 = req.getParameter("daanA5");
		String daanB5 = req.getParameter("daanB5");
		String daanC5 = req.getParameter("daanC5");
		String daanD5 = req.getParameter("daanD5");
		String Rdaan5 = req.getParameter("Rdaan5");

		String Q6 = req.getParameter("Q6");
		String daanA6 = req.getParameter("daanA6");
		String daanB6 = req.getParameter("daanB6");
		String daanC6 = req.getParameter("daanC6");
		String daanD6 = req.getParameter("daanD6");
		String Rdaan6 = req.getParameter("Rdaan6");

		String Q7 = req.getParameter("Q7");
		String daanA7 = req.getParameter("daanA7");
		String daanB7 = req.getParameter("daanB7");
		String daanC7 = req.getParameter("daanC7");
		String daanD7 = req.getParameter("daanD7");
		String Rdaan7 = req.getParameter("Rdaan7");

		String Q8 = req.getParameter("Q8");
		String daanA8 = req.getParameter("daanA8");
		String daanB8 = req.getParameter("daanB8");
		String daanC8 = req.getParameter("daanC8");
		String daanD8 = req.getParameter("daanD8");
		String Rdaan8 = req.getParameter("Rdaan8");

		String Q9 = req.getParameter("Q9");
		String daanA9 = req.getParameter("daanA9");
		String daanB9 = req.getParameter("daanB9");
		String daanC9 = req.getParameter("daanC9");
		String daanD9 = req.getParameter("daanD9");
		String Rdaan9 = req.getParameter("Rdaan9");

		String Q10 = req.getParameter("Q10");
		String daanA10 = req.getParameter("daanA10");
		String daanB10 = req.getParameter("daanB10");
		String daanC10 = req.getParameter("daanC10");
		String daanD10 = req.getParameter("daanD10");
		String Rdaan10 = req.getParameter("Rdaan10");



		try
		{
			//生成新科目的ID
		            connn = dbcb.openConnection();
		            PreparedStatement y = connn.prepareStatement
							("select MAX(tileiID) from tilei");

					ResultSet result = y.executeQuery();
					result.next();
                    int NewtileiID = result.getInt(1) + 1;


            //保存新科目ID和名称
			conn = dbcb.openConnection();

			PreparedStatement s = conn.prepareStatement
			        ("insert tilei values(?,?,?)");

			s.setInt(1,NewtileiID);
			s.setString(2,nameobject);
			s.setInt(3,thistileiID);

			int rows = s.executeUpdate();
							if(rows==0)
							{
								System.out.println("数据超出规格，注册失败！");
				             }


		    //保存新创建科目所必须的10道题
		    for(int count=1;count<11;count++)
		    {
				if(count==1)
				{
					Q = Q1;
					daanA = daanA1;
					daanB = daanB1;
					daanC = daanC1;
					daanD = daanD1;
					Rdaan = Rdaan1;
				}
				if(count==2)
				{
					Q = Q2;
					daanA = daanA2;
					daanB = daanB2;
					daanC = daanC2;
					daanD = daanD2;
					Rdaan = Rdaan2;
				}
				if(count==3)
				{
					Q = Q3;
					daanA = daanA3;
					daanB = daanB3;
					daanC = daanC3;
					daanD = daanD3;
					Rdaan = Rdaan3;
				}
				if(count==4)
				{
					Q = Q4;
					daanA = daanA4;
					daanB = daanB4;
					daanC = daanC4;
					daanD = daanD4;
					Rdaan = Rdaan4;
				}
				if(count==5)
				{
					Q = Q5;
					daanA = daanA5;
					daanB = daanB5;
					daanC = daanC5;
					daanD = daanD5;
					Rdaan = Rdaan5;
				}
				if(count==6)
				{
					Q = Q6;
					daanA = daanA6;
					daanB = daanB6;
					daanC = daanC6;
					daanD = daanD6;
					Rdaan = Rdaan6;
				}
				if(count==7)
				{
					Q = Q7;
					daanA = daanA7;
					daanB = daanB7;
					daanC = daanC7;
					daanD = daanD7;
					Rdaan = Rdaan7;
				}
				if(count==8)
				{
					Q = Q8;
					daanA = daanA8;
					daanB = daanB8;
					daanC = daanC8;
					daanD = daanD8;
					Rdaan = Rdaan8;
				}
				if(count==9)
				{
					Q = Q9;
					daanA = daanA9;
					daanB = daanB9;
					daanC = daanC9;
					daanD = daanD9;
					Rdaan = Rdaan9;
				}
				if(count==10)
				{
					Q = Q10;
					daanA = daanA10;
					daanB = daanB10;
					daanC = daanC10;
					daanD = daanD10;
					Rdaan = Rdaan10;
				}

			fconn = dbcb.openConnection();

			PreparedStatement p = fconn.prepareStatement
			        ("insert timu values(?,?,?,?,?,?,?)");

			p.setInt(1,NewtileiID);
			p.setString(2,Q);
			p.setString(3,daanA);
			p.setString(4,daanB);
			p.setString(5,daanC);
			p.setString(6,daanD);
			p.setString(7,Rdaan);

			int frows = p.executeUpdate();
							if(frows==0)
							{
								System.out.println("数据超出规格，注册失败！");
				             }
			}

            conn.close();
            connn.close();
            fconn.close();
            System.out.println("科目" + nameobject + " 添加成功!");

                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("</head>");
		        out.println("<body>");
                out.println("<div align='center'>");
                out.println("<p>");
                out.println(nameobject + " 已经成功添加!");
                out.println("</p>");
                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());
		}
	}


}