Cs9228 Web Technology Lab Manual

(1)

CS9228 WEB TECHNOLOGY LAB

1. _{Creation of HTML pages with frames, links, tables and other tags.} 2. _{Usage of internal and external CSS along with HTML pages.} 3. _{Client Side Programming.}

a. Javascript for displaying date and comparing two dates.

b. Form validation including textfield, radio buttons, checkboxes, listbox and other controls

4. Usage of ASP/JSP objects Request, Response, Application, Session, Server, ADO etc. (Writing online applications such as Shopping, railway/air/bus ticket reservation system with set of ASP/JSP pages.)

5. Writing Servlet Program using HTTP Servlet. 6. Any online application with database access.

(Write an ASP application for Telephone Directory using MS-ACCESS) 7. Creation of XML document for a specific domain.

8. Writing DTD or XML schema for the domain specific XML document. 9. Parsing an XML document using DOM and SAX Parsers.

(2)

CREATION OF STUDENT PROFILES USING HTML TAGS

AIM:

To develop a webpage to enter the student profiles.

ALGORITHM:

Step1: Start the program

Step 2: Using html tags, create table to enter the student profile Step3: For each row of the table, enter the data using <td> such that create student name,fathers name,address and e-mail,etc..

Step 4: Using <table> we have to enter the qualification of the students.

Step 5: Using radio button,we have to choose the entertainment and software exposure of the student.

Step 6: Using <form>, we have to create a declare text to type the text. Step 7: Execute the web page in Internet explorer

(3)

PROGRAM : <html> <head> <title>Resume page</title> </head> <body bgcolor="#fffFF"> <center><font color="#6600CC"><h1><b><b><u>PROFILE</u></b></b></h1></center></fo nt>

<tr>

<td>Father Name:</td>

<td>Mother Name:</td>

<td>Date Of Birth:</td>

<td>Marital Status:</td>

<td>Communication:</td>

<tr>

<td>Gender:</td>

<td>Male:<input type="checkbox" name="male">Female:<input type="checkbox" name="female"></td>

(4)

<tr>

<th colspan="6">Educational Qualifications</th></tr> <tr>

<th>Name of the Deg.</th><th>name of the degree</th><th>Name of the Instistution</th><th>Year of

Pass</th><th>Grade</th><th>Specialization</th></tr> <tr>

<tr>

<tr>

<tr>

<tr>

(5)

<td><input type="text" height='10' width='25'></td> <td><input type="text" height='10' width='25'></td> <td><input type="text" height='10' width='25'></td> </tr> <br><br><br> <tr> <th colspan="6">Software Exposure</th> </tr> <tr> <td>OS:</td>

<<td colspan="5">Windows XP/00/03<input type="checkbox"

name="male">LINUX<input type="checkbox" name="female">UNIX<input type="checkbox" name="female">others<input type="checkbox"

name="female"></td> </tr>

<tr>

<td>Languages:</td>

<td colspan="5">C:<input type="checkbox" name="male">C++:<input type="checkbox" name="female">Java:<input type="checkbox"

name="female">J2EE:<input type="checkbox" name="female"></td> </tr>

<tr>

<td>Extra Curriculam Acvtivities:</td>

<td colspan="5">Dance:<input type="checkbox" name="male">Swimming:<input type="checkbox" name="female">Shuttle:<input type="checkbox"

name="female">Music:<input type="checkbox" name="female"></td> </tr>

<tr>

<td>Any Other Information:</td>

<tr>

<center><th>Declaration:</th></center>

</tr> <tr>

<td><input type="text" name="male"></td> <td>Place:</td>

(6)

</tr> <tr>

<td><input type="Submit" value="submit"> <A

href="webpageprofile.htm"></A><br CLEAR=both></td> <td><input type="reset" value="reset"></td>

</tr> </center> </body> </html>

(7)

SAMPLE OUTPUT :

RESULT:

(8)

DEVELOPING WEB SITE USING INTERNAL AND EXTERNAL CSS ALONG WITH HTML PAGES.

AIM:

To develop a web site application using various html tags, forms, attributes, css properties.

ALGORITHM:

Step 1: Start the program.

Step 2: Using html tags create a main page .

Step 3: Using link tags, open the various pages which links with the main page.

Step 4: Using img tag, place the pictures in web page, wherever it is needed.

Step 5: Using css properties create the link pages. Step 6: Enter the details in link pages using html tags.

Step 7: Run the home page and click the link pages to view the details. Step 8: Stop the program.

(9)

PROGRAM: Home.Html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<body>

<tr>

</td> </tr> <tr>

</tr> </table>

(10)

<tr>

<p><h2>Your interesting Air Travel</h2> </p><p> Curabitur mi nibh, cursus vel, laoreet sit amet, aliquet sit amet, justo. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Lorem ipsum dolor sit amet,

consectetuer adipiscing elit. Aenean vel magna. Nunc accumsan nulla. Nunc feugiat cursus lorem. Cras turpis. <br />

<br />

