Smarty

React Native Developer

  • Home
  • Buy Smart Phone
  • YouTube
  • honda sp 125

Saturday, March 23, 2019

Home / GTU JWT PRACTICAL / JWT PRACTICAL GTU

JWT PRACTICAL GTU

by SmartSpy on March 23, 2019 in GTU JWT PRACTICAL


Lab Manual
On
Subject Name: Java Web Technology (4649305)

M.C.A. – 4th Semester    





Submitted By :                                                                   Paresh Chavda                                                                            

DBMS ALL PRACTICAL SET DOWNLOAD



Practical List

11)    Write a Servlet to display “Hello World” on browser.

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ResourceBundle;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Hello extends HttpServlet {

    private static final long serialVersionUID = 1L;

    @Override
    public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
        ResourceBundle rb =
            ResourceBundle.getBundle("LocalStrings",request.getLocale());
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();

        out.println("<html>");
        out.println("<head>");

        String title = rb.getString("helloworld.title");

        out.println("<title>" + title + "</title>");
        out.println("</head>");
        out.println("<body bgcolor=\"white\">");

    

        out.println("<a href=\"../helloworld.html\">");
        out.println("<img src=\"../images/code.gif\" height=24 " +
                    "width=24 align=right border=0 alt=\"view code\"></a>");
        out.println("<a href=\"../index.html\">");
        out.println("<img src=\"../images/return.gif\" height=24 " +
                    "width=24 align=right border=0 alt=\"return\"></a>");
        out.println("<h1>" + title + "</h1>");
        out.println("</body>");
        out.println("</html>");
    }
}

* Xml File
<servlet>
        <servlet-name>Hello</servlet-name>
        <servlet-class>Hello</servlet-class>
    </servlet>

<servlet-mapping>
        <servlet-name>Hello</servlet-name>
        <url-pattern>/Hello</url-pattern>
    </servlet-mapping>

Output


22)    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 headerjwt extends HttpServlet {

    public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws IOException, ServletException
    {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();

            String title="header Title for jwt";
           
            out.println("<HTML>\n" +
            "<HEAD><TITLE>" + title +" </TITLE></HEAD>\n" +
            "<BODY BGCOLOR=\"#FDFSE6\">\n" +
            "<H1 align=\"CENTER\">" + title +"</H1>\n" +
           
            "<B> Request method:</B>" +
           
            request.getMethod() +"<BR>\n" +
            "<B> Request URI:</B>"+
           
            request.getRequestURL()+ "<BR>\n"+
            "<B> Request Protocol:</B> "+

        request.getProtocol()+"<BR>\n"+
            "<TABLE BORDER=1 ALIGN=\"CENTER\">\n"+
           
            "<TR BGCOLOR=\"#FFAD00\">\n"+
            "<TH>Header Name</TH>Header value</TR>");

            Enumeration headerNames=request.getHeaderNames();
            //Enumeration headerEnumeration = headers.getAllHeaders();                         
            while(headerNames.hasMoreElements())
            {
            String headerName=(String)headerNames.nextElement();
                        out.println("<TR><TD>"+headerName);
                        out.println("</TD></TR>"+request.getHeader(headerName));
            }
            out.println("</TABLE>\n</BODY></HTML>");
    }
}
           
                                    Output



33)    Write a Servlet to display parameters available on request.

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
public class Gtu3 extends HttpServlet {

    public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws IOException, ServletException
    {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
            //out.println("<br><b>User:</b>:"+ request.getParameter("usr")+"<br><b>Password</b>:"+ request.getParameter("pwd")+"");
            out.println("<html><head><title>Write a Servlet to display parameters available on request. .</title></head><body><center><h1>write a Servlet to display parameters available on request.</h1></center><br><br>");
                        //display haeder name and value in table format
            out.println("<table border=1>");
            out.println("<tr><th>Parameter name</th><th>parameter values</th></tr>");
            Enumeration e=request.getParameterNames();
            while(e.hasMoreElements())
            {
                        String header_name=(String) e.nextElement();
                        String header_value=(String)request.getParameter(header_name);
                        out.println("<tr><td><b>"+header_name+"</b></td><td>"+header_value+"</td></tr>");
            }
            out.println("</table>");
            out.println("</body></html>");

}
}


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

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
public class gtu4 extends HttpServlet {
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
 response.setContentType("text/html");
 PrintWriter out = response.getWriter();

out.println("<html><head><title>Write a Servlet to display all the
attributes available from request and context.</title></head>");
out.println("<table border=1>");
out.println("<tr><th>Request Context</th><th>Parameter
values</th></tr>");

out.println("<tr><td><b>"+"Local Name:getLocalName()"
+"</b></td><td>"+request.getLocalName()+"</td></tr>");
out.println("<tr><td><b>"+"Local Port:getLocalPort()"
+"</b></td><td>"+request.getLocalPort()+"</td></tr>");
//out.println("<tr><td><b>"+"Protocol:getLocalProtocol()"
+"</b></td><td>"+request.getLocalProtocol()+"</td></tr>");
out.println("<tr><td><b>"+"Remote Address:getLocalAddr()"
+"</b></td><td>"+request.getLocalAddr()+"</td></tr>");
out.println("<tr><td><b>"+"Server Name :getServerName()"
+"</b></td><td>"+request.getServerName()+"</td></tr>");
out.println("<tr><td><b>"+"Server Port :getServerPort()"
+"</b></td><td>"+request.getServerPort()+"</td></tr>");
out.println("<tr><td><b>"+"Char
Encoding:getCharacterEncoding()"
+"</b></td><td>"+request.getCharacterEncoding()+"</td></tr>");

out.println("<tr><td><b>"+"Content Type:getContentType()"
+"</b></td><td>"+request.getContentType()+"</td></tr>");
out.println("<tr><td><b>"+"Context Length:getContentLength()"
+"</b></td><td>"+request.getContentLength()+"</td></tr>");

out.println("</table>");
out.println("</body></html>");
}
}
Web.xml
<servlet>
 <servlet-name>gtu4</servlet-name>
 <servlet-class>gtu4</servlet-class>
</servlet>
<servlet-mapping>
 <servlet-name>gtu4</servlet-name>
 <url-pattern>/gtu4</url-pattern>
</servlet-mapping>

Output:















5. 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 java.util.*;

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

public class q5 extends HttpServlet

