Question: chn.ilp.test

Ads

 
 
 

Share on Google+Share on Google+

rajesh
chn.ilp.test
9 Answer(s)      5 years and a month ago
Posted in : Java Beginners
public class Constants {
    public static String DRIVERNAME = "oracle.jdbc.driver.OracleDriver";
    public static String SERVERNAME = "172.24.137.30";
    public static String PORTNUMBER = "1521";
    public static String SID = "ora10G";
    public static String URL = "jdbc:oracle:thin:@" + SERVERNAME + ":"
            + PORTNUMBER + ":" + SID;
    public static String USERNAME = "e";
    public static String PASSWORD = "";
}
Ads
View Answers

April 2, 2012 at 8:05 AM


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import com.otts.constants.Constants;




public class ConnectionOracle {
public Connection OraConn() 
{       

    Connection conn=null;
    try 
    {
        // load the JDBC-ODBC Bridge driver         
        Class.forName(Constants.DRIVERNAME);
        conn =DriverManager.getConnection( Constants.URL,Constants.USERNAME,Constants.PASSWORD );


    }

    catch ( ClassNotFoundException cnfex ) 
    {
        System.out.println("Class not found !! " +cnfex);           
    }
    catch ( SQLException sqlex ) 
    {
        System.out.println("SQL Exception !! " +sqlex);         
        sqlex.printStackTrace();
    }
    catch (Exception ex)
    {
        System.out.println("Exception has occured "+ex);
    }
    return conn;
}

}


April 2, 2012 at 8:06 AM


package com.otts.servlet;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.log4j.Logger;

import com.otts.dao.GetStudentCountDAO;
import com.otts.dao.GetStudentIDDAO;
import com.otts.dao.GetTeacherIDDAO;
import com.otts.dao.GetTestIDDAO;
import com.otts.service.AssignQuestiontoTestService;
import com.otts.service.AssignStudentService;
import com.otts.service.CreateQuestionService;
import com.otts.service.CreateTestService;
import com.otts.service.DeleteQuestionService;
import com.otts.service.DeleteQuestionfromTestService;
import com.otts.service.DeleteStudentService;
import com.otts.service.DeleteTestService;
import com.otts.service.TakeTestService;
import com.otts.service.UpdateQntoTestService;
import com.otts.service.UpdateQuestionService;
import com.otts.service.UpdateStudentService;
import com.otts.service.UpdateTestService;
import com.otts.service.ViewQnfromTest1Service;
import com.otts.service.ViewQnfromTestService;
import com.otts.service.ViewQues1Service;
import com.otts.service.ViewQuestionService;
import com.otts.service.ViewStudentService;
import com.otts.service.ViewTestService;
import com.otts.vo.CreateTestVo;
import com.otts.vo.DeleteTestVo;
import com.otts.vo.QuestionVO;
import com.otts.vo.StudentVO;
import com.otts.vo.TakeTestVO;
import com.otts.vo.TestVO;
import com.otts.vo.TestVO1;
import com.otts.vo.ViewTestVo;

/**
* Servlet implementation class TestQuestionManagementServlet
*/
public class TestQuestionManagementServlet extends HttpServlet {
private static final Logger log = Logger
    .getLogger(TestQuestionManagementServlet.class);
private static final long serialVersionUID = 1L;
public int selectedAnsArray[] = new int[10];
String testName, category;
int duration, participants, invigilator, testID;
CreateTestVo createtestvo = new CreateTestVo();
CreateTestService createtestservice = new CreateTestService();
ViewTestVo viewtest = new ViewTestVo();

/**
* @see HttpServlet#HttpServlet()
*/
public TestQuestionManagementServlet() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#service(HttpServletRequest request, HttpServletResponse
*      response)
*/
protected void doPost(HttpServletRequest request,
    HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}