Curabitur vel velit. Curabitur mi nibh, cursus vel, laoreet sit amet, aliquet sit amet, justo. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Pellentesque id nibh. Sed risus. Fusce quis velit eu felis vestibulum sceleris- que. Nam lectus dolor, interdum at, mollis et, vehicula ut, sem. <a

href="#"></a> </p>

<p>Latest News Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean vel magna. Nunc accumsan nulla. <a href="#"></a> Curabitur mi nibh, cursus vel, laoreet sit amet, aliquet sit amet, justo. Lorem ipsum dolor.Curabitur mi nibh, cursus vel, laoreet. <a href="#"></a> </p>

<table align="left" border="1" color="blue"> <tbody> <tr> <td> USERNAME </td> <td><input name="Input" /></td> </tr> <tr> <td> PASSWORD </td>

<tr>

(11)

<h2>Hot Tours</h2> </p>

<p><a href="#"><img height="7" alt="" src="aboutus_cp_arrw.gif" width="5" />Dolor sit amet, consectetuer adipis</a><br />

<img height="7" alt="" src="aboutus_cp_arrw.gif" width="5" /><a href="#">Aliquam erat volutpat. Nulla id orci.</a><br />

<img height="7" alt="" src="aboutus_cp_arrw.gif" width="5" /><a href="#">Phasellus congue justo quis leo.</a><br />

<img height="7" alt="" src="aboutus_cp_arrw.gif" width="5" /><a href="#">sed urna imperdiet suscipit.</a> </p>

</table>

<tr>

<a href="#" class="cp_anchrtxt1">Home</a> <span style="margin:0px 11px 0px 11px;">|</span> <a href="aboutus.html#" class="cp_anchrtxt1"> About us </a> <span style="margin:0px 11px 0px 11px;">|</span> <a href="accounts.html" class="cp_anchrtxt1"> Accounts </a> <span style="margin:0px 11px 0px 11px;">|</span> <a

href="booking.html" class="cp_anchrtxt1">Booking </a> <span

style="margin:0px 11px 0px 11px;">|</span> <a href="specialoffer.html" class="cp_anchrtxt1"> Special Offers </a> <span style="margin:0px 11px 0px 11px;">|</span><a href="contact.html" class="cp_anchrtxt1">

Contacts</a><br /></td> </tr>

</table>

</body>

(12)

Aboutus.Html

<body>

<tr>

</td> </tr> <tr>

</td> </tr> </table>

(13)

<p><h2>About us </h2>

<p>To render adequate, efficient, safe and economical air services Best airlines began its operation on 1st August, 2000 following the enactment of Air Corporations Act 2000. Today, Best Airlines, together with its fully owned subsidiary Alliance Air, has a fleet of 70 aircrafts. Since its very inception Indian Airlines has been setting standards for civil aviation. With many first in its credit, Indian Airlines has been feeding both the lavish and economical requirements of passengers across the globe. Over the years, Indian Airline has turned out to be synonymous with service, reliability and efficiency. Best Airlines' network covers Singapore in the East and Kuwait in the west and connects 18 destinations abroad. It's international network spans Oman, Kuwait, UAE, Qatar and Bahrain in West Asia; Singapore, Thailand, Malaysia and Mayanmar in South East Asia and Afghanistan, Pakistan, Nepal, Bangladesh, Sri Lanka and Maldives in the South Asia sub-continent. With a staff of over 500 thousand, Indian Airlines offers services which are simply exemplary and quite unmatched.</p>

</p> </p>

<ul> <li>Business to Consumer Solutions </li> </ul> <ul> <li>Internet Banking Solutions </li> </ul> <ul> <li>Intranet Workflow Solutions </li> </ul> <ul> <li>E-Governance Solutions </li> </ul>

<ul> <li>Corporate Wide E-Mail Infrastructure </li> </ul>

<ul><li>Internet/Intranet Security Solutions Dynamic Web Design and Consultancy </li> </ul>

<ul><li>Domain Name Registration </li> </ul> <ul> <li>Key Name Registration </li> </ul>

<ul><li>Web Sever Co-location Solutions </li> </ul> <ul> <li>Call center Solutions </li> </ul>

<ul> <li>Company Wide Internet Connectivity </li> </ul> <ul>

<li>Web Hosting solutions </li> </ul>

<ul> <li>Shared Hosting Services </li> </ul>

<ul> <li>Customer Relation Management (CRM) Solutions </li> </ul> <p style="float:left;width:641px;margin-top:22px;"><span style="float:left;font:11px/20px verdana;color:#29022A;margin:20px 0px 0px 0px;"><a href="#"></a> </span> </p>

</td>

(14)

</table>

<tr>

<a href="#" class="cp_anchrtxt1">Home</a> <span style="margin:0px 11px 0px 11px;">|</span> <a href="aboutus.html#" class="cp_anchrtxt1"> About us </a> <span style="margin:0px 11px 0px 11px;">|</span> <a

