Thursday, January 07, 2016

Project Demo On Student Registration, Student Login Forms With Servlets And Playing YouTube Video After Login Success !!!!

1) Hi , Here i am going to illustrate Demo Project On : 

     a) Student Registration Form( Details Should Be Store On Database)

     b) Login Form (Credentials Should Match With Database Student Table)

      c) After Login Successful Have To Play The YouTube Video

SQL Script: Create table Student(name varchar(100),Email varchar(100), pass varchar(15));

2)  Source Codes As Follows

1)Web.xml
<web-app>  
  
<servlet>  
<servlet-name>Register</servlet-name>  
<servlet-class>com.dinesh.Register</servlet-class>
</servlet>  
  
<servlet-mapping>  
<servlet-name>Register</servlet-name>  
<url-pattern>/register</url-pattern>
</servlet-mapping>  

<servlet>
        <servlet-name>login</servlet-name>
        <servlet-class>com.dinesh.Login</servlet-class>
    </servlet>
<servlet-mapping>
        <servlet-name>login</servlet-name>
        <url-pattern>/login</url-pattern>
</servlet-mapping>
    <servlet>
        <servlet-name>Welcome</servlet-name>
        <servlet-class>com.dinesh.Welcome</servlet-class>
    </servlet>
    
    <servlet-mapping>
        <servlet-name>Welcome</servlet-name>
        <url-pattern>/Welcome</url-pattern>
    </servlet-mapping>
  
<welcome-file-list>  
    <welcome-file>Home.html</welcome-file>
</welcome-file-list>  
  

</web-app>

2)Home.html

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<body>

<title>Welcome To The Guest </title>
Have An Account Login Here

<a href=Login.html>Login</a>

<br><br><br>

New User CAn Register Here,!!!
<a href=Register.html>Register</a>


</head>


</body>

</html>

3)Login.html

<html>
    <head>
        <title>login form</title>
    </head>
    <body>
        <form method="post" action="login">
        Email ID:<input type="text" name="email" /><br/>
        Password:<input type="text" name="pass" /><br/>
        <input type="submit" value="login" />
        </form>
    </body>
</html>

4) Register.html

<html>
    <head>
        <title>Register form</title>
    </head>
    <body>
        <form method="post" action="register">
        Name:<input type="text" name="name" /><br/>
        Email ID:<input type="text" name="email" /><br/>
        Password:<input type="password" name="pass" /><br/>
        <input type="submit" value="register" />
        </form>
    </body>

</html>

5) Youtube.html

Hi User Now You are Accessing Our Yotube Channel !!!!

<br><br><br>
<iframe width="660" height="415" 

src="https://www.youtube.com/embed/3u1fu6f8Hto" frameborder="0" allowfullscreen></iframe>

6)Login.java

package com.dinesh;

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

public class Login extends HttpServlet {

    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        
        String email = request.getParameter("email");
        String pass = request.getParameter("pass");
        
        if(Validate.checkUser(email, pass))
        {
            RequestDispatcher rs = request.getRequestDispatcher("Welcome");
            rs.forward(request, response);
        }
        else
        {
           out.println("Username or Password incorrect");
           RequestDispatcher rs = request.getRequestDispatcher("Home.html");
           rs.include(request, response);
        }
    }  

}

7) Register.java

package com.dinesh;

import java.io.*;

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

import java.sql.*;

@SuppressWarnings("serial")
public class Register extends HttpServlet {
    
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();

        String name = request.getParameter("name");
        String email = request.getParameter("email");
        String pass = request.getParameter("pass");
        try{
        
     
        Class.forName("oracle.jdbc.driver.OracleDriver");


          Connection  con=DriverManager.getConnection
                     ("jdbc:oracle:thin:@localhost:1521:xe","system","system");

        PreparedStatement ps=con.prepareStatement
                  ("insert into Student values(?,?,?)");

        ps.setString(1, name);
        ps.setString(2, email);
        ps.setString(3, pass);
        int i=ps.executeUpdate();
        
          if(i>0)
          {
            out.println("You are sucessfully registered");
          }
        
        }
        catch(Exception se)
        {
            se.printStackTrace();
        }

      }

  }


8)Validate.html

package com.dinesh;

import java.sql.*;

public class Validate
 {
     public static boolean checkUser(String email,String pass) 
     {
      boolean st =false;
      try{

         Class.forName("oracle.jdbc.driver.OracleDriver");
 
         Connection con=DriverManager.getConnection
                        ("jdbc:oracle:thin:@localhost:1521:xe","system","system");
         PreparedStatement ps =con.prepareStatement
                             ("select * from student where email=? and pass=?");
         ps.setString(1, email);
         ps.setString(2, pass);
         ResultSet rs =ps.executeQuery();
         st = rs.next();
        
      }catch(Exception e)
      {
          e.printStackTrace();
      }
         return st;                 
  }   

}

9) Welcome.java

package com.dinesh;

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

public class Welcome extends HttpServlet {

    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        out.println("Welcome user");
        out.println("You are Eligible For Accessing Our Videos");
        RequestDispatcher rd = request.getRequestDispatcher("/Youtube.html");
        rd.include(request, response);
      }  

}


Source Code Zipped File : https://sites.google.com/site/powerdineshblogspotin/home/StudentRegistration.rar?attredirects=0&d=1



No comments:

Post a Comment