ONLINE EXAMINATION USING JSP
AIM:
To
create a three tier application for conducting online examination using
JSP and database.
ALGORITHM:
1.
Design the HTML page (ExamClient.html) with the following
a)
Create a form to get the input from the user.
b) Use
radio buttons to make various options for the questions.
c)
Set the URL of the server (ExamServer.jsp) as the value of the action
attribute.
d)
Use submit button to invoke the server and send the form data to the server.
2.
Create the JSP file with the following
a)
Read the input from the client.
b)
Retrieve the answers from the database.
c)
Match the answers from the user with the correct answers from the database
table.
d)
For each correct answer increment the mark by 5.
e)
Server displays the mark and result to the client as a response.
ExamServer.jsp:
<%@page
contentType="text/html" language="java"
import="java.sql.*"%>
<html>
<head>
<title>Online
Exam Server</title>
<style
type="text/css">
body{background-color:black;font-family:courier;color:blue}
</style>
</head>
<body>
<h2
style="text-align:center">ONLINE EXAMINATION</h2>
<p>
<a
href="ExamClient.html">Back To Main Page</a>
</p>
<hr/>
<%
String
str1=request.getParameter("ans1");
String
str2=request.getParameter("ans2");
String
str3=request.getParameter("ans3");
int
mark=0;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:examDS");
Statement
stmt=con.createStatement();
ResultSet
rs=stmt.executeQuery("SELECT * FROM examTab");
int i=1;
while(rs.next())
{
if(i==1)
{
String dbans1=rs.getString(1);
if(str1.equals(dbans1))
{
mark=mark+5;
}
}
if(i==2)
{
String dbans2=rs.getString(1);
if(str2.equals(dbans2))
{
mark=mark+5;
}
}
if(i==3)
{
String dbans3=rs.getString(1);
if(str3.equals(dbans3))
{
mark=mark+5;
}
}
i++;
}
if(mark>=10)
{
out.println("<h4>Your Mark Is :
"+mark+"</h4>");
out.println("<h3>Congratulations....!
You Are Eligible For The Next Round...</h3>");
}
else
{
out.println("<h4>Your Mark is :
"+mark+"</h4>");
out.println("<h3>Sorry....!! You
Are Not Eligible For The Next
Round...</h3>");
}
%>
</form>
</body>
</html>
ExamClient.HTML:
<html>
<head>
<title>Online
Exam Client</title>
<style
type="text/css">
body{background-color:black;font-family:courier;color:blue}
</style>
</head>
<body>
<h2
style="text-align:center">ONLINE EXAMINATION</h2>
<h3>Answer
the following questions (5 marks for each correct answer)</h3>
<hr/>
<form
name="examForm" method="post"
action="ExamServer.jsp">
1. All
computers must have <br/>
<input
type="radio" name="ans1" value="Operating
System">Operating System
<input
type="radio" name="ans1" value="Application
Software">Application Software
<input
type="radio" name="ans1" value="CD Drive">CD
Drive
<input
type="radio" name="ans1" value="Microsoft
word">Microsoft word
<br/><br/>
2. The
term PC means <br/>
<input
type="radio" name="ans2" value="Private
Computer">Private Computer
<input
type="radio" name="ans2" value="Professional
Computer">Professional Computer
<input
type="radio" name="ans2" value="Personal
Computer">Personal Computer
<input
type="radio" name="ans2" value="Personal
Calculator">Personal Calculator
<br/><br/>
3.C was
developed by?<br/>
<input
type="radio" name="ans3" value="Dennis
Ritchie">Dennis Ritchie
<input
type="radio" name="ans3"
value="Stroustrup">Stroustrup
<input
type="radio" name="ans3" value="David
Ritchie">David Ritchie
<input
type="radio" name="ans3" value="Charles
Babbage">Charles Babbage
<br/><br/>
<input
type="submit" value="Check Your Result"/>
</form>
</body>
</html>
DATABASE
OUTPUT SCREENSHOTS
No comments:
Post a Comment