Develop Static Pages (Using Only HTML) of An Online Book Store. Should Consist The Following Pages

1
1.
AIM:
The pages should resemble :www.amazon.com. The website should consist the following pages.
Develop static pages (using only HTML) of an online Book store.
Home page Registration and user Login User profile page Books catalog Shopping cart Payment by credit cardOrder Conformation
PROCEDURE: Home page

Main.html:
<html> <head> <title> Amazon</title> </head> <body bgcolor="cyan"> <center> <strong><h1>Welcome to AMAZON</h1></strong> <form method="post" action="login.html" target=_blank > <h4>for books</h4><input type="submit" value="click here"> </form> </center> </body> </html>
HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT
Registration and user Login

Login.html:
<html> <head> <title> login page</title> </head> <body bgcolor="cyan"> <center> <strong><h1> AMAZON </h1></strong></center> <right> <table align="right"> <tr> <td><h4>user name</td> <td><input type="text" ></td> <td></td> </tr> <tr> <td><h4>password</td> <td><input type="password"></td> <td></td> </tr> <tr> <td> <form method="post" action="catalog.html" > <input type="submit" value="submit" > </form> </td> <td> <form method="post" action="userpro.html" > <input type="submit" value="register" >    <input type="reset" value="reset"></form></td> </tr> </table> </body> </html>
User profile page

Userpro.html:
<html> <head> <title> login page</title> </head> <body bgcolor="cyan"> <center><strong><h1> AMAZON </h1></strong></center> <form method="post" action="catalog.html" > <right> <table align="left"> <tr> <td><h4>user name</td> <td><input type="text" ></td> <tr> <tr> <td><h4>password</td> <td><input type="password"></td> </tr> <tr> <td><h4>confirm password</td> <td><input type="password"></td> </tr> <tr> <td><h4>male    <option > <input type="radio" name="sex" id="male"></td> <td><h4>female <input type="radio" name="sex" id="female" ></td> </option> </tr> <tr> <td>Address</td> <td><textarea name="address" rows=5 cols=19> </textarea> </td> <tr> <td> <input type="submit" value="submit" ></td> <td> <input type="reset" value="reset"></td> </tr></form></body></html>
Books catalog
Catalog.html:
<html> <head> <title> books catalog</title> </head> <body bgcolor="cyan"> <center><h1>AMAZON</h1></center> <form method="post" action="shopping.html"> <left> <table> <tr> <td><b><h3>frontend books</td> <td></td></tr> <tr> <td></td> <td><h4>C&Ds</td> </tr> <tr> <td></td> <td><h4>Ads</td> </tr> <tr> <td></td> <td><h4>JAVA </td></tr> <tr> <td><b><h3>backend books</td> <td></td> </tr> <tr> <td></td> <td><h4>Oracle</td> </tr> <tr> <td></td> <td><h4>Ms SQL Server </td></tr> <tr> <td></td> <td><h4>MySql </td> </tr> </table>
</h4> <center> <b>for buy one of these books <br> </b><input type="submit" value="click here"> </center> </form> </body> </html>
Shopping cart
Shopping.html:
<html> <head><title>shopping cart</title> </head> <body bgcolor="cyan"> <center><h1> Shopping Cart</h1></center> <br><br><br><br><br> <table align="center"> <tr> <td>Text Books</td> <td> <select > <optgroup label="select the book"> <option value="C&Ds">C&Ds <option value="Ads">Ads <option value="Java">Java <option value="Oracle">Oracle <option value="Ms SQL Server">Ms SQL Server <option value="MySql">MySql </optgroup> </select> </td></tr> <tr> <td> Quantity</td> <td> <input type="text" id="q"> </td></tr> <tr> <td></td> <td> <form method=post action="payment.html"> <input type="submit" value=ok /> </form> </td></tr> </table> <center> <pre>Cost of one book is"500" + shipping "100"</pre> </center> <body> </html>
Payment by credit card

Payment.html:
<html> <head><title>payment</title></head> <body bgcolor="cyan"> <center><h1>Payment By Credit Card</h1></center> <form method=post action="ordrconform.html"> <br><br><br><br><br> <table align="center"> <tr> <td> <h4>Total Amount</h4></td> <td><input type="text"> </td> </tr> <tr> <td><h4>Credit Card Number</td> <td><input type="text"></td> </tr> <tr> <td> </td> <td><input type="submit" value=OK> </td> </tr> </table> </form></body> </html>
Order Conformation
Ordrconform:
<html> <head><title>order conformation</title><M/head> <body bgcolor="cyan"> <center> <h1><b>AMAZON</h1> <pre><strong> <b>Your order Is Conformed </strong></pre> <h2><b>THANK YOU</h2> </center> </body></html>
Result:
Home page:
Registration and user Login:
10
User profile page:
11
Books catalog:
12
Shopping cart:
13
Payment by credit card:
14
Order Conformation:
15
2. AIM:
Validate the Registration, user login, user profile and payment by
credit card pages using JavaScript. PROCEDURE:
Home page:
Main.html:
<frameset rows=25%, 75 %> <frame src=top.html name=top> <frameset cols=25%,75%> <frame src=left.html name=left> <frame src=right.html name=right> </frameset> </frameset>
Top.html:
<html> <body bgcolor=pink> <br><br> <marquee><h1 align=center><b><u>ONLINE BOOK STORAGE</u></b></h1></marquee> </body> </html>
Right.html:
<html> <body bgcolor=pink> <br><br><br><br><br> <h2 align=center> <b><p> welcome to online book storage. Press login if you are having id otherwise press registration. </p></b></h2> </body> </html>
16
Left.html:
<html> <body bgcolor=pink> <h3> <ul> <li><a href=login.html target=right><font color=black> LOGIN</font></a></li><br><br> <li><a href=profile.html target=right><fontcolor=black> USER PROFILE</font></a></li><br><br> <li><a href=catalog.html target=right><fontcolor=black> BOOKS CATALOG</font></a></li><br><br> <li><a href=scart.html target=right><font color=black> SHOPPINGCART</font></a></li><br><br> <li><a href=payment.html target=right><fontcolor=black> PAYMENT</font></a></li><br><br> <li><a href=order.html target=right><font color=black> ORDER CONFIRMATION</font></a></li><br><br> </ul> </body> </html>
17