{

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

PrintWriter out = res.getWriter(); Cookie[] myCookie = req.getCookies(); boolean found = false; int v=0;

if(myCookie !=null)

{
for(int i=0; i<myCookie.length;i++)

{

if(myCookie[i].getName().equals("pageCount"))
{

v=Integer.parseInt(myCookie[i].getValue());

v++;

Cookie c1 = new Cookie("pageCount",String.valueOf(v));
res.addCookie(c1);

out.println("visit No:"+v);

found=true;

break;
}

}

}

if(found==false)
{

Cookie c1 =new Cookie("pageCount",String.valueOf(v));
res.addCookie(c1);

out.println("<h1>Welcome to gtu Program 3</h1>");
}

}

}

Web.xml

<servlet>

<servlet-name>q5</servlet-name>

<servlet-class>q5</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>q5</servlet-name>

<url-pattern>/q5</url-pattern>

</servlet-mapping>
output:












6)  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).


gtu6.html
<html>
<body>
<h2>
            GTU MCA SEM - 4 SYLLABUS LIST
</h2>
<form action="http://localhost:8080/paresh/gtu6" method="GET">
<table border=1>
<tr>
            <td>
                        Your Name:
            </td>
            <input type="text" name="name">
</tr>
<tr>
            <td>
                        select pdf:
            </td>
            <td>
                        <select name="sem">
                        <option value="mca-1.pdf"> mca-1</option>
                        <option value="mca-2.pdf"> mca-2</option>
                        <option value="mca-3.pdf"> mca-3</option>
                        </select>
            </td>
</tr>

            <colspan=2 align="center">
            <input type ="submit" value ="show">
</table>
</form>
</body>
</html>

 OR
<html>
<body>
<h2>GTU 6</h2>
<form action="http://localhost:8080/paresh/gtu6" method="GET">
<table>
<tr>
<td>Your Subject Code:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>
Select PDF :
</td>
<td>
<select name="sem">
<option value="CN.pdf">4649301</option>
<option value="stats.pdf">4649302</option>
<option value="mc.pdf">4649303</option>
<option value="PROJECT.pdf">4649304</option>
<option value="JWT.pdf">4649305</option>
</select>
</td>
</tr>
<td colspan="2" align="center">
<input type="submit" value="Select File">
</td>
</table>
</form>
</body>
</html>


gtu6.java
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class gtu6 extends HttpServlet {

    private static final long serialVersionUID = 1L;

    @Override
    public void doGet(HttpServletRequest req,
                      HttpServletResponse res)
        throws IOException, ServletException
    {
      res.setContentType("application/pdf");
       PrintWriter out = res.getWriter();
            String name=req.getParameter("sem");
            res.sendRedirect(name);      
    }
}

web.xml

<servlet>
<servlet-name>gtu6</servlet-name>
<servlet-class>gtu6</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>gtu6</servlet-name>
<url-pattern>/gtu6</url-pattern>
</servlet-mapping>

output:

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


public class gtu66 extends HttpServlet {

    private static final long serialVersionUID = 1L;

    @Override
    public void doGet(HttpServletRequest req,
                      HttpServletResponse res)
        throws IOException, ServletException
    {
      res.setContentType("text/html");
       PrintWriter out = res.getWriter();
            String st = "Load PDF files";
            out.println("<title>"+st+"</title><body><center>");
            out.println("<form method =POST>");
            out.println("<select size=1 name=syll><br><br>");
            out.println("<option>mca1</option>");
            out.println("<option>mca2</option>");
            out.println("<option>mca3</option>");
            out.println("</select><br><br>");
            out.println("<input type=submit value=show>");
            out.println("</form>");
            out.println("</center></body>");
           
            }
            public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
            {
                        String st=request.getParameter("syll");
                        response.setContentType("application/pdf");
                        if(st.equals("mca1"))
                        {
                                    response.sendRedirect("./mca-1.pdf");       
                        }
                        else if(st.equals("mca2"))
                        {
                                    response.sendRedirect("./mca-2.pdf");       
                        }
                        else if(st.equals("mca3"))
                        {
                                    response.sendRedirect("./mca-3.pdf");       
                        }
            }
}


16)  GTU jwt Practical 8

<html>

  <head>
  <title>GTU jwt Practical 7</title>
 </head>
 <body>

 <h2 align="center"> GTU jwt Practical 8 :  </h2>



  <table>
  <tr>
   <th>Student Result</th>
  </tr>
  <tr>
  <td>
  <form action="../gtu7dbs" method="get">
   Enrollment Number : 
   <input type="text" name="par1" value="">
   
   <input type="submit" value="submit">
  </form>
  </td>
  </tr>
  </table>
 </body>
</html>

gtu7dbs.java

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

public class prg7 extends HttpServlet {

public void doPost(HttpServletRequest req, HttpServletResponse res)
throws IOException,ServletException
{
res.setContentType("text/html");
PrintWriter out = res.getWriter();
String name="";

try
{
//need restart after adding exts i think so restart ur lappy
//Class.forName("com.mysql.cj.jdbc.Driver");what is ur email id???
out.println("<h1 align='center'>Your Result Is:</h1>");
    Connection con=DriverManager.getConnection( "jdbc:mysql://localhost:3306/student_marks","root","");


Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from stud where eno ="+req.getParameter("enrolment"));
// ResultSet rs=stmt.executeQuery("select * from stud");

out.println("<table border=1 align='center'>");
out.println("<tr><th>JWT</th><th>SM</th><th>MC</th></tr>");

while(rs.next())
{
//name=""+rs.getString(1);
out.println("<tr><td>"+rs.getInt(3)+"</td><td>"+rs.getInt(4)+"</td><td>"+rs.getInt(5)+"</td></tr>");
name=rs.getString(2);
}
out.println("</table>");
out.println("<h4 align='center'>Your Enrolment No:"+req.getParameter("enrolment")+"</h4>");
out.println("<h4 align='center'>Your Name:"+name+"</h4>");
con.close();

}
catch(Exception ex)
{
out.println("Exception:-"+ex);
}
finally
{
out.close();
}
}
}

OR

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

public class gtu7dbs extends HttpServlet{