href="accounts.html" class="cp_anchrtxt1"> Accounts </a> <span style="margin:0px 11px 0px 11px;">|</span> <a href="booking.html" class="cp_anchrtxt1">Booking </a> <span style="margin:0px 11px 0px 11px;">|</span> <a href="specialoffer.html" class="cp_anchrtxt1"> Special Offers </a> <span style="margin:0px 11px 0px 11px;">|</span><a

href="contact.html" class="cp_anchrtxt1"> Contacts</a><br /></td> </tr>

</table>

</html>

Booking.Html

<body>

<tr>

(15)

</td> </tr> <tr>

</table>

<Form>

<center><h2 style="color:BLUE">Ticket Booking </h2></center> <table align=center border=2>

<tr>

<td>Departure <Input type=radio name="desparture"></td><td>Arriaval <Input type=radio name="arrival"></td></tr>

<option> Chennai </option><option> Delhi</option> <option> Kolkata</option><option> bangalore </option> <option> London </option><option> Mumbai </option> <option> Singapore</option><option> muscat</option> </select>

</td>

<option> Chennai </option><option> Delhi</option> <option> Kolkata</option><option> bangalore </option> <option> London </option><option> Mumbai </option> <option> Singapore</option><option> muscat</option> </select>

</td></tr> <tr>

(16)

<tr><td> Adult <Select><option> 1</option> <option> 2</option><option> 3</option> <option> 4 </option><option> 5 </option> <option> 6 </option><option> 7</option> <option> 8 </option>

</select> </td>

<td> Child <Select>

</td></tr> <tr>

<option> Indian bank</option><option> State bank</option> <option> ICICI BANK</option><option> HDFC BANK </option> <option> AXIS BANK </option><option> IDBI Bank </option>

<option> Indian overseas Bank</option><option> CITY BANK </option> </select>

</td>

<td>Amount <Input type="text" ></td></tr>

</table> </form>

<tr>

href="accounts.html" class="cp_anchrtxt1"> Accounts </a> <span style="margin:0px 11px 0px 11px;">|</span> <a href="booking.html" class="cp_anchrtxt1">Booking </a> <span style="margin:0px 11px 0px 11px;">|</span> <a href="specialoffer.html" class="cp_anchrtxt1"> Special

(17)

Offers </a> <span style="margin:0px 11px 0px 11px;">|</span><a

href="contact.html" class="cp_anchrtxt1"> Contacts</a><br /></td> </tr> </table>

</html>

Contacts.html:

<body>

<tr>

</td> </tr> <tr>

(18)

</td> </tr> </table>

<tr>

<td valign="top" width="698" style="padding-left:26px;"><p> </p> <p><h2>Email Supporting </h2>

<p>Use the form below to get in touch with us in connection with the travel related queries. </p>

<tr>

<td>email ID</td>

<tr>

<td>subject</td>

<option value="Delhi" selected="selected">Delhi</option> <option value="mumbai">mumbai</option> <option value="chennai">chennai</option> <option value="kolkata">kolkata</option> <option value="bangalore">bangalore</option> <option value="covai">covai</option><option value="singapure">singapure</option> <option value="muscat">muscat</option> </select></td> </tr>

(19)

<tr>

<td>location</td>

<option value="reservation" selected="selected">reservation</option> <option value="product and services">product and services</option> <option value="complients and compliments">complients and

compliments</option>

<option value="fares and tickets">fares and tickets</option> <option value="frequently flyer">frequently flyer</option> <option value="feedback">feedback</option> <option value="others">others</option> > </select></td> </tr> <tr> <td>Descrption</td>

</tr> </tbody> </table></td>

<tr>

</table>

<tr>

href="accounts.html" class="cp_anchrtxt1"> Accounts </a> <span style="margin:0px 11px 0px 11px;">|</span> <a href="booking.html" class="cp_anchrtxt1">Booking </a> <span style="margin:0px 11px 0px 11px;">|</span> <a href="specialoffer.html" class="cp_anchrtxt1"> Special Offers </a> <span style="margin:0px 11px 0px 11px;">|</span><a

(20)

</tr> </table>

</html>

(21)

RESULT:

(22)

CLIENT SIDE PROGRAMMING JAVASCRIPT FOR DISPLAYING DATE AND COMPARING TWO DATES

AIM:

To validate the student profile using javascript. ALGORITHM:

Step 1: start the program.

Step 2: Design a home page student profile using different html tags, forms and attributes.

Step 3: Using javascript, we validate whether the text and other text fields are empty or to be filled.

Step 4: Check whether the checkbox has been already checked or not. Step 5: Check whether the radio button has been already checked or not.

Step 6: Check whether the nick name is used as a password or not. Step 7: Validate the date of birth that should be in date format(dd-mm-yy) or not.

Step 8: Allow the age field size should be two and only be the numbers. Step 9: In the name field, ensure that it should allow only the capital letters.

Step 10: Check that the password field contains only the 8 characters. Step 11: Execute the program in Internet explorer.

(23)

PROGRAM: <html> <head>

<title>Compare Dates</title>

