Untitled

index .html

<!DOCTYPE html>
<html>
    <head>
        <title>Login form</title>
    </head>
    <body>
        <h1>Google Form</h1>
         <a href="Login.html">Login</a>
        <a href="LogOut">Logout</a>


    </body>
</html>

login.html

<!DOCTYPE html>

<html>
    <head>

        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>


        <h1>LOGIN</h1>

        <form action="MySQLConnect" method="post" >
        Username :<input type="text" name="user" /><br/><br/>
        Password :<input type="text" name="pass" /><br/><br/>
        <input type="submit" value="Login" />
        <a href="Signup.html">Sign Up</a>
        </form>


</body>
</html>


logout.html


import java.io.IOException;
import java.io.PrintWriter;

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

			HttpSession session=request.getSession();
			session.invalidate();

			out.print("You are successfully logged out!");
	request.getRequestDispatcher("index.html").include(request, response);

			out.close();
	}


}

reg1.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

import java.sql.*;

public class Reg1 extends HttpServlet {

    protected void doPost(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        response.setContentType("text/html");

        PrintWriter out = response.getWriter();

        String n = request.getParameter("fname");

        String p = request.getParameter("lname");

        String e = request.getParameter("user");

        String c = request.getParameter("pass");

        try {

            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/set5", "root", "");

            PreparedStatement stmt = con.prepareStatement("insert into login values(?,?,?,?)");

            stmt.setString(1, n);

            stmt.setString(2, p);

            stmt.setString(3, e);

            stmt.setString(4, c);

            int i = stmt.executeUpdate();

            if (i > 0) {

                out.println("You are successfully registered.....");

            out.println("<a href=index.html>Login</a>");

            }

        } catch (Exception ey) {

            System.out.println(ey);

        }

        out.close();

    }

}

signup.html

<!DOCTYPE html>

<html>
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>
        <h1>REGISTRATION</h1>

        <form action="Reg1" method="post">

First Name :<input type="text" name="fname"><br><br>
Last Name  :<input type="text" name="lname"><br><br>
User Name  :<input type="text" name="user"><br><br>
Password   :<input type="password" name="pass"><br><br>

<input type="submit" value="Submit"><br>

        </form>


    </body>
</html>