   public void doPost(HttpServletRequest request, HttpServletResponse response)
  throws ServletException, IOException {
 
  // JDBC driver name and database URL
  String JDBC_DRIVER = "com.mysql.jdbc.Driver";
  String DB_URL="jdbc:mysql://localhost/gtu";
  String USER = "root";
  String PASS = "";

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

  String title = "Database Result";
 
  String docType ="<!doctype html public \"-//w3c//dtd html 4.0 " + "transitional//en\">\n";
 
  out.println(docType +
      "<html>\n" +
      "<head><title>" + title + "</title></head>\n" +
      "<body bgcolor = \"#f0f0f0\">\n" +
      "<h1 align = \"center\">" + title + "</h1>\n");
  try {
      // Register JDBC driver
      Class.forName("com.mysql.jdbc.Driver");

      // Open a connection
      Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);

      // Execute SQL query
      Statement stmt = conn.createStatement();
   
      String enr=request.getParameter("txtpar1");
  String   sql = "SELECT * FROM student where enrollmentno='"+enr+"'";
      ResultSet rs = stmt.executeQuery(sql);

      // Extract data from result set
      while(rs.next()){
        //Retrieve by column name
        int id  = rs.getInt("enrollmentno");
     
        String studnm= rs.getString("student");
int m1 = rs.getInt("mark-1");
int m2 = rs.getInt("mark-2");
int m3 = rs.getInt("mark-3");
int m4 = rs.getInt("mark-4");
int m5 = rs.getInt("mark-5");
     
        //Display values
        out.println("ID: " + id + "<br>");
        out.println(" Student Name : " + studnm + "<br>");
        out.println("Marks-1: " + m1 + "<br>");
        out.println(" Marks-2: " + m2 + "<br>");
        out.println(" Marks-3: " + m3 + "<br>");
        out.println(" Marks-4: " + m4 + "<br>");
        out.println(" Marks-5: " + m5 + "<br>");
}
      out.println("</body></html>");

      rs.close();
      stmt.close();
      conn.close();
  } catch(SQLException se) {
      se.printStackTrace();
  } catch(Exception e) {
      e.printStackTrace();
  } finally {
   
   
  }
   }
}




Web.xml

<servlet>

<servlet-name>gtu7dbs</servlet-name>

<servlet-class>gtu7dbs</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>gtu7dbs</servlet-name>

<url-pattern>/gtu7dbs</url-pattern>

</servlet-mapping>

8) Develop a Servlet which looks for cookies for username and password, and forwards to a home.jsp in case the cookies are valid and forwards to login.jsp, in case the cookies are not found or the cookies are not valid. 


File Name : index.jsp
File Location : Tomcat_Apache\webapps\gtu17\
<html>
 <head>
  <title>GTU JWT Practical 8 :</title>
 </head>
 <body>
 
 <h2 align="center"> GTU JWT Practical 8 :   </h2>
 
 
  <form action="/gtu8/LoginVerificationUsingCookies" method="get">
 
   <table>
    <tr><th colspan="2">Login</th></tr>
    <tr><td>Username : </td><td>  <input type="text" name="par1" value=""> </td></tr>
    <tr><td>Password : </td><td>  <input type="password" name="par2" value=""> </td></tr>
    <tr><td colspan="2"><input type="submit" value="Login"></td></tr>
   </table>
   
  </form>
 </body>
</html>


File Name : home.jsp
File Location : Tomcat_Apache\webapps\gtu17\
<html>
 <head>
  <title>GTU JWT Practical 8</title>
 </head>
 <body>
 
 <h2 align="center"> GTU JWT Practical 8 : Develop a Servlet which looks for cookies for username and password, and forwards to a home.jsp in case the cookies are valid and forwards to login.jsp, in case the cookies are not found or the cookies are nto valid </h2>
 
 
  <br><br><center>
  <table>
  <tr>
   <th>Welcome to Home Page</th>
  </tr>
  </table>
  </center>
  
 </body>
</html>

File Name : web.xml
File Location : Tomcat_Apache\webapps\gtu17\WEB-INF
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
                      http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
  version="3.0"
  metadata-complete="true">  
  
  <display-name>GTU JWT Practical 8  </display-name>
  <description>ADevelop a Servlet which looks for cookies for username and password, and forwards to a home.jsp in case the cookies are valid and forwards to login.jsp, in case the cookies are not found or the cookies are nto valid </description>
  
  <servlet>
    <servlet-name>LoginVerificationUsingCookies</servlet-name>
    <servlet-class>LoginVerificationUsingCookies</servlet-class>
  </servlet>

  <servlet-mapping>
    <servlet-name>LoginVerificationUsingCookies</servlet-name>
      <url-pattern>/LoginVerificationUsingCookies</url-pattern>
  </servlet-mapping> 
  
</web-app>

File Name : LoginVerificationUsingCookies.java
File Location : Tomcat_Apache\webapps\gtu17\WEB-INF\classes
import java.io.*;

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


public class LoginVerificationUsingCookies extends HttpServlet
{
 
 public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
 {
  
  PrintWriter out=response.getWriter();
  response.setContentType("text/html");      
  out.println("<html><head><title>GTU WTAD Practical 8 : Develop a Servlet which looks for cookies for username and password, and forwards to a home.jsp in case the cookies are valid and forwards to login.jsp, in case the cookies are not found or the cookies are nto valid </title></head><body></h1></center><br><br>");
 
  
  String s1 = request.getParameter("par1");
  String s2 = request.getParameter("par2");
  
  
  Cookie[] c = request.getCookies();
  
  boolean user=false,pass=false;
   
  for(int i=0;i<c.length;i++)
  {
   Cookie t = c[i];
   

   if(t.getName().equals("username") && t.getValue().equals(s1) )
   {
    user=true;
   }
   
  
   if(t.getName().equals("password") && t.getValue().equals(s2) )
   {
    pass=true;
   }
   
  }
  
  if(user==true && pass==true)
  {
   
   response.sendRedirect("home.jsp");
  }
  else
  {
  
   
   Cookie c1 = new Cookie("username",s1);
   Cookie c2 = new Cookie("password",s2);
   
   
   c1.setMaxAge(60*60*24*7);
   c2.setMaxAge(60*60*24*7);
   
   
   response.addCookie(c1);
   response.addCookie(c2);
   
   
   response.sendRedirect("index.jsp");
  }
 
  
 }
}

Output (index page)
GTU WTAD Practical 17 : Develop a Servlet which looks for cookies for username and password, and forwards to a home.jsp in case the cookies are valid and forwards to login.jsp, in case the cookies are not found or the cookies are nto valid
Output (home page after login)
GTU_17_2













 9. Write a servlet to implement Session tracking using all four methods.



Index.jsp:-
<html>
            <head>
                        <title>GTU WTAD Practical 9</title>
            </head>
            <body>
           
            <h2 align="center"> GTU WTAD Practical 9 : Develop a Servlet to authenticate a user, where the loginid and password are available as request parameters. 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 the user's information like full name, address, etc. </h2>
                        <form action="/GTU9/LoginVerificationUsingSession" method="get">
                                    <table>
                                                <tr><th colspan="2">Login</th></tr>
                                                <tr><td>Username : </td><td>  <input type="text" name="par1" value=""> </td></tr>
                                                <tr><td>Password : </td><td>  <input type="password" name="par2" value=""> </td></tr>
                                                <tr><td colspan="2"><input type="submit" value="Login"></td></tr>
                                    </table>
                        </form>
            </body>
