addq.java

jsp

//AddQ.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 AddQ extends HttpServlet
{
	//初始化数据库类
	static Connection conn;
	static Connection connn;
	static Connection fconn;
	static Connection nconn;

	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("selectobject");

		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
 		            nconn = dbcb.openConnection();
		            PreparedStatement n = nconn.prepareStatement
							("select MAX(thisID) from tilei where objectname=?");

                    n.setString(1,nameobject);
					ResultSet resultn = n.executeQuery();
					resultn.next();
                    int NewthisID = resultn.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,NewthisID);

			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;
				}*/
				connn = dbcb.openConnection();
		            PreparedStatement y = connn.prepareStatement
							("select MAX(PID) from timu");

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


			fconn = dbcb.openConnection();

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

			p.setInt(1,NewPID);
			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(" 成功添加一个题目!");

                out.println("<html>");
		        out.println("<head>");
		        out.println("<meta http-equiv='Content-Type' content='text/html; charset=gb2312'>");
		        out.println("<title>");
		      
		        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(" 成功添加一个题目!");
                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());
		}
	}


}