Milan Vachhani

Welcome!!!!!!!

2011-06-14T21:24:00.000+05:30

Welcome to my Blog.
This blog is specially for GTU MCA Students.
You can download

and other subject related material, syllabus,assignment,tutorial, questions and many more things.
You can also post your questions related to this subject, We will provide you help.

Mobile Computing (MC) - 650003

2011-06-14T09:23:00.000+05:30

Syllabus
1. Mobile Computing (MC)- 650003 Download
2. Software Lab in Mobile Computing (SL-MC) Download
Materials

Textbook - Android Wireless Application Development - Download

Assignments
1. Mobile Computing (MC) - Assignment 1 & 2
2. Mobile Computing (MC) - Assignment 3
3. Mobile Computing (MC) - Assignment 4
4. Mobile Computing (MC) - Assignment 5
5. Mobile Computing (MC) - Assignment 6
6. Mobile Computing (MC) - Assignment 7
7. Mobile Computing (MC) - Assignment 8
Tutorials/Program

Tutorial Solution

Tutorial 1 to 4 Solution by Kajal Savjani - Download New
Tutorial 5 to 8 Solution by Nilesh Ramoliya, Khushal Khant, Ravi Thanki, Vishal Bhut - Download New

Test
1. Mobile Computing (MC) - Test 1 - Result
2. Mobile Computing (MC) - Test 2 - Result
3. Mobile Computing (MC) - Test 3

Important Mobile Computing Question List
1. Question List 1 - Download New
2. Question List 2 - Download New
Android Class Program/Projects - Download New

For any query related to Mobile Computing comment on this page.

MCA 3 Test 1 Result (Batch : 2010-2013)

2011-06-03T10:03:00.000+05:30

Fundamentals of Java Programming Test 1 and 2 Result

ID No	Name	T1 (25)	T1 (10)	T2 (25)	T2 (10)	Average (10)
10MCA001	Doshi Priya Mukesh		0		0	0
10MCA002	Gaglani Mayur Virenbhai	17	7		0	4
10MCA003	Lakhyani Vishal Ishwarlal	19	8	20	8	8
10MCA004	Jismon Mathew		0		0	0
10MCA005	Ponkiya Yagnesh Chandubhai	19	8		0	4
10MCA006	Mehta Priya Pareshkumar	8	3	9	4	4
10MCA007	Dadhania Niharikaben Pravinbhai		0		0	0
10MCA008	Buddh Ashish Narendrabhai		0		0	0
10MCA010	Vachhani Disha Kantilal	14	6	11	4	5
10MCA011	Kothiya Nareshkumar Ramesh	13	5	12	5	5
10MCA012	Vora Neha Rakeshkumar	13	5		0	3
10MCA013	Sutariya Piyushkumar Vinubhai	18	7		0	4
10MCA014	Patel Savankumar Manasukhbhai	22	9	20	8	9
10MCA015	Parmar Megha Bharatbhai	16	6		0	3
10MCA016	Shah Maulikkumar Mukeshbhai		0		0	0
10MCA017	Badani Hemdip Maheshnbhai	14	6	17	7	7
10MCA018	Makadiya Chiragkumar Kishorbhai	18	7		0	4
10MCA019	Dharsandiya Ankitaben Shantilal	10	4		0	2
10MCA020	Sardhara Chetankumar Chandulal	11	4	14	6	5
10MCA021	Hedau Kartikkumar Shishirbhai	13	5		0	3
10MCA022	Bhayani Rahul Sureshbhai	15	6	16	6	6
10MCA023	Mundadiya Alpeshbhai Mansukhbhai	18	7		0	4
10MCA024	Chudasama Trupti Bharatbhai	14	6	12	5	6
10MCA025	Joshi Vishal Harishkumar	8	3		0	2
10MCA026	Bhalodiya Hasmukh Jerambhai	8	3		0	2
10MCA027	Jaksaniya Nisha Kantilal	15	6	13	5	6
10MCA028	Vasoya Parul Maganbhai	12	5	7	3	4
10MCA029	Paghadar Sanjaykumar Jitendrabhai	13	5	12	5	5
10MCA030	Singh Naveenkumar Dataram	7	3		0	2
10MCA031	Joshi Vinayakkumar Sureshbhai	1	0		0	0
10MCA032	Bhadja Ravitkumar Jayantilal	11	4		0	2
10MCA033	Joshi Hiralben Narendrabhai	15	6		0	3
10MCA034	Tejani Nilesh Himmatbhai	17	7		0	4
10MCA035	Jivani Rajnish Sundarjibhai	12	5		0	3
10MCA036	Joshi Kishan Rajendrabhai	13	5	8	3	4
10MCA037	Rachchh Bhavisha Rajeshkumar		0		0	0
10MCA038	Chothani Khushbu Kishorbhai	10	4	9	4	4
10MCA039	Singal Neetuben Virjibhai		0		0	0
10MCA040	Khilchi Aejazkhan Ahmedkhan	11	4	11	4	4
10MCA041	Tank Rohit Ratilal	12	5		0	3
10MCA042	Rathod Jatin Bharatbhai	13	5	8	3	4
10MCA043	Patadiya Lalitkumar Vajubhai	12	5	5	2	4
10MCA044	Nenuji Dharmeshkumar Ashvinbhai	1	0		0	0
10MCA045	Parmar Shailesh Jagdishbhai		0		0	0
10MCA046	Dangar Vijaykumar Naranbhai	15	6	13	5	6
10MCA048	Bhatti Siddharth Kantibhai	8	3		0	2
10MCA049	Badeliya Dixit Kishorbhai	17	7	18	7	7
10MCA050	Hakda Samaben Yunasbhai		0		0	0
10MCA051	Solanki Nilesh Ishvarbhai		0		0	0
10MCA052	Nimavt Jaydeepkumar Ramniklal	11	4		0	2
10MCA053	Chavda Maheshkumar Naranbhai		0	11	4	2
10MCA054	Indrodiya Jasmin Dilipbhai		0		0	0
10MCA055	Vaghela Rashmikant Dipakkumar		0		0	0
10MCA056	Bhatt Bhushan Nutanbhai	8	3	9	4	4
10MCA057	Kaneria Pinal Rasiklal	15	6	10	4	5
10MCA058	Bhuptani Jay Ashvinkumar	9	4		0	2
10MCA059	Baldha Heenaben Jentilal		0		0	0
10MCA060	Bhoraniya Sanjaykumar Laxmanbhai	15	6	15	6	6
10MCA061	Koradiya Vishalkumar Vallabhadas	20	8		0	4
10MCA062	Ghedia Ghanshyam C		0		0	0
37MCA09	Viral Oza	13	5		0	3
38MCA09	Pandya Ambrish		0		0	0
17MCA09	Garsar Dhiren		0		0	0
42MCA09	Parmar Vimal		0		0	0

Programming Skills – VII (WTAD) 640012 p4

2011-05-14T13:44:00.000+05:30

Write a JSP page which uses tags available from the standard tag library JSTL


<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jst1/core" %>
<html>
<head>
   <title>JSTL TAGs</title>
</head>
<body>
   <h4><code><c:set> and  <c:remove> Tags</code></h4>
   <c:set var="date" value="<%=new java.util.Date()%>" scope="request">
   </c:set>
   Today's Date:<c:out value="${date}" />
   <c:remove var="date" />
        Date after using
   <c:remove />
   <c:out value="${date}" />
   </br>
 
   <h4> <code> <c:if>, <c:forToken>,<c:forEach>, <c:choose> and <c:when> Tags</code></h4>
   <c:forToken var="item" items="< once ) Upon , A ( Time % there..>" delims="<),(%.>">
   <ul>
        <c:forEach var="i" begin="1" end="10">
           <li>
             i=${i}
             <c:if test="$(i == 2)"> Value is Equal 2 </c:if>
 
             <c:choose>
             <c:when test="${i < 3}">less then 3</c:when>
             <c:when test="${i < 5}">less then 5</c:when>
             <c:otherwise>Value is Greater then 3 or 5</c:otherwise>
             </c:choose>
           </li>
        </c:foreach>
   </ul>
   <h4> <code> <c:catch> Tags</code></h4>
   <c:catch var="x">
        <% int x=1/0;%>
   </c:catch>
</body>
</html>

Write A Servlet which uses the concept of Request forwarding & including external source in the current servlet context.


Servletforward :

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