</html>
Home.jsp:-
<html>
               <head>
                              <title>GTU WTAD Practical 9</title>
               </head>
               <body>
              
               <h2 align="center"> GTU WTAD Practical 9 : Develop a Servlet to authenticate a user, where the loginid and password are available as request parameters. 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 the user's information like full name, address, etc. </h2>
                              <br><br><center>
                              <table>
                              <tr>
                                             <th>Welcome to Home Page</th>
                              </tr>
                              <tr>
                                             <td>Logged in user is : Admin</td>
                              </tr>
                             
                              <tr>
                                             <td>Name: Maharshi Patel</td>
                              </tr>
                             
                              <tr>
                                             <td>Address : Surat</td>
                              </tr>
                              </table>
                              </center>
                             
               </body>
</html>

LoginVerificationUsingSession.java
               /*
                              GTU WTAD Practical 18 : Develop a Servlet to authenticate a user, where the loginid and password are available as request parameters. 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 the user's information like full name, address, etc.
*/

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

public class LoginVerificationUsingSession extends HttpServlet
{
              
               public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
               {
                             
                              PrintWriter out=response.getWriter();
                              response.setContentType("text/html");     
                              out.println("<html><head><title>GTU WTAD Practical 18 : Develop a Servlet to authenticate a user, where the loginid and password are available as request parameters. 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 the user's information like full name, address, etc. </title></head><body></h1></center><br><br>");

                              //===============================================
                              // Read parameter value send by page1
                              //===============================================
                              String s1 = request.getParameter("par1");
                              String s2 = request.getParameter("par2");
                             
                              //===============================================
                              // Read Current Session
                              //===============================================
                              HttpSession current_session = request.getSession();

                              //===============================================
                              // Read Session Parameter 1 and 2
                              //===============================================                 
                              String session_value1 = (String) current_session.getAttribute("session_par1");
                              String session_value2 = (String) current_session.getAttribute("session_par2");
                             
                              if( s1.equals("admin") && s2.equals("admin") )
                              {
                                             if( session_value1==null || session_value2==null)
                                             {
                                                            //===============================================
                                                            // Write Parameter 1 and 2 into Session
                                                            //===============================================
                                                            current_session.setAttribute("session_par1","admin");
                                                            current_session.setAttribute("session_par2","admin");
                                             }
                                            
                              }
                              else
                              {
                                             //===============================================
                                             // Invalid User redirect to login page
                                             //===============================================
                                             response.sendRedirect("index.jsp");
                              }
                             
               }
}

   10.  Develop a Servlet to authenticate a user, where the loginid and password are available as request parameters. 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 the user's information like full name, address, etc.

Prg10.jsp:-

<html>
            <head>
                        <title>
                                    Jsp : Login
                        </title>
            </head>
            <body>
                        <h2>Login With JSP using Sessoion</h2>
                        <form action="../prg10" action='POST'>
                        <table width='2' align='center'>
                                    <tr>
                                                <td>
                                                            Enter Your Name:
                                                </td>
                                                <td>
                                                            <input type='text' name='userName'/>
                                                </td>
                                    </tr>
                                    <tr>
                                                <td>
                                                            Enter Your Password:
                                                </td>
                                                <td>
                                                            <input type='text' name='userPass'/>
                                                </td>
                                    </tr>
                                    <tr>
                                                <td>
                                                            <input type='submit' value='Submit'>
                                                </td>
                                    </tr>
                        </table>
                        <form>
            </body>
</html>

Prg10reg:-

<html>
            <head>
                        <title>
                                    Jsp : Registation
                        </title>
            </head>
            <body>
                        <h2>Login With JSP and Cookie</h2>
                        <form action="../prg10Reg" action='GET'>
                        <table width='2' align='center'>
                                    <tr>
                                                <td>
                                                            Enter Your Name:
                                                </td>
                                                <td>
                                                            <input type='text' name='userName'/>
                                                </td>
                                    </tr>
                                    <tr>
                                                <td>
                                                            Enter Your Address:
                                                </td>
                                                <td>
                                                            <input type='text' name='address'/>
                                                </td>
                                    </tr>
                                    <tr>
                                                <td>
                                                            Enter Your Mobile:
                                                </td>
                                                <td>
                                                            <input type='number' name='mobile'/>
                                                </td>
                                    </tr>
                                    <tr>
                                                <td>
                                                            Enter Your City:
                                                </td>
                                                <td>
                                                            <input type='text' name='city'/>
                                                </td>
                                    </tr>
                                    <tr>
                                                <td>
                                                            Enter Your State:
                                                </td>
                                                <td>
                                                            <input type='text' name='state'/>
                                                </td>
                                    </tr>
                                    <tr>
                                                <td>
                                                            <input type='submit' value='Submit'>
                                                </td>
                                    </tr>
                        </table>
                        <form>
            </body>
</html>


Prg10Reg.java:-

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class prg10Reg extends HttpServlet {

    public void doGet(HttpServletRequest req, HttpServletResponse res)
    throws IOException, ServletException
    {
        res.setContentType("text/html");
        PrintWriter out = res.getWriter();
        String          user = req.getParameter("userName"),
                                             add =req.getParameter("address"),
                                             mob =req.getParameter("mobile"),
                                             city =req.getParameter("city"),
                                             state =req.getParameter("state");

               HttpSession sn = req.getSession();
               sn.setAttribute("userName",user);
               sn.setAttribute("","");
               res.sendRedirect("html/prg10.jsp");
               out.close();

  }
}

11. Write a simple JSP page to display a simple message (It may be a simple html page).
gtu11.jsp
<html><head>
            <title>GTU 11</title>
            </head>
            <body>
                        <h2 align="center"> GTU 11 :  Write a simple JSP page to display a simple message (It may be a simple html page) </h2>
<%                              out.println("<br><br>Hello using JSP");
                                    /* This is JSP Comments Line */
            out.println("<br><br><b>Following are the Implicit Objects Available in JSP</b>");
                                    out.println("<ol><li> request");
                                    out.println("<li> response");
                                    out.println("<li> session");
                                    out.println("<li> out");
                                    out.println("<li> application");
                        %>

            </body></html>

12. Write a JSP page, which uses the include directive to show its header and footer.
header.jsp
<font color="red">
<h2 align="center"> JWT GTU-12 :</h2>
</font><hr>

footer.jsp
<hr>
<h2 align="center"> Devloped by::Monika Matai</h2>

gtu12.jsp
<html>
            <head><title>GTU 11=</title></head>
            <body>
                        <jsp:include page="header.jsp"/>     
                        <br><br><br><br>
                        Above Line is from header page and following line is from footer
                        <br><br><br><br>    
                        <jsp:include page="footer.jsp"/>
