DECLARATION This is to certify that Report entitled ”E -LEARNING.” which is submitted by us in partial fulfillment of the requirement for the award of degree B.Tech. in Information Technology to YOUR
COLLEGE NAME, YOUR UNIVERSITY NAME,CITY NAME comprises NAME comprises only our own work and due acknowledgement has been made in the text to all other material used. Date: DD.MM.YYYY Your Name(Your Regn No)
Certificate This is to certify that Report entitled “E“E-LEARNING” which is submitted by YOUR NAME in NAME in partial fulfillment of the requirement for for the award of degree B.Tech B.Tech.. in Information Technology to YOUR COLLEGE NAME,PLACE,YOUR UNIVERSITGY NAME,PLACE is NAME,PLACE is a record of the candidates own work carried out by b y him/her under my/our supervision. The matter embodied in this thesis is original and has not been submitted for the award of any other degree.
Date: DD/MM/YYYY
Supervisor Name of the Guide Signature
ACKNOWLEDGEMENT
We take this opportunity to express our profound sense of gratitude and respect to all those who helped us throughout the duration of o f this project . Firstly, we are extremely grateful to your college name, for providing us the excellent working environment to undergo our project.
We devote our success in this effort to to our project guide your guide name for giving us the opportunity to undertake the project and providing crucial feedbacks that influenced us and provided opportunity to undertake the project work in the esteemed concern. We are also deeply thankful to professor Name with Deptt Name whose useful suggestions, gentle and soothing attitude and right directions helped us a lot to learn in this project pro ject and also for his constant encouragement and support throughout the project Last, but not the least, we would like to extend our profound thanks to all our esteemed colleagues and friends at college level who helped us in the specific areas of this project. Your name
Table of Contents S. No.
Topics
Page Number
01 02 03 04
Declaration Certificate Acknowledgement Introduction (i) About the project (ii) Purpose of the project (iii) Understanding of existing system (iv) Tools / Environment used System Development Life Cycle Requirement analysis phase (i) Feasibility study System Design (i) ER Diagram (ii) Class Diagram (iii) Table Structure Coding (i) Front End (ii) Back End
2 3 4 7 7 8 8
05 06 07
08
9 11 13 14 17 21 102
09 10
11 12 13 14
Testing Screen Snap Shots (i) Main Screens (ii) Forms (iii) Reports Conclusion Limitations Further Enhancement References / Bibliography
123 125 128 135 141 142 143 144
4. INTRODUCTION 4.1 About the project E-learning is another form of distance learning where education and training courses are delivered using computer technology. Typically, this means that courses are delivered either via the Internet, or on computer networks (linked co mputers). With the increased availability of PCs and Internet access, e-learning is becoming more and more popular. E-Learning is a web application uses JSP. The database is Oracle 10g. This online application enables the end users to register online, select the subject, read the tutorial and appear for the exam online. The results of the exams are also declared just after taking the test. The minimum pass percentage is 50%. A person is given three attempts to pass a paper. In subjects containing more than one exam, the candidate should take tests in a particular sequence and also he can attempt the next test only if he has completed the previous papers. The correct answers for the questions are displayed after the exam. The date of the registration, date of exam, number of attempts, test result etc. are stored in the database.
4.2 Purpose of the project Education through the internet, network and a computer is E-learning. This helps in network enabled transfer of skills and knowledge. E-learning refers to u se of electronic applications and processes to learn. This is a web based application which can be hosted in the website of any training institute. The students will be able to register online, read the course material and write online exam. Certificates also will be issued online. The objectives of this project are • To provide distance learning • To make it convenient for people who have other commitments • Cost reduction
• Reduced paper work • Computer evaluated tests
4.3 Understanding of existing system Shows educators and trainers how to adapt teaching methods and materials to make use of the Internet. Including a framework showing how to apply Internet technology progressively as skills and confidence grow, the project demonstrates the route from adapting materials to developing a virtual course. Nowadays, when people are not having time to visit an institute. Therefore, the software is designed to provide the education through Internet. The project “E – LEARNING” helps the common world in any field they are to get the knowledge what they want even sitting at there places. This helps them to spare time in their busy schedule and save their time during transportation.
4.4 Tools/Environment Used HARDWARE REQUIREMENTS
Processor : Pentium III/IV (Preferably P-IV) RAM: 256 MB SOFTWARE REQUIREMENTS Web Server: Apache Tomcat Server 0perating System: Windows ME/2000/XP/UNIX Language: JSP(JAVA Server Pages), HTML Database : Oracle 10g
5. System Development Life Cycle
The methodology used for developing this system is PROTOTYPING MODEL. This model is used here because detailed input, output requirements are not present in the beginning, and thus it is felt that a prototyping model will be more suitable for development. In this model, we will create a quick design and then invite user to test the developed system and refine requirements if any. Thus, the process for development will be iterative. Often, a customer defines a set of general objectives for software but does not identify detailed input, processing or output requirements. In other cases, the developer may be unsure of the efficiency of an algorithm, the adaptability of an operating system, or the form that human/machine interaction should take. In these, and many other situations, a prototyping model offers the best approach.
It generally has the following steps: i. Requirement Gathering ii. Quick Design iii. Build Prototype iv. Customer Evaluation v. Review/Modify Requirements vi. Coding vii. Testing
6. Requirement Analysis Phase 6.1 Feasibility study This part or aspect of systems analysis that concentrates on finding ou t whether an intended course of action violates any constraints is referred to a s FEASIBILITY analysis .All the projects are feasible – given unlimited resources and infinite time! Unfortunately, the development of a computer – based system or product is more likely beleaguered by scarcity of evaluate the feasibility of a project at the earliest possible time of project inception.
Technical Feasibility-: Technical feasibility centers on the existing computer system (hardware,software,etc.) and on the extent it can support the proposed addition . Financial considerations have to be taken into account for technical enhancements. In short the study of function, performance, and constraints that may affect the ability to achieve an acceptable system. If the budget is a serious constraint, then the project is judge not feasible .This project is considered technically feasible for development.
Economical Feasibility-: Economic analysis is the most frequently used method for evaluation the effectiveness of a candidate system. More commonly known as cost/benefit analysis, the procedure is to determine the benefits and savings that are expected from candidate system and compare them with costs. If benefits outweigh costs then the decision.
Operational Feasibility-:
Operational Feasibility is reviewed in the early stages of project plannin g . Proposed project is beneficial only if it can be turned into information systems that will meet the organization’s operational requirement. In the operational feasibility it is checked if the s ystem will work, when it is developed and deployed which are major barriers to the development a consideration about the working of the system after installation in the organization. The software, which is developed , has an interactive, user-friendly interface, so operational difficulties are almost eliminated. It will improve the performance after implementation as the information can be delivered to the destination with utmost security. Hence the project is considered operationally feasible.
7.1 ER-Diagram
7.2 Class Diagram
7.3 Table Structure
Results Field Name course_id trainee_id Marks qn1 qn2 qn2 ans1 ans2
Data Type Number Text Number Number Number Number Number Number
ans3 paper_id Attempt_id Result
Number Number Number Number x_masterListOfCategory
Field Name Course_category_id
Data Type Number
Course_category
Text x_masterListOfCourses
Field Name Course_id Course_category_id Course_name Course_description No_of_papers
Data Type Number Number Text Text Number x_masterListOfPapers
Field Name
Data Type
Paper_id Paper_no Paper_name Course_id Paper_description
Number Number Text Number Text x_masterListOfDocuments
Field Name Document_id Paper_id
Data Type Number Number
Paper_no Document_name Document_filename Document_description
Number Text Text Text _masterListOfQuestions
Field Name Paper_id Question_id Question Choice1 Choice2
Data Type Number Number Text Text Text
Choice3 Choice4 Ans
Text Text Number _master_elearning_user
Field Name User_name
Data Type Text
Pass_word First_name Designation Email City Country
Text Text Text Text Text Text
_master_trainee_detail_online Field Name Trainee_id
Data Type Number
Is_regiteres Is_attended_exam Is_successfully_completed Course_completed_date Total_marks Doe User_name Course_id Paper1_no_of_attempts Paper2_no_of_attempts Paper3_no_of_attempts Paper1_marks Paper2_marks Paper3_marks Paper1_completed_date Paper2_completed_date Paper3_completed_date Paper_id1 Paper_id2 Paper_id3 Is_paper1_completed Is_paper2_completed Is_paper3_completed Paper1_appeared_on Paper2_appeared_on Paper3_appeared_on Is_paper1_tutorial_viewed Is_paper2_tutorial_viewed Is_paper3_tutorial_viewed No_of_papers
Number Number Number Date Number Date Text Number Number Number Number Number Number Number Date Date Date Number Number Number Number Number Number Date Date Date Number Number Number Number
9. Testing TestPlan:-This document describes the plan for testing E-Learning Software. All the
major testing strategies are specified here; additional testing may be scheduled later, if necessary. 1.Test Units
In this project we will perform two levels of testing: Unit testing & System testing. Because the System is moderate in Size, it is felt that there is no need for elaborate integration testing. The basic units to be tested are: # Modules to Tables # Tables to Reports # Other Units In addition, some other units may be chosen for testing. The testing for these different units will be done independently. 2.Features To Be Tested
All the functional features specified in the requirement document will be tested. No testing will be done for the performance, as the response time requirement is quite weak. 3.Approach To Testing
For Unit Testing, Structural Testing based on the branch coverage criterion will be used. The goal is to achieve branch coverage of more than 95%. System testing will be largely functional in nature. The focus is on Invalid and Valid cases, Boundary Value and Special Cases. 4.Test Deliverables
The following documents are required (besides this Test Plan): • Unit test report of each Unit. • Test case Specification for System Testing • Test Report for System Testing • Error Report
The test case specification for System Testing has to be submitted for review before System Testing Commences. 5.Schedule
The entire testing- Unit & System will be finished within the month of December. Test case Specifications for the System Testing will be produced while Unit Testing is going on. This Schedule is consistent with the over all schedule of the project. The schedule for the testing is shown in the Project Planning section. Test Case Specification for System Testing
Here we specify all the test cases that are used for System Testing. First, the different conditions that need to be tested, along with the test cases for testing those condition and the expected output are given. Then the data files used for testing are given. The Test cases are specified with respect to these data files. The Test cases have been selected using functional approach. The goal is to test the different functional requirements, as specified in the requirement document. Test cases have been selected for both Valid as well as Invalid Input.
List of Screenshots: Shot 1 : Participant Login Page Shot 2 : List of Subjects Shot 3 : Enrollment of Participant Shot 4: SignUp Shot 5 : Change Password Shot 6 : List of Study Materials Shot 7 : Exam Status Shot 8 : Exam Instructions
Shot 9 : Exam Question Display Shot 10 : Exam Question Display (continued) Shot 11 : Result Shot 12 : Result (continued) Shot 13 : Exam Status Shot 14 : Exam Status(continued) Shot 15 : User Menu Shot 16 : Profile
11. Conclusion We have successfully designed and developed a project on E – Learning. Working on the project was good experience. This project is designed for “Online Education”. This project is designed in JSP(Java Server Pages) which runs on Apache Tomcat Web Server. Keeping in view these facts we have developed successfully. Developing the project has helped us some experience on website development.
12. Limitations Some of the Liminations of this project are · The questions have to be written to the database directly · There is no facility for multiple choice questions · There is no facility for subjective answers · There is no chat facility which allows the student to interact with the lecturer directly
13. Further enhancements Further enhancements to this project will be to create a module for entering the questions to the database. As of now, the questions are directly written into tables by the administrator . Creating a computerized module for it may help entry without mistakes. Another enhancement would be to allo w multiple choice questions and subjecti ve questions.This would allow many varieties of questions to be added. The tutorials can be made available in flash format and other animated formats.
14. References 1.JAVAServer Pages By: SAMS ,Techmedia. 2.Javascript By: Ivan Bayross 3.HTML Complete By: Sybex Authors 4.Dynamic HTML By: Joseph Schmuller 5.System Analysis & Design By: Ilias M Awad 6.Software Engineering A Practitioner’s Approach By: Roger S Pressman 7.Oracle 9i The Complete Reference
By: LONEY KOCH
A complete JAVA(JSP) Project for Engineering Students A complete JAVA(JSP) Project on ELEARNING for Engineering College Students.This page Contains complete coding,screenshots,E-R Diagrams,Data Flow Diagrams and the complete documentation. It gives the idea for how to prepare documentation for a college project and makes the work of documentation very easy.
TOPIC-8-CODING (Elearning Project)
8. Coding course_list_index2.jsp <%@ page language="java"%>
E-LEARNING <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script> function fnValidate() { if(document.f1.user_name.value==""){ alert("Enter your user name."); return false; }
if(document.f1.pass_word.value==""){ alert("Enter your Password."); return false; } }
<% if(request.getParameter("result")!=null) { %> <% } %> | |
------------------------------------------------------------------------------------------
signup.jsp <%@ page import="INCLUDES.*"%> <%@ page import="java.sql.*"%> <%@ page import="java.io.*"%> <%@ page import="java.util.*"%>
e-Learning <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script> function fnMenuBg1(elementId) { document.getElementById(elementId).style.backgroundColor="#dfdfdf"; } function fnMenuBg2(elementId) { document.getElementById(elementId).style.backgroundColor="#ffffff"; } function fnValidate() { if(document.f1.trainee_name.value==""){ alert("Enter your name."); return false; } if(document.f1.email.value==""){ alert("Enter your Email Id."); return false; } if(document.f1.user_name.value==""){ alert("Enter username."); return false; }
if(document.f1.pass_word.value==""){ alert("Enter Password"); return false; } if(document.f1.retype_pass.value==""){ alert("Retype Password"); return false; } if(document.f1.pass_word.value!=document.f1.retype_pass.value){ alert("Password did not match"); return false; } }
<%if(request.getParameter("result")!=null) { %>
<% }%> |
-----------------------------------course_list1_model2.jsp-------------------------------------
<%@ page import="INCLUDES.DBConnection"%> import="INCLUDES.DBConnection"%> <%@ page import="java.sql.*"%> import="java.sql.*"%> <%@ page import="java.io.*"%> import="java.io.*"%> <%@ page import="java.util.*"%> import="java.util.*"%>
n"/>
n"/>
<% String sort_by=""; String user_name=(String)session.getA user_name=(String)session.getAttribute("user_name") ttribute("user_name");; if(user_name==null) { response.sendRedirect("course_list_index2.jsp? result=Session Timed Out.Please, Login again."); } if(request.getParameter("sort_by")!=null) { sort_by=request.getParameter("sort_by"); } if(sort_by.equals("category")) {
sort_by="course_category,course_name"; } else { sort_by="course_name"; } String statement="select * from x_masterListOfCourses s,x_masterListOfCategory cat where s.course_category_id=cat.course_category_id order by " + sort_by; ResultSet objRs=null; ResultSet oRsTraineeStatus=null; try { DB.setStatement(statement); objRs=(ResultSet)DB.result(); } catch(Exception e) { %>error occured : <%=e%><% } %>
e-Learning
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script> function fnMenuBg1(elementId) { document.getElementById(elementId).style.backgroundColor="#dfdfdf"; } function fnMenuBg2(elementId) { document.getElementById(elementId).style.backgroundColor=""; }
| | | | | | | | | | | | Login by:<%=user_name%> | |
<%if(request.getParameter("result")!=null) { %>
<% }%> |
S.No | C. Code | |
| Your Status | | <% try { int i=1; while(objRs.next()) { %> <% int course_id=objRs.getInt("course_id"); int no_of_attempts=0; int is_successfully_completed=0; String date_of_registration_str=null; String course_completed_date_str=null;
java.util.Date date_of_registration=null; java.util.Date course_completed_date=null; int is_registered=0; String back_color=""; try { String statement1="select * from x_master_trainee_detail_online where course_id=" + course_id + " and user_name='" + session.getAttribute("user_name") + "'"; DB1.setStatement(statement1); oRsTraineeStatus=DB1.result(); if(oRsTraineeStatus.next()) { is_registered=oRsTraineeStatus.getInt("is_registered"); date_of_registration=oRsTraineeStatus.getDate("doe"); date_of_registration_str=date_of_registration.getDate() + "-" + (date_of_registration.getMonth()+1) + "-" + (date_of_registration.getYear()+1900); is_successfully_completed=oRsTraineeStatus.getInt("is_successfully_completed"); course_completed_date=oRsTraineeStatus.getDate("course_completed_date"); course_completed_date_str=course_completed_date.getDate() + "-" + (course_completed_date.getMonth()+1) + "-" + (course_completed_date.getYear()+1900); } } catch(Exception ex) {
} if(is_successfully_completed==1) { back_color="bgcolor=#FFFFCC"; } else { if(is_registered==1) { back_color="bgcolor=#f0f0ff"; } else { back_color=""; } } %> > <%=i%> | <%=course_id%> | " ><%=objRs.getString("course_name")%> | <%=objRs.getString("course_category")%> | <% if(is_successfully_completed > 0) {%> Successfully completed on <%=course_completed_date_str%> <% } else { if(is_registered==1) { %> Enrolled on <%=date_of_registration_str%> (not yet completed) <% } else {%> Not yet enrolled
<% } }%> | | <% i=i+1; } } catch(Exception e) { %> Error ocuured in while : <%=e%> <% } %>
|
------------------------------------------course_step.jsp----------------------------------------<%@ page import="INCLUDES.DBConnection"%> <%@ page import="java.sql.*"%> <%@ page import="java.io.*"%>
<% int course_id=0; String user_name=(String)session.getAttribute("user_name"); if(user_name==null) { response.sendRedirect("course_list_index2.jsp?result=Session Timed Out.Please, Login again."); } String statement="";
String course_name=""; String course_category=""; String trainee_name=""; int no_of_papers=0; String course_description=""; if(request.getParameter("course_id")!=null) { course_id=Integer.parseInt(request.getParameter("course_id")); session.setAttribute("course_id",Integer.toString(course_id)); } ResultSet objRs=null; ResultSet oRsTraineeStatus=null; try { statement="select * from x_master_elearning_user u,x_masterListOfCourses c,x_masterListOfCategory cat where c.course_category_id=cat.course_category_id and c.course_id=" + course_id + " and u.user_name='" + user_name + "'"; DB.setStatement(statement); objRs=(ResultSet)DB.result(); } catch(Exception e) { %>error occured : <%=e%><%
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script> function fnMenuBg1(elementId) { document.getElementById(elementId).style.backgroundColor="#dfdfdf"; } function fnMenuBg2(elementId) { document.getElementById(elementId).style.backgroundColor=""; } function fnClick(getElement,course_id) { if(getElement=="enroll") { location.href="enroll.jsp?course_id=" + c ourse_id; }
if(getElement=="tutorial") { location.href="view_document.jsp?course_id=" + course_id; } if(getElement=="evaluate") { location.href="course_registration_form.jsp?course_id=" + c ourse_id; } if(getElement=="exam") { location.href="course_tutorial1.jsp?course_id=" + course_id; } if(getElement=="result") { location.href="course_registration_form.jsp?course_id=" + course_id; } if(getElement=="certificate") { location.href="view_certificate.jsp?course_id=" + course_id; } if(getElement=="choose") { location.href="course_list1_model2.jsp";
} } <% try { if(objRs.next()) { trainee_name=objRs.getString("first_name"); course_name=objRs.getString("course_name"); course_category=objRs.getString("course_category"); no_of_papers=objRs.getInt("no_of_papers"); course_description=objRs.getString("course_description"); } } catch(Exception e) { out.print("Error occured in objRs : " + e); } %>
----------------------------------------course_tutorial1.jsp------------------------------------<%@ page import="INCLUDES.DBConnection"%> <%@ page import="java.sql.*"%> <%@ page import="java.io.*"%> <%@ page import="java.util.*"%>
<% int course_id=0; int is_objRs_present=0; String statement=""; ResultSet objRs=null; ResultSet objRsPaper=null; String user_name=(String)session.getAttribute("user_name");
if(user_name==null) { response.sendRedirect("course_list_index2.jsp?result=Session Timed Out.Please, Login again."); } String trainee_name=""; String course_name=""; if(request.getParameter("course_id")!=null) { course_id=Integer.parseInt(request.getParameter("course_id")); } try { statement="select * from x_master_elearning_user u,x_master_trainee_detail_online t,x_masterListOfCourses c,x_masterListOfCategory cat where c.course_id=t.course_id and t.user_name=u.user_name and c.course_category_id=cat.course_category_id and c.course_id=" + course_id + " and u.user_name='" + user_name + "'"; DB.setStatement(statement); objRs=(ResultSet)DB.result(); if(objRs.next()) { trainee_name=objRs.getString("first_name"); course_name=objRs.getString("course_name"); is_objRs_present=1; }
else { response.sendRedirect("course_list_index2.asp?result=Session Timed out"); } session.setAttribute("trainee_id",objRs.getString("trainee_id")); } catch(Exception e) { %>error occured : <%=e%><% } %>
--------------------------------------------course_tutorial2.jsp-----------------------------------<%@ page import="INCLUDES.DBConnection"%> <%@ page import="java.sql.*"%> <%@ page import="java.io.*"%>
<script> function fnMenuBg1(elementId) { document.getElementById(elementId).style.backgroundColor="#dfdfdf"; } function fnMenuBg2(elementId) { document.getElementById(elementId).style.backgroundColor=""; } <% String statement=""; ResultSet objRs=null; ResultSet oRsQn=null; int course_id=0;
int paper_no=0; int attempt_id=0; String attempt=""; String paper_name=""; String course_name=""; String trainee_name=""; int number_of_questions=0; String user_name=(String)session.getAttribute("user_name"); if(user_name==null) { response.sendRedirect("course_list_index2.jsp?result=Session Timed Out.Please, Login again."); } if(request.getParameter("course_id")!=null) { course_id=Integer.parseInt(request.getParameter("course_id")); paper_no=Integer.parseInt(request.getParameter("paper_no")); attempt_id=Integer.parseInt(request.getParameter("attempt_id")); } try { statement="select * from x_master_elearning_user u,x_master_trainee_detail_online t,x_masterListOfCourses c,x_masterListOfPapers p where c.course_id=t.course_id and t.user_name=u.user_name and c.course_id=p.course_id and c.course_id=" + course_id + " and u.user_name='" + user_name + "'";
DB.setStatement(statement); objRs=(ResultSet)DB.result(); if(objRs.next()) { paper_name=objRs.getString("paper_name"); course_name=objRs.getString("course_name"); trainee_name=objRs.getString("first_name"); } } catch(Exception e) { out.print("Error occured : " + e); } if(attempt_id==1) { attempt="first"; } else { if(attempt_id==2) { attempt="second"; }
else { attempt="third"; } } try { statement="select * from TRAINING_CENTRE_PARAMETERS"; DB1.setStatement(statement); oRsQn=(ResultSet)DB1.result(); if(oRsQn.next()) { number_of_questions=oRsQn.getInt("number_of_questions"); } else { number_of_questions=25; } session.setAttribute("number_of_questions","" + number_of_questions); } catch(Exception e) { out.print("errror occured 2 : " + e);
--------------------------------------exam_question.jsp---------------------------------------------
<%@ page import="INCLUDES.DBConnection"%> <%@ page import="java.sql.*"%> <%@ page import="java.io.*"%>
<% String dbase=(String)session.getAttribute("dbase"); String trainee_id=(String)session.getAttribute("trainee_id"); String user_name=(String)session.getAttribute("user_name"); if(user_name==null) { response.sendRedirect("course_list_index2.jsp?result=Session Timed Out.Please, Login again."); } int attempt_id=Integer.parseInt((String)session.getAttribute("attempt_id")); int number_of_questions=Integer.parseInt((String)session.getAttribute("number_of_questions")); int course_id=Integer.parseInt((String)session.getAttribute("course_id")); int paper_id=Integer.parseInt((String)session.getAttribute("paper_id")); String statement=null; ResultSet objRs=null;
ResultSet objRsQNo=null; ResultSet objRsQ=null; int no_of_papers=0,paper_no=0; String course_name="",trainee_name="",paper_name=""; try { statement="select * from x_master_elearning_user u,x_master_trainee_detail_online t,x_masterListOfCourses c ,x_masterListOfPapers p where p.course_id=c.course_id and c.c ourse_id=t.course_id and t.user_name=u.user_name and c.course_id=" + course_id + " and u.user_name='" + user_name + "' and p.paper_id=" + paper_id; DB.setStatement(statement); objRs=(ResultSet)DB.result(); if(objRs.next()) { course_name=objRs.getString("course_name"); trainee_name=objRs.getString("first_name"); paper_name=objRs.getString("paper_name"); no_of_papers=objRs.getInt("no_of_papers"); paper_no=objRs.getInt("paper_no"); } } catch(Exception e) { out.print("error occured 1 :" + e);
} int i=0; if(request.getParameter("question_no")==null) { i=1; } else { i=Integer.parseInt(request.getParameter("question_no"))+1; } try { statement="select * from results where paper_id=" + paper_id + " and course_id=" + course_id + " and trainee_id='" + trainee_id + "'"; DB1.setStatement(statement); objRsQNo=(ResultSet)DB1.result(); if(objRsQNo.next()) { if(i<= number_of_questions) { statement="select * from x_masterListOfQuestions where paper_id=" + paper_id + " and question_id=" + objRsQNo.getInt("qn" + i); DB2.setStatement(statement);
objRsQ=(ResultSet)DB2.result(); } } } catch(Exception e) { out.print("error occured 22 :" + e); } %>