public class servletforward extends HttpServlet
{
   public void doGet(HttpServletRequest req,HttpServletResponse res)throws IOException,ServletException
   {
        String address = "/servletinclude";
         RequestDispatcher dispatcher = req.getRequestDispatcher(address);
          dispatcher.forward(req, res);
   }
}

ServletInclude ::   

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

public class servletinclude extends HttpServlet
{
   public void doGet(HttpServletRequest req,HttpServletResponse res)throws IOException,ServletException
   {
        String header="/header.jsp";
        String footer="/footer.jsp";
        res.setContentType("text/html");
        PrintWriter out=res.getWriter();
        out.println("<html><body><center><table border=2><tr>\n"+
                  "<td>");
        RequestDispatcher dispatcher1 =req.getRequestDispatcher(header);
        dispatcher1.include(req, res);
        out.println("</td></tr><tr><td><h2>hello friends welcome</h2></td></tr>");
        out.println("<tr>\n"+
                  "<td>");
        RequestDispatcher dispatcher2 =req.getRequestDispatcher(footer);
        dispatcher2.include(req, res);
        out.println("</td></tr></table></body></html>");
   }
}

Develop a JSP Page to display the personal information and result information of the student in two different tabular formats.


<html>
<head>
<title>Ex33</title>
</head>
<body>
<%@page import="java.sql.*" %>
<%
   try
   {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con = DriverManager.getConnection("JDBC:ODBC:DATASOURCE");              
        Statement s=con.createStatement();
        s.executeQuery("Select * from stud");
        ResultSet rs=s.getResultSet();
        rs.next();
   %>
   <table align="center" width="100%" height="70%">
   <tr>
        <td>
      
   <table align="center" width="60%" height="50%" border="1">
        <tr bgcolor="#CCCCCC"><th colspan="2" align="left"><b>Student's Personal Information</b></th></tr>
        <tr><td>Name</td><td><%=rs.getString("name")%></td></tr>
        <tr><td>Enrollment Number</td><td><%=rs.getString("EnrollNum")%></td></tr>
        <tr><td>Date Of Birth</td><td><%=rs.getString("DOB")%></td></tr>
        <tr><td>Address</td><td><%=rs.getString("Address")%></td></tr>
        <tr><td>Gender</td><td><%=rs.getString("Gender")%></td></tr>
        <tr><td>Contact Number</td><td><%=rs.getString("cellnum")%></td></tr>
   </table>
   </td>
   <td>
        <table align="center" width="60%" height="50%" border="1">
             <tr bgcolor="#CCCCCC"><th colspan="2" align="left"><b>Result of Semester 3</b></th></tr>
             <tr><td>JAVA</td><td><%=rs.getString("JAVA")%></td></tr>
             <tr><td>SS</td><td><%=rs.getString("SS")%></td></tr>
             <tr><td>SM</td><td><%=rs.getString("SM")%></td></tr>
             <tr><td>OS</td><td><%=rs.getString("OS")%></td></tr>
             <tr><td>SOOADM</td><td><%=rs.getString("SOOADM")%></td></tr>
        </table>
    </td>
   </tr>
   </table>
            
   <% }
   catch(Exception e)
   {%>
   Exception generated. Description<%=e%>
   <%}%>
</body>
</html>

Develop a JSP Page to perform database driven operations like insert, Delete, Update and selection with table named Student having fields like StudId, Name, and Address result.


<html>
<body>
   <title>
        Tutorial 7 Pogram-1(AddressBook)
    <title>
     <center><h3>My AddressBook</h3></center>
    <form method=get>
       <table align=center>
        <tr><td>Student Id          <input type=text name="id" value=<% if(request.getParameter("up")!=null) { out.println(request.getParameter("uid"));}%>></td></tr>
       <tr><td>Student Name    <input type=text name="name" value=<% if(request.getParameter("up")!=null) { out.println(request.getParameter("uname"));}%>></td></tr>
         <tr><td>Address             <input type=text name="addr" value=<% if(request.getParameter("up")!=null) { out.println(request.getParameter("uaddr"));}%>></td></tr>
         <tr colspan=3 align=center><td><input type="submit" name=<% if(request.getParameter("up")!=null) { out.println("updat");} else {out.println("add");}%> value=<% if(request.getParameter("up")!=null) { out.println("Update");} else {out.println("ADD");}%>>
        <input type="submit" name="dis" value="Display"></td></tr>
        </table>
    </form>
</body>
</html>