</body></html>



13. Create a listener that notifies (through System.out) whenever a user adds a product to a shopping cart (i.e. adds an object to the session object) or removes it again. Hint: check out the class HttpSessionAttributeListener. Make it print the name and price of the object (hint: access the session through the HttpBindingEvent object). Also, let the listener print the total price of all objects saved in the session so far (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).

gtu13.jsp

<html>
<head>
<title> jwt gtu 13</title>
</head>
<body>
<form method="get" action="http://localhost:8080/monu/gtu13">
<h1>Welcome to our Site to Purchase Product</h1>
Mouse :<input type="checkbox" name="mouse" value="100"><br>
Keyboard :<input type="checkbox" name="keyboard" value="200"><br>
monitor :<input type="checkbox" name="mouse" value="3000"><br>

<input type="submit" value="Add to cart">
</form>
<br>
<br>
</body>
</html>
gtu13.java

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

public class gtu13 extends HttpServlet
{
            public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
            {
                        int total=0;
                                    HttpSession session = req.getSession();
                        PrintWriter out = res.getWriter();
                        try
                        {         
                                    res.setContentType("text/html");
                                    out.println("<html>"+"<body>");
                                    out.println("<center><h2>Shopping Cart</h2></center><br>");
                                    out.println("<table><tr><th>Product Name</th><th>Price</th></tr>");    
                                    Enumeration parameters=req.getParameterNames();
                                                while(parameters.hasMoreElements())
                                    {
                                                String productname=(String)parameters.nextElement();
                                                int price=Integer.parseInt(req.getParameter(productname));
                                                session.setAttribute(productname, price);
                                    }
                                    Enumeration sessionAllAttributes =session.getAttributeNames();
                                    while(sessionAllAttributes.hasMoreElements())
                                    {
                                                try
                                                {
                                    String sessionAttributeName=(String)sessionAllAttributes.nextElement();
                        int sessionAttributeValue=(int)session.getAttribute(sessionAttributeName);
                                                            total=total+sessionAttributeValue;
                                                            out.println("<tr><td>" + sessionAttributeName + "</td><td>" + sessionAttributeValue + "</td></tr>") ;
                                                }catch(Exception e) {
out.println(e.getMessage());
            }
            }
                                   
out.println("<tr><th>Total</th><th>" + total + "</th></tr>") ;
out.println("</table>");
out.println("<br><br><a href=\"gtu13.jsp\"> Back to Product List </a>");
out.println("</body></html>");
}
catch (Exception e)
{}
}
}

14. Create a servlet filter that logs all access to and from servlets in an application and prints
the following to System.out:
1. the time the request was received 2. the time the response was sent 3. how much time it took to process the request 4. the URL of the resource requested 5. the IP address of the visitor

Index.jsp
<%
            response.sendRedirect("./FilterDemo_Servlet");
%>

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

public class FilterDemo implements Filter
{
            protected FilterConfig config;
            private ServletContext context;
            public void init(FilterConfig con)throws javax.servlet.ServletException
            {
                        config=con;
            }
            public void destroy()
            {
            }
            public void doFilter(ServletRequest request,ServletResponse response,FilterChain chain)
                                            throws java.io.IOException, javax.servlet.ServletException
            {
                        PrintWriter out = response.getWriter();
                       
                        try
                        {
                                    long startTime=System.currentTimeMillis();
                                    long endTime=System.currentTimeMillis();
                                    HttpServletRequest req=(HttpServletRequest)request;
                                    String path=req.getRequestURI();
                                    String visitor=req.getRemoteHost();
                                    out.print("filter is called... and can modify objects"); 
                                    chain.doFilter(request,response);
                                    out.print("after actual servlet again filter is called"); 
                        }
                        catch(Exception e)
                        {
                        }
            }

}
FilterDemo_Servlet.java

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

public class FilterDemo_Servlet extends HttpServlet
{

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

Web.xml

<servlet>
            <servlet-name>FilterDemo_Servlet</servlet-name>
            <servlet-class>FilterDemo_Servlet</servlet-class>
  </servlet>

  <servlet-mapping>
            <servlet-name>FilterDemo_Servlet</servlet-name>
            <url-pattern>/FilterDemo_Servlet</url-pattern>
  </servlet-mapping>
  <filter>
    <filter-name>FilterDemo</filter-name>
    <filter-class>FilterDemo</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>FilterDemo</filter-name>
    <servlet-name>FilterDemo_Servlet</servlet-name>
  </filter-mapping>

15. Develop 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.

index15.jsp

<html>
            <head>
                        <title>JWT GTU-15</title>
            </head>
            <body>
            <h2 align="center"> Develop 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.</h2>
            <table><tr>
            <th>Interest Calculation </th>
                        </tr>
                        <tr>
                        <td>
                        <form action="http://localhost:8080/monu/gtu15" method="post">
                                    Principal Amount : <input type="text" name="p"> <br>
                                    Rate of Interest : <input type="text" name="r"> <br>
                                    Year : <input type="text" name="n"> <br>
                                    <input type="submit" value="Calculate">
                        </form>
                        <br><br>
                        <div>
                        <%
                                    String s = request.getParameter("interest");
                                    String p = request.getParameter("p");
                                    String r = request.getParameter("r");
                                    String n = request.getParameter("n");                       
                                    if(s!=null)
                                    {
                                                out.println("<b>Simple Interest is as follow:</b><br>");
                                                out.println("Pincipal Amount : " + p + "<br>");
                                                out.println("Rate of Interest : " + r + "<br>");
                                                out.println("Years : " + n + "<br>");
                                                out.println("\n\n SI is : " + s);
                                    }
                        %>
                        </div>
                        </td>
                        </tr>
                        </table>
            </body>
</html>
gtu15.java
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class gtu15 extends HttpServlet
{

            public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException
            {
                        String p = request.getParameter("p");
                        String r = request.getParameter("r");
                        String n = request.getParameter("n");
                       
                        float si = Float.parseFloat(p) * Float.parseFloat(r) * Float.parseFloat(n) / 100;
                       
                        response.sendRedirect("index15.jsp?interest=" + si + "&p=" + p + "&r=" + r + "&n=" + n);
            }

}

 web.xml
<servlet>
            <servlet-name>gtu15</servlet-name>
            <servlet-class>gtu15</servlet-class>
  </servlet>

  <servlet-mapping>
            <servlet-name>gtu15</servlet-name>
            <url-pattern>/gtu15</url-pattern>
  </servlet-mapping>


16. 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)
Index16.jsp
<%
            response.sendRedirect("http://localhost:8080/monu/UsingCookies16");