Login.html:
<html> <body bgcolor="pink"><br><br><br> <script language="javascript"> function validate() { var flag=1; if(document.myform.id.value==""|| document.myform.pwd.value=="") { flag=0; } if(flag==1) { alert("VALID INPUT"); } else { alert("INVALID INPUT"); document.myform.focus(); } } </script> <form name="myform"> <div align="center"><pre> LOGIN ID :<input type="text" name="id"><br> PASSWORD:<input type="password" name="pwd"></pre><br><br> </div> <br><br> <div align="center"> <input type="submit" value="ok" onClick="validate()">     <input type="reset" value="clear" > </form> </body> </html>
18
User profile page

Profile.html:
<html> <body bgcolor=pink><br><br> <script language=javascript> function validate() { var flag=1; if(document.myform.name.value==|| document.myform.addr.value==|| document.myform.phno.value==|| document.myform.id.value==|| document.myform.pwd.value==) { flag=0; } var str=document.myform.phno.value; var x; for(var i=0;i<str.length;i++) { x=str.substr(i,1) if(!(x<=9)) { flag=0; break; } } if(flag==1) { alert("VALID INPUT"); } else { alert("INVALID INPUT"); document.myform.focus(); } } </script> <form name="myform"> <div align="center"><pre> NAME :<input type="text" name="name"><br> ADDRESS :<input type="type" name="addr"><br> CONTACT NUMBER:<iput type="text" name="phno"><br> LOGINID :<input type="text" name="id"><br>
19
PASSWORD :<input type="password" name="pwd"></pre><br><br> </div> <br><br> <div align="center"> <input type="submit" value="ok" onClick="validate()">    <input type="reset" value="clear"> </form></body></html>
20
Books catalog:
Scart.html:
<html> <body bgcolor="pink"><br><br><br> <script language="javascript"> function validate() { var flag=1; if(document.myform.title.value=="") { flag=0; } str=document.myform.title.value; if(str=="c") { document.writeln("<body bgcolor=pink>"); document.writeln("title-->c"+" cost-->444"); } else if(str=="jsp") { document.writeln("<body bgcolor=pink>"); document.writeln("title-->jsp"+" cost-->555"); } else { flag=0; } if(flag==1) { alert("VALID INPUT"); } else { alert("INVALID INPUT"); document.myform.focus(); } } </script> <form name="myform" > <div align="center"><pre> BOOK TITLE :<input type="text" name="title"><br>
21
</pre><br><br> </div> <br><br> <div align="center"> <input type="submit" value="ok" onClick="validate()">     <input type="reset" value="clear"> </form> </body> </html>
22
Shopping cart: Catalog.html:

<html> <body bgcolor="pink"><br><br><br> <script language="javascript"> function validate() { var flag=1; if(document.myform.id.value==""|| document.myform.title.value==""|| document.myform.no.value==""|| document.myform.cost.value==""|| document.myform.date.value=="") { flag=0; } var str=document.myform.no.value; var x; for(var i=0;i<str.length;i++) { x=str.substr(i,1) if(!(x<=9)) { flag=0; break; } } str=document.myform.title.value; var str1=document.myform.cost.value; if(!((str=="c"&& str1==444) || (str=="jsp" && str1==555))) { flag=0; } if(flag==1) { alert("VALID INPUT"); } else { alert("INVALID INPUT"); document.myform.focus(); } } </script>
23
<form name="myform" > <div align="center"><pre> LOGIN ID :<input type="text" name="id"><br> TITLE :<input type="text" name="title"><br> NO.OF BOOKS :<input type="text" name="no"><br> COST OF BOOK :<input type="text"name="cost"><br> DATE :<input type="text" name="date"><br></pre><br><br> </div> <br><br> <div align="center"> <input type="submit" value="ok" onClick="validate()">      <input type="reset" value="clear"> </form> </body> </html>
24