var mon1 = parseInt(str1.substring(3,5),10); var yr1 = parseInt(str1.substring(6,10),10); var dt2 = parseInt(str2.substring(0,2),10); var mon2 = parseInt(str2.substring(3,5),10); var yr2 = parseInt(str2.substring(6,10),10); var date1 = new Date(yr1, mon1, dt1); var date2 = new Date(yr2, mon2, dt2); if(date2 < date1)

{

alert("To date cannot be greater than from date"); return false; } else { alert("Submitting ..."); document.form1.submit(); } } </Script> </head>

<br>

<h1 align=center style={color:maroon}><u>Date Comparison</u></h1><br><br>

(24)

<input type="text" name="todate" id="todate" value=""><br><br><br> <input type="button" value="compare dates" onclick="CompareDates()"> </form> </center> </body> </html> Sample Output: RESULT:

Thus the program for Javascript for displaying date and comparing two Dates has been successfully compiled and executed..

(25)

FORM VALIDATION INCLUDING TEXTFIELD, RADIO BUTTONS, CHECKBOXES, LISTBOX AND OTHER CONTROLS

AIM:

To validate the student profile using javascript. ALGORITHM:

Step 1: start the program.

Step 2: Design a home page student profile using different html tags,forms and attributes.

Step 3: Using javascript, we validate whether the text and other text fields are empty or to be filled.

Step 4: Check whether the checkbox has been already checked or not. Step 5: Check whether the radio button has been already checked or not.

Step 6: Check whether the nick name is used as a password or not. Step 7: Validate the date of birth that should be in date format(dd-mm-yy) or not.

Step 8: Allow the age field size should be two and only be the numbers. Step 9:In the name field,ensure that it should allow only the capital letters.

Step 10:Check that the password field contains only the 8 characters. Step 11:Execute the program in Internet explorer.

(26)

PROGRAM : <html>

<head><title> from validation </title> function checkEmail (strng) {

var error=""; if (strng == "") {

error = "You didn't enter an email address.\n"; }

var emailFilter=/^.+@.+\..{2,3}$/; if (!(emailFilter.test(strng))) {

error = "Please enter a valid email address.\n"; }

else {

//test email for illegal characters

var illegalChars= /[\<\>\,\;\:\\\"\[\]]/ if (strng.match(illegalChars)) {

error = "The email address contains illegal characters.\n"; }

}

return error; }

// phone number - strip out delimiters and check for 10 digits function checkPhone (strng) {

var error = ""; if (strng == "") {

error = "You didn't enter a phone number.\n"; }

var stripped = strng.replace(/[\.\-\ ]/g, ''); //strip out acceptable non-numeric characters

if (isNaN(parseInt(stripped))) {

error = "The phone number contains illegal characters.";

}

if (!(stripped.length == 10)) {

error = "The phone number is the wrong length. Make sure you included an area code.\n";

}

return error; }

(27)

function checkPassword (strng) { var error = "";

if (strng == "") {

error = "You didn't enter a password.\n"; }

var illegalChars = /[\W_]/; // allow only letters and numbers

if ((strng.length < 6) || (strng.length > 8)) { error = "The password is the wrong length.\n"; }

else if (illegalChars.test(strng)) {

error = "The password contains illegal characters.\n"; }

else if (!((strng.search(/(a-z)+/)) && (strng.search(/(A-Z)+/)) && (strng.search(/(0-9)+/)))) {

error = "The password must contain at least one uppercase letter, one lowercase letter, and one numeral.\n";

}

return error; }

// username - 4-10 chars, uc, lc, and underscore only. function checkUsername (strng) {

var error = ""; if (strng == "") {

error = "You didn't enter a username.\n"; }

var illegalChars = /\W/; // allow letters, numbers, and underscores if ((strng.length < 4) || (strng.length > 10)) {

error = "The username is the wrong length.\n"; }

else if (illegalChars.test(strng)) {

error = "The username contains illegal characters.\n"; }

return error; }

(28)

function isEmpty(strng) { var error = "";

if (strng.length == 0) {

error = "The mandatory text area has not been filled in.\n" }

return error; }

// was textbox altered

function isDifferent(strng) { var error = "";

if (strng != "Can\'t touch this!") {

error = "You altered the inviolate text area.\n"; }

return error; }

// exactly one radio button is chosen function checkRadio(checkvalue) { var error = "";

if (!(checkvalue)) {

error = "Please check a radio button.\n"; }

return error; }

// valid selector from dropdown list function checkDropdown(choice) { var error = "";

if (choice == 0) {

error = "You didn't choose an option from the drop-down list.\n"; }

return error; }

</head> </html>

(29)

Sample output:

RESULT:

Thus the web page for student profile has been developed and validated successfully.

(30)

STUDENT INFORMATION SYTEM USING JSP AND SERVLET

AIM:

To develop the student webpage information using java servlet and JDBC.

ALGORITHM :

Start the program

Create main HTML page for student database maintenance Select option to do the following operation

Insertion, search ,delete and modify or update the student recode

Main.Html <html>