%>

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

public class UsingCookies16 extends HttpServlet
{

  public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException
  {
      PrintWriter out = response.getWriter();
      out.println("<html><head><title>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) </title></head><body><h2>GTU  Practical  : 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) </h2>");

      Cookie[] cookies = request.getCookies();
      String last_visit_date=null;
      if (cookies != null)
      {
           for(int i=0; i<cookies.length; i++)
           {
            Cookie cookie = cookies[i];
            if (cookie.getName().equals("last_visit"))
            {
              last_visit_date= cookie.getValue();
               break;
            }
           }          
      }
      if(last_visit_date!=null)
      {   
        out.println("Your last visit was on : " +  last_visit_date) ;
        Date now = new Date();
        Cookie c = new Cookie("last_visit",now+"");
        c.setMaxAge(60*60*24*365);  //1 year
        response.addCookie(c);
      }
      else
      {
        Date now = new Date();
        Cookie c = new Cookie("last_visit",now+"");
        c.setMaxAge(60*60*24*365);  //1 year
        response.addCookie(c);
        out.println("Welcome to Website... Hope You will Visit Again");
      }
        out.println("</body></html>");
  }
}

Web.xml
<servlet>
            <servlet-name>UsingCookies16</servlet-name>
            <servlet-class>UsingCookies16</servlet-class>
  </servlet>

  <servlet-mapping>
            <servlet-name>UsingCookies16</servlet-name>
            <url-pattern>/UsingCookies16</url-pattern>
  </servlet-mapping>


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

index.jsp
<%
                                    String session_value = (String)session.getAttribute("user");
                                    if (session_value != null)
                                    {
                                               response.sendRedirect("./Welcome");
                                    }
%>
<html>
                        <head>
                                    <title>GTU WTAD Practical 25</title>
                        </head>
                        <body>
                       
                        <h2 align="center"> GTU WTAD Practical 25 : Develop an application to keep track of one user across several servlet invocations within the same browser session. </h2>

                                    <table>
                                    <tr>
                                               <th>Session Tracking </th>
                                    </tr>
                                    <tr>
                                    <td>
                                               <form action="./Welcome" method="post">
                                                                       Username : <input type="text" name="u"> <br>
                                                                       Password : <input type="password" name="p"> <br>
                                                                       <input type="submit" value="Login">
                                               </form>
                                               <br><br>
                                    </td>
                                    </tr>
                                    </table>
                        </body>
</html>

Welcome.java
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Welcome extends HttpServlet
{

                        public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException
                        {
                                    doPost(request,response);
                        }
                        public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException
                        {
                                    PrintWriter out = response.getWriter();
                                    out.println("<html><head><title>GTU WTAD Practical 25 :  Develop an application to keep track of one user across several servlet invocations within the same browser session.  </title></head><body><h2>GTU WTAD Practical 25 :  Develop an application to keep track of one user across several servlet invocations within the same browser session.  </h2>");
                                   
                                    out.println("<center> <a href=\"./Signout\"> Signout </a> </center> ");
                                   
                                    String u = request.getParameter("u");
                                    String p = request.getParameter("p");
                                   
                                    HttpSession session = request.getSession();
                                    String session_value = (String)session.getAttribute("user");
                                    if (session_value == null)
                                    {
                                               // No Session found.. Need to create new session
                                              
                                               session.setAttribute("user", u);
                                               out.println("Welcome " + u + " for First Time");
                                    }
                                    else
                                    {
                                               //Session Found
                                               out.println("Welcome Back " + session_value);
                                    }
                                   
                                   
                                    out.println("</body></html>");
                        }

}
Signout.java

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


public class Signout extends HttpServlet
{

                        public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException
                        {
                                    HttpSession session = request.getSession();
                                    session.invalidate();
                                    response.sendRedirect("./index.jsp");
                        }

}

web.xml

<servlet>
                        <servlet-name>Welcome</servlet-name>
                        <servlet-class>Welcome</servlet-class>
  </servlet>

  <servlet-mapping>
                        <servlet-name>Welcome</servlet-name>
                        <url-pattern>/Welcome</url-pattern>
  </servlet-mapping>

   <servlet>
                        <servlet-name>Signout</servlet-name>
                        <servlet-class>Signout</servlet-class>
  </servlet>

  <servlet-mapping>
                        <servlet-name>Signout</servlet-name>
                        <url-pattern>/Signout</url-pattern>
  </servlet-mapping>


18. Develop an application to write a "page-composite" JSP that includes other pages or passes control to another page. (Hint: Use or ).
 index.jsp
<html>
                        <head>
                                    <title>GTU WTAD Practical 26</title>
                        </head>
                        <body>
                       
                        <h2 align="center"> GTU WTAD Practical 26 :  Develop an application to write a "page-composite" JSP that includes other pages or passes control to another page.   </h2>
                        <br><br><br>
                        <form method="get" action="process.jsp">
                                    <b>Select Your Favorite Color :</b>             <br><br>
                                    <input type="radio" name="color" value="red.jsp"> Red                                        <br>
                                    <input type="radio" name="color" value="green.jsp"> Green              <br>
                                    <input type="radio" name="color" value="blue.jsp"> Blue                                     <br><br>
                                    <input type="submit" value="Click Here">
                        </form>
                        <br><br><br><br><br><br>
                        <jsp:include page="footer.jsp"/>
                        </body>
</html>
process.jsp
<html>
<head>
                        <title> GTU WTAD Practical 26 : Develop an application to write a "page-composite" JSP that includes other pages or passes control to another page.</title>
</head>
<body>

<%
                        String c = request.getParameter("color");
                        if(c==null)
                        {
%>
                                    <jsp:forward page="./index.jsp"/>
<%      }
                        else
                        {
%>
                                    <jsp:forward page="<%=c%>"/>
<%
                        }
%>
                       
</body>
</html>
footer.jsp
<hr>
<h2 align="center">Designed and Developed by: Adarsh Patel (written inside footer.jsp page)</h2>
 red.jsp
<html>
<body bgcolor="red">
<center>
<h2>Wow You Like Color of Blood !</h2>
<br><br><br>
<a href="index.jsp"> Back </a>
</center>
</body>
</html>
green.jsp
<html>
<body bgcolor="green">
<center>
<h2> You Like Green Color </h2>
<br><br><br>
<a href="index.jsp"> Back </a>
</center>
</body>
</html>
blue.jsp
<html>
<body bgcolor="blue">
<center>
<h2> Great !!! You Like Blue Color </h2>
<br><br><br>
<a href="index.jsp"> Back </a>
</center>
</body>
</html>