Payment.html:
<html> <body bgcolor="pink"><br><br><br> <script language="javascript"> function validate() { var flag=1; if(document.myform.id.value==""|| document.myform.pwd.value==""|| document.myform.amount.value==""|| document.myform.num.value=="") { flag=0; } var str=document.myform.amount.value; var x; for(var i=0;i<str.length;i++) { x=str.substr(i,1); if(!(x<=9)) { flag=0; break; } } str=document.myform.num.value; for(var i=0;i<str.lenght;i++) { x=str.substr(i,1); if(!(x<=9)) { flag=0; break; } } if(flag==1) { alert("VALID INPUT"); } else { alert("INVALID INPUT"); document.myform.focus();
25
} } </script> <form name="myform"> <div align="center"><pre> LOGIN ID :<input type="text" name="id"><br> PASSWORD :<input type="password" name="pwd"><br> AMOUNT :<input type="text" name="amount"><br> CREDITCARDNUMBER:<input type="PASSWORD" name="num+"><br></pre><br><br> </div> <br><br> <div align="center"> <input type="submit" value="ok" onClick="validate()">     <input type="reset" value="clear" > </form> </body> </html>
Order Conformation
Order.html:
<html> <head><title>order conformation</title><M/head> <body bgcolor="cyan"> <center> <h1><b>AMAZON</h1> <pre><strong> <b>Your order Is Conformed </strong></pre> <h2><b>THANK YOU</h2> </center> </body></html>
26
Result: Home page
27
28
User profile page
29
Books catalog
30
Shopping cart
31
32
Order Conformation
33
3. AIM:
Create and Save an XML document at the server, which contains 10 users information. Write program, which takes user ID as input and returns the user details by taking the user information from XML Document.
Procedure:
Login Page:
Login.html:
<html> <head> <script type="text/javascript"> function ser() { var xmldoc=new ActiveXObject("Microsoft.XMLDOM"); xmldoc.load("users.xml"); var id=f1.id.value; var pass=f1.pass.value; var x=xmldoc.getElementsByTagName("userid"); var y=xmldoc.getElementsByTagName("password"); for(i=0;i<x.length;i++) { if(x[i].childNodes[0].nodeValue==id) { if(y[i].childNodes[0].nodeValue==pass) { alert("successfull logged"); var ob=window.open("userinfo.html","_blank"); ob.document.f1.uid.value=x[i].childNodes[0].nodeValue; xmldoc.load("userinfo.xml"); var x0=xmldoc.getElementsByTagName("userid"); var x1=xmldoc.getElementsByTagName("username"); var x2=xmldoc.getElementsByTagName("qualification"); var x3=xmldoc.getElementsByTagName("job"); var x4=xmldoc.getElementsByTagName("companyname"); var x5=xmldoc.getElementsByTagName("dob"); var x6=xmldoc.getElementsByTagName("street"); var x7=xmldoc.getElementsByTagName("city"); for(var j=0;j<x0.length;j++) {
34
if(x0[j].childNodes[0].nodeValue==id) { ob.document.f1.uname.value=x1[j].childNodes[0].nodeValue; ob.document.f1.qual.value=x2[j].childNodes[0].nodeValue; ob.document.f1.jn.value=x3[j].childNodes[0].nodeValue; ob.document.f1.cn.value=x4[j].childNodes[0].nodeValue; ob.document.f1.dob.value=x5[j].childNodes[0].nodeValue; ob.document.f1.address.value=x6[j].childNo des[0].nodeValue+","+x7[j].childNodes[0].nodeValue; } } } else alert("incorrect password"); return; } } alert("incorrect userid") ; } </script> </head> <body> <form name="f1"> <center> <h1>Login Form</h1> <br><B>User Id:   <input type="text" name="id"> <br><br>Password:</B><input type ="password" name="pass"> <br><br> <input type="button" value="submit" onClick="ser()"> </center> </form> </body> </html>
35
User information page:

Userinfo.html:
<html> <head> <title>User Info</title> </head> <body> <center> <h1>User Information</h1> <form name="f1"> <pre> <B> User Id: <input type="text" name="uid" onblur="fun()"> User Name: <input type="text" name="uname"> Qualification: <input type="text" name="qual"> Job: <input type="text" name="jn"> Company: <input type="text" name="cn"> Date Of Birth: <input type="text" name="dob"> Address: <textarea name="address" rows=5 cols=19> </textarea> </B> </pre> </form> </center> </body> </html>
36
Users xml pages:
Users.xml:
<?xml version="1.0" encoding="UTF-8"?> <users> <user> <userid>1</userid> <password>a</password> </user> <user> <userid>2</userid> <password>b</password> </user> <user> <userid>3</userid> <password>c</password> </user> <user> <userid>4</userid> <password>d</password> </user> <user> <userid>5</userid> <password>e</password> </user> <user> <userid>6</userid> <password>f</password> </user> </users>
37
Userinfo.xml:
<?xml version="1.0" encoding="UTF-8"?> <userinfo> <user> <userid>1</userid> <username>abc</username> <qualification>def</qualification> <job>ghi</job> <companyname>jkl</companyname> <dob>may06,88</dob> <address> <street>mno</street> <city>pqr</city> </address> </user> <user> <userid>2</userid> <username>def</username> <qualification>ghi</qualification> <job>jkl</job> <companyname>mno</companyname> <dob>june24,88</dob> <address> <street>pqr</street> <city>stu</city> </address> </user> <user> <userid>3</userid> <username>ghi</username> <qualification>jkl</qualification> <job>mno</job> <companyname>pqr</companyname> <dob>may07,86</dob> <address> <street>stu</street> <city>vwx</city> </address> </user> <user> <userid>4</userid> <username>jkl</username> <qualification>mno</qualification> <job>pqr</job> <companyname>stu</companyname>
38
<dob>sep6,88</dob> <address> <street>vwx</street> <city>yz</city> </address> </user> <user> <userid>5</userid> <username>mno</username> <qualification>pqr</qualification> <job>stu</job> <companyname>vwx</companyname> <dob>aug23,87</dob> <address> <street>yz</street> <city>abc</city> </address> </user> <user> <userid>6</userid> <username>pqr</username> <qualification>stu</qualification> <job>vwx</job> <companyname>yz</companyname> <dob>oct22,88</dob> <address> <street>abc</street> <city>def</city> </address> </user> </userinfo>
39
Output: Login page:
40
User information page:
41
4. AIM: Install TOMCAT web server. Convert the static webpages of assignments 2 into dynamic webpages using servlets and cookies. Hint: Users information (user id, password, credit card number) would be stored in web.xml. Each user should have a separate Shopping Cart.
PROCEDURE:
First install the tomcat into the system. Then make a subdirectly(eg., tr) in the \tomcat\webapps. Under tr create WEB-INF directory and also place the html files in this tr directory only. Next under WEB-INF create two subclasses lib,classes and web.xml Next place all the class files under the classes and jar files(servlet-api.jar,classes12.jar etc) under lib subdirectories. After this start tomcat by giving the following command at the instll_dir>tomcat>bin Catalina.bat run At the I.E(web browser) give the url as http;//localhost:8080//tr/htmlfile or servlet url pattern Portno 8080 is assigned for the tomcat.
Home page:
Main.html:
<html> <body> <br /><br /><br /><br /><br /> <h1 align="center"><U>ONLINE BOOK STORAGE</U></h1><br /><br /><br /> <h2 align="center"><pre> <b>Welcome to online book storage. Press LOGIN if you are having id otherwise press REGISTRATION </b></pre></h2> <br /><br /><pre> <div align="center"><a href="login.html">LOGIN</a> <a href="reg.html"> REGISTRATION</a></div></pre> </body> </html>
42
Login page:
Login.html:
<html> <body><br /><br /><br /> <form name="myform" method="post" action="login"> <div align="center"><pre> LOGIN ID :<input type="text" name="id" /><br /> PASSWORD :<input type="password" name="pwd" /></pre><br /><br /> </div> <br /><br /> <div align="center"> <input type="submit" value="ok" onclick="validate()" />       <input type="reset" value="clear" /> </div> </form> </body> </html>
43
Registration page:
Reg.html:
<html> <body><br /><br /> <form name="myform" method="post" action="reg"> <table align="center" > <tr> <td>NAME</td> <td>:<input type="text" name="name" /></td> </tr> <tr> <td>ADDRESS</td> <td>:<input type="text" name="addr" /></td> </tr> <tr> <td>CONTACT NUMBER</td> <td>:<input type="text" name="phno" /></td> </tr> <tr> <td>LOGINID</td> <td>:<input type="text" name="id" /></td> </tr> <tr> <td>PASSWORD</td> <td>:<input type="password" name="pwd" /></td> </tr> </table> <br /><br /> <div align="center"> <input type="submit" value="ok" onclick="validate()" />       <input type="reset" value="clear" /> </div> </form> </body> </html>
User profile page:
44
Profile.html:
<html> <body><br /><br /><br /> <form name="myform" method="post" action="profile"> <div align="center"><pre> LOGIN ID :<input type="text" name="id" /><br /> </pre><br /><br /> </div> <br /><br /> <div align="center"> <input type="submit" value="ok" onclick="validate()" />       <input type="reset" value="clear" /> </div> </form> </body> </html>
Books catalog page:
Catalog.html:
<html> <body><br /><br /><br /> <form method="post" action="catalog"> <div align="center"><pre> BOOK TITLE :<input type="text" name="title" /><br /> </pre><br /><br /> </div> <br /><br /> <div align="center"> <input type="submit" value="ok" name="button1"/>       <input type="reset" value="clear" name="button2"/> </div> </form> </body> </html> Shopping cart, Payment by credit
card,
Order
Conformation page:
45
Order.html:
<html> <body><br /><br /> <form method="post" action="order"> <div align="center"><pre> ID :<input type="text" name="id" /><br /> PASSWORD :<input type="password" name="pwd" /><br/> TITLE :<input type="text" name="title" /><br /> NO. OF BOOKS :<input type="text" name="no" /><br /> DATE :<input type="text" name="date" /><br /> CREDIT CARD NUMBER :<input type="password" name="cno" /><br /></pre><br /><br /> </div> <br /><br /> <div align="center"> <input type="submit" value="ok" name="button1"/>       <input type="reset" value="clear" name="button2"/> </div> </form> </body> </html>
46
Login servlet:
Login.java:
import java.sql.*; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; public class login extends HttpServlet { public void service(HttpServletRequest req,HttpServletResponse resp) throws ServletException,IOException { PrintWriter pw=resp.getWriter(); pw.println("<html><body>"); String id=req.getParameter("id"); String pwd=req.getParameter("pwd"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:orcl","scott","tiger"); Statement stmt=con.createStatement(); String sqlstmt="select id,pwd from login"; ResultSet rs=stmt.executeQuery(sqlstmt); int flag=0; while(rs.next()) { if(id.equals(rs.getString(1))&&pwd.equals(rs.getString(2))) { flag=1; } } if(flag==0) { pw.println("<br><br>SORRY INVALID ID TRY AGAIN ID<br><br>"); pw.println("<a href=\"login.html\">press LOGIN to RETRY</a>"); } else { pw.println("<br><br>VALID LOGIN ID<br><br>"); pw.println("<h3><ul>");
47
pw.println("<li><a href=\"profile.html\"><fontcolor=\"black\">USER PROFILE</font> </a></li><br><br>"); pw.println("<li><a href=\"catalog.html\"><fontcolor=\"black\">BOOKS CATALOG</font></a></li><br><br>"); pw.println("<li><a href=\"order.html\"><fontcolor=\"black\">ORDER CONFIRMATION</font> </a></li></ul><br><br>"); } pw.println("</body></html>"); } catch(Exception e) { resp.sendError(500,e.toString()); } } }
48
Registration servlet:
Reg.java:
import java.sql.*; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; public class reg extends HttpServlet { public void service(HttpServletRequest req,HttpServletResponse resp) throws ServletException,IOException { PrintWriter pw=resp.getWriter(); resp.setContentType("text/html"); pw.println("<html><body>"); String name=req.getParameter("name"); String addr=req.getParameter("addr"); String phno=req.getParameter("phno"); String id1=req.getParameter("id"); String pwd1=req.getParameter("pwd"); int no=Integer.parseInt(phno); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:orcl","scott","tiger"); Statement stmt=con.createStatement(); String sqlstmt="select id,pwd from login"; ResultSet rs=stmt.executeQuery(sqlstmt); int flag=0; while(rs.next()) { if(id1.equals(rs.getString(1))&&pwd1.equals(rs.getString(2))) { flag=1; } } if(flag==1) { pw.println("<br><br>SORRY INVALID ID ALREADY EXITS TRY AGAIN WITH NEW ID<br><br>"); pw.println("<a href=\"reg.html\">press REGISTER to RETRY</a>");
49
} else { Statement stmt1=con.createStatement(); stmt1.executeUpdate("insert into login values('"+name+"','"+addr+"',"+no+",'"+id1+"','"+pwd1+"');" ); pw.println("<br><br>YOUR DETAILS ARE ENTERED<br><br>"); pw.println("<a href=\"login.html\">press LOGIN to login</a>"); } pw.println("</body></html>"); } catch(Exception e) { resp.sendError(500,e.toString()); } } }
50
Profile servlet:
Profile.java:
import java.sql.*; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; public class profile extends HttpServlet { public void service(HttpServletRequest req,HttpServletResponse resp) throws ServletException,IOException { PrintWriter pw=resp.getWriter(); pw.println("<html><body>"); String id=req.getParameter("id"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:orcl","scott","tiger"); Statement stmt=con.createStatement(); String sqlstmt="select * from login where id="+id+""; ResultSet rs=stmt.executeQuery(sqlstmt); int flag=0; pw.println("<br><br><br>"); while(rs.next()) { pw.println("<div align=\"center\">"); pw.println("NAME :"+rs.getString(1)+"<br>"); pw.println("ADDRESS :"+rs.getString(2)+"<br>"); pw.println("PHONE NO :"+rs.getString(3)+"<br>"); pw.println("</div>"); flag=1; } if(flag==0) { pw.println("<br><br>SORRY INVALID ID TRY AGAIN ID<br><br>"); pw.println("<a href=\"profile.html\">press HERE to RETRY</a>"); } pw.println("</body></html>"); } catch(Exception e) {
51
resp.sendError(500,e.toString()); } } }
52
Catalog servlet:
Catalog.java:
import java.sql.*; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; public class catalog extends HttpServlet { public void service(HttpServletRequest req,HttpServletResponse resp) throws ServletException,IOException { PrintWriter pw=resp.getWriter(); pw.println("<html><body>"); String title=req.getParameter("title"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:orcl","scott","tiger"); Statement stmt=con.createStatement(); String sqlstmt="select * from book where title=\'"+title+"\'"; ResultSet rs=stmt.executeQuery(sqlstmt); int flag=0; while(rs.next()) { pw.println("<div align=\"center\">"); pw.println("TITLE :"+rs.getString(1)+"<br>"); pw.println("AUTHOR :"+rs.getString(2)+"<br>"); pw.println("VERSION :"+rs.getString(3)+"<br>"); pw.println("PUBLISHER :"+rs.getString(4)+"<br>"); pw.println("COST :"+rs.getString(5)+"<br>"); pw.println("</div>"); flag=1; } if(flag==0) { pw.println("<br><br>SORRY INVALID TITLE TRY AGAIN <br><br>"); pw.println("<a href=\"catalog.html\">press HERE to RETRY</a>"); } pw.println("</body></html>"); } catch(Exception e)
53
{ resp.sendError(500,e.toString()); } } }
54
Order servlet:
Order.java:
import java.sql.*; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; public class order extends HttpServlet { public void service(HttpServletRequest req,HttpServletResponse resp) throws ServletException,IOException { int count; PrintWriter pw=resp.getWriter(); pw.println("<html><body>"); String id=req.getParameter("id"); String pwd=req.getParameter("pwd"); String title=req.getParameter("title"); String count1=req.getParameter("no"); String date=req.getParameter("date"); String cno=req.getParameter("cno"); try { count=Integer.parseInt(count1); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:orcl","scott","tiger"); Statement stmt=con.createStatement(); String sqlstmt="select id,pwd from login"; ResultSet rs=stmt.executeQuery(sqlstmt); int flag=0,amount,x; while(rs.next()) { if(id.equals(rs.getString(1))&&pwd.equals(rs.getString(2))) { flag=1; } } if(flag==0) { pw.println("<br><br>SORRY INVALID ID TRY AGAIN ID<br><br>"); pw.println("<a href= \" order.html \" >press HERE to RETRY</a>");
55
} else { Statement stmt2=con.createStatement(); String s="select cost from book where title=\'"+title+"\'"; ResultSet rs1=stmt2.executeQuery(s); int flag1=0; while(rs1.next()) { flag1=1; x=Integer.parseInt(rs1.getString(1)); amount=count*x; pw.println("<br><br>AMOUNT :"+amount+"<br><br><br><br>"); Statement stmt1=con.createStatement(); stmt1.executeUpdate("insert into details values('"+id+"','"+title+"',"+amount+",'"+cno+"');"); pw.println("<br>YOUR ORDER has taken<br>"); } if(flag1==0) { pw.println("<br><br><br>SORRY INVALID ID TRY AGAIN ID<br><br>"); pw.println("<a href=\"order.html\">press HERE to RETRY</a>"); } } pw.println("</body></html>"); con.close(); } catch(Exception e) { resp.sendError(500,e.toString()); } } }
Web.xml:
56
<?xml version="1.0"?> <web-app > <servlet> <servlet-name>login</servlet-name> <servlet-class>login</servlet-class> </servlet> <servlet> <servlet-name>reg</servlet-name> <servlet-class>reg</servlet-class> </servlet> <servlet> <servlet-name>profile</servlet-name> <servlet-class>profile</servlet-class> </servlet> <servlet> <servlet-name>order</servlet-name> <servlet-class>order</servlet-class> </servlet> <servlet> <servlet-name>catalog</servlet-name> <servlet-class>catalog</servlet-class> </servlet> <servlet-mapping> <servlet-name>login</servlet-name> <url-pattern>/login</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>reg</servlet-name> <url-pattern>/reg</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>profile</servlet-name> <url-pattern>/profile</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>order</servlet-name> <url-pattern>/order</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>catalog</servlet-name> <url-pattern>/catalog</url-pattern> </servlet-mapping> <welcome-file-list> <welcome-file>main.html</welcome-file> </welcome-file-list> </web-app>
Output:
57
Home page:
Login page:
58
Login servlet:
59
Registration page:
60
Reg servlet:
61
User profile page:
62
Profile servlet:
63
Books catalog page:
64
Catalog servlet:
65
Shopping cart, Payment Conformation page:
by
credit
card,
Order
66
Order servlet:
67
5. AIM:
Redo the previous task using JSP by converting the static web pages of assignments 2 into dynamic web pages. Create a database with user
68
information and books information and books information. The books catalogue should be dynamically loaded from the database. Follow the MVC architecture while doing the website.
PROCEDURE:
1) 2) 3) 4) Create your own directory under tomcat/webapps (e.g. tr1) Copy the html files in tr1 Copy the jsp files also into tr1 Start tomcat give the following command Catalina.bat run At install-dir/bin 5) at I.E give url as http://localhost:8081/tr1/main.html
Home page:
Main.html:
<html> <body> <br><br><br><br><br><br> <h1 align="center"><u>ONLINE BOOK STORAGE</u></h1><br><br><br> <h2 align="center"><PRE> <b> Welcome to online book storage. Press LOGIN if you are having id Otherwise press REGISTRATION </b></PRE></h2> <br><br><pre> <div align="center"><a href="login.html">LOGIN</a> <a href="reg.html">REGISTRATION</a></div></pre> </body></html>
Login page:
Login.html:
69
<html> <body><br /><br /><br /> <form name="myform" method="post" action="login.jsp"> <div align="center"><pre> LOGIN ID :<input type="text" name="id" /><br /> PASSWORD :<input type="password" name="pwd" /></pre><br /><br /> </div> <br /><br /> <div align="center"> <input type="submit" value="ok" onclick="validate()" />       <input type="reset" value="clear" /> </div> </form> </body> </html>
Registration page:
Reg.html:
70
<html> <body><br /><br /> <form name="myform" method="post" action="reg.jsp"> <table align="center" > <tr> <td>NAME</td> <td>:<input type="text" name="name" /></td> </tr> <tr> <td>ADDRESS</td> <td>:<input type="text" name="addr" /></td> </tr> <tr> <td>CONTACT NUMBER</td> <td>:<input type="text" name="phno" /></td> </tr> <tr> <td>LOGINID</td> <td>:<input type="text" name="id" /></td> </tr> <tr> <td>PASSWORD</td> <td>:<input type="password" name="pwd" /></td> </tr> </table> <br /><br /> <div align="center"> <input type="submit" value="ok" onclick="validate()" />       <input type="reset" value="clear" /> </div> </form> </body> </html>
User profile page:

Profile.html:
<html>
71
<body><br /><br /><br /> <form name="myform" method="post" action="profile.jsp"> <div align="center"><pre> LOGIN ID :<input type="text" name="id" /><br /> </pre><br /><br /> </div> <br /><br /> <div align="center"> <input type="submit" value="ok" onclick="validate()" />       <input type="reset" value="clear" /> </div> </form> </body> </html>
Books catalog page:
Catalog.html:
<html> <body><br /><br /><br /> <form method="post" action="catalog.jsp"> <div align="center"><pre> BOOK TITLE :<input type="text" name="title" /><br /> </pre><br /><br /> </div> <br /><br /> <div align="center"> <input type="submit" value="ok" name="button1"/>       <input type="reset" value="clear" name="button2"/> </div> </form> </body> </html> Shopping cart, Payment by credit
card,
Order
Conformation page:
Order.html:
72
<html> <body><br /><br /> <form method="post" action="order.jsp"> <div align="center"><pre> ID :<input type="text" name="id" /><br /> PASSWORD :<input type="password" name="pwd" /><br/> TITLE :<input type="text" name="title" /><br /> NO. OF BOOKS :<input type="text" name="no" /><br /> DATE :<input type="text" name="date" /><br /> CREDIT CARD NUMBER :<input type="password" name="cno" /><br /></pre><br /><br /> </div> <br /><br /> <div align="center"> <input type="submit" value="ok" name="button1"/>       <input type="reset" value="clear" name="button2"/> </div> </form> </body> </html>
Login JSP:
Login.jsp:
<%@page import="java.sql.*"%> <%@page import="java.io.*"%>
73
<%
out.println("<html><body>"); String id=request.getParameter("id"); String pwd=request.getParameter("pwd"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:orcl","scott","tiger"); Statement stmt=con.createStatement(); String sqlstmt="select id,pwd from login"; ResultSet rs=stmt.executeQuery(sqlstmt); int flag=0; while(rs.next()) { if(id.equals(rs.getString(1))&&pwd.equals(rs.getString(2))) { flag=1; } } if(flag==0) { out.println("<br><br>SORRY INVALID ID TRY AGAIN ID<br><br>"); out.println("<a href=\"login.html\">press LOGIN to RETRY</a>"); } else { out.println("<br><br>VALID LOGIN ID<br><br>"); out.println("<h3><ul>"); out.println("<li><a href=\"profile.html\"><fontcolor=\"black\">USER PROFILE</font> </a></li><br><br>"); out.println("<li><a href=\"catalog.html\"><fontcolor=\"black\">BOOKS CATALOG</font></a></li><br><br>"); out.println("<li><a href=\"order.html\"><fontcolor=\"black\">ORDER CONFIRMATION</font> </a></li></ul><br><br>"); } out.println("</body></html>"); con.close();
%>
Registration JSP:
Reg.jsp:
<%@page import="java.sql.*"%>
74
<%@page import="java.io.*"%> <% response.setContentType("text/html"); out.println("<html><body>"); String name=request.getParameter("name"); String addr=request.getParameter("addr"); String phno=request.getParameter("phno"); String id1=request.getParameter("id"); String pwd1=request.getParameter("pwd"); int no=Integer.parseInt(phno); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:orcl","scott","tiger"); Statement stmt=con.createStatement(); String sqlstmt="select id,pwd from login"; ResultSet rs=stmt.executeQuery(sqlstmt); int flag=0; while(rs.next()) { if(id1.equals(rs.getString(1))&&pwd1.equals(rs.getString(2))) { flag=1; } } if(flag==1) { out.println("<br><br>SORRY INVALID ID ALREADY EXITS TRY AGAIN WITH NEW ID<br><br>"); out.println("<a href=\"reg.html\">press REGISTER to RETRY</a>"); } else { Statement stmt1=con.createStatement(); stmt1.executeUpdate("insert into login values('"+name+"','"+addr+"',"+no+",'"+id1+"','"+pwd1+"');"); out.println("<br><br>YOUR DETAILS ARE ENTERED<br><br>"); out.println("<a href=\"login.html\">press LOGIN to login</a>"); } out.println("</body></html>"); con.close(); %>
Profile JSP:
Profile.jsp:
<%@page import="java.sql.*"%> <%@page import="java.io.*"%> <% out.println("<html><body>"); String id=request.getParameter("id");
75
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:orcl","scott","tiger"); Statement stmt=con.createStatement(); String sqlstmt="select * from login where id="+id+""; ResultSet rs=stmt.executeQuery(sqlstmt); int flag=0; out.println("<br><br><br>"); while(rs.next()) { out.println("<div align=\"center\">"); out.println("NAME :"+rs.getString(1)+"<br>"); out.println("ADDRESS :"+rs.getString(2)+"<br>"); out.println("PHONE NO :"+rs.getString(3)+"<br>"); out.println("</div>"); flag=1; } if(flag==0) { out.println("<br><br>SORRY INVALID ID TRY AGAIN ID<br><br>"); out.println("<a href=\"profile.html\">press HERE to RETRY</a>"); } out.println("</body></html>"); con.close(); %>
Catalog JSP:
Catalog.jsp:
<%@page import="java.sql.*"%> <%@page import="java.io.*"%> <% out.println("<html><body>");
76
String title=request.getParameter("title"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:orcl","scott","tiger"); Statement stmt=con.createStatement(); String sqlstmt="select * from book where title=\'"+title+"\'"; ResultSet rs=stmt.executeQuery(sqlstmt); int flag=0; while(rs.next()) { out.println("<div align=\"center\">"); out.println("TITLE :"+rs.getString(1)+"<br>"); out.println("AUTHOR :"+rs.getString(2)+"<br>"); out.println("VERSION :"+rs.getString(3)+"<br>"); out.println("PUBLISHER :"+rs.getString(4)+"<br>"); out.println("COST :"+rs.getString(5)+"<br>"); out.println("</div>"); flag=1; } if(flag==0) { out.println("<br><br>SORRY INVALID TITLE TRY AGAIN <br><br>"); out.println("<a href=\"catalog.html\">press HERE to RETRY</a>"); } out.println("</body></html>"); con.close(); %>
Order servlet:
Order.java:
<%@page import="java.sql.*"%> <%@page import="java.io.*"%> <% int count; out.println("<html><body>");
77
String id=request.getParameter("id"); String pwd=request.getParameter("pwd"); String title=request.getParameter("title"); String count1=request.getParameter("no"); String date=request.getParameter("date"); String cno=request.getParameter("cno"); count=Integer.parseInt(count1); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:orcl","scott","tiger"); Statement stmt=con.createStatement(); String sqlstmt="select id,pwd from login"; ResultSet rs=stmt.executeQuery(sqlstmt); int flag=0,amount,x; while(rs.next()) { if(id.equals(rs.getString(1))&&pwd.equals(rs.getString(2))) { flag=1; } } if(flag==0) { out.println("<br><br>SORRY INVALID ID TRY AGAIN ID<br><br>"); out.println("<a href= \"order.html \" >press HERE to RETRY</a>"); } else { Statement stmt2=con.createStatement(); String s="select cost from book where title=\'"+title+"\'"; ResultSet rs1=stmt2.executeQuery(s); int flag1=0; while(rs1.next()) { flag1=1; x=Integer.parseInt(rs1.getString(1)); amount=count*x; out.println("<br><br>AMOUNT :"+amount+"<br><br><br><br>"); Statement stmt1=con.createStatement(); stmt1.executeUpdate("insert into details values('"+id+"','"+title+"',"+amount+",'"+cno+"');"); out.println("<br>YOUR ORDER has taken<br>"); } if(flag1==0)
78
{ out.println("<br><br><br>SORRY INVALID ID TRY AGAIN ID<br><br>"); out.println("<a href=\"order.html\">press HERE to RETRY</a>"); } } out.println("</body></html>"); con.close(); %>
Output: Home page:
79
Login page:
80
Login JSP:
81
Registration page:
82
Reg JSP:
83
User profile page:
84
Profile JSP:
85
Books catalog page:
86
Catalog JSP:
87
Shopping cart, Payment Conformation page:
by
credit
card,
Order
88
Order JSP:
89
6.
AIM:
Implement the "Hello World!" program using JSP Struts Framework
90
PROCEDURE: Step 1:
in tomcat install directory Open tomcat/webapps Create a subdirectory(ts) Copy the struts-blank.war file At that directory path in cmd give the command as Jar xvf struts-blank.war
Step 2:
create a directory (work in e:\) and copy struts.jar,servelet-appi.jar into work d directory.Then set the classpath as
91
set classpath=struts.jar;servlet-api.jar; then copy the ActionOne.class file to webapps/ts/WEB-INF/classes
ActionOne.java:
import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import org.apache.struts.action.*; public class ActionOne extends Action { publicActionForwardexecute(ActionMappingmapping,ActionFormform,HttpServletReque st request,HttpServletResponse response)throws Exception { System.out.println("---Action executed----"); PrintWriter pw=response.getWriter(); pw.println("HELLO WORLD!"); return null; } }
Step 3: Struts-Config.xml file

<?xml version="1.0" encoding="UTF-8"?> <struts-config>
92
<action-mappings> <action path="/xxx" type="ActionOne"/> </action-mappings> </struts-config>
Step 4: Web.xml
<?xml version="1.0" encoding="ISO-8859-1"?> <web-app> <servlet>
93
<servlet-name>action</servlet-name> <servlet-class>org.apache.struts.action.ActionServlet</servlet-class> <init--param> <param-name>config</param-name> <param-value>/WEB-INF/struts-config.xml</param-value> </init-param> <init-param> <param-name>debug</param-name> <param-value>2</param-value> </init-param> <load-on-startup>2</load-on-startup> </servlet>  <servlet-mapping> <servlet-name>action</servlet-name> <url-pattern>*.do</url-pattern> </servlet-mapping>  <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list>  <taglib> <taglib-uri>/tags/struts-bean</taglib-uri> <taglib-location>/WEB-INF/struts-html.tld</taglib-location> </taglib> <taglib> <taglib-uri>/tags/struts-logic</taglib-uri> <taglib-location>/WEB-INF/struts-logic.tld</taglib-location> </taglib> <taglib> <taglib-uri>/tags/struts-nested</taglib-uri> <taglib-location>/WEB-INF/struts-nested.tld</taglib-location> </taglib> <taglib> <taglib-uri>/tags/struts-tiles</taglib-uri> <taglib-location>/WEB-INF/struts-tiles.tld</taglib-location> </taglib> </web-app>
Step 5:
then in I.E give the url as http:localhost:8080/ts/xxx.do
94
4. Beans Assignment a. Create a JavaBean which gives the excange value of INR(Indian Ruppes) into equivalent American Dollar Value.
import java.awt.event.*; public class CurrCon extends Canvas
95
{ private String rupees; private double ERate=0.071; private NumberFormat fmt=NumberFormat.getInstance(); public CurrCon() { setSize(70,70); rupees="1.0"; change(); } public String getRupees() { return rupees; } public void setRupees(String rupees) { this.rupees=rupees; } public void change() { rupees=get_val(); repaint(); } public String get_val() { double Value=Double.parseDouble(rupees); Value*=ERate; fmt.setMaximumFractionDigits(3); fmt.setMinimumFractionDigits(3); rupees="$"+fmt.format(Value); return rupees; } public void paint(Graphics g) { g.drawString(rupees,10,10); } }; Procedute: 1. 2. 3. 4. 5. 6. 7. Compile the above program and copy the class file in a folder. Create a Manifest File in editor in MSDos . Manifest File should be named with extension ft And type as Name: Class file name and Java-Bean: True Create a Jar file using command >jar cvfm jarName manifestFileName Class Name. Copy jar file into beans soft ware Jars folder. Run bdk
96
8. 9. 10. 11. 12.
Created class named bean will be shown in the tool window. Click on that drag on the BeanBox. Select Button from tool window and drag on BeanBox. Goto edit menu select action performed option, and select target bean component (before created bean) select change option from property window.

Develop Static Pages (Using Only HTML) of An Online Book Store. Should Consist The Following Pages

Uploaded by

Document Informationclick to expand document information

Copyright:

Available Formats

Develop Static Pages (Using Only HTML) of An Online Book Store. Should Consist The Following Pages

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Develop Static Pages (Using Only HTML) of An Online Book Store. Should Consist The Following Pages

Uploaded by

Copyright:

Available Formats

1

Develop static pages (using only HTML) of an online Book store.

PROCEDURE: Home page

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

Registration and user Login

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

User profile page

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

Payment by credit card

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

Registration and user Login:

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

User profile page:

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

Payment by credit card:

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

credit card pages using JavaScript. PROCEDURE:

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

Registration and user Login

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

User profile page

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

Shopping cart: Catalog.html:

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

Payment by credit card

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

Result: Home page

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

Registration and user Login

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

User profile page

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

Payment by credit card

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

User information page:

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

Users xml pages:

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT

HYDERABAD INISTITUTE OF TECHOLOGY AND MANAGEMENT