<label><h2>Student database maintenance</h2> </label> <TABLE> <TR><TD><a href="http://localhost:7001/student/register.html">REGISTER</a></TD></T R> <TR><TD><a href="http://localhost:7001/student/find3">SEARCH</a></TD></TR> <TR><TD><a href="http://localhost:7001/student/viewall">VIEW ALL </a></TD></TR> <TR><TD><a href="http://localhost:7001/student/delete2.html">DELETE</a></TD></TR>  </table> </div></body></html>

(31)

Register.HTML

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML>

<HEAD>

<TITLE> registration </TITLE> </HEAD>

Enter Id : <input type=text name="id" size=4 ><br> Enter Name : <input type=text name="name" size=20 ><br> Enter Age : <input type=text name="age" size=4 ><br>

Enter Branch: <input type=text name="branch" size=10 ><br> Enter Mark1 : <input type=text name="m1" size=4 ><br> Enter Mark2 : <input type=text name="m2" size=4 ><br> Enter Mark3 : <input type=text name="m3" size=4 ><br> Enter Grade : <input type=text name="grade" size=20 ><br>

Click : <input type="submit" name="submit" value=register> </pre></form></BODY></HTML>

Insert.Html

<HEAD>

<TITLE> registration </TITLE> </HEAD>

Enter Id : <input type=text name="id" size=4 ><br> Enter Name : <input type=text name="name" size=20 ><br> Enter Age : <input type=text name="age" size=4 ><br>

Enter Branch: <input type=text name="branch" size=10 ><br> Enter Mark1 : <input type=text name="m1" size=4 ><br> Enter Mark2 : <input type=text name="m2" size=4 ><br> Enter Mark3 : <input type=text name="m3" size=4 ><br> Enter Grade : <input type=text name="grade" size=4 ><br> <input type="submit" name="submit" value=register>

(32)

</div></pre></form></BODY></HTML> Delete.Html

<HEAD>

<TITLE> DELETE STUDENT RECORD </TITLE></HEAD> <BODY bgcolor=yellow text=cyan>

Enter the ID :<input type=text name="idno" size=4 ><br>

Click :<input type="submit" name=submit value=delete> </pre> </form> </BODY> </HTML> Second.java import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import java.lang.*;

public class second extends HttpServlet {

public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException

{

loginform(res,false); }//goGet()

private void loginform(HttpServletResponse res,boolean error)throws ServletException,IOException

{

res.setContentType("text/html"); PrintWriter pr=res.getWriter();

pr.println("<html><body bgcolor=blue text=red>"); pr.println("<div align=center>");

if(error) {

(33)

pr.println("<H2>LOGIN FAILED, PLEASE TRY AGAIN!!!</H2>");

}

pr.println("<form method=post NAME=FORM>");

pr.println("<table><TR><TD><label> please enter your name and password</label></TR></TD>");

pr.println("<TR><TD>Username:<input type=text name=username> ");

pr.println("<TR><TD>Password:<input type=password name=password><br></TR></TD><hr width=100%></TR></TD>");

pr.println("<TR><TD>Press:<input type=submit name=submit value=Continue></TR></TD>");

pr.println("<TR><TD>clear:<input type=reset name =reset value=Clear></TR></TD></TABLE>");

pr.println("</form></div></body></html>"); }//loginform()

public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException { String name=req.getParameter("username"); String pass=req.getParameter("password"); if(logindb(name,pass)) { RequestDispatcher rd=req.getRequestDispatcher("/main.html"); rd.forward(req,res); } else { loginform(res,true); } }//doPost()

boolean logindb(String name, String pass) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:logindb"); Statement s=con.createStatement();

String sql="select * from stu where username= '" + name + "' AND password= '" + pass + "' ";

(34)

ResultSet rs=s.executeQuery(sql); if(rs.next()) { return true; } con.close(); } catch(SQLException s) { s.printStackTrace(); } catch(Exception e) { e.printStackTrace(); } return false; }//login() }; Register1.java

/* INSERTING THE DATA */ import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*; import java.sql.*; import java.lang.*;

