EXERCISE: 1
DATE:
EMBEDDING AN IMAGE MAP IN AN HTML PAGE
Aim:
To create an html page with an embedded image and to fix the hotspots for linking.
Algorithm:
Step 1: Start the program.
Step 2: Create an html page and embed an image in it.
Step 3: Using the X-Y co-ordinates, fix the various hotspots used to link other pages.
Step 4: Create 4 different pages separately.
Step 5: Using link tag, connect each hotspot with its respective link page.
Step 6: Load the main html program, and check the links.
Step 7: Stop the program.
PROGRAM CODE:
map.html
<html>
<head>
<font color=red align="center">
<h1>INDIA</h1</font>
</head>
<body bgcolor="white" align="center">
<map name="mymap">
<area shape="circle" coords="205,270,5" href="chennai.html">
<area shape="circle" coords="135,200,5" href="mumbai.html">
<area shape="circle" coords="285,165,5" href="kolkatta.html">
<area shape="circle" coords="172,102,5" href="delhi.html">
</map>
<marquee<font color="green">
<h2>INDIA IS MY COUNTRY</h2>
</font</marquee<img src="map.jpg" usemap="#mymap">
</body>
</html>
chennai.html
<html>
<head<b<h1 align="center">
<font color="green">CHENNAI</font</b</head>
<body bgcolor="cyan"<h2 align="left">About chennai</h2<hr>
<ul<h3 align="left"<li>Chennai is the capital of Tamilnadu<br>
<li>It is one of the 4 metropolitan cities of India<br>
<li>Tamil is the native language of Chennai<br</ul>
<center>
<a href="C:\map.html">home</a</center>
</font>
</body>
</html>
mumbai.html
<html>
<head<b<h1 align="center">
<font color="green">MUMBAI</font</b</head>
<body bgcolor="pink"<h2 align="left">About Mumbai</h2<hr>
<ul<h3 align="left"<li>Mumbai is popularly called as Bollywood city<br>
<li>It is one of the 4 metropolitan cities of India<br>
<li>Hindi is the native language of Mumbai<br</ul>
<center>
<a href="C:\map.html">home</a</center>
</font>
</body>
</html>
delhi.html
<html>
<head<b<h1 align="center">
<font color="red">DELHI</font</b</head>
<body bgcolor="yellow"<h2 align="left">About Delhi</h2<hr>
<ul<h3 align="left"<li>Delhi is the capital of India<br>
<li>It is one of the 4 metropolitan cities of India<br>
<li>Hindi is the native language of Delhi<br</ul>
<center>
<a href="C:\map.html">home</a</center>
</font>
</body>
</html>
kolkatta.html
<html>
<head<b<h1 align="center">
<font color="red">KOLKATTA</font</b</head>
<body bgcolor="violet"<h2 align="left">About Kolkatta</h2<hr>
<ul<h3 align="left"<li>Kolkatta is the capital of West Bengal<br>
<li>It is one of the 4 metropolitan cities of India<br>
<li>Bengali is the native language of Chennai<br</ul>
<center>
<a href="C:\map.html">home</a</center>
</font>
</body>
</html>
SCREEN OUTPUT:
RESULT:
Thus an html page with an embedded image has been created and hotspots are fixed for linking.
EXERCISE: 2
DATE:
APPLYING STYLE TO AN HTML PAGE USING CSS
Aim:
To create an html page, and to apply style formatting using external Cascading Style Sheet.
Algorithm:
Step 1: Start the program.
Step 2: Create an html page.
Step 3: Create an external CSS (Cascading Style Sheet).
Step 4: Link the external style sheet page with the main html page.
Step 5: Load the main page.
Step 6: The style formatting will be applied to the main html page.
Step 7: Stop the program.
PROGRAM CODE:
style.html
<html>
<head>
<title>My first styled page</title>
<link rel="stylesheet"href="mystyle.css">
</head>
<body>
<!--site navigation menu-->
<ul class="navbar">
<li<a href="About.html">About us</a>
<li<ahref="Dept.html">Department</a>
<li<a href="Contact.html">Contact us</a>
</ul>
<!--Main content-->
<h1>My first styled page</h1>
<p>SHRI ANDAL ALAGAR COLLEGE OF ENGINEERING<BR>
NO 6,G.S.T. ROAD.<br>
MAMANDUR-636111.<br>
<p>
An ISO 9001:2008 institution<br>
NBA Accredited<br>
<!--sign and date the page-->
<p<address>December 28th <br>
Dept. of I.T.</address>
</body>
</html>
mystyle.css
BODY
{
PADDING-LEFT: 11em;
COLOR: purple;
FONT-FAMILY: Georgia, "Times New Roman",
Times, serif;
BACKGROUND-COLOR: #d8da3d
}
UL.navbar
{
PADDING-RIGHT: 0px;
PADDING-LEFT: 0px;
LEFT: 1em;
PADDING-BOTTOM: 0px;
MARGIN: 0px;
WIDTH: 9em;
PADDING-TOP: 0px;
LIST-STYLE-TYPE: none;
POSITION: absolute;
TOP: 2em
}
H1
{
FONT-FAMILY: Helvetica, Geneva, Arial, SunSans-Regular, sans-serif
}
UL.navbar LI
{
BORDER-RIGHT: 1em solid;
PADDING-RIGHT: 0px;
PADDING-LEFT: 0px;
BACKGROUND: white;
PADDING-BOTTOM: 0.3em;
MARGIN: 0.5em 0px;
PADDING-TOP: 0.3em
}
UL.navbar A
{
TEXT-DECORATION: none
}
A: link
{
BORDER-RIGHT: mediumblue;
BORDER-TOP: mediumblue;
BORDER-LEFT: mediumblue;
COLOR: blue;
BORDER-BOTTOM: mediumblue
}
A: visited
{
COLOR: purple
}
ADDRESS
{
BORDER-TOP: thin dotted;
MARGIN-TOP: 1em;
PADDING-TOP: 1em
}
SCREEN OUTPUT:
RESULT:
Thus an html page is created and style formatting is applied using external Cascading Style Sheet.
EXERCISE: 3
DATE:
COLOR PALETTE CREATION USING JAVA APPLET
Aim:
To create a color palette using java applet to change the foreground and background color.
Algorithm:
Step 1: Start the program.
Step 2: Create an applet using 10 buttons for choosing color and 2 checkboxes for
Choosing fore-ground and back-ground color.
Step 3: Place these components on the layout.
Step 4: Load the applet from the command prompt.
Step 5: Stop the program.
PROGRAM CODE:
import java.applet.*;
import java.awt.*;
import java.awt.event.*;
public class Colpal extends Applet implements ActionListener,ItemListener
{
int flag,Col;
Button b1,b2,b3,b4,b5,b6,b7,b8,b9,b10;
Checkbox cb1,cb2;
CheckboxGroup ckb;
Panel p1,p2,p3;
String val="Welcome";
TextArea t1;
@Override
public void init()
{
flag=1;
Col=1;
b1=new Button(" ");
ckb=new CheckboxGroup();
p1=new Panel();
p2=new Panel();
p3=new Panel();
p1.setLayout(new FlowLayout(FlowLayout.CENTER));
p2.setLayout(new GridLayout(1,1));
p3.setLayout(new GridLayout(5,5));
b2=new Button(" ");
b3=new Button(" ");
b4=new Button(" ");
b5=new Button(" ");
b6=new Button(" ");
b7=new Button(" ");
b8=new Button(" ");
b9=new Button(" ");
b10=new Button(" ");
b1.setBackground(Color.blue);
b2.setBackground(Color.red );
b3.setBackground(Color.green );
b4.setBackground(Color.pink );
b5.setBackground(Color.yellow );
b6.setBackground(Color.black );
b7.setBackground(Color.white );
b8.setBackground(Color.gray );
b9.setBackground(Color.darkGray );
b10.setBackground(Color.magenta );
t1=new TextArea(val,15,60);
cb1=new Checkbox("Background",ckb,true);
cb2=new Checkbox("Foreground",ckb,false);
p1.add(cb1);
p2.add(t1);
p1.add(cb2);
p3.add(b1);
p3.add(b2);
p3.add(b3);
p3.add(b4);
p3.add(b5);
p3.add(b6);
p3.add(b7);
p3.add(b8);
p3.add(b9);
p3.add(b10);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b4.addActionListener(this);
b5.addActionListener(this);
b6.addActionListener(this);
b7.addActionListener(this);
b8.addActionListener(this);
b9.addActionListener(this);
b10.addActionListener(this);
cb1.addItemListener(this);
cb2.addItemListener(this);
setLayout(new BorderLayout());
add("North",p1);
add("West",p2);
add("East",p3);
}
public void itemStateChanged(ItemEvent e)
{
if(cb1.getState()==true)
{
flag=1;
}
if(cb2.getState()==true)
{
flag=2;
}
repaint();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==b1)
Col=1;
if(e.getSource()==b2)
Col=2;
if(e.getSource()==b3)
Col=3;
if(e.getSource()==b4)
Col=4;
if(e.getSource()==b5)
Col=5;
if(e.getSource()==b6)
Col=6;
if(e.getSource()==b7)
Col=7;
if(e.getSource()==b8)
Col=8;
if(e.getSource()==b9)
Col=9;
if(e.getSource()==b10)
Col=10;
repaint();
}
@Override
public void paint(Graphics g)
{
if(flag==1)
{
switch(Col)
{
case 1:
t1.setBackground(Color.blue);
break;
case 2:
t1.setBackground(Color.red);
break;
case 3:
t1.setBackground(Color.green);
break;
case 4:
t1.setBackground(Color.pink);
break;
case 5:
t1.setBackground(Color.yellow);
break;
case 6:
t1.setBackground(Color.black);
break;
case 7:
t1.setBackground(Color.white);
break;
case 8:
t1.setBackground(Color.gray);
break;
case 9:
t1.setBackground(Color.darkGray);
break;
case 10:
t1.setBackground(Color.magenta);
break;
}
}
switch(Col)
{
case 1:
t1.setForeground(Color.blue);
break;
case 2:
t1.setForeground(Color.red);
break;
case 3:
t1.setForeground(Color.green);
break;
case 4:
t1.setForeground(Color.pink);
break;
case 5:
t1.setForeground(Color.yellow);
break;
case 6:
t1.setForeground(Color.black);
break;
case 7:
t1.setForeground(Color.white);
break;
case 8:
t1.setForeground(Color.gray);
break;
case 9:
t1.setForeground(Color.darkGray);
break;
case 10:
t1.setForeground(Color.magenta);
break;
}
}
@Override
public Insets getInsets()
{
return(new Insets(10,40,180,100));
}
}
/*<applet code="Colpal.class" width="710" height="500">
</applet>*/
SCREEN OUTPUT:
RESULT:
Thus an html page is created and style formatting is applied using external Cascading Style Sheet.
EXERCISE: 4
DATE:
CLIENT SIDE SCRIPTS FOR VALIDATING WEB FORMS USING HTML
Aim:
To write Client Side Scripts for Validating Web Form Controls using HTML.
Algorithm:
Step 1: Start the program.
Step 2: Design a form using html.
Step 3: Write a JavaScript function to validate all the fields in the form.
Step 4: Call the function from the html page.
Step 5: Stop the program.
PROGRAM CODE:
mark.html
<HTML>
<HEAD>
<TITLE>Student Mark List</TITLE>
<SCRIPT LANGUAGE="JavaScript">
function mark()
{
if (parseInt(form1.registerno.value)<=0)
alert ("Register Number Should Not be Negative");
if (parseInt(form1.registerno.value.length)==0)
alert ("Register Number Should Not be Null");
if (form1.name.value.length<=0)
alert ("Name Should not be Null");
if (parseInt(form1.mark1.value) < 0 || parseInt(form1.mark1.value) > 100 || parseInt(form1.mark1.value.length)==0)
alert ("Invalid Mark 1");
if(parseInt(form1.mark2.value) < 0 || parseInt(form1.mark2.value) > 100 || parseInt(form1.mark2.value.length)==0)
alert("Invalid Mark 2");
if(parseInt(form1.mark3.value) < 0 || parseInt(form1.mark3.value) > 100 || parseInt(form1.mark3.value.length)==0)
alert("Invalid Mark 3");
if(parseInt(form1.mark4.value) < 0 || parseInt(form1.mark4.value) > 100 || parseInt(form1.mark4.value.length)==0)
alert("Invalid Mark 4");
if(parseInt(form1.mark5.value) < 0 || parseInt(form1.mark5.value) > 100 || parseInt(form1.mark5.value.length)==0)
alert("Invalid Mark 5");
form1.total.value=parseInt(document.form1.mark1.value)+parseInt(document.form1.
mark2.value) +parseInt(document.form1.mark3.value)+parseInt(document.form1.
mark4.value) +parseInt(document.form1.mark5.value)
form1.avg.value=form1.total.value/5
if(parseInt(form1.mark1.value) < 50 || parseInt(form1.mark2.value) < 50 || parseInt(form1.mark3.value) < 50 || parseInt(form1.mark4.value) < 50 || parseInt(form1.mark5.value) < 50)
form1.result.value="fail"
else if(parseInt(form1.mark1.value) >= 50 & parseInt(form1.mark2.value) >= 50 & parseInt(form1.mark3.value) >= 50 & parseInt(form1.mark4.value) >= 50 & parseInt(form1.mark5.value) >= 50)
form1.result.value="pass"
if(parseInt(form1.avg.value) >= 75 & parseInt(form1.mark1.value) >= 50 & parseInt(form1.mark2.value) >= 50 & parseInt(form1.mark3.value) >= 50 & parseInt(form1.mark4.value) >= 50 & parseInt(form1.mark5.value) >= 50)
form1.grade.value="DISTINCTION"
else if(parseInt(form1.avg.value) >= 60 & parseInt(form1.avg.value) <75 & parseInt(form1.mark1.value) >= 50 & parseInt(form1.mark2.value) >= 50 & parseInt(form1.mark3.value) >= 50 & parseInt(form1.mark4.value) >= 50 & parseInt(form1.mark5.value) >= 50 )
form1.grade.value="First Class"
else if(parseInt(form1.avg.value) >= 50 & parseInt(form1.avg.value) < 60 & parseInt(form1.mark1.value) >= 50 & parseInt(form1.mark2.value) >= 50 & parseInt(form1.mark3.value) >= 50 & parseInt(form1.mark4.value) >= 50 & parseInt(form1.mark5.value) >= 50)
form1.grade.value="Second Class"
else if(parseInt(form1.avg.value) < 50)
form1.grade.value="Fail"
}
</script>
</head>
<body>
<h1<b>STUDENT MARK DETAILS</b</H1>
<form name="form1">
<table border="0">
<tr>
<td width="104"<h4>Register No:</h4</td>
<td width="430"<input type="text" name="registerno"</td>
</tr>
<tr>
<td width="104"<h4>Name :</h4</td>
<td width="430"<input type="text" name="name"</td>
</tr>
<tr>
<td width="104"<h4>Mark1 :</h4</td>
<td width="430"<input type="text" name="mark1"</td>
</tr>
<tr>
<td width="104"<h4>Mark2 :</h4</td>
<td width="430"<input type="text" name="mark2"</td>
</tr>
<tr>
<td width="104"<h4>Mark3 :</h4</td>
<td width="430"<input type="text" name="mark3"</td>
</tr>
<tr>
<td width="104"<h4>Mark4 :</h4</td>
<td width="430"<input type="text" name="mark4"</td>
</tr>
<tr>
<td width="104"<h4>Mark5 :</h4</td>
<td width="430"<input type="text" name="mark5"</td>
</tr>
<tr>
<td width="104"<h4>Total Marks :</h4</td>
<td width="430"<input type="text" name="total"</td>
</tr>
<tr>
<td width="104"<h4>Average :</h4</td>
<td width="430"<input type="text" name="avg"</td>
</tr>
<tr>
<td width="104"<h4>Grade :</h4</td>
<td width="430"<input type="text" name="grade"</td>
</tr>
<tr<td width="104"<h4>Result:</h4</td>
<td width="430"<input type="text" name="result"</td>
</tr>
</table>
<br>
<h1<input type="button" value="RESULT" onClick="mark()">
<input type="reset" size="25" value="RESET"</h1>
</form>
</body>
</HTML>
SCREEN OUTPUT:
RESULT:
Thus the client side validation of the form fields is done using JavaScript in the html web page.
EXERCISE: 5
DATE:
SIMPLE SERVLET TO DISPLAY MARKS OF STUDENTS
Aim:
To create a java servlet to display the marks of students without a database.
Algorithm:
Step 1: Start the program.
Step 2: Create a servlet using the required packages.
Step 3: Deploy the servlet class file in the webapps directory of tomcat server.
Step 4: Configure the web.xml file.
Step 5: Start the tomcat server.
Step 6: Load the servlet from the browser.
Step 7: Stop the program.
PROGRAM CODE:
marklist.java
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Marklist extends HttpServlet
{
public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
String s;
s=request.getParameter("reg");
String s1="S.Aarthi";
String s2="komathi";
String s3="Sathish";
int mk10=98,mk11=98,mk12=98,mk20=98,mk21=98,mk22=98,mk30=78,mk31=87,mk32=78;
String r1="4001",r2="4002",r3="4003";
out.println("<html>");
out.println("<body>");
out.println("<head>");
out.println("<title>Marklist</title>");
out.println("</head>");
if(s.equals(r3))
{
out.println("<h3>Name is:"+s3+"</h3>");
out.println("<h3>Regno is:"+s+"</h3>");
out.println("<h3>Mark1:"+mk30+"</h3>");
out.println("<h3>Mark2:"+mk31+"</h3>");
out.println("<h3>Mark3:"+mk32+"</h3>");
}
else if(s.equals(r1))
{
out.println("<h3>Name is:"+s1+"</h3>");
out.println("<h3>Regno is:"+s+"</h3>");
out.println("<h3>Mark1:"+mk10+"</h3>");
out.println("<h3>Mark2:"+mk11+"</h3>");
out.println("<h3>Mark3:"+mk12+"</h3>");
}
else if(s.equals(r2))
{
out.println("<h3>Name is:"+s2+"</h3>");
out.println("<h3>Regno is:"+s+"</h3>");
out.println("<h3>Mark1:"+mk20+"</h3>");
out.println("<h3>Mark2:"+mk21+"</h3>");
out.println("<h3>Mark3:"+mk22+"</h3>");
}
out.println("</body>");
out.println("</html>");
}
}
SCREEN OUTPUT:
RESULT:
Thus a java servlet has been created to display the student’s marks.
EXERCISE: 6
DATE:
JAVA SERVLET TO CONDUCT ONLINE EXAM
Aim:
To develop a simple Java servlet to conduct online examination.
Algorithm:
Step 1: Start the program.
Step 2: Create a servlet using the required packages.
Step 3: Deploy the servlet class file in the webapps directory of tomcat server.
Step 4: Configure the web.xml file.
Step 5: Start the tomcat server.
Step 6: Load the servlet from the browser.
Step 7: Stop the program.
PROGRAM CODE:
online.html
<html>
<body>
<div align="center">
</h1>ONLINE EXAMINATION</h1>
<form action="http://localhost:8080/examples/servlet/Onli">
<p align="left">
1. What is the capital of tamilnadu? </p>
<p align="left">
<input name="r1" type="radio" value="delhi">delhi
<input name="r1" type="radio" value="chennai">chennai
<input name="r1" type="radio" value="kerala">kerala
</p>
<p align="left">
2. Who is the president of india? </p>
<p align="left">
<input name="r2" type="radio" value="pratiba">prathiba
<input name="r2" type="radio" value="ABDUL Kalam">abdulkalam
<input name="r2" type="radio" value="rajini">rajini
</p>
<p align="left">
3. What is the land of cokes?</p>
<p align="left">
<input name="r3" type="radio" value="scotland">Scotland
<input name="r3" type="radio" value="greenland">greenland
<input name="r3" type="radio" value="ireland">Ireland
</p>
<p align="left">
<input type="submit">
<input type="reset">
</p>
</form>
</div>
</body>
</html>
Onli.java
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Onli extends HttpServlet
{
public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException
{
int score=0;
PrintWriter out=response.getWriter();
String r1=request.getParameter("r1");
String r2=request.getParameter("r2");
String r3=request.getParameter("r3");
response.setContentType("text/html");
if(r1.equals("chennai"))
{
score=score+1;
}
if(r2.equals("pratiba"))
{
score=score+1;
}
if(r3.equals("scotland"))
{
score=score+1;
}
out.println("<html>");
out.println("<head>");
out.println("<title>helloworld</title>");
out.println("</head>");
out.println("<body>");
if(score==3)
{
out.println("congratz");
out.println("score is:"+score);
}
else
{
out.println("score is:"+score);
out.println("<body>");
out.println("<html>");
}
}
}
SCREEN OUTPUT:
RESULT:
Thus a simple Java servlet has been developed for conducting online examination.
EXERCISE: 7
DATE:
CREATION OF 3-TIER APPLICATION USING SERVLET AND DATABASE
Aim:
To develop a 3-tier application for displaying student’s mark list using java servlet and
MS-Access database.
Algorithm:
Step 1: Start the program.
Step 2: Create a MS-Access database table named student for storing student’s marks.
Step 3: Create an html form for entering the register number of the student.
Step 4: Open control panel and make the database connectivity settings.
Step 5: Create a servlet for processing the student’s marks from the database.
Step 6: Deploy the servlet and the html page in the Netbeans 6.8 IDE to create the application package.
Step 7: Run the application in the IDE.
Step 8: The student’s mark list for the corresponding register number will be displayed.
Step 9: Stop the program.
PROGRAM CODE:
mark.html
<html>
<body bgcolor=#779966 text=black>
<center<font color=blue<h2>LOGIN FORM</h2</font</center>
<form method =get action="http://localhost:8084/marklist/Student">
<table align=center border=0 bgcolor=#777799>
<tr<td>REG NUMBER</td<td>:</td<td<input type=text name=login value="">
</td>
</table<br<br<center>
<input type=submit value=SUBMIT>
<input type=Reset value=RESET</center>
</form>
</body>
</html>
Student.java
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Student extends HttpServlet
{
int m1,m2,m3,m4,m5,m6;
public void doGet(HttpServletRequest r,HttpServletResponse rs)throws
IOException,ServletException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:student");
Statement st=con.createStatement();
ResultSet res;
String query="select *from student";
res=st.executeQuery(query);
rs.setContentType("text/html");
PrintWriter out=rs.getWriter();
out.println("<html<body>");
int reg1=Integer.parseInt(r.getParameter("login"));
int valid=0;
while(res.next())
{
if(res.getInt(1)==reg1)
{
valid=1;
m1=res.getInt(2);
m2=res.getInt(3);
m3=res.getInt(4);
m4=res.getInt(5);
m5=res.getInt(6);
m6=res.getInt(7);
break;
}
}
if(valid==0)
{
out.println("not valid RegNo");
}
else
{
out.println("<html<body bgcolor=#ccbbaa");
out.println("<p </p>");
out.println("<center<font color=blue<h2>SAACE</h2</font</center>");
out.println("<p align=center>");
out.println("MARK1<input type=text name=mark1 value="+m1+">");
out.println("MARK2<input type=text name=mark2 value="+m2+">");
out.println("<p>");
out.println("<p align=center>");
out.println("MARK3<input type=text name=mark3 value="+m3+">");
out.println("MARK4<input type=text name=mark4 value="+m4+">");
out.println("<p>");
out.println("<p align=center>");
out.println("MARK5<input type=text name=mark5 value="+m5+">");
out.println("MARK6<input type=text name=mark6 value="+m6+">");
int tot1;
double avg1;
tot1=m1+m2+m3+m4+m5+m6;
avg1=((tot1)/6.0);
out.println("<hr>");
out.println("<p </p>");
out.println("<p </p>");
out.println("<p align=center>");
out.println("TOTAL<input type=text name=total value="+tot1+">");
out.println("AVERAGE<input type=text name=avg value="+avg1+">");
out.println("<p>");
out.println("</body</html>");
}
}
catch(SQLException e)
{
System.out.println(e);
}
catch(ClassNotFoundException e)
{
System.out.println(e);
}
}
}
SCREEN OUTPUT:
RESULT:
Thus a 3-tier application for displaying student’s mark list using java servlet and
MS-Access database has been successfully developed.
EXERCISE: 8
DATE:
CREATION OF 3-TIER APPLICATION USING JSP AND DATABASE
Aim:
To develop a 3-tier application for displaying student’s mark list using java server pages and
MS-Access database.
Algorithm:
Step 1: Start the program.
Step 2: Create a MS-Access database table named student for storing student’s marks.
Step 3: Create an html form for entering the register number of the student.
Step 4: Open control panel and make the database connectivity settings.