/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
*      response)
*/
protected void doGet(HttpServletRequest request,
    HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
*      response)
*/
protected void service(HttpServletRequest request,
    HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
// Servlet for CreateQuestion
String pagename = request.getParameter("pagename");
log.info("Page : " + pagename);
if (pagename.equals("CreateQuestion")) {

    int teacherid = Integer.parseInt(request.getParameter("teacherid"));
    int questionid = Integer.parseInt(request
            .getParameter("questionid"));
    String questioncontent = request.getParameter("questioncontent");
    String category = request.getParameter("category");
    String option1 = request.getParameter("option1");
    String option2 = request.getParameter("option2");
    String option3 = request.getParameter("option3");
    String option4 = request.getParameter("option4");
    int correctanswer = Integer.parseInt(request
            .getParameter("correctanswer"));

    GetTeacherIDDAO teaid = new GetTeacherIDDAO();
    int teacheridcheck = 0;
    teacheridcheck = teaid.getTeacherId(teacherid);

    if (teacheridcheck == 0) {
        String status = "Teacher Id not present";
        log.info("Teacher Id not present in Servlet");
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/ FailureCaseinDatabase.jsp");
        request.setAttribute("status", status);
        rd1.forward(request, response);
    } else {

        // setting values to vo
        log.info(questioncontent + "content servlet");
        QuestionVO question = new QuestionVO();

        question.setTeacherid(teacherid);
        question.setCategory(category);
        question.setQuestionid(questionid);
        question.setQuestioncontent(questioncontent);
        log.info(questioncontent);
        question.setOption1(option1);
        question.setOption2(option2);
        question.setOption3(option3);
        question.setOption4(option4);
        question.setCorrectanswer(correctanswer);

        CreateQuestionService createques = new CreateQuestionService();
        int count = 0;
        try {
            count = createques.insertQuestion(question, 1);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            log.info("Failed at Servlet");
            log.info("Failed at servlet Create Question");
        }
        // Success Page
        if (count >= 1) {
            request.setAttribute("mycount", count);
            RequestDispatcher rd1 = getServletContext()
                    .getRequestDispatcher(
                            "/JSP/InsertQuestionSucess.jsp");
            log.info("Question Inserted");
            rd1.forward(request, response);
            // Error Page
        } else {
            RequestDispatcher rd1 = getServletContext()
                    .getRequestDispatcher("/JSP/FailureCase.jsp");
            log.info("Failed to insert question");
            rd1.forward(request, response);
        }
    }
    // Servlet for AssignQuestion
} else if (pagename.equalsIgnoreCase("assignQuestion")) {
    int questionId1 = Integer.parseInt(request
            .getParameter("questionId1"));
    int questionId2 = Integer.parseInt(request
            .getParameter("questionId2"));
    int questionId3 = Integer.parseInt(request
            .getParameter("questionId3"));
    int questionId4 = Integer.parseInt(request
            .getParameter("questionId4"));
    int questionId5 = Integer.parseInt(request
            .getParameter("questionId5"));
    int questionId6 = Integer.parseInt(request
            .getParameter("questionId6"));
    int questionId7 = Integer.parseInt(request
            .getParameter("questionId7"));
    int questionId8 = Integer.parseInt(request
            .getParameter("questionId8"));
    int questionId9 = Integer.parseInt(request
            .getParameter("questionId9"));
    int questionId10 = Integer.parseInt(request
            .getParameter("questionId10"));
    int testId = Integer.parseInt(request.getParameter("testId"));
    // Create object for Testvo
    TestVO question = new TestVO();
    question.setQuestionId1(questionId1);
    question.setQuestionId2(questionId2);
    question.setQuestionId3(questionId3);
    question.setQuestionId4(questionId4);
    question.setQuestionId5(questionId5);
    question.setQuestionId6(questionId6);
    question.setQuestionId7(questionId7);
    question.setQuestionId8(questionId8);
    question.setQuestionId9(questionId9);
    question.setQuestionId10(questionId10);
    question.setTestId(testId);

    question.setTestId(testId);

    AssignQuestiontoTestService assignquestionservice = new AssignQuestiontoTestService();
    int count = 0;
    try {
        count = assignquestionservice.data(question);
    } catch (Exception e) {
        e.printStackTrace();
    }
    // Success Page
    if (count >= 1) {
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/ViewAssignQnSuccess.jsp");
        rd1.forward(request, response);
        // ErrorPage
    } else if (count == -2) {
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/ViewAssignQnFailure.jsp");
        rd1.forward(request, response);
    }

}
// Srevlet for Update QuestionId
else if (pagename.equalsIgnoreCase("Update3")) {
    int testid = Integer.parseInt(request.getParameter("testid"));
    int question1 = Integer.parseInt(request
            .getParameter("questionid1"));
    int question2 = Integer.parseInt(request
            .getParameter("questionid2"));
    int question3 = Integer.parseInt(request
            .getParameter("questionid3"));
    int question4 = Integer.parseInt(request
            .getParameter("questionid4"));
    int question5 = Integer.parseInt(request
            .getParameter("questionid5"));
    int question6 = Integer.parseInt(request
            .getParameter("questionid6"));
    int question7 = Integer.parseInt(request
            .getParameter("questionid7"));
    int question8 = Integer.parseInt(request
            .getParameter("questionid8"));
    int question9 = Integer.parseInt(request
            .getParameter("questionid9"));
    int question10 = Integer.parseInt(request
            .getParameter("questionid10"));

    TestVO question = new TestVO();

    question.setTestId(testid);
    question.setQuestionId1(question1);
    question.setQuestionId2(question2);
    question.setQuestionId3(question3);
    question.setQuestionId4(question4);
    question.setQuestionId5(question5);
    question.setQuestionId6(question6);
    question.setQuestionId7(question7);
    question.setQuestionId8(question8);
    question.setQuestionId9(question9);
    question.setQuestionId10(question10);

    UpdateQntoTestService upques = new UpdateQntoTestService();
    int count = upques.updateQuestion(question);
    // Success Page
    if (count >= 1) {
        request.setAttribute("mycount", count);
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/UpdateQntoTestSuccess.jsp");
        rd1.forward(request, response);
        // ErrorPage
    } else {
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/UpdateQntoTestFailure.jsp");
        rd1.forward(request, response);
    }
}
// Servlet for UpdateTest
else if (pagename.equalsIgnoreCase("update1")) {

    int testId = Integer.parseInt(request.getParameter("testId"));
    ViewQnfromTest1Service vqs = new ViewQnfromTest1Service();

    HashMap<Integer, TestVO> ar = null;
    try {
        ar = vqs.viewQuestions(testId);
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    log.info(ar);
    System.out.println("ajs");
    request.setAttribute("arr", ar);

    RequestDispatcher rd1 = getServletContext().getRequestDispatcher(
            "/JSP/UpdateQuestiontoTestDB.jsp");
    rd1.forward(request, response);

}
// Servlet for UpdateQuestion
else if (pagename.equals("update2")) {
    log.info(pagename);
    RequestDispatcher rd1 = getServletContext().getRequestDispatcher(
            "/JSP/UpdateQuestiontoTestFinal.jsp");
    String test1 = request.getParameter("testId1");
    String qn1 = request.getParameter("questionId1");
    String qn2 = request.getParameter("questionId2");
    String qn3 = request.getParameter("questionId3");
    String qn4 = request.getParameter("questionId4");
    String qn5 = request.getParameter("questionId5");
    String qn6 = request.getParameter("questionId6");
    String qn7 = request.getParameter("questionId7");
    String qn8 = request.getParameter("questionId8");
    String qn9 = request.getParameter("questionId9");
    String qn10 = request.getParameter("questionId10");
    request.setAttribute("testId1", test1);
    request.setAttribute("qid1", qn1);
    request.setAttribute("qid2", qn2);
    request.setAttribute("qid3", qn3);
    request.setAttribute("qid4", qn4);
    request.setAttribute("qid5", qn5);
    request.setAttribute("qid6", qn6);
    request.setAttribute("qid7", qn7);
    request.setAttribute("qid8", qn8);
    request.setAttribute("qid9", qn9);
    request.setAttribute("qid10", qn10);

    try {
        rd1.forward(request, response);
    } catch (ServletException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

}
// Servlet for DeleteQuestion
else if (pagename.equalsIgnoreCase("deleteQuestion")) {
    int count = 0;
    int testId = Integer.parseInt(request.getParameter("testId"));

    TestVO question = new TestVO();
    question.setTestId(testId);

    DeleteQuestionfromTestService deletequestiontservice = new DeleteQuestionfromTestService();
    try {
        count = deletequestiontservice.data(question);
    } catch (SQLException e1) {
        // TODO Auto-generated catch block
        e1.printStackTrace();
    }

    if (count >= 1) {
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/DeleteAssignQnSuccess.jsp");
        try {
            rd1.forward(request, response);
        } catch (ServletException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    } else {
        log.info("error");
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/DeleteAssignQnFailure.jsp");
        rd1.forward(request, response);
    }
}
// Servlet for View Question
else if (pagename.equals("viewQuestion11")) {
    List count;

    int testId = Integer.parseInt(request.getParameter("testId"));

    TestVO quest = new TestVO();
    quest.setTestId(testId);

    GetTestIDDAO tesid = new GetTestIDDAO();
    int testidcheck = tesid.getTestId(testId);

    ViewQnfromTestService obj = new ViewQnfromTestService();
    count = obj.calculate(testId);
    if (testidcheck == 0) {
        String status = "Test Id not present";
        log.info("Test Id not present in Servlet");
        request.setAttribute("status", status);
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/ FailureCaseinDatabase.jsp");
        rd1.forward(request, response);
    }

    else if (count != null) {
        RequestDispatcher rd = getServletContext()
                .getRequestDispatcher(
                        "/JSP/ViewQuestiontoTestSuccess.jsp");
        request.setAttribute("UpdateDetails", count);
        rd.forward(request, response);

    } else {
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher(
                        "/JSP/ViewQuestiontoTestFailure.jsp");
        rd1.forward(request, response);
    }
}

// Servlet for UpdateQuestion
else if (pagename.equals("UpdateQuestion")) {

    int questionid = Integer.parseInt(request
            .getParameter("questionid"));

    String questioncontent = request.getParameter("questioncontent");
    String category = request.getParameter("category");
    String option1 = request.getParameter("option1");
    String option2 = request.getParameter("option2");
    String option3 = request.getParameter("option3");
    String option4 = request.getParameter("option4");
    int correctanswer = Integer.parseInt(request
            .getParameter("correctanswer"));

    QuestionVO question = new QuestionVO();

    question.setCategory(category);
    question.setQuestionid(questionid);
    question.setQuestioncontent(questioncontent);
    question.setOption1(option1);
    question.setOption2(option2);
    question.setOption3(option3);
    question.setOption4(option4);
    question.setCorrectanswer(correctanswer);

    UpdateQuestionService upques = new UpdateQuestionService();
    int count = upques.updateQuestion(question);
    if (count >= 1) {
        request.setAttribute("mycount", count);
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/UpdateQuestionSucess.jsp");
        log.info("Question Updated Successfully");
        rd1.forward(request, response);
    } else {
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/FailureCase.jsp");
        log.info("Question does not Updated");
        rd1.forward(request, response);
    }
    // Servlet for ViewQuestion By category
} else if (pagename.equals("ViewQuestion")) {
    String category = request.getParameter("category");
    ViewQuestionService vqs = new ViewQuestionService();

    HashMap<Integer, QuestionVO> ar = vqs.viewQuestions(category);
    log.info(ar);

    request.setAttribute("arr", ar);

    RequestDispatcher rd1 = getServletContext().getRequestDispatcher(
            "/JSP/ViewQuestionsSucess.jsp");
    log.info("Question Viewed Successfully");
    rd1.forward(request, response);

} else if (pagename.equals("ViewQuestionsCategory")) {
    String category = request.getParameter("category");
    ViewQuestionService vqs = new ViewQuestionService();

    HashMap<Integer, QuestionVO> arr = vqs.viewQuestions(category);
    log.info(arr);

    request.setAttribute("arr", arr);

    RequestDispatcher rd1 = getServletContext().getRequestDispatcher(
            "/JSP/ViewQuestionsOnly.jsp");
    log.info("Question Viewed by catagory");
    rd1.forward(request, response);
    // Servlet for DeleteQuestion
} else if (pagename.equals("DeleteQuestion")) {
    int questionid = Integer.parseInt(request
            .getParameter("questionid"));
    DeleteQuestionService dqs = new DeleteQuestionService();

    int count = dqs.deleteQuestion(questionid);
    if (count >= 1) {
        request.setAttribute("mycount", count);

        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/DeleteQuestionSucess.jsp");
        log.info("Question Deleteded Successfully");
        rd1.forward(request, response);
    } else {
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/FailureCase.jsp");
        log.info("Question failed to delete");
        rd1.forward(request, response);
    }

} else if (pagename.equals("viewquestionsuccess")) {
    RequestDispatcher rd1 = getServletContext().getRequestDispatcher(
            "/JSP/UpdateQuestion.jsp");
    log.info("Question Viewed Successfully");
    String quesid = request.getParameter("qid");
    String quescategory = request.getParameter("category");
    String quescontent = request.getParameter("questioncontent");
    String option1 = request.getParameter("option1");
    String option2 = request.getParameter("option2");
    String option3 = request.getParameter("option3");
    String option4 = request.getParameter("option4");
    String correctanswer = request.getParameter("correctanswer");

    log.info(quesid);
    request.setAttribute("qid", quesid);
    request.setAttribute("qcnt", quescontent);
    request.setAttribute("option1", option1);
    request.setAttribute("option2", option2);
    request.setAttribute("option3", option3);
    request.setAttribute("option4", option4);
    request.setAttribute("correctanswer", correctanswer);
    request.setAttribute("category", quescategory);
    try {
        rd1.forward(request, response);
    } catch (ServletException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

}
// Servlet for AssignStudent
else if (pagename.equals("AssignStudent")) {
    int testId = Integer.parseInt(request.getParameter("testId"));
    int studentId = Integer.parseInt(request.getParameter("studentId"));
    int teacherId = Integer.parseInt(request.getParameter("teacherId"));
    int stuidcheck = 0;
    int testidcheck = 0;
    int teacheridcheck = 0;
    String status;

    GetStudentIDDAO stuid = new GetStudentIDDAO();
    stuidcheck = stuid.getStudentId(studentId);

    GetTestIDDAO tesid = new GetTestIDDAO();
    testidcheck = tesid.getTestId(testId);

    GetTeacherIDDAO teaid = new GetTeacherIDDAO();
    teacheridcheck = teaid.getTeacherId(teacherId);

    GetStudentCountDAO stucnt = new GetStudentCountDAO();
    int checkstu = stucnt.checkStudentCount(testId);

    if (checkstu == 0) {
        status = "Student Count Excedded Maximum Allocated Students.";
        log
                .info("Student Count Excedded Maximum Allocated Students in Servlet");
        request.setAttribute("status", status);
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/ FailureCaseinDatabase.jsp");
        rd1.forward(request, response);
    } else if (testidcheck == 0) {
        status = "Test Id not present";
        log.info("Test Id not present in Servlet");
        request.setAttribute("status", status);
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/ FailureCaseinDatabase.jsp");
        rd1.forward(request, response);
    } else if (stuidcheck == 0) {
        status = "Student Id not present";
        log.info("Student Id not present in Servlet");
        request.setAttribute("status", status);
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/ FailureCaseinDatabase.jsp");
        rd1.forward(request, response);
    } else if (teacheridcheck == 0) {
        status = "Teacher Id not present";
        log.info("Teacher Id not present in Servlet");
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/ FailureCaseinDatabase.jsp");
        request.setAttribute("status", status);
        rd1.forward(request, response);
    } else {
        StudentVO student = new StudentVO();
        student.setStudentId(studentId);
        student.setTestId(testId);
        student.setTeacherId(teacherId);

        AssignStudentService assignstudentservice = new AssignStudentService();
        int count = 0;
        try {
            count = assignstudentservice.data(student);
        } catch (Exception e) {
            e.printStackTrace();
        }
        if (count >= 1) {
            RequestDispatcher rd1 = getServletContext()
                    .getRequestDispatcher(
                            "/JSP/AssignStudentSuccess.jsp");
            rd1.forward(request, response);
        }

    }
    // servlet for ViewStudent
} else if (pagename.equals("ViewStudent")) {
    int testId = Integer.parseInt(request.getParameter("testId"));

    StudentVO student = new StudentVO();
    student.setTestId(testId);

    ViewStudentService viewstudentservice = new ViewStudentService();

    ArrayList Ar = new ArrayList();
    try {
        Ar = viewstudentservice.viewStudent(testId);
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    request.setAttribute("arr", Ar);

    RequestDispatcher rd1 = getServletContext().getRequestDispatcher(
            "/JSP/ViewStudentSuccess.jsp");
    rd1.forward(request, response);
    // Servlet for UpdateStudent
} else if (pagename.equals("UpdateStudent")) {
    int studentId = Integer.parseInt(request.getParameter("studentId"));
    int testId = Integer.parseInt(request.getParameter("testId"));
    int teacherId = Integer.parseInt(request.getParameter("teacherId"));
    int stuidcheck = 0;
    int testidcheck = 0;
    int teacheridcheck = 0;
    String status;

    GetStudentIDDAO stuid = new GetStudentIDDAO();
    stuidcheck = stuid.getStudentId(studentId);

    GetTestIDDAO tesid = new GetTestIDDAO();
    testidcheck = tesid.getTestId(testId);

    GetTeacherIDDAO teaid = new GetTeacherIDDAO();
    teacheridcheck = teaid.getTeacherId(teacherId);

    if (testidcheck == 0) {
        status = "Test Id not present";
        log.info("Test Id not present in Servlet");
        request.setAttribute("status", status);
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/ FailureCaseinDatabase.jsp");
        rd1.forward(request, response);
    } else if (stuidcheck == 0) {
        status = "Student Id not present";
        log.info("Student Id not present in Servlet");
        request.setAttribute("status", status);
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/ FailureCaseinDatabase.jsp");
        rd1.forward(request, response);
    } else if (teacheridcheck == 0) {
        status = "Teacher Id not present";
        log.info("Teacher Id not present in Servlet");
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/ FailureCaseinDatabase.jsp");
        request.setAttribute("status", status);
        rd1.forward(request, response);
    } else {
        StudentVO student = new StudentVO();

        student.setStudentId(studentId);
        student.setTestId(testId);
        student.setTeacherId(teacherId);

        UpdateStudentService updatestudentservice = new UpdateStudentService();

        int count = 0;
        try {
            count = updatestudentservice.data(student);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        if (count >= 1) {
            RequestDispatcher rd1 = getServletContext()
                    .getRequestDispatcher(
                            "/JSP/UpdateStudentSuccess.jsp");
            rd1.forward(request, response);
        }
    }

    // Servlet for DeleteStudent
} else if (pagename.equals("DeleteStudent")) {
    int count = 0;
    int studentId = Integer.parseInt(request.getParameter("studentId"));

    StudentVO student = new StudentVO();
    student.setStudentId(studentId);

    DeleteStudentService deletestudentservice = new DeleteStudentService();
    try {
        count = deletestudentservice.data(student);
    } catch (SQLException e1) {
        // TODO Auto-generated catch block
        e1.printStackTrace();
    }

    if (count >= 1) {
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/DeleteStudentSuccess.jsp");
        try {
            rd1.forward(request, response);
        } catch (ServletException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    } else {
        log.info("error");
    }
    // Servlet for CreateTest
} else if (pagename.equals("CreateTest")) {

    testName = request.getParameter("testName");
    testID = Integer.parseInt(request.getParameter("testID"));
    duration = Integer.parseInt(request.getParameter("duration"));
    participants = Integer.parseInt(request
            .getParameter("participants"));
    invigilator = Integer.parseInt(request.getParameter("invigilator"));
    category = request.getParameter("category");

    createtestvo.setTestName(testName);
    createtestvo.setTestID(testID);
    createtestvo.setDuration(duration);
    createtestvo.setParticipants(participants);
    createtestvo.setInvigilator(invigilator);
    createtestvo.setCategory(category);

    int count = 0;
    try {
        count = createtestservice.data(createtestvo);
    } catch (SQLException e) {
        e.printStackTrace();
    }

    if (count >= 1) {
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/CreateTestSuccess.jsp");
        request.setAttribute("checks", "1");
        rd1.forward(request, response);
    }

}// Servlet for UpdateTest
else if (pagename.equalsIgnoreCase("UpdateTest3")) {
    int testid = Integer.parseInt(request.getParameter("testid"));
    String testName = request.getParameter("testName");
    int duration = Integer.parseInt(request.getParameter("duration"));
    String category = request.getParameter("category");
    int count1 = Integer.parseInt(request.getParameter("count"));
    int invigilator = Integer.parseInt(request
            .getParameter("invigilator"));

    TestVO1 question = new TestVO1();

    question.setTestID(testid);
    question.setTestName(testName);
    question.setDuration(duration);
    question.setCategory(category);
    question.setNoofstudent(count1);
    question.setInvigilatorID(invigilator);

    UpdateTestService upques = new UpdateTestService();
    int count = upques.updateQuestion(question);
    if (count >= 1) {
        request.setAttribute("mycount", count);
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/UpdateTestSuccess.jsp");
        rd1.forward(request, response);
    } else {
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/UpdateTestFailure.jsp");
        rd1.forward(request, response);
    }
}

else if (pagename.equalsIgnoreCase("updateTest1")) {

    int testId = Integer.parseInt(request.getParameter("testId"));
    ViewQues1Service vqs = new ViewQues1Service();

    HashMap<Integer, TestVO1> ar = vqs.viewQuestions(testId);

    request.setAttribute("arr", ar);

    RequestDispatcher rd1 = getServletContext().getRequestDispatcher(
            "/JSP/UpdateTestDB1.jsp");
    rd1.forward(request, response);

}

else if (pagename.equalsIgnoreCase("updateTest2")) {
    log.info(pagename);
    RequestDispatcher rd1 = getServletContext().getRequestDispatcher(
            "/JSP/UpdateTestFinal.jsp");
    String test1 = request.getParameter("testId1");
    String testName1 = request.getParameter("testName");
    String duration1 = request.getParameter("duration");
    String category1 = request.getParameter("category");
    String count1 = request.getParameter("noofStudents");
    String invigilator1 = request.getParameter("invigilatorId");
    request.setAttribute("testId2", test1);
    request.setAttribute("testName2", testName1);
    request.setAttribute("duration2", duration1);
    request.setAttribute("category2", category1);
    request.setAttribute("count2", count1);
    request.setAttribute("invigilator2", invigilator1);

    try {
        rd1.forward(request, response);
    } catch (ServletException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    // Servlet for DeleteTest
} else if (pagename.equals("DeleteTest")) {

    int testID;

    DeleteTestVo deletetestvo = new DeleteTestVo();
    DeleteTestService deletetestservice = new DeleteTestService();

    testID = Integer.parseInt(request.getParameter("testID"));

    deletetestvo.setTestID(testID);

    int count = 0;
    try {
        count = deletetestservice.test(deletetestvo);

    } catch (SQLException e) {
        e.printStackTrace();
    }

    if (count >= 1) {
        RequestDispatcher rd1 = getServletContext()
                .getRequestDispatcher("/JSP/DeleteTestSuccess.jsp");
        request.setAttribute("checks", "2");
        rd1.forward(request, response);
    }
} else if (pagename.equals("ViewTest")) {
    List ls = new ArrayList();
    ViewTestVo viewtest = new ViewTestVo();
    ViewTestService viewtestservice = new ViewTestService();

    ls = (List) viewtestservice.calculate(viewtest);

    if (ls != null) {
        RequestDispatcher rd = getServletContext()
                .getRequestDispatcher("/JSP/ViewTestSucess.jsp");
        request.setAttribute("ViewTestDetails", ls);
        rd.forward(request, response);

    }
    // Servlet for AttendingTest
} else if (pagename.equals("AttendingTest")) {
    String submitValue = request.getParameter("submit");
    log.info("Submit value : " + submitValue);
    if (submitValue.equals("Submit")) {
        int testId = Integer.parseInt(request.getParameter("testId"));
        log.info("Entered test id: " + testId);
        int studentId = Integer.parseInt(request
                .getParameter("studentId"));
        log.info("Entered student id: " + studentId);
        TakeTestService testService = new TakeTestService();
        int check = 0;
        try {
            check = testService.checkValideStudent(studentId, testId);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        if (check == 0) {
            RequestDispatcher rd = getServletContext()
                    .getRequestDispatcher("/JSP/StartTestFailure.jsp");
            log.info("Invalid login");
            // request.setAttribute("invalidinput", 1);
            rd.forward(request, response);
        } else {
            log.info("Vaild user!!!");
            int qidIndex = 1;
            TakeTestVO testVO = new TakeTestVO();
            ArrayList<TakeTestVO> ar = null;
            testVO.setTestId(testId);
            testVO.setQid(qidIndex);
            ar = testService.viewTestQnService(testId, qidIndex,
                    studentId);
            log.info("Returned back to servlet");
            if (ar != null) {
                RequestDispatcher rd = getServletContext()
                        .getRequestDispatcher("/JSP/TakeTest.jsp");
                request.setAttribute("qnDetails", ar);
                rd.forward(request, response);
            }
        }
    } else if (submitValue.equals("Save")
            || submitValue.equals("Cancel")) {
        int selectedAnswer;
        int testId = Integer.parseInt(request.getParameter("testId"));
        log.info("Entered test id: " + testId);
        int qnId = Integer.parseInt(request.getParameter("questionId"));
        log.info("QuestionId to save/cancel : " + qnId);
        int index = Integer.parseInt(request.getParameter("index"));
        log.info("Index :" + index);
        int studentid = Integer.parseInt(request
                .getParameter("studentId"));
        log.info("studentid :" + studentid);
        if (submitValue.equals("Save")) {
            selectedAnswer = Integer.parseInt(request
                    .getParameter("option"));
            log.info("Selected option : " + selectedAnswer);
            selectedAnsArray[index - 1] = selectedAnswer;
        } else {
            selectedAnswer = 0;
            selectedAnsArray[index - 1] = selectedAnswer;
        }

        TakeTestService saveService = new TakeTestService();
        TakeTestVO testIdVO = new TakeTestVO();
        ArrayList<TakeTestVO> ar = null;
        testIdVO.setTestId(testId);
        testIdVO.setQid(qnId);
        testIdVO.setIndex(index);
        log.info("Entering service method!!");
        selectedAnsArray[index - 1] = selectedAnswer;
        ar = saveService.saveAnswerService(testId, qnId,
                selectedAnswer, index, studentid);
        log.info("Returned back to servlet");
        if (ar != null) {

            RequestDispatcher rd = getServletContext()
                    .getRequestDispatcher("/JSP/TakeTest.jsp");
            request.setAttribute("qnDetails", ar);
            rd.forward(request, response);
        } else {
            log.info("ArrayList is empty. Nothing to send to jsp file");
        }

    } else if (submitValue.equals("Save All")) {
        int selectedOption;
        int testId = Integer.parseInt(request.getParameter("testId"));
        log.info("Entered test id: " + testId);
        int qnId = Integer.parseInt(request.getParameter("questionId"));
        log.info("QuestionId to save/cancel : " + qnId);
        String opt = request.getParameter("option");
        if (opt == null)
            selectedOption = 0;
        else
            selectedOption = Integer.parseInt(opt);
        log.info("Selected option : " + selectedOption);
        int index = Integer.parseInt(request.getParameter("index"));
        log.info("Index :" + index);
        int studentid = Integer.parseInt(request
                .getParameter("studentId"));
        log.info("studentid :" + studentid);
        selectedAnsArray[index - 1] = selectedOption;
        TakeTestService saveService = new TakeTestService();
        TakeTestVO testIdVO = new TakeTestVO();
        testIdVO.setTestId(testId);
        testIdVO.setQid(qnId);
        testIdVO.setIndex(index);
        log.info("Entering service method!!");
        int count = saveService.saveAllAnswerService(testId, qnId,
                selectedOption, index, studentid, selectedAnsArray);
        log.info("Returned back to servlet");
        if (count != 0) {
            RequestDispatcher rd = getServletContext()
                    .getRequestDispatcher("/JSP/FinishTest.jsp");
            rd.forward(request, response);
        } else {
            log.info("ArrayList is empty. Nothing to send to jsp file");
        }
    } else {
        int testId = Integer.parseInt(request.getParameter("testId"));
        log.info("Entered test id: " + testId);
        int studentId = Integer.parseInt(request
                .getParameter("studentId"));
        log.info("studentid :" + studentId);
        int qidIndex = 1;
        int index = Integer.parseInt(request.getParameter("index"));
        if (submitValue.equals("Prev")) {
            index = index - 1;
        } else if (submitValue.equals("Next")) {
            index = index + 1;
        } else {
            index = Integer.parseInt(submitValue);
        }
        qidIndex = index;
        log.info("Navigation key entered : " + index);
        TakeTestService testService = new TakeTestService();
        TakeTestVO testIdVO = new TakeTestVO();
        ArrayList<TakeTestVO> ar = null;
        testIdVO.setTestId(testId);
        testIdVO.setQid(qidIndex);
        ar = testService.viewTestQnService(testId, qidIndex, studentId);
        log.info("Returned back to servlet");
        if (ar != null) {
            RequestDispatcher rd = getServletContext()
                    .getRequestDispatcher("/JSP/TakeTest.jsp");
            request.setAttribute("qnDetails", ar);
            rd.forward(request, response);
        } else {
            log.info("ArrayList is empty. Nothing to send to jsp file");
        }

    }

} else {
    RequestDispatcher rd = getServletContext().getRequestDispatcher(
            "/JSP/FailureCase.jsp");
    rd.forward(request, response);
}

}

}


April 2, 2012 at 8:08 AM


<h2>Question Management</h2>
<ul>
<form>

<table>
<tr>
    <td><a href="/TestAndQuestionManagement/JSP/CreateQuestion.jsp">Create Question</a></td>
</tr>

<tr>
    <td><a href="/TestAndQuestionManagement/JSP/DeleteQuestion.jsp">Delete Question</a></td>
</tr>

<tr>
    <td><a href="/TestAndQuestionManagement/JSP/ViewQuestionsCategory.jsp">View Questions</a></td>
</tr>
<tr>
    <td><a href="/TestAndQuestionManagement/JSP/ViewQuestions.jsp">View and Update Question</a></td>
</tr>


</table>
</form>
</ul>
</li>
<li>
<h2>Allocate Student To Test</h2>
<ul>
    <form>

<table>
<tr>
    <td><a href="/TestAndQuestionManagement/JSP/AssignStudent.jsp">Assign Student to Test</a></td>
</tr>

<tr>
    <td><a href="/TestAndQuestionManagement/JSP/DeleteStudent.jsp">Delete Student from Test</a></td>
</tr>

<tr>
    <td><a href="/TestAndQuestionManagement/JSP/ViewStudent.jsp">View Student from Test</a></td>
</tr>
<tr>
    <td><a href="/TestAndQuestionManagement/JSP/UpdateStudent.jsp">Update Student to Test</a></td>
</tr>


</table>
</form>


April 2, 2012 at 8:12 AM


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <%@ page import="java.util.*"%>
<%@ page import="com.otts.vo.QuestionVO"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<script language="JavaScript" type="text/JavaScript"
    src="../JS/ValidateViewQuestion.js"></script>
<title>Test And Question Management System</title>
<link rel="stylesheet" type="text/css"
    href="/TestAndQuestionManagement/CSS/style.css" />
<script language="JavaScript" type="text/JavaScript"
    src="../JS/ValidateViewQuestion.js"></script>
</head>
<body>
<div id="wrapper">
<div id="header-wrapper">
<div id="header">
<div id="logo">
<h1><a href="#">Test and Question Management System</a></h1>
</div>
</div>
<!-- end #header -->
<div id="menu">
<ul>
    <li class="current_page_item"><a
        href="/TestAndQuestionManagement/JSP/HomePage.jsp">Homepage</a></li>
    <li><a href="#">About</a></li>
    <li><a href="#">Links</a></li>
    <li><a href="#">Contact</a></li>
</ul>
</div>
<!-- end #menu -->
<div id="page">
<div id="page-bgtop">
<div id="page-bgbtm">
<div id="content">
<div class="post">
<h2 class="title"><a href="#">View Question</a></h2>
&nbsp;&bull;&nbsp;
<div class="entry">


<%HashMap<Integer,QuestionVO> questiondetails = (HashMap<Integer,QuestionVO>) request.getAttribute("arr"); 
Set set=questiondetails.entrySet();

Iterator itr=set.iterator();%>
<form name="ViewSucess" method=post
    action="<%= request.getContextPath()%>/TestQuestionManagement"><input
    type="hidden" name="pagename" value="viewquestionsuccess">
<table border="1" width="30">
    <tr>
        <td>TeacherID</td>
        <td>Category</td>
        <td>QuestionID</td>
        <td>QuestionContent</td>
        <td>Option1</td>
        <td>Option2</td>
        <td>Option3</td>
        <td>Option4</td>
        <td>CorrectAnswer</td>
    </tr>
    <%
while(itr.hasNext())
{
Map.Entry me=(Map.Entry)itr.next();
QuestionVO ques=(QuestionVO)me.getValue();;
%>

    <tr>
        <td><%=ques.getTeacherid() %></td>
        <td><%=ques.getCategory() %></td>
        <td><%=ques.getQuestionid() %></td>
        <td><%=ques.getQuestioncontent() %></td>
        <td><%=ques.getOption1() %></td>
        <td><%=ques.getOption2()%></td>
        <td><%=ques.getOption3() %></td>
        <td><%=ques.getOption4() %></td>
        <td><%=ques.getCorrectanswer() %></td>
    </tr>
    <%
}
%>
</table>
</form>


April 2, 2012 at 8:14 AM


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <%@ page import="java.util.*"%>
<%@ page import="com.otts.vo.QuestionVO"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<script language="JavaScript" type="text/JavaScript"
    src="../JS/ValidateViewQuestion.js"></script>
<title>Test And Question Management System</title>
<link rel="stylesheet" type="text/css"
    href="/TestAndQuestionManagement/CSS/style.css" />
<script language="JavaScript" type="text/JavaScript"
    src="../JS/ValidateViewQuestion.js"></script>
</head>
<body>
<div id="wrapper">
<div id="header-wrapper">
<div id="header">
<div id="logo">
<h1><a href="#">Test and Question Management System</a></h1>
</div>
</div>
<!-- end #header -->
<div id="menu">
<ul>
    <li class="current_page_item"><a
        href="/TestAndQuestionManagement/JSP/HomePage.jsp">Homepage</a></li>
    <li><a href="#">About</a></li>
    <li><a href="#">Links</a></li>
    <li><a href="#">Contact</a></li>
</ul>
</div>
<!-- end #menu -->
<div id="page">
<div id="page-bgtop">
<div id="page-bgbtm">
<div id="content">
<div class="post">
<h2 class="title"><a href="#">View Question</a></h2>
&nbsp;&bull;&nbsp;
<div class="entry">


<%HashMap<Integer,QuestionVO> questiondetails = (HashMap<Integer,QuestionVO>) request.getAttribute("arr"); 
Set set=questiondetails.entrySet();

Iterator itr=set.iterator();%>
<form name="ViewSucess" method=post
    action="<%= request.getContextPath()%>/TestQuestionManagement"><input
    type="hidden" name="pagename" value="viewquestionsuccess">
<table border="1" width="30">
    <tr>
        <td>TeacherID</td>
        <td>Category</td>
        <td>QuestionID</td>
        <td>QuestionContent</td>
        <td>Option1</td>
        <td>Option2</td>
        <td>Option3</td>
        <td>Option4</td>
        <td>CorrectAnswer</td>
    </tr>
    <%
while(itr.hasNext())
{
Map.Entry me=(Map.Entry)itr.next();
QuestionVO ques=(QuestionVO)me.getValue();;
%>

    <tr>
        <td><%=ques.getTeacherid() %></td>
        <td><%=ques.getCategory() %></td>
        <td><%=ques.getQuestionid() %></td>
        <td><%=ques.getQuestioncontent() %></td>
        <td><%=ques.getOption1() %></td>
        <td><%=ques.getOption2()%></td>
        <td><%=ques.getOption3() %></td>
        <td><%=ques.getOption4() %></td>
        <td><%=ques.getCorrectanswer() %></td>
    </tr>
    <%
}
%>
</table>
</form>


April 2, 2012 at 8:14 AM


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <%@ page import="java.util.*"%>
<%@ page import="com.otts.vo.QuestionVO"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<script language="JavaScript" type="text/JavaScript"
    src="../JS/ValidateViewQuestion.js"></script>
<title>Test And Question Management System</title>
<link rel="stylesheet" type="text/css"
    href="/TestAndQuestionManagement/CSS/style.css" />
<script language="JavaScript" type="text/JavaScript"
    src="../JS/ValidateViewQuestion.js"></script>
</head>
<body>
<div id="wrapper">
<div id="header-wrapper">
<div id="header">
<div id="logo">
<h1><a href="#">Test and Question Management System</a></h1>
</div>
</div>
<!-- end #header -->
<div id="menu">
<ul>
    <li class="current_page_item"><a
        href="/TestAndQuestionManagement/JSP/HomePage.jsp">Homepage</a></li>
    <li><a href="#">About</a></li>
    <li><a href="#">Links</a></li>
    <li><a href="#">Contact</a></li>
</ul>
</div>
<!-- end #menu -->
<div id="page">
<div id="page-bgtop">
<div id="page-bgbtm">
<div id="content">
<div class="post">
<h2 class="title"><a href="#">View Question</a></h2>
&nbsp;&bull;&nbsp;
<div class="entry">


<%HashMap<Integer,QuestionVO> questiondetails = (HashMap<Integer,QuestionVO>) request.getAttribute("arr"); 
Set set=questiondetails.entrySet();

Iterator itr=set.iterator();%>
<form name="ViewSucess" method=post
    action="<%= request.getContextPath()%>/TestQuestionManagement"><input
    type="hidden" name="pagename" value="viewquestionsuccess">
<table border="1" width="30">
    <tr>
        <td>TeacherID</td>
        <td>Category</td>
        <td>QuestionID</td>
        <td>QuestionContent</td>
        <td>Option1</td>
        <td>Option2</td>
        <td>Option3</td>
        <td>Option4</td>
        <td>CorrectAnswer</td>
    </tr>
    <%
while(itr.hasNext())
{
Map.Entry me=(Map.Entry)itr.next();
QuestionVO ques=(QuestionVO)me.getValue();;
%>

    <tr>
        <td><%=ques.getTeacherid() %></td>
        <td><%=ques.getCategory() %></td>
        <td><%=ques.getQuestionid() %></td>
        <td><%=ques.getQuestioncontent() %></td>
        <td><%=ques.getOption1() %></td>
        <td><%=ques.getOption2()%></td>
        <td><%=ques.getOption3() %></td>
        <td><%=ques.getOption4() %></td>
        <td><%=ques.getCorrectanswer() %></td>
    </tr>
    <%
}
%>
</table>
</form>


April 2, 2012 at 8:17 AM


/*<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<%@ page import="java.util.*"%>
<[email protected] import="java.sql.*"%>
<[email protected] import="java.util.ArrayList"%>
<[email protected] import="java.util.Iterator"%>
<[email protected] import="com.otts.vo.StudentVO"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<script language="JavaScript" type="text/JavaScript"
    src="../JS/ValidateViewStudent.js"></script>
<title>Test And Question Management System</title>
<link rel="stylesheet" type="text/css"
    href="/TestAndQuestionManagement/CSS/style.css" />
<script language="JavaScript" type="text/JavaScript"
    src="../JS/ValidateViewStudent.js"></script>
</head>
<body>
<div id="wrapper">
<div id="header-wrapper">
<div id="header">
<div id="logo">
<h1><a href="#">Test and Question Management System</a></h1>
</div>
</div>
<!-- end #header -->
<div id="menu">
<ul>
    <li class="current_page_item"><a
        href="/TestAndQuestionManagement/JSP/HomePage.jsp">Homepage</a></li>
    <li><a href="#">About</a></li>
    <li><a href="#">Links</a></li>
    <li><a href="#">Contact</a></li>
</ul>
</div>
<!-- end #menu -->
<div id="page">
<div id="page-bgtop">
<div id="page-bgbtm">
<div id="content">
<div class="post">
<h2 class="title"><a href="#">View Student</a></h2>
&nbsp;&bull;&nbsp;
<div class="entry">


<%
    ArrayList arr=(ArrayList)request.getAttribute("arr");
StudentVO student=new StudentVO();
Iterator iter=arr.iterator();
%>

<table border="1" width="30">
    <tr>
        <td>StudentId</td>
        <td>TeacherId</td>
    </tr>

    <%
    while(iter.hasNext())
{

student=(StudentVO)iter.next();
%>

    <tr>
        <td><%=student.getStudentId()%></td>
        <td><%=student.getTeacherId()%></td>
    </tr>
    <%}%>
</table>




</div>
</div>
</div>
<!-- end #content -->
<div id="sidebar">
<ul>

<li>
<h2>Question Management</h2>
<ul>
    <form>

    <table>
        <tr>
            <td><a href="/TestAndQuestionManagement/JSP/CreateQuestion.jsp">Create Question</a></td>
        </tr>

        <tr>
            <td><a href="/TestAndQuestionManagement/JSP/DeleteQuestion.jsp">Delete Question</a></td>
        </tr>

        <tr>
            <td><a href="/TestAndQuestionManagement/JSP/ViewQuestionsCategory.jsp">View Questions</a></td>
        </tr>
        <tr>
            <td><a href="/TestAndQuestionManagement/JSP/ViewQuestions.jsp">View and Update Question</a></td>
        </tr>


    </table>
    </form>*/


April 2, 2012 at 8:30 AM


(<%
    ArrayList arr=(ArrayList)request.getAttribute("arr");
StudentVO student=new StudentVO();
Iterator iter=arr.iterator();
%>

<table border="1" width="30">
    <tr>
        <td>StudentId</td>
        <td>TeacherId</td>
    </tr>

    <%
    while(iter.hasNext())
{

student=(StudentVO)iter.next();
%>

    <tr>
        (<td><%=student.getStudentId()%></td>
        <td><%=student.getTeacherId()%></td>)
    </tr>
    <%}%>
</table>)	


April 2, 2012 at 8:31 AM


(h1>View Test</h1>

<%
if (request.getAttribute("ViewTestDetails") == null) {

} else {
    List ls = (List) request.getAttribute("ViewTestDetails");
%>
<table border='1'>
<tr>
    <td>TestId</td>

    <td>TestName</td>
    <td>Duration</td>
    <td>Category</td>

    <td>No of Students</td>
    <td>Teacher Id</td>
</tr>
<%
    int j = 0;
%>
<%
    for (int i = 0; i < (ls.size() / 6); i++) {
%>
<tr>

    <td><input type="text" name="TestId" value="<%=ls.get(j++)%>"
        size="20" /></td>
    <td><input type="text" name="TestName" value="<%=ls.get(j++)%> "
        size="20" /></td>
    <td><input type="text" name="Duration" value="<%=ls.get(j++)%> "
        size="20" /></td>
    <td><input type="text" name="Category" value="<%=ls.get(j++)%> "
        size="20" /></td>
    <td><input type="text" name="No of Students"
        value="<%=ls.get(j++)%> " size="20" /></td>

    <td><input type="text" name="Teacher Id"
        value="<%=ls.get(j++)%> " size="20" /></td>

</tr>
<%
    }
    }
%>

</table>)

Ads









Related Tutorials/Questions & Answers:
chn.ilp.test
chn.ilp.test   public class Constants { public static String DRIVERNAME = "oracle.jdbc.driver.OracleDriver"; public static String SERVERNAME = "172.24.137.30"; public static String PORTNUMBER = "1521"; public
Tutorials   
Java Spring Hibernate Struts Training Apache Commons ioutils maven dependency Read/Convert an inputStream to a String What is the meaning of Java Platform? Why Java is a platform independent language? What is the benefits of learning Core Java? Which technology should I learn after Java? What is array in java with example? How to Convert ArrayList to Array? How to substring in Java? How to format number in Java? What is instance variable in Java? How to download MySQL JDBC driver? What is Calendar class in Java? Which is the best Java tutorials for beginners? How to rename a file in Java? How to delete file in Java code? How to get day from date in Java using Calendar? How to get day of week in Java? How to calculate Date Difference in Java? How to compare date in Java? How to declare array in Java? How to calculate average of array in Java? What is Array in Java? write a java program to find the summation of all the integers entered on command line Sum of two numbers using command line arguments in Java How to create and use Array in Java? How to pass command line arguments in Java? How to create Applet Hello World? Appending String efficiently in Java How to append String in Java? How to list even numbers between 1 and 100? How to add BigDecimal in Java? What is Abstraction In Java? Which is best Beginners Java Tutorial? What is java.util package? Create list from array in Java Filter collection in Java 8 What is the best way to filter a Java Collection? Easy way to transform Collection to Array? How to convert Collection to Array in Java? What are Basic Java Language Elements? Advanced Java Tutorials in 2017 Java brief history Best Reasons to learn Java Java Example Codes and Tutorials in 2017 How do I read a large file quickly in Java? Is learning Java worthwhile? How to create first Java Program? Retrieve database from the table dynamically in jsp from oracle using servlet What does core Java include?

Ads

 
Advertisement null

Ads