19.You want to reduce the amount of Java coding in your JSP using a JavaBean component.
(Hint: Use <jsp:useBean> with the name of your bean).

Index.jsp
<html>
            <head>
                        <title>GTU WTAD Practical 27</title>
            </head>
            <body>
            <h2 align="center"> GTU WTAD Practical 27 :   You want to reduce the amount of Java coding in your JSP using a JavaBean component. (Hint:  Use &ltjsp:useBean&gt with the name of your bean).   </h2>
            <br><br>
            <jsp:useBean id="date" class="java.util.Date" />
            <h2>Todays Date is : <font color="red"> <%= date %> </font> </h2>
            </body>
</html>

21. Update the JSP page from above exercise to use tags availabe from the standard tag library JSTL.
           
INDEX.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
            <head>
                        <title>GTU Practical 21</title>
            </head>
            <body>
            <h2 align="center"> GTU Practical 21 : Write a JSP page which uses tags availabe from the standard tag
library JSTL.    </h2>
            <br><br>        
            <c:out value="This text is displayed using c:out"/>
            </body>
</html>

Web.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
                      http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
  version="3.0"
  metadata-complete="true"> 
  <display-name>GTU Practical 21</display-name>
  <description>Write a JSP Page to use JSP scripting.</description>

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

Index.jsp
<html>
            <head>
                        <title>GTU WTAD Practical 33</title>
            </head>
            <body>
<h2 align="center"> GTU WTAD Practical 33 : Develop a  JSP Page to display the personal information and result information of the student in two different tabular formats. </h2>
            <br><br>
            <table border="1">
            <tr>
                        <th colspan="2"> Student Personal Details </th>
            </tr>
            <tr>
                        <td> Name: </td>
                        <td> Abc </td>
            </tr>
            <tr>
                        <td> Address: </td>
                        <td> Baroda </td>
            </tr>
            </table>          
            </body>
</html>

Web.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
                      http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
  version="3.0"
  metadata-complete="true"> 
  <display-name>GTU WTAD Practical 33  </display-name>
  <description>Develop a  JSP Page to display the personal information and result
information of the student in two different tabular formats. </description>

</web-app>

 27.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

Index.jsp
<%@ page import="java.sql.*;" %>
<html>
            <head>
                        <title>GTU WTAD Practical 28</title>
            </head>
            <body>
            <h2 align="center"> GTU WTAD Practical 28 :    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 </h2>
            <br><br>
            <form method="post" action="InsertServlet">
                        <table>
                        <tr><td colspan="2"> Employee Details </td></tr>
                        <tr><td colspan="2"> &nbsp; </td></tr>
                        <tr><td>Employee Id</td> <td> <input type="text" name="EmpId"></td></tr>
                        <tr><td>Employee Name</td> <td> <input type="text" name="Empname"></td></tr>
                        <tr><td>Employee Designation</td> <td> <input type="text" name="Emp_desig"></td></tr>
                        <tr><td>Employee Joining Date</td> <td> <input type="text" name="Emp_J_Date"></td></tr>
                        <tr><td>Employee Salary</td> <td> <input type="text" name="Emp_Salary"></td></tr>
                        <tr><td colspan="2"> &nbsp; </td></tr>
                        <tr><td colspan="2"> <input type="submit" value="Insert"> </td></tr>
                        </table>
                        <%
                                    String s = (String) session.getAttribute("msg");
                                    if(s!=null)
                                    {
                                                out.println("<div align=\"left\"><font color=\"blue\">"+s+"</font></div>");
                                                session.removeAttribute("msg");
                                    }
                                    Class.forName("com.mysql.jdbc.Driver");
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase","root","");
            Statement st=con.createStatement();
            ResultSet rs=st.executeQuery("Select * from employee");
                                    out.println("<center><table border=1>");
                                    out.println("<tr><th>Emp ID </th><th>Employee Name</th><th>Designation</th><th>Joinnig Date</th><th>Salary</th><th>Edit</th><th>Delete</th></tr>");
                                    while(rs.next())
                                    {
                                                 out.println("<tr><td>"+rs.getInt(1)+" </td>");
                                                 out.println("<td>"+rs.getString(2)+ "</td>");
                                                 out.println("<td>"+rs.getString(3)+ "</td>");
                                                 out.println("<td>"+rs.getString(4)+ "</td>");
                                                 out.println("<td>"+rs.getFloat(5)+ "</td>");
                                                 out.println("<td> <a href=edit.jsp?id="+rs.getInt(1)+ "> Edit </a> </td>");
                                                 out.println("<td> <a href=./DeleteServlet?id="+rs.getInt(1)+ "> Delete </a> </td></tr>");
                                    }
                                    out.println("</table></center>");                                 
                        %>
            </form>
            </body>
</html>

Edit.jsp
<%@ page import="java.sql.*;" %>
<html>
            <head>
                        <title>GTU WTAD Practical 28</title>
            </head>
            <body>
            <h2 align="center"> GTU WTAD Practical 28 :    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 </h2>
            <br><br>
                        <form method="post" action="./UpdateServlet">
                        <%
                                   
                                   
                                    Class.forName("com.mysql.jdbc.Driver");
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase","root","");
            Statement st=con.createStatement();
            ResultSet rs=st.executeQuery("Select * from employee where EmpId=" + request.getParameter("id") );
                                    out.println("<center><table border=1>");
                                    out.println("<tr><th>Field</th><th>Details</th></tr>");
                                    if(rs.next())
                                    {
                                                 out.println("<tr><td>Employee ID</td><td> <input name=\"EmpId\" readonly type=\"text\" value="+rs.getInt(1)+"> </td></tr>");
                                                 out.println("<tr><td>Employee Name</td><td> <input name=\"Empname\" type=\"text\" value="+rs.getString(2)+ "> </td></tr>");
                                                 out.println("<tr><td>Employee Designation</td><td> <input name=\"Emp_desig\" type=\"text\" value="+rs.getString(3)+ "></td></tr>");
                                                 out.println("<tr><td>Employee Joining Date</td><td> <input name=\"Emp_J_Date\" type=\"text\" value="+rs.getString(4)+ "></td></tr>");
                                                 out.println("<tr><td>Employee Salary</td><td> <input name=\"Emp_Salary\" type=\"text\" value="+rs.getFloat(5)+ "></td></tr>");
                                    }          
                                    out.println("</table>");                        
                        %>
                        <tr><td colspan="2"> <input type="submit" value="Update"> </td></tr>
                        </table>
            </form>
            </body>
</html>

 InsertServlet.java

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class InsertServlet extends HttpServlet
{
   public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
          {
                    PrintWriter out=response.getWriter();
                    response.setContentType("text/html");     
                   
                    out.println("<html><head><title>GTU WTAD Practical 28 : 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 </title></head><body></h1></center><br><br>");
                    HttpSession session = request.getSession();
                    try
                    {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase","root","");
            Statement st=con.createStatement();
                              String EmpId = request.getParameter("EmpId");
                              String Empname = request.getParameter("Empname");
                              String Emp_desig = request.getParameter("Emp_desig");
                              String Emp_J_Date = request.getParameter("Emp_J_Date");
                              String Emp_Salary = request.getParameter("Emp_Salary");
                              String insertSQL = "insert into employee values("+ EmpId + ",'" + Empname + "','"+ Emp_desig +"','" + Emp_J_Date+ "'," + Emp_Salary+ ")";
                              int return_value = st.executeUpdate(insertSQL);                  
                              if(return_value>0)
                              {
                                        session.setAttribute("msg","Data Inserted Succesfully");
                                        response.sendRedirect("./");
                              }
                              else
                              {
                                        session.setAttribute("msg","Data Insersion Error");
                                        response.sendRedirect("./");
                              }
                             
                               
                             
                                 
       }
       catch (Exception e)
       {
          out.println("The error is:" + e.getMessage());
       }           
          }
}
UpdateServlet.java

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class UpdateServlet extends HttpServlet
{
          public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
          {
                    PrintWriter out=response.getWriter();
                    response.setContentType("text/html");     
                    HttpSession session = request.getSession();
                    try
                    {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase","root","");
            Statement st=con.createStatement();
                              String EmpId = request.getParameter("EmpId");
                              String Empname = request.getParameter("Empname");
                              String Emp_desig = request.getParameter("Emp_desig");
                              String Emp_J_Date = request.getParameter("Emp_J_Date");
                              String Emp_Salary = request.getParameter("Emp_Salary");
                              String updateSQL = "update employee set Empname='" + Empname + "',Emp_desig='" + Emp_desig + "',Emp_J_Date='" + Emp_J_Date + "',Emp_Salary=" + Emp_Salary + " where EmpId=" + EmpId;
                              int return_value = st.executeUpdate(updateSQL);      
                              if(return_value>0)
                              {
                                        session.setAttribute("msg","Data Updated Succesfully");
                                        response.sendRedirect("./");
                              }
                              else
                              {
                                        session.setAttribute("msg","Data Updation Failed, Try Again");
                                        response.sendRedirect("./");
                              }
       }
       catch (Exception e)
       {
          out.println("The error is:" + e.getMessage());
       }
          }
}
DeleteServlet.java

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

public class DeleteServlet extends HttpServlet
{
          public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
          {
                    //PrintWriter out=response.getWriter();
                    response.setContentType("text/html");     

                    HttpSession session = request.getSession();
                   
                    try
                    {

            Class.forName("com.mysql.jdbc.Driver");
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase","root","");
            Statement st=con.createStatement();
                              String EmpId = request.getParameter("id");
                               
                              String deleteSQL = "delete from employee where EmpId=" + EmpId;
                              int return_value = st.executeUpdate(deleteSQL);
                             
                              if(return_value>0)
                              {
                                        session.setAttribute("msg","Data Deleted Succesfully");
                                        response.sendRedirect("./");
                              }
                              else
                              {
                                        session.setAttribute("msg","Data Deletion Failed, Try Again");
                                        response.sendRedirect("./");
                              }
                             
                   
       }
       catch (Exception e)
       {
          //out.println("The error is:" + e.getMessage());
       }
          }
}
WEB.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
                      http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
  version="3.0"
  metadata-complete="true"> 
  <display-name>GTU WTAD Practical 28  </display-name>
  <description>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 </description>
  <servlet>
    <servlet-name>InsertServlet</servlet-name>
    <servlet-class>InsertServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>InsertServlet</servlet-name>
      <url-pattern>/InsertServlet</url-pattern>
  </servlet-mapping>
  <servlet>
    <servlet-name>DeleteServlet</servlet-name>
    <servlet-class>DeleteServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>DeleteServlet</servlet-name>
      <url-pattern>/DeleteServlet</url-pattern>
  </servlet-mapping>
  <servlet>
    <servlet-name>UpdateServlet</servlet-name>
    <servlet-class>UpdateServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>UpdateServlet</servlet-name>
      <url-pattern>/UpdateServlet</url-pattern>
  </servlet-mapping>
</web-app>




Comments




Tags # GTU JWT PRACTICAL
Whatsapp
Author Image

About SmartSpy
alistarbot is a blogger resources site is a provider of high quality blogger template with premium looking layout and robust design. The main mission of templatesyard is to provide the best quality blogger templates.

Related Posts:
GTU JWT PRACTICAL
By SmartSpy - March 23, 2019
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Tagged In: GTU JWT PRACTICAL

2 comments:

  1. SmartSpyMarch 23, 2019 at 9:11 AM

    good

    ReplyDelete
    Replies
      Reply
  2. AnonymousJuly 7, 2020 at 10:06 AM

    thank you bro...

    ReplyDelete
    Replies
      Reply
Add comment
Load more...

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)
AUTOSITE Waterproof Two Wheeler Cover for Honda

Random Posts

Follow Us

  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram
  • Home

Popular Posts

  • How to Multi-Select Items(CHECKBOX) in a FlatList using hooks in - React Native
    You’ve  likely   listened   approximately  a Flatlist component  on the off chance that   you're  working in  Respond   local  and  deal...
  • dbms set 6 mca 3 gtu
    SET – 6 Create the database HOSPITAL and create given tables with all necessary constraints such as primary key, foreign key, unique ...
  • Ripple effect in React Native
    RIPPLE.TSX        import React from 'react' ; import { Alert , Dimensions , StyleSheet , Text , View } from 'react-native...
  • set 7 dbms gtu
    SET – 7 Create the database SHOPPING and create given tables with all necessary constraints such as primary key, foreign key, uniqu...
  • gtu mca 3 set 5 gtu
    SET – 5 HOSTEL (HNO, HNAME, HADDR, TOTAL_CAPACITY, WARDEN) create table hostel ( hnonumber(10) primary key, hname varchar2(...

My Blog List

  • raksha-bandhan-pc.blogspot.com/
  • pc1432.blogspot.com/?m=1

About Me

My photo
SmartSpy
surat, gujarat, India
View my complete profile

Facebook

Pc Infotech © 2020. All Copyrights Reserved.
PC INFOTECH. Powered by Blogger.

Total Pageviews

Contact Form

Name

Email *

Message *