<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%

        Connection cn=null;
        String q=null;
        ResultSet rs=null;
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        cn=DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:\\tomcat7\\webapps\\jsp\\34\\student_info.mdb","",""); 
        Statement statement = cn.createStatement();
        if(request.getParameter("add")!=null)
        {        
            try
            {               
                q="INSERT INTO student VALUES('"+request.getParameter("id").toString().trim()+"','" +
                                request.getParameter("name").toString().trim() + "','" +
                                request.getParameter("addr").toString().trim()+"')";
                int a=statement.executeUpdate(q);
                if (a>0)
                {
                  out.println("Successfully inserted");
                }
                else
                {
                    out.println("Not inserted");
                }                
              }
              catch(SQLException e)   
              {
                 out.println(e.toString());
              }
         }
         if(request.getParameter("dis")!=null)
         {
              String uid,uname,uaddr;
              q="SELECT * FROM student";
              rs = statement.executeQuery(q);
              if(rs.next())
              {
                    %>
                     <table border=0 align="center">
                     <tr>
                       <td>STUDENT ID</td>
                        <td>NAME</td>
                        <td>ADDRESS</td>
                     </tr>
                   <%
                   while(rs.next())
                     {
                        uid=rs.getString(1);
                        uname=rs.getString(2);
                        uaddr=rs.getString(3);
                        out.println("<tr>");
                        out.println("<td>"+uid+</td>");
                        out.println("<td>"+uname+</td>");
                        out.println("<td>"+uaddr+</td>");
                        out.println("<td><a href=addressbook.jsp?uid="+uid+"&up=dd&uaddr="+uaddr+"&uname="+uname+">Update</a></td>");
                        out.println("<td>"<a href=addressbook.jsp?uid="+uid+"&del=ddd&uaddr="+uaddr+"&uname="+uname+">Delete</a></td>");
                        out.println("</tr>");                     
                     }%>
      </table>
                   <%
                  }
                  else
                  {
                     out.println("Record not found");
                  }
             }
       if(request.getParameter("updat")!=null)
          {
                 try
                  {
                     q="UPDATE student SET name='"+request.getParameter("name")+"',address='"+request.getParameter("addr")+"' where id='"+request.getParameter("id")+"'";
                     int bb=statement.executeUpdate(q);
                     if (bb>0)
                     {
                          out.println("<center>Successfully updated</center>");
                     }
                     else
                     {
                          out.println("Not updated");
                     }
                 }
                 catch(SQLException e)
                 {
                     out.println(e);

                 }
          }   
         if(request.getParameter("del")!=null)
         {              
              try
              {
                     q="DELETE FROM student WHERE id='"+request.getParameter("uid")+"'";
        
                     int bb=statement.executeUpdate(q);
                     if (bb>0)
                     {
                          out.println("<center>Successfully deleted</center>");
                     }
                     else
                     {
                          out.println("Not deleted");
                     }
                 }
                 catch(SQLException e)
                 {
                      out.println(e);
                 }
          }
%>

Write a JSP page to use JSP’s Page Directives.

<html>
   <head>
        <title>Use Of Jsp Page Directive</title>
   </head>
   <body>
        <h2>The Import Attribute</h2>
             <%@ page import="java.util.*" %>
             Today's Date is :: <%= new Date() %>
             <%@ page contentType="application/vnd.ms.excel" %>
             <table border=1>
                  <tr>
                       <th>Item</th>
                       <th>Price</th>
                  </tr>
                  <tr>
                       <td>TV</td>
                       <td>6000</td>
                  </tr>
                  <tr>
                       <td>TV</td>
                       <td>6000</td>
                  </tr>
             </table>
             <%@ page session="true" %>
   </body>
</html>

Write a JSP page to use JSP Scripting.

<html>
   <head>
        <title>Scriplet Tag Example</title>
   </head>
   <%
        String bgcolor=request.getParameter("bgcolor");
        if((bgcolor == null) || (bgcolor.trim().equals("")))
        {
             bgcolor="WHITE";
        }
   %>
   <body bgcolor="<%= bgcolor %>">
        <center>
             <H2>Testing BackGround Color = "<%= bgcolor %>" </h2>
        </center>
   </body>
</html>

Write a JSP Page to which uses Session Tracking for online shopping
```
Available Soon.....
```

BACK

Prepared By:

Student of B. H. Gardi College of Eng. & Tech., MCA Department

(Nisarg Juthani, Kajal Savjani, Desai Paresh, Ramoliya Nilesh, Thanki Ravi.....)

Programming Skills – VII (WTAD) 640012 p3

2011-05-08T14:08:00.000+05:30

Create a Java class called Product with the following properties: name, description,price. Create a listener that notifies (through System.out) whenever a user adds aproduct to a shopping cart (i.e. adds an object to the session object) or removes itagain. Hint: check out the class HttpSessionAttributeListener. Make it print the name and price of the object (hint: access the session through the HttpBindingEventobject). Also, let the listener print the total price of all objects saved in the session sofar (one way to accomplish this could be to keep a collection of all objects saved to the session – or just their keys – in the listener or an associated class).


File 1
--------
package model;

public class Product
{
public String name;
public String descr;
public float price;

public Product(String name,String descr,float price)
{
     this.name=name;
     this.descr=descr;
     this.price=price;
}
}

File 2
-------
package web;
import javax.servlet.*;
import javax.servlet.http.*;
import model.*;

public class SessionListenerImplementationDemo implements HttpSessionAttributeListener
{
public void attributeAdded(HttpSessionBindingEvent sbEvent)
{
     HttpSession mySession=sbEvent.getSession();
     String attribName=sbEvent.getName();
     Product p=(Product)sbEvent.getValue();
     String attribVal=(String)sbEvent.getValue();
     System.out.println("Attribute with attribute name "+attribName+" is added to session and value is"+attribVal);
     System.out.println("Product Details added to the session");
     System.out.println("Name: "+p.name);
     System.out.println("Price:"+p.price);
}
public void attributeRemoved(HttpSessionBindingEvent sbEvent)
{
     HttpSession mySession=sbEvent.getSession();
     String attribName=sbEvent.getName();
     Product p=(Product)sbEvent.getValue();
     String attribVal=(String)sbEvent.getValue();
     System.out.println("Attribute with attribute name "+attribName+" is removed from session and value is"+attribVal);
     System.out.println("Detail of Product Removed from the session");
     System.out.println("Name: "+p.name);
     System.out.println("Price:"+p.price);
}
public void attributeReplaced(HttpSessionBindingEvent sbEvent)
{
}
}

File 3
-------

package web;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import model.*;

public class ServletEx21 extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res)
throws IOException,ServletException{

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

          HttpSession mySession=req.getSession();
          out.println("<html><body>");
          try
          {
               Product p1=new Product("Corbey","Nice handset",6200);
               Product p2=new Product("Galaxy","It has anroid os",12000);
               Product p3=new Product("Champ","Good sound quality",4500);
               
               mySession.setAttribute("Cell_1","Corbey");
               mySession.setAttribute("Cell_2","Galaxy");
               mySession.setAttribute("Cell_3","Champ");
               
               mySession.removeAttribute("Cell_3");
               //     out.println("Hello World");
               out.println("Session activity are tracked by this server.Check console or catalina folder");
          }
          catch(Exception e)
          {
               out.println(e);
          }
          out.println("Hello Test");
          out.println("</body></html>");
     }
}

Web.xml
---------
<?xml version="1.0" encoding="UTF-8"?>

<web-app>

<servlet>
<servlet-name>MyServletGetTracked</servlet-name>
<servlet-class>web.ServletEx21</servlet-class>

</servlet>

<servlet-mapping>
<servlet-name>MyServletGetTracked</servlet-name>
<url-pattern>/Ex21</url-pattern>
</servlet-mapping>
<listener>
<description>sessionListener</description>
<listener-class>web.SessionListenerImplementationDemo</listener-class>
</listener></web-app>

Create a servlet filter that logs all access to and from servlets in an application and prints the following to System.out:

a. the time the request was received
b. the time the response was sent
c. how much time it took to process the request
d. the URL of the resource requested
e. the IP address of the visitor.

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

public class filterDemo implements Filter
{
   String rs;
   Date reqd;
   Date resd;
   Calendar calendar1 = Calendar.getInstance();
   Calendar calendar2 = Calendar.getInstance();

   String ip;
   ServletContext context;
   FilterConfig config;

   public void doFilter(ServletRequest request,ServletResponse response,FilterChain chain)throws ServletException,IOException
   {
         resd=new Date();
         calendar1.set(reqd.getYear(),reqd.getMonth(),reqd.getDate());
         calendar2.set(resd.getYear(),resd.getMonth(),resd.getDate());
         long milliseconds1 = calendar1.getTimeInMillis();
         long milliseconds2 = calendar2.getTimeInMillis();
         long diff = milliseconds2 - milliseconds1;
         Date ddate=new Date(diff);
         HttpServletRequest req=(HttpServletRequest)request;
          
         context.log("IP:--"+req.getRemoteAddr()+"---" +req.getRequestURL()+" request time::-"+reqd.toString()+" Response Time::-"+resd.toString()+"diff"+ddate.toString());
         chain.doFilter(request,response);   
   }
   public void init(FilterConfig config)
   {
         reqd=new Date();
         this.config=config;
         context=config.getServletContext();
   }
   public void destroy()
   {
   }
}

WEB.XML File::
--------------
<web-app>
<servlet>
  <servlet-name>calculate</servlet-name>
  <servlet-class>calculate</servlet-class>
</servlet>
<servlet-mapping>
  <servlet-name>calculate</servlet-name>
  <url-pattern>/calculate</url-pattern>
</servlet-mapping>
<filter>
<filter-name>filterDemo</filter-name>
 <filter-class>filterDemo</filter-class>
</filter>
<filter-mapping>
<filter-name>filterDemo</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>

Devlop a interest Calculation application in which user will provide all information in HTML form and that will be processed by servlet and response will be generated back to the user.

SERVLET ::
------------
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

class simpleinterest extends HttpServlet
{
int p,r,n;
float si;
public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
     p=Integer.parseInt(req.getParameter("txtp"));
     r=Integer.parseInt(req.getParameter("txtr"));
     n=Integer.parseInt(req.getParameter("txtt"));
     si=(float)((p*r*n)/100);
     String value=String.valueOf(si);
     Cookie c = new Cookie("Simple Interest",value);
     res.addCookie(c);
     res.sendRedirect("http://localhost:8080/WTAD/jspfiles/simint.jsp");
}
}
HTML FILE  ::
--------------
<!-- html form which get interest calcuation's Information -->

<html>
<head>
     <title> SIMPLE INTEREST </title>
</head>
<body>
     <form name="frmsi" action="http://localhost:8080/WTAD/simpleinterest" method="post">
          <center><br>
               Input Principle Amount :: <input type="text" name="txtp" value="input no only"><br>
               Input Rate in persentage :: <input type="text" name="txtr" value="input no only"><br>
               Input Time :: <input type="text" name="txtt" value="input no only"><br><br>
          
               <script language="javascript">
               
                    var results = document.cookie.match ( '(^|;) ?' + "Simple Interest + '=([^;]*)(;|$)' ); if ( results )
                         document.writeln( unescape ( results[2] ) );
               </script>
          
               <input type="submit" name="cmdsi" value="CALCULATE">          
                <input type="reset" name="cmdrs" value="CLEAR">
          </center>
     </form>
</body>
</html>

Develop an application to demonstrate how the client (browser) can remember the last time it visited a page and displays the duration of time since its last visit. (Hint: use Cookie).

File 1
---------
<html>
<head>
     <title>Ex24</title>
     <script language="javascript">
     function validate()
     {
          if(document.getElementById(1).value=="")
          {
               alert("Please insert username");
               return false;
          }
          if(document.getElementById(2).value=="")
          {
               alert("Please insert password");
               return false;
          }
          return true;
     }
     </script>
</head>
<body>
     <br>
     <h1>FACEBOOK</h1>
     <hr>
     <table border=1 align="right" hspace="20%">
     <tr><td>
     <form action="setTimeCookie.jsp" method="post" onSubmit="return validate();">
          <table width=100%>
          <tr>
               <th colspan=2>Log in to FB<th>
          </tr>
          <tr>
               <td>Username</td>
               <td><input type="text" name="uname" id=1></td>
          </tr>
          <tr>
               <td>Password</td>
               <td><input type="password" name="password" id=2></td>
          <tr>
               <td colspan=2 align="Center"><input type="Submit" value="Submit"></td>
          </tr>
     
          </table>
     </form>
     </tr></td></table>
</body>
</html>

FILE 2:
--------
<html>

<head>
     <title>
     <title>
</head>

<body>
<%@page import="java.util.Date"%>
<%@page import="java.sql.*"%>

<%
     String uname=request.getParameter("uname");
     String pwd=request.getParameter("password");
     try
     {
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          Connection con=DriverManager.getConnection("JDBC:ODBC:DATASOURCE");
          Statement st=con.createStatement();
          st.executeQuery("Select* from user");
          ResultSet rs=st.getResultSet();
          boolean found=false;
          if(rs!=null)
          {
               while(rs.next())
               {
               
                    if(uname.equals(rs.getString("username")) && pwd.equals(rs.getString("password")))
                    {
                         found=true;
                         Date now = new Date();
                         String timeStamp = now.toString();
                         Cookie cookies[]=request.getCookies();
                         String cookie1="username";
                         String cookie2="lastTime";
                         Cookie unameCookie=null;
                         Cookie timeCookie=null;
                         if(cookies!=null)
                         {
                              for(int i=0;i<cookies.length;i++)
                              {
                                   if(cookies[i].getName().equals(cookie1))
                                   {
                                        unameCookie=cookies[i];
                                   }
                                   if(cookies[i].getName().equals(cookie2))
                                   {
                                        timeCookie=cookies[i];
                                   }
                              }
                         }

                         %><h1><%="Welcome.."+uname%>
                         <br><%
                         if(timeCookie!=null && unameCookie!=null)
                         {
                              if(unameCookie.getValue().equals(uname))
                              {
                         %><%="Last time you had visited this site on "+timeCookie.getValue()+"."%>
                         <%
                              }
                              else
                              {
                              %>
                                   <%="This is your first visit to our site"%>
                              <%
                              }
                         }
                         unameCookie=new Cookie("username",uname);
                         timeCookie=new Cookie("lastTime",timeStamp);
                         response.addCookie(unameCookie);
                         response.addCookie(timeCookie);
                    }
               }
               if(!found)
               {
               %><h1><%="Invalid username and/or password"%></h1>
               <%
               }
          }
     }
     catch(Exception e)
     {
     %> <%=e%>
     <%
     }
%>

</body>
</html>

Develop an application to keep track of one user across several servlet invocations
within the same browser session.
```
Available soon
```

Develop An application to write a “page – composite” JSP that includes other pages or passes control to another page.

<!-- Write A JSP Page, which uses the include directive to show its header and footer -->
<html>
<head>
     <title>  </title>
</head>
<body>
     <table border="1" align="center" cellpadding="0"cellspacing="0">
          <tr>
               <td align="center" id="header">
                         <jsp:include page="header.jsp"/>
               </td>
          </tr>
          <tr height="500">
               <td>
                    <script language="javascript">
                         var n1=parseInt(prompt("Input anyInteger no to N1:"));
                         var n2=parseInt(prompt("Input anyInteger No to N2:"));
                         if(n1>n2)
                         {
                              <jsp:forward page="small.jsp"/>
                         }
                         else
                         {
                              <jsp:forward page="small.jsp"/>
                         }
                    </script>
               </td>
          </tr>
          <tr>
               <td align="right" id="footer">
                    <jsp:include page="footer.jsp"/>
               </td>
          </tr>
     </table>
</body>
</html>

You want to reduce the amount of java coding in your JSP Using Java Bean component.

STRINGBEAN.JAVA
----------------
public class StringBean
{
private String message="No message";
public String getMessage()
{
     return(message);
}
public void setMessage(String m)
{
     this.message=m;
}
}

STRINGBEANEXAMPLE.JSP
-----------------------
<html>
<head>
  <title>Using JavaBean With JSP</title>
</head>
<body>
<center>
     <table border=2>
                <tr>
                      <th>Using JavaBean With JSP</th>
          </tr>
     </table>
</center>
<jsp:useBean id="strbean" class="StringBean" />
<ol>
     <li>Initial Value :: <jsp:getProperty name="strbean" property="message" /></li>
     <li><jsp:setProperty name="strbean" property="message" value="hello" />value after seeting value from jsp:<jsp:getProperty name="strbean" property="message" /></li>
</ol>
</body>
</html>

Develop a program to perform the database driven operation like insert, Delete,
Update and select. To perform the above operations create one table named
Employee.
Field Name Field Type
EmpId Integer
Empname Varchar
Emp_desig Varchar
Emp_J_Date Varchar
Emp_Salary Numeric

import java.sql.*;
class Ex28
{
public static Connection con=null;
public static Statement s=null;
public static ResultSet rs=null;
public static ResultSetMetaData rsmdt=null;

public static void main(String args[])
{
   try
   {
       Class.forName("com.mysql.jdbc.Driver");
       con=DriverManager.getConnection("jdbc:mysql://localhost/emp","root","");
       s=con.createStatement();

       displayAllRecord();
       System.out.println("Inserting one new Record...");
       insertRecord();
       System.out.println("After insert....");
       displayAllRecord();

       System.out.println("Deleting one record....");
       deleteRecord(4);
       System.out.println("After delete....");
       displayAllRecord();

       System.out.println("Updating one record..");
       updateRecord(3);
       System.out.println("After update....");
       displayAllRecord();

       rs.close();
       s.close();
       con.close();
   }
   catch(Exception e)
   {
       System.out.println(e);
   }
}
public static void  displayAllRecord()
{
   try
   {
       rs=s.executeQuery("Select * from employee");
       rsmdt=rs.getMetaData();
       System.out.println(rsmdt.getColumnCount());
       for(int i=1;i<rsmdt.getColumnCount();i++)
       {
           System.out.print(rsmdt.getColumnName(i)+"||");
       }
       System.out.println();
       System.out.println("==================================================================");
while(rs.next())
       {
           System.out.println();
           System.out.print(rs.getString(1)+" || ");
           System.out.print(rs.getString(2)+" || ");
           System.out.print(rs.getString(3)+" || ");
           System.out.print(rs.getString(4)+" || ");
           System.out.print(rs.getString(5)+" || ");
       }
   }
   catch(Exception e)
   {
       System.out.println(e);
   }
}
public static void insertRecord()
{
   try
   {
       String query="INSERT INTO `employee` ( `empid` , `empname` , `emp_desig` , `emp_j_dare` , `emp_salary` )VALUES ('7', 'dextors', 'Assistant Progremer', '12/6/2012', '45000')";
       s.executeUpdate(query);
   }
   catch(Exception e)
   {
       System.out.println(e);
   }
}
public static void deleteRecord(int empid)
{
   try
   {
       String query="DELETE FROM `employee` WHERE `empid`="+empid;
       s.executeUpdate(query);
   }
   catch(Exception e)
   {
       System.out.println(e);
   }
}
public static void updateRecord(int empid)
{
   try
   {
       String query="UPDATE `employee` SET `empname` = ‘MultiDextors',`emp_salary` = '51200' WHERE `empid` ="+empid;
       s.executeUpdate(query);
   }
   catch(Exception e)
   {
       System.out.println(e);
   }
}
}

Develop a Java application to perform the database driven operation like insert, Delete, Update and selection using PreparedStatement. To perform the above operations use the table from exercise 28.

import java.sql.*;
class Ex29
{
public static Connection con=null;
public static PreparedStatement ps=null;
public static ResultSet rs=null;
public static ResultSetMetaData rsmdt=null;

public static void main(String args[])
{
   try
   {
       Class.forName("com.mysql.jdbc.Driver");
       con=DriverManager.getConnection("jdbc:mysql://localhost/emp","root","");

       displayAllRecord();
       System.out.println("Inserting one new Record...");
       insertRecord();
       System.out.println("After insert....");
       displayAllRecord();

       System.out.println("Deleting one record....");
       deleteRecord(4);
       System.out.println("After delete....");
       displayAllRecord();

       System.out.println("Updating one record..");
       updateRecord(3);
       System.out.println("After update....");
       displayAllRecord();

       rs.close();
       ps.close();
       con.close();
   }
   catch(Exception e)
   {
       System.out.println(e);
   }
}
public static void  displayAllRecord()
{
   try
   {
       String query="Select * from employee";
       ps=con.prepareStatement(query);
       rs=ps.executeQuery();
       rsmdt=rs.getMetaData();
       //System.out.println(rsmdt.getColumnCount());
       for(int i=1;i<rsmdt.getColumnCount();i++)
       {
           System.out.print(rsmdt.getColumnName(i)+"||");
       }
       System.out.println();
       System.out.println("==================================================================");

       while(rs.next())
       {
           System.out.println();
           System.out.print(rs.getString(1)+" || ");
           System.out.print(rs.getString(2)+" || ");
           System.out.print(rs.getString(3)+" || ");
           System.out.print(rs.getString(4)+" || ");
           System.out.print(rs.getString(5)+" || ");
       }
   }
   catch(Exception e)
   {
       System.out.println(e);
   }
}
public static void insertRecord()
{
   try
   {
       String query="INSERT INTO `employee` ( `empid` , `empname` , `emp_desig` , `emp_j_dare` , `emp_salary` )VALUES ('4', 'Manish Prajapati', 'Assistant Progremer', '12/6/2012', '45000')";
       ps=con.prepareStatement(query);
       ps.executeUpdate();
   }
   catch(Exception e)
   {
       System.out.println(e);
   }
}
public static void deleteRecord(int empid)
{
   try
   {
       String query="DELETE FROM `employee` WHERE `empid`= ? ";
       ps=con.prepareStatement(query);
       ps.setInt(1,empid);
       ps.execute();
   }
   catch(Exception e)
   {
       System.out.println(e);
   }
}
public static void updateRecord(int empid)
{
   try
   {
       String query="UPDATE `employee` SET `empname` = ?,`emp_salary` = ? WHERE `empid` =?";
       ps=con.prepareStatement(query);
       ps.setString(1,"Raj Aryan");
       ps.setFloat(2,250000);
       ps.setInt(3,empid);
       ps.execute();
   }
   catch(Exception e)
   {
       System.out.println(e);
   }
}
}

Write a Java application to invoke a stored procedure using a CallableStatement. For this a stored procedure called incrementSalary may be developed to increase all the employees salary by a percentage specified in the parameter.

Code of Stored procedure.
-----------------------------------------------------------------------------------------
Run this on oracle or mysql
---------------------------------------------------------------
CREATE PROCEDURE salIncr(IN per INT)
BEGIN
update employee set emp_salary=emp_salary+emp_salary*per/100;
END
//
-----------------------------------------------------------------
One more imp note:
In mysql you can not use one connection obejct to create multiple objects of different types
of statement like callable,prepared.(code doesn’t work with single con that’s why telling so..not sure about it ).now what happens with oracle i don't know. Test it over oracle and give
feed back here. I think it will allow.*/

import java.sql.*;

public class Ex30
{
public static Connection con=null;
public static CallableStatement cbs=null;
public static ResultSet rs=null;
public static Statement s=null;
public static ResultSetMetaData rsmdt=null;

public static void main(String args[])
{
     try
     {
          /* Code with xamp mysql server
          Class.forName("com.mysql.jdbc.Driver");
     con=DriverManager.getConnection("jdbc:mysql://localhost/emp","root","");
          */
          //Code with full mysql server.
          Class.forName("com.mysql.jdbc.Driver");
          String url ="jdbc:mysql://localhost:3306/emp";
          Connection con = DriverManager.getConnection(url,"root","123456");
          String query="call salIncr(20)";
          cbs=con.prepareCall(query);
          cbs.executeQuery();
          cbs.close();
          System.out.println("After execution of stored procedure");
          displayAllRecord();
          rs.close();
          s.close();
          con.close();
     }
     catch(Exception e)
     {
          System.out.println(e);
     }
}
public static void  displayAllRecord()
{
     try
     {
          Class.forName("com.mysql.jdbc.Driver");
          String url ="jdbc:mysql://localhost:3306/emp";
          Connection con1 = DriverManager.getConnection(url,"root","123456");

          s=con1.createStatement();
          rs=s.executeQuery("Select * from employee");
          rsmdt=rs.getMetaData();
          System.out.println(rsmdt.getColumnCount());
          for(int i=1;i<rsmdt.getColumnCount();i++)
          {
               System.out.print(rsmdt.getColumnName(i)+"||");
          }
          System.out.println();
          System.out.println("==============================================");
     
          while(rs.next())
          {
               System.out.println();
               System.out.print(rs.getString(1)+" || ");
               System.out.print(rs.getString(2)+" || ");
               System.out.print(rs.getString(3)+" || ");
               System.out.print(rs.getString(4)+" || ");
               System.out.print(rs.getString(5)+" || ");
          }
     }
     catch(Exception e)
     {
          System.out.println(e);
     }
}
}

BACK

Prepared By:

Student of B. H. Gardi College of Eng. & Tech., MCA Department

(Nisarg Juthani, Kajal Savjani, Desai Paresh, Ramoliya Nilesh, Thanki Ravi.....)

Programming Skills – VII (WTAD) 640012 p2

2011-05-08T12:12:00.000+05:30

Write a Servlet to display all the headers available from request

//----------
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;

public class requestheader extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res) throws   ServletException,IOException
{
res.setContentType("text/html");
PrintWriter out= res.getWriter();
out.println("<HTML>\n" +" <head> <title> TABLE OF REQUEST HEADERS</title></head>\n"
                    + "<body> <h1> TABLE OF REQUEST HEADERS</h1><b>REQUEST METHOD : </b>"+req.getMethod()
                      +"<b>REQUEST URI :</B>" + req.getRequestURI()
                      + " <b> REQUEST PROTOCOL </B> "+ req.getProtocol()
                     +"<table border=1 align=\*CENTER\*> \n <tr> <th>HEADER NAME </th><th> HEADER VALUE </th>");
Enumeration headers =req.getHeaderNames();
while(headers.hasMoreElements())
{
String headnam = (String)headers.nextElement();
out.prinln("<tr><td>" + headers);
out.println("<TR><TD>" + req.getHeader(headnam));
}
}
}

Write a Servlet to display parameters available on request.

//----------
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class paramvalue extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res) extends ServetException,IOException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
String title="Reading All Request parameters";
Enumeration params =req.getParametersNames();
while(params.hasMoreElements())
{
 String pnam = (String)params.nextElement();
 out.prinln("<tr><td>" + pnam);
 out.println("<TR><TD>" + req.getParameter(pnam));
}
}
}

Write a Servlet to display all the attributes available from request and context.

//----------
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class ShowRequestAndSessionAttributes extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res)
throws IOException,ServletException{

 res.setContentType("text/html");
 PrintWriter out=res.getWriter();
 out.println("<hrml><body><br><br>");


 //Request Attributes....
 req.setAttribute("name","Rakesh");
 req.setAttribute("course","MCA");
 req.setAttribute("collage","LD Engineering");

 Enumeration nameOfAttrib=req.getAttributeNames();
 out.println("<table border='1'><tr><th colspan=2>List of all request Attributes</th></tr>");
 out.println("<tr><td>Attribute Name</td><td>Attribute Value</td></tr>");

 String attribName;
 while(nameOfAttrib.hasMoreElements())
 {
     attribName=(String)nameOfAttrib.nextElement();
     out.println("<tr><td>"+attribName+"</td><td>");
     Object obj=req.getAttribute(attribName);
     out.println(""+obj+"</td><tr>");
 }
 out.println("</table>");


 //Context attributes..
 ServletContext con=getServletContext();

 con.setAttribute("Enrollement Number","095160693024");
 con.setAttribute("Seat Number","c-456464");


 out.println("<br><br>");
 Enumeration contextAttrib=con.getAttributeNames();
 out.println("<table border='1'><tr><th colspan=2>List of all Session Attributes</th></tr>");
 out.println("<tr><td>Attribute Name</td><td>Attribute Value</td></tr>");

 while(contextAttrib.hasMoreElements())
 {
     attribName=(String)contextAttrib.nextElement();
     out.println("<tr><td>"+attribName+"</td><td>");
     Object obj=con.getAttribute(attribName);
     out.println(""+obj+"</td><tr>");
 }
 out.println("</table>");
 out.println("</body></html>");
}

public void doPost(HttpServletRequest req,HttpServletResponse res)
 throws IOException,ServletException{
     doGet(req,res);
}
}

Write a Servlet which displays a message and also displays how many times the message has been displayed (how many times the page has been visited).

//----------
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class accesscounter extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res) throws  ServletException,IOException
{
String count=CookieUtilities.getCookieValue(req,"AccessCount","1");
int count=1;
try
{
 count=Integer.parseInt(countString);
}
catch(NumberFormatException nfe)
{}
LongLiveCookie c=new LongLiveCookie("accessCount",String.valueOf(count+1));
res.addCookie(c);
res.setContentType("text/html");
printWriter out=res.getWriter();
String title="Access Count Servlet";
out.println("<html> \n" + "<head> <title> message </title> </head>\n" + "<h2>This is visit  number "+ count + "by this browser.</h2>\n" + "</html>");
}
}

Assume that we have got three pdf files for the MCA-1 Syllabus, MCA-2 Syllabus and MCA-3 Syllabus respectively, Now write a Servlet which displays the appropriate PDF file to the client, by looking at a request parameter for the year (1, 2 or 3).

//----------
Html file
------------
<html>
<head>
<title>Untitled Document</title>
</head>
<body>
<form action="http://localhost:8080/GTU/Ex15" method="get">
<table>
<tr>
 <th>Select semester to download syllabus</th>
</tr>
<tr>
 <td>
     <select name="sem">
         <option value="Semester1">Semester1</option>
         <option value="Semester2">Semester2</option>
         <option value="Semester3">Semester3</option>
     </select>
 </td>
</tr>
<tr>
 <td><input type="submit" value="Download"></td>
</tr>
</table>
</form>
</body>
</html>

Servlet File ::
---------------

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

public class Ex15 extends HttpServlet {
public void doGet(HttpServletRequest req,
         HttpServletResponse res)
throws ServletException, IOException {
 res.setContentType("text/html");
 PrintWriter out = res.getWriter();
 out.println("<body><br><br><br><table border=1 align='center'>");

 String[] paramValues = req.getParameterValues("sem");
 String semValue=paramValues[0];
 if(semValue.equals("Semester1"))
 {
     res.sendRedirect("http://gtu.ac.in/syllabus/MCA/MCA%20SEM-1,2%20DETAILED%20SCHEME_SYLLABUS.zip");
 }
 else if(semValue.equals("Semester2"))
 {
     res.sendRedirect("http://gtu.ac.in/syllabus/MCA/MCA%20SEM-1,2%20DETAILED%20SCHEME_SYLLABUS.zip");
 }
 else if(semValue.equals("Semester3"))
 {
     res.sendRedirect("http://gtu.ac.in/syllabus/MCA/MCA_SEM_-_III_&_SEM_IV_Syllabus.zip");
 }
 else
 {
     out.println("Some problem in redirecting the page");
     //out.println(semValue);
 }
 out.println("</table></body></html>");
}

}

Assume that the information regarding the marks for all the subjects of a student in the last exam are available in a database, Develop a Servlet which takes the enrollment number of a student as a request parameter and displays the marksheet for the student.

//----------
HTML FILE ::
------------

<html>
<head>
<title>Untitled Document</title>
</head>
<script language="javascript">
function validate()
{
//alert(document.getElementById(1).value);
if(document.getElementById(1).value=="")
{
alert("Pleas enter enrollment number");
return false;
}
return true;
}
</script>
<body>
<table width="20%">
<form action="http://localhost:8080/GTU/Ex16" method="get" onSubmit="return validate();">
<tr>
<td>Enter Enrollment Number</td>
</tr>
<tr>
<td><input type="text" name="enum" id=1></td>
</tr>
<tr>
<td><input type="submit"></td>
</tr>
</form>
</table>
</body>
</html>

Servlet File…
-------------

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

public class Ex16 extends HttpServlet{
public void doGet(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{

res.setContentType("text/html");
PrintWriter out=res.getWriter();
out.println("<html><body>");
String eNum=req.getParameter("enum");
/*out.println("<h2>"+eNum+"</h2>");
String myQuery="SELECT* FROM stud";
out.println("<h2>"+myQuery+"</h2>");
*/
try
{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 Connection con = DriverManager.getConnection("JDBC:ODBC:DATASOURCE");  
 Statement s=con.createStatement();
 s.executeQuery("Select * from result where EnrollNum='"+eNum+"'");
 ResultSet rs=s.getResultSet();
 rs.next();
 if(rs!=null)
 {

         out.println("<table border=1>");
         out.println("<tr><td>Roll No</td><td>"+rs.getString(2)+"</td></tr>");
         out.println("<tr><td>Name</td><td>"+rs.getString(3)+"</td></tr>");
         out.println("<tr><td>Subject1</td><td>"+rs.getString(4)+"</td></tr>");
         out.println("<tr><td> Subject2</td><td>"+rs.getString(5)+"</td></tr>");
         out.println("<tr><td> Subject3</td><td>"+rs.getString(6)+"</td></tr>");
         out.println("<tr><td> Subject4</td><td>"+rs.getString(7)+"</td></tr>");
         out.println("<tr><td>spi</td><td>"+rs.getString(8)+"</td></tr>");
         out.println("</table>");
 }
 out.println("</body></html>");
}catch (Exception err) {
         System.out.println( "Error: " + err );
}
}
}

Devlop A Servlet to which looks for cookies for username and Password, and forword to a home.jsp in case the cookies are valid and forword to a login.jsp in case the cookies are not found or the cookies are not valid.

//----------
Servlet ::
----------

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

class authorised extends HttpServlet
{
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
int cnt=0;
String userid="cuid";
String password="cpwd";
String uid=req.getParameter("txtuid");
String pwd=req.getParameter("txtpwd");
Cookie[] cookies=req.getCookies();
if(cookies != null)
{
 for(int i=0;i<cookies.length;i++)
 {
     if((userid.equals(cookies[i].getName())) &&(uid.equals(cookies[i].getValue())))
     {
         cnt++;
     }
     if((password.equals(cookies[i].getName())) &&(pwd.equals(cookies[i].getValue())))
     {
         cnt++;
     }
 }
 if(cnt==2)
 {
 res.sendRedirect("http://localhost:8080/wtad/jspfiles/home.jsp");
 }
 else
 {
     Cookie uidc=new Cookie(userid,uid);
     Cookie pwdc=new Cookie(password,pwd);

     res.addCookie(uidc);
     res.addCookie(pwdc);
 res.sendRedirect("http://localhost:8080/wtad/jspfiles/login.jsp");
 }
}
}
}

HOME.JSP ::
-----------

<html>
<head>
<title>Hello WElcome to the Home page</title>
</head>
<body>
Hello WElcome to the Home page
</body>
</html>

LOGIN.JSP  ::
-------------

<!-- login file for session tracting program 18 -->
<html>
<head>
<title>
 login page
</title>
</head>
<body>
<form name="frmlogin"action="http://localhost:8080/wtad/authorised" method="post"
<center><B>User Id :: </B> <input type="text" name="txtid"><br>
<B>PassWord :: </B><input type="password" nam="txtpwd"><br>
 <input type="submit" name="cmdsend" value="Log In">

 <input type="reset" name="cmdclear" value="Clear"></center>
</form>
</body>
</html>

Devlop a Servlet to authenticate a user,where the login id and password are available as request parameter.In case the authentication is successful,it should setup a new session and store the user’s information in the session before forwarding to home.jsp, which displays a user informations.

//----------
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

class authoriseds extends HttpServlet
{
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
int cnt=0;
String userid="suid";
String password="spwd";
String uid=req.getParameter("txtuid");
String pwd=req.getParameter("txtpwd");
HttpSession session = request.getSession(true);
if(uid.equals(session.getValue(userid)) && pwd.equals(session.getValue(password)))
{
 res.sendRedirect("http://localhost:8080/wtad/jspfiles/home.jsp");
}
else
{
 session.addValue(userid,uid);
 session.addValue(password,pwd);
 res.sendRedirect("http://localhost:8080/wtad/jspfiles/login.jsp");
}
}
}

Write a simple JSP pages to display a simple message.

//----------
<html>
<head>
<title> JSP PAGE WITH DISPLAY HELLO WORLD</title>
</head>
<body>
<%! String msg="Hello World..."; %>
<center><h3 color="pink"> <%= msg %> </h3>
</body>
</html>