public class register1 extends HttpServlet {

public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException

{ try { res.setContentType("Text/html"); PrintWriter pr=res.getWriter(); int id=Integer.parseInt(req.getParameter("id")); String name=req.getParameter("name"); int age=Integer.parseInt(req.getParameter("age")); String branch=req.getParameter("branch"); int m1=Integer.parseInt(req.getParameter("m1"));

(35)

int m2=Integer.parseInt(req.getParameter("m2")); int m3=Integer.parseInt(req.getParameter("m3")); String grade=req.getParameter("grade");

pr.println("<html><body bgcolor=yellow text=red><div align=center>");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:ss"); //pr.println("student information are successfully registered"); //pr.println("<a

href=http://localhost:7001/student/main.html>goto main page</a>"); PreparedStatement pst=con.prepareStatement("Insert into studata values(?,?,?,?,?,?,?,?) "); pst.setInt(1,id); pst.setString(2,name); pst.setInt(3,age); pst.setString(4,branch); pst.setInt(5,m1); pst.setInt(6,m2); pst.setInt(7,m3); pst.setString(8,grade); pst.executeQuery();

pr.println("student information are successfully registered"); pr.println("<a

href=http://localhost:7001/student/main.html>goto main page</a>"); pr.println("</html></body>"); con.commit(); } catch(SQLException e) { System.out.println(e.getMessage()); } catch(Exception e) { e.printStackTrace(); } } };

(36)

Insert.java import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*; import java.sql.*; import java.lang.*;

public class register extends HttpServlet {

{ try { res.setContentType("Text/html"); PrintWriter pr=res.getWriter(); int id=Integer.parseInt(req.getParameter("id")); String name=req.getParameter("name"); int age=Integer.parseInt(req.getParameter("age")); String branch=req.getParameter("branch"); int m1=Integer.parseInt(req.getParameter("m1")); int m2=Integer.parseInt(req.getParameter("m2")); int m3=Integer.parseInt(req.getParameter("m3")); String grade=req.getParameter("grade");

pr.println("<html><body bgcolor=yellow text=red><div align=center>");

Connection con=DriverManager.getConnection("jdbc:odbc:ss"); // pr.println("Get connection");

PreparedStatement pst=con.prepareStatement("Insert into studata values(?,?,?,?,?,?,?,?) "); pst.setInt(1,id); pst.setString(2,name); pst.setInt(3,age); pst.setString(4,branch); pst.setInt(5,m1); pst.setInt(6,m2); pst.setInt(7,m3); pst.setString(8,grade); pst.executeQuery();

(37)

con.commit();

pr.println("student information are successfully registered"); pr.println("<a

href=http://localhost:7001/student/main.html>goto main page</a>"); pr.println("</html></body>"); con.close(); } catch(SQLException e) { System.out.println(e.getMessage()); } catch(Exception e) { e.printStackTrace(); } } }; Find3.Java

/* SEARCH THE PARTICULAR RECORD */ import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*; import java.sql.*; import java.lang.*;

public class find3 extends HttpServlet {

public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException

{

res.setContentType("Text/html"); PrintWriter pr=res.getWriter();

pr.println("<html><body bgcolor=black text=green><div align=center>");

pr.println("<form action=http://localhost:7001/student/find3 method=post name=form1>");

pr.println("<h4>Enter the student ID:</h4><input type=text name=id >");

(38)

pr.println("<h4>click:</h4><input type=submit name=submit value=search>");

pr.println("</form></div></body></html>"); }

{ try { res.setContentType("Text/html"); PrintWriter pr=res.getWriter(); String id =req.getParameter("id"); int idno=Integer.parseInt(id);

pr.println("<html><body bgcolor=black text=green><div align=center>");

Connection con=DriverManager.getConnection("jdbc:odbc:ss"); //PreparedStatement pst=con.prepareStatement("select * from studata where ID= '" + idno + "' ");

PreparedStatement pst=con.prepareStatement("select * from studata where ID= ? "); pst.setInt(1,idno); ResultSet r=pst.executeQuery(); while(r.next()) { pr.println(r.getInt(1)+"\t"+r.getString(2)+"\t"+r.getInt(3)+"\t"+r.getSt ring(4)+"\t"+r.getInt(5)+"\t"+r.getInt(6)+"\t"+r.getInt(7)+"\t"+r.getString(8) ); pr.println("<br>"); }

pr.println("<a href=http://localhost:7001/student/main.html>goto main page</a>"); pr.println("</html></body>"); } catch(SQLException e) { System.out.println(e.getMessage()); } catch(Exception e) { e.printStackTrace();

(39)

} } }; Delete2.java import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*; import java.sql.*; import java.lang.*;

public class delete2 extends HttpServlet {

{ try {

res.setContentType("Text/html"); PrintWriter pr=res.getWriter();

pr.println("<html><body bgcolor=black text=yellow>"); String idno=req.getParameter("idno");

int id=Integer.parseInt(idno);

Connection con=DriverManager.getConnection("jdbc:odbc:ss"); pr.println("get connected");

//PreparedStatement pst=con.prepareStatement("Delete from studata where ID= '" + id + "' ");

PreparedStatement pst=con.prepareStatement("Delete from studata where ID= ? ");

pst.setInt(1,id); pst.executeUpdate();

pr.println("<h2>student record is successfully deleted");

pr.println("<a href=http://localhost:7001/student/main.html>goto main page</a>"); pr.println("</html></body>"); con.commit(); } catch(SQLException e) { System.out.println(e.getMessage());

(40)

} catch(Exception e) { e.printStackTrace(); } } }; Output: Studenttable.

(41)

(42)

RESULT :

Thus student information java script program is successfully completed.

(43)

SERVLET PROGRAM USING HTTP SERVLET AIM:

To create a servlet program and check the script validation. ALGORITHM:

Step 1: Start the program.

Step 2: Get the context text at Servlet at text html.

Step 3: Get the response from the user by entering the username field. Step 4: Get the response from the user by entering the password field. Step 5: If the username and password are correct, then the user is authenticated and can enter into web page.

Step 6: Execute the program in Internet Explorer. Stepe 7: Stop the program.

(44)

PROGRAM HTML Code : <HTMl> <HEAD><CENTER> </CENTER></HEAD> <CENTER> <body bgcolor="green">

<form action="http://localhost:7001/parthi_servlet/servlet1" method="get"> <h1>USERNAME AND PASSWORD></h1>

<TD>USERNAME<INPUT TYPE="TEXT" name="username"></TD></TR> <TR>

<TD> PASSWORD<INPUT TYPE="password" name="password"></TD></TR>

<TR>

</TABLE></CENTER> </form>

</body> </HTML>

Java Servlet Code : import java.io.*;

import javax.servlet.*; import javax.servlet.http.*;

public class servlet1 extends HttpServlet {

public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException { res.setContentType("text/html"); PrintWriter pw=res.getWriter(); String admin=req.getParameter("username"); String pass=req.getParameter("password"); pw.println(admin); pw.println(pass);

(45)

if((admin.equals("admin2010")) && (pass.equals("abc123"))) { pw.println("Authorized user"); } else {

pw.println("not an Authorized user"); }

} }

(46)

Sample output:

RESULT:

Thus the servlet program has been created and validated successfully.

(47)

IMPLEMENTATION OF JAVA DATABASE CONNECTIVITY(JDBC) AIM:

To connect the database using jdbc connectivity in java.

ALGORITHM:

Step 1:Start the program.

Step2 :Write the source code for connectivity. Step 3:Using MS-Access, save the database.

Step 4:connect the database using ODBC Source connection.

Step 5: Add the database name in ODBC data source administrator. Step 6:Add the table name to connection.

Step 7:Compile the program and execute it. Step 8:Stop the program.

(48)

PROGRAM import java.sql.*; import java.io.*; public class jdbcdemo {

public static void main(String args[]) { Connection c= null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); c=DriverManager.getConnection("jdbc:odbc:jdbcdemodb"); Statement stmt=c.createStatement();

ResultSet rs=stmt.executeQuery("select * from Employee"); System.out.println("name and password are");

while(rs.next()) { System.out.println(rs.getString(1)+"\t"+rs.getInt(2)+"\t"+rs.getDouble(3)); } c.close(); } catch(SQLException e1) { e1.printStackTrace(); } catch(Exception e) { System.out.println("error"+e.getMessage()); } } }

(49)

Sample output:

RESULT:

Thus the implementation of Java Database connectivity has been executed successfully.

(50)

IMPLEMENTATION OF SERVLET - JDBC DEMO PROGRAM

AIM:

To create a servlet with JDBC connectivity in java.

ALGORITHM:

Step 1:Start the program.

Step 2:Get the context text at Servlet at text html.

Step 3:Get the response from the user by entering the username field. Step 4: Get the response from the user by entering the password field. Step 5:If the username and password are correct, then the user is authenticated

and can enter into web page.

Step 6:Execute the program in Internet Explorer. Step 7 :Write the source code for connectivity. Step 8:Using MS-Access, save the database.

Step 9:connect the database using ODBC Source connection.

Step 10: Add the database name in ODBC data source administrator. Step 11:Add the table name to connection.

Step 12:Compile the program and execute it. Step 13 :Stop the program.

(51)

PROGRAM

import javax.servlet.*; import java.io.*;

import java.sql.*;

public class servletdemojdbc implements Servlet {

public void init(ServletConfig c) throws ServletException {

//super.init(c);

System.out.println("joint method"); }

public void service(ServletRequest req,ServletResponse res)throws ServletException,IOException { Connection c= null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); c=DriverManager.getConnection("jdbc:odbc:jdbcdemo"); Statement stmt=c.createStatement();

ResultSet rs=stmt.executeQuery("select * from Employee"); System.out.println("name and password are");

while(rs.next()) { System.out.println(rs.getString(1)+"\t"+rs.getInt(2)+"\t"+rs.getDouble(3)); } c.close(); } catch(SQLException e1) { e1.printStackTrace(); } catch(Exception e) { System.out.println("error"+e.getMessage()); } System.out.println("exec "); }

public String getServletInfo() {

(52)

String program="c";

System.out.println(author+"wrote"+program); return null;

}

public ServletConfig getServletConfig() {

return null; }

public void destroy() {

} }

(53)

Sample output:

RESULT:

Thus the program for database connectivity using jdbc has been created and executed successfully

(54)

SAMPLE WEB APPLICATION DEVELOPMENT IN THE OPEN SOURCE ENVIRONMENT WITH DATABASE ACCESS.

AIM:

To create Sample web application development in the open source environment.

ALGORITHM :

Step1: start the program

Step2: Inside the asp definiton tag include the html contents

Step3: include the code for the database connectivity using the ado object Step4: select all the datas form the student table

Step5: Traverse all the tuples in the table Step6: Print the datas

Step7: close the connection Step8: stop the program

(55)

Programs: access.asp file: <% Option Explicit %> <html> <% DIM name set con=Server.CreateObject("ADODB.Connection"> con.open "dsn=cse;" set rs=Server.Createobject("ADODB.RecordSet")

set rs=con.Execute("select * from student where name="&name&")%> <table border="," width="50"%>

<% while NOT rs.EOF %> <tr><% for t=0 to 6 %>

<% Move Next wend %></table> <%con.close%>

</html>

stuaccess.html file: <html>

Name<input type="text" name="Name"><br><br> <input type="submit">

(56)

Sample Output:

RESULT :

Thus the Sample web application development in the open source environment has been executed successfully executed.

(57)

CREATION OF XML DOCUMENT FOR A SPECIFIC DOMAIN.

AIM:

To creation of XML document for a specific domain

ALGORITHM:

Step1:start the program

Step2:using Onclick(),validate the student details as entered. Step3:In XML file,we use styles for structure the program as #PCDATA(datafield)

Step4:Using various HTML tags and attribute,we design the web page. Step5:Using various XML attribute list and entity list to retrieve the information of student.

Step6:Using processing instructions which we required to describe the data.

Step7:Using “note.xml”as xmlid to connect with html file.Execute the program.

(58)

Program Student.html: <HTML> <HEAD> <SCRIPT> function prev_onclick() { std.previousPage() } function next_onclick() { std.nextPage() } </SCRIPT> </HEAD> <BODY> <xml id="note" src="note.xml"></xml>

<table id="std" dataSrc="#note" datapagesize="1" border="1"> <thead> <tr><th>REGNO</th><th>NAME</th><th>COURSE</th><TH>SEM</th></ tr> </thead> <tbody> <tr><td><span datafld="REGNO"></span></td> <td><span datafld="NAME"></span></td> <td><span datafld="COURSE"></span></td> <td><span datafld="SEM"></span></td> </tr> </tbody> </table>

<INPUT TYPE="BUTTON" VALUE="NEXT" ONCLICK="next_onclick()"> <INPUT TYPE="BUTTON" VALUE="PREVIOUS"

ONCLICK="prev_onclick()"> </BODY>

</HTML> note.xml:

(59)

<note> <STUDENT> <REGNO>VMP49</REGNO> <NAME>THANUJA.O</NAME> <COURSE>M.E CSE</COURSE> <SEM>II</SEM> </STUDENT> <STUDENT> <REGNO>VMP52</REGNO> <NAME>TAMILARASI</NAME> <COURSE>M.E CSE</COURSE> <SEM>II</SEM> </STUDENT> </note> Sample Output : RESULT :

(60)

WRITING DTD OR XML SCHEMA FOR THE DOMAIN SPECIFIC XML DOCUMENT

AIM:

To write a program for DTD and XML schema for the domain specific XML document.

ALGORITHM:

Step1:start the program

Step2:open an XML file as Letter.xml, to create detail of person using various xml attribute list

Step3:using user defined tags, we can create details of person using name, pincode, address, ph.no, etc..

Step4:open DTD file as letter . dtd

Step5:using an external and internaldtd,we create elementlist as #PCDATA for retrieve the datafield

Step6:using attribute declaration ,use to retrieve the datafield as more than one time

(61)

Program: Letter.xml: <?xml version="1.0"?> <letter> <contact type="sender"> <name>aaaa</name> <address>dfdsgdsgdsfvg</address> <city>chennai</city> <state>tamilnadu</state> <zip>600089</zip> <phone>044-23456789</phone> <flag gender="F"/> </contact> <contact type="receiver"> <name>bbbb</name> <address1>dfdsgdsgdsfvg</address1> <address2>fvgefgffdg</address2> <city>chennai</city> <state>tamilnadu</state> <zip>600089</zip> <phone>044-23456789</phone> <flag gender="F"/> </contact>

<paragraph>It is our privillege ...</paragraph> <closing>Sincerely</closing>

<signature>Ms.aaaaa</signature> </letter>

(62)

Letter.dtd:

<!element letter(contact+, salutation, paragraph+, closing, signature)> <element contact(name, address1, address2, city, state, zip, phone, flag)> <!attlist contacttype CDATA #implied>

<!element address1(#PCDATA)> <!element address2(#PCDATA)> <!element city(#PCDATA)> <!element state(#PCDATA)> <!element zip(#PCDATA)> <!element phone(#PCDATA)> <!element flag EMPTY>

<!attlist flag gender(M/F)"M"> <!element salutation(#pcdata)> <!element closing (#pcdata)> <!element paragraph (#pcdata)> <!element signature (#pcdata)>

(63)

Output:

RESULT:

Thus the program for writing DTD or XML schema for the domain specific XML document has been successfully completed.

(64)

PARSING AN XML DOCUMENT USING DOM AND SAX PARSERS.

AIM:

To Parsing an XML document using DOM and SAX Parsers.

ALGORITHM : Using Dom:

Step1: Get a document builder using document builder factory and parse the xml file to create a DOM object

Step 2: Get a list of employee elements from the DOM

Step3: For each employee element get the id, name, age and type. Create an employee value object and add it to the list.

Step4: At the end iterate through the list and print the employees to verify we parsed it right.

Using Sax

Step1: Create a Sax parser and parse the xml

Step2: In the event handler create the employee object Step3 : Print out the data