Write A JSP Page, which uses the include directive to show its header and footer

//----------
<!-- Write A JSP Page, which uses the include directive to show its header and footer -->

<html>
<head>
<title>  </title>
</head>
<body>
<table border="1" align="center" cellpadding="0" cellspacing="0">
 <tr>
     <td align="center" id="header">
         <%@ include file="header.jsp" %>
     </td>
 </tr>
 <tr height="500">
     <td>

     </td>

 </tr>

 <tr>
     <td align="right" id="footer">
         <%@ include file="footer.jsp" %>
     </td>
 </tr>
</table>
</body>
</html>
HEADER.JSP ::
<html>
<head>
<title>
 Header Page for Applictaion
</title>
</head>
<body>
<table>
 <tr>
     <td colspan=4> Appication Names </td>
 </tr>
 <tr>
     <td>link1</td>
     <td>link2</td>
     <td>link3</td>
     <td>link4</td>
 </tr>
</table>
</body>
</html>
FOOTER.JSP ::
<html>
<body>
<table align="right" cellpadding="0" cellspacing="5" border="0">
<tr align="right">
<td>link1 | </td>
<td>link2 | </td>
<td>link3 | </td>
<td>link4 | </td>
</tr>
<tr align="right">
     <td align="left" colspan="2"> Site Visited : </td>
     <td colspan="8">© 2000-2011 Application</td>
</tr></table>
</body>
</html>

BACK NEXT

Prepared By:

Student of B. H. Gardi College of Eng. & Tech., MCA Department

(Nisarg Juthani, Kajal Savjani, Desai Paresh, Ramoliya Nilesh, Thanki Ravi.....)

Programming Skills – VII (WTAD) 640012 p1

2011-03-30T08:16:00.000+05:30

Write a JavaScript that shows how a variable’s type can be changed on-the-fly.

//----------
<html>
<head>
<title>Tutorial - 1</title>
</head>
<body>
<script language="javascript">
var n=10
document.writeln("<font size=5> value of variable N :: " + n + "</font><br>");
n=prompt("Input any string you want:","JAVA");
document.writeln("<font size=5>value of variable N :: " + n);
</script>
</body>
</html>

Write a JavaScript that demonstrates the use of +=,-=,*=,/= operators.

//----------
<html>
<head>
<title>Tutorial - 1</title>
</head>
<body>
<script language="javascript">
var n1 = 26;
var n2=parseInt(prompt("Input any Integer No to N2:"));
n1+=n2;
document.write("<font size=4> Value of n1 after Addition is " +n1+"</font></br>");
n1-=n2;
document.write("<font size=4> Value of n1 after Substraction is "+n1+"</font></br>");
n1*=n2;   document.write("<font size=4> Value of n1 after Multiplication "+n1+"</font></br>");
n1/=n2;
document.write("<font size=4> Value of n1 after  Division "+n1+"</font></br>");
</script>
</body>
</html>

Create a form in html with two fields,minimum and maximum. Write javascript to validate that only numeric value is entered in both,and the value entered in minimum is less than the value in maximum.

//----------
<html>
<head>
<script language="javascript">
function checkNums(e)
{
try
{
var unicode;
if(window.event)
unicode=e.keyCode;
else if(e.which)
unicode=e.which;

if(((unicode<48) || (unicode>57)) && (unicode!=8))
return false;
else
return true;

}

catch(err)
{
txt="There was an error on this page.\n";
txt+="Error description: " + err.description + "\n";
txt+="Click OK to continue.\n";
alert(txt);
}
}
function checkmax(n1,n2)
{
n1=parseInt(n1);
n2=parseInt(n2);
if(n1>n2)
{
alert("minimumm value should not exceed maximum value");
maxval.setFocus;
}
}
</script>
<body>
<form action="" name="valueCheck" method="">
Minimum Value :: <input type="text" name="minval" onKeyPress="return checkNums(event);" />
Maximum Value :: <input type="text" name="maxval" onKeyPress="return checkNums(event);" onBlur="checkmax(minval.value,maxval.value);" />
</form>

</body>
</html>

Write a JavaScript that finds out multiples of 10 in 0 to 10000. On the click of button start the timer and stop the counter after 10 seconds. Display on the screen how many multiples of 10 are found out within stipulated time.

//----------
<html>
<head>
<title>Tutorial 1</title>
</head>
<body>
<input type=button value="start" onclick="win();" />
<script language="javascript">
function win()
{
t=window.setTimeout("s();",1000);
}
function s()
{
try
{
 v=10;
 sum=0;
 for(i=0;i<=10000;i++);
 {
  sum=v*i;   
  document.writeln("<br> Mutiple Of 10:"+sum);
 }
}
catch(err)
{
 txt="There was an error on this page.\n";
 txt+="Error description: " + err.description + "\n";
 txt+="Click OK to continue.\n";
 alert(txt);
}
}
</script>
</body>
</html>

Write A javascript to generate two Random Numbers and find out minimum and maximum out of it

//----------
<html>
<head>
<title>Tutorial 1</title>
</head>
<body>
<Script language="javascript">
try
{
n1=(Math.random()*12);
n2=(Math.random()*12);
document.writeln("<font size=5> First Random Number is :: " + n1 + "</font><br>");
document.writeln("<font size=5> Second Random Number is :: " + n2 + "</font><br>");
if(n1>n2)
 document.writeln("<font size=5> N1 is Maximum</font>");
else
 document.writeln("<font size=5> N2 is Minimum</font>");
}

catch(err)
{
txt="There was an error on this page.\n";
txt+="Error description: " + err.description + "\n";
txt+="Click OK to continue.\n";
alert(txt);
}
</script>
</body>
</html>

Write a JavaScript to remove the highest element from the array and arrange the array in ascending order.

//----------
<html>
<head>
<script type="text/javascript">
var a=new Array();
function funadd()
{

   a.push(parseInt(document.frm.txtdata.value));
   document.getElementById("pera").innerHTML=a;
   document.frm.txtdata.value="";
   document.frm.txtdata.focus();

}
function funremove()
{

   var l=a.length;
   for(i=0;i<=l;i++)
   {
       for(j=i+1;j<l;j++)
       {
           if(a[i]>a[j])
           {
               t=a[i];
               a[i]=a[j];
               a[j]=t;
           }
       }
   }
   alert("The deleted element is: "+a.splice(l-1,1));
   document.getElementById("msg").innerHTML="<b><u>Sorted Array:</u></b>";
   document.getElementById("sortdata").innerHTML=a;
}

</script>
</head>
<body>
<form name=frm>
<input type="text" id="txtdata">
<input type=button value="ADD" onclick="funadd();">
<input type=button value="REMOVE" onclick="funremove();">
</br>
</br>
<b><u>Elements In Array:</u></b>
</form>
<p id=pera></p>
<p id=Msg></p>
<p id=sortdata></p>
</body>
</html>

Write a JavaScript to convert Celsius to Fahrenheit.

//----------
<html>
<body>
<form name="mywin">
<input type="text" name="txt1" />
<input type="button" name="click" value="Compute" onClick="win();"/>
</form>

<script language="javascript">
function win()
{
var v=document.mywin.txt1.value;
var f=0;
f=(v*1.8)+32;
alert(f);
}
</script>
</body>
</html>

Write a JavaScript to find a string from the given text. If the match is found then replace it with another string

//----------
<html>
<head>
<script type="text/javascript">
function findout(form)
{
var str=new String(form.strng.value);
form.strng.value=str.replace(form.find.value,form.replace.value);  
}
</script>
</head>

<body >
<form>
Enter a Text : <input type="text" name="strng" size=50><br/><br/>
Word to find : <input type="text" name="find" ><br/>
Word to Replace : <input type="text" name="replace"><br/>
<input type="button" value="REPLACE" onClick="findout(this.form)">
</form>
</body>
</html>

Write a JavaScript to show a pop up window with a message Hello and background color lime and with solid black border.

//----------
<html>
<head>
<title>JavaScript Popup Example</title>
</head>
<script type="text/javascript">
function poponload()
{
testwindow = window.open("", "mywindow", "location=1,status=1,scrollbars=1,width=300,height=100,border:2px solid #ffffff;");
testwindow.moveTo(200, 200);
testwindow.document.write('<h1>HELLO!</h1>');
testwindow.document.bgColor = "#BFFF00";
}
</script>

<body onload="poponload()">
<h1>JavaScript Popup Example 3</h1>
</body>
</html>

Write a Servlet to display "Hello World" on browser

//----------
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class HelloWorld extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res)
 throws IOException,ServletException
{
PrintWriter out=res.getWriter();
out.println("Hello World");
}
}

NEXT

Prepared By:

Student of B. H. Gardi College of Eng. & Tech., MCA Department

(Nisarg Juthani, Kajal Savjani, Desai Paresh, Ramoliya Nilesh, Thanki Ravi.....)

MCA 5 Test Result (Batch : 2009-2012)

2011-03-02T14:04:00.000+05:30

ID No	Name	T1 (25)	10	T2 (30)	10	AVG
01MCA09	Amrutiya Sandhya D.		0	17	6	3
03MCA09	Bhut Vishalkumar K.	12	5		0	3
04MCA09	Chakravarti Mithun V.	0	0	16	5	3
09MCA09	Dave Manishkumar O.	12	5	18	6	6
11MCA09	Desai Paresh C.	18	7	21	7	7
14MCA09	Dharsandiya Nikita		0	18	6	3
15MCA09	Dharsandiya Shruti J.	9	4	12	4	4
16MCA09	Fuletra Dipali A.	11	4	17	6	5
19MCA09	Ghodasara Nimesh N.	12	5	11	4	5
20MCA09	Godhasara Harish C.	12	5	20	7	6
21MCA09	Goradiya Janki	7	3		0	2
22MCA09	Hudka Palmi	11	4	17	6	5
23MCA09	Joshi Brijesh U.	13	5	12	4	5
25MCA09	Juthani Nisarg C.	18	7	18	6	7
26MCA09	Kadvani Ankit P.		0	13	4	2
27MCA09	Kansagara Arjun S.		0	15	5	3
28MCA09	Katira Rutu B.	10	4	10	3	4
29MCA09	Khant Khushal	13	5	18	6	6
30MCA09	Khetiya Chintan J.	12	5	17	6	6
33MCA09	Maru Divyaben S.	10	4	17	6	5
34MCA09	Mehta Nidhi N.	7	3	17	6	5
35MCA09	Mehta Madhuri K.	18	7	14	5	6
41MCA09	Parekh Pooja	7	3	18	6	5
45MCA09	Patel Sagar H.	13	5	14	5	5
46MCA09	Ramoliya Nileshkumar P.	16	6		0	3
47MCA09	Rughani Chintan P.		0		0	0
48MCA09	Sarvaiya Vijay H.	12	5	13	4	5
49MCA09	Savaliya Kapil J.	11	4		0	2
50MCA09	Savjani Kajal	10	4	19	6	5
53MCA09	Sisodiya Nilesh B.	15	6	16	5	6
54MCA09	Solanki Yagnik H.	13	5	18	6	6
55MCA09	Thanki Ravi	12	5	10	3	4
56MCA09	Vora Jinesh N.	11	4	21	7	6
57MCA09	Vyas Grishma S.		0	13	4	2
58MCA09	Vyas Vaibhavi A.	7	3	10	3	3
59MCA09	Zala Mayursinh	10	4	14	5	5

Object Oriented Concepts and Programming - OOCP

2011-02-15T13:17:00.000+05:30

Syllabus
1. Object Oriented Concepts and Programming (OOCP) - 620003
2. Programming Skills - III (OOCP) - 620004
Material
1. C++ Complete Reference Download
Assignments
1. Object Oriented Concepts and Programming - Assignment 1
2. Object Oriented Concepts and Programming - Assignment 2
3. Object Oriented Concepts and Programming - Assignment 3
4. Object Oriented Concepts and Programming - Assignment 4
Tutorials/Program
1. Object Oriented Concepts and Programming - Tutorial 1
2. Object Oriented Concepts and Programming - Tutorial 2
3. Object Oriented Concepts and Programming - Tutorial 3
4. Object Oriented Concepts and Programming - Tutorial 4
5. Object Oriented Concepts and Programming - Tutorial 5
6. Object Oriented Concepts and Programming - Tutorial 6
7. Object Oriented Concepts and Programming - Tutorial 7
8. Object Oriented Concepts and Programming - Tutorial 8
9. Object Oriented Concepts and Programming - Tutorial 9
10. Object Oriented Concepts and Programming - Tutorial 10

Tutorials/Program Solution By Gardi Vidyapith Students
1. Tutorial Solution By Savan Patel - Download New
2. Tutorial Solution By Piyush Sutariya - Download New
3. Tutorial Solution By Rahul Bhayani - Download New
4. Tutorial Solution By Nilesh Tejani - Download New
5. Tutorial Solution By Naresh Parmar - Download New
Test
1. Object Oriented Concepts and Programming - Test 1
2. Object Oriented Concepts and Programming - Test 2
OOCP Question Set
1. Object Oriented Concepts and Programming - Question Set 1
2. Object Oriented Concepts and Programming - Question Set 2
3. Object Oriented Concepts and Programming - Question Set 3

For any query related to OOCP make comment on this page.

OOCP Question List
1. Questions Chapterwise New
2. Questions from old Papers New

Web Technology & Application Development (WTAD)

2011-02-01T12:57:00.000+05:30

Syllabus
1. Web Technology & Application Development (WTAD)- 640004
2. Programming Skills - VII (WTAD)- 640012
Material
1. HTML TAG Detail Download New
2. HTML Material Download New
3. Core Servlets and JavaServer Pages - VOL 1
4. Core Servlets and JavaServer Pages - VOL 2
5. RFC 2616 HTTP/1.1 Protocol Download
6. Servlet Specifications 3.0 Download
7. Servlet-3_0-final-javadoc Download
8. Unit -10 (New features in Servlet 3.0 - annotation, File Upload, Internationalization, Asynchronuous execution of processing) Download New
9. WTAD PPT New
Assignments - Download All in One File New
1. Web Technology & Application Development (WTAD) - Assignment 1
2. Web Technology & Application Development (WTAD) - Assignment 2
3. Web Technology & Application Development (WTAD) - Assignment 3
4. Web Technology & Application Development (WTAD) - Assignment 4
5. Web Technology & Application Development (WTAD) - Assignment 5
6. Web Technology & Application Development (WTAD) - Assignment 6
7. Web Technology & Application Development (WTAD) - Assignment 7
8. Web Technology & Application Development (WTAD) - Assignment 8
9. Web Technology & Application Development (WTAD) - Assignment 9
Tutorials/Programs
1. Web Technology & Application Development (WTAD) - Tutorial 1
2. Web Technology & Application Development (WTAD) - Tutorial 2
3. Web Technology & Application Development (WTAD) - Tutorial 3
4. Web Technology & Application Development (WTAD) - Tutorial 4
5. Web Technology & Application Development (WTAD) - Tutorial 5
6. Web Technology & Application Development (WTAD) - Tutorial 6
7. Web Technology & Application Development (WTAD) - Tutorial 7
8. Web Technology & Application Development (WTAD) - Tutorial 8
9. Web Technology & Application Development (WTAD) - Tutorial 9
WTAD Old Question Papers
1. 640002 (Jun-2011) (Regular) - Download New
2. 640002 (Dec-2011) (Remedial) - Download New
3. 640002_Gardi Internal (MAR – 2011) - Download
4. 640002_Gardi MID Sem (April – 2011) - Download
5. 640002_Gardi REMEDIAL (April – 2011) - Download
6. 640002_Gardi PRE GTU (April – 2011) - Download New
Tutorial Solution

Test
1. Web Technology & Application Development (WTAD) - Test 1
2. Web Technology & Application Development (WTAD) - Test 2
WTAD Class Programs/Examples Download New
JDBC Drivers (MySql and Oracle) Download New
For any query related to WTAD make comment on this page.

Differenciate: Java Application and Java Applet

2010-12-21T14:02:00.001+05:30

Java Application:

Must be installed on local machine.
Must be run explicitly within a java compatible machine.
Can run with or without a graphical user.
Starts execution with its main method.
Once stared, manages its own flow of control.
Has no inherent security restriction.

Java Applet:

Need no explicit installation on local machine.
Loads and runs it at automatically in a java enabled browser.
Must run within a graphical user interface.
Starts execution with its init method.
Has its flow of executing determined partly by its browser context.
Has significant security controls to prevent poorly written applets from harming the user’s system.