Login Application Using Session Management+Mysql+Bootstrap

Create database masterjee using mysql

create database masterjee;

Create table user

create table user(id INT NOT NULL AUTO_INCREMENT, name varchar(255) not null,email varchar(255) NOT NULL, password varchar(255) not null, contact VARCHAR(20) NOT NULL, primary key(id));

Create Dynamic web project "LoginApplicationUsingSession"

Add jars inside WebContent/WEB-INF/lib

• javax.servlet-api-3.1.0.jar
• mysql-connector-java-5.1.42-bin.jar

Add bootstrap.min.css file to WebContent for UI

web.xml

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

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">

  <display-name>LoginApplicationUsingSession</display-name>

  <welcome-file-list>

    <welcome-file>home.jsp</welcome-file>

  </welcome-file-list>

  

  <servlet>

  <servlet-name>profile</servlet-name>

  <servlet-class>com.masterjee.servlet.ProfileServlet</servlet-class>

  </servlet>

  <servlet-mapping>

  <servlet-name>profile</servlet-name>

  <url-pattern>/profile</url-pattern>

  </servlet-mapping>

  

   

  <servlet>

  <servlet-name>register</servlet-name>

  <servlet-class>com.masterjee.servlet.RegisterServlet</servlet-class>

  </servlet>

  <servlet-mapping>

  <servlet-name>register</servlet-name>

  <url-pattern>/register</url-pattern>

  </servlet-mapping>

    

  <servlet>

  <servlet-name>logout</servlet-name>

  <servlet-class>com.masterjee.servlet.LogoutServlet</servlet-class>

  </servlet>

  <servlet-mapping>

  <servlet-name>logout</servlet-name>

  <url-pattern>/logout</url-pattern>

  </servlet-mapping>

    

  <servlet>

  <servlet-name>login</servlet-name>

  <servlet-class>com.masterjee.servlet.LoginServlet</servlet-class>

  </servlet>

  <servlet-mapping>

  <servlet-name>login</servlet-name>

  <url-pattern>/login</url-pattern>

  </servlet-mapping>

</web-app>

Put all jsp/css files inside WebContent

header.jsp

<nav class="navbar navbar-default navbar-fixed-top">

      <div class="container">

        <div class="navbar-header">

          <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">

            <span class="sr-only">Toggle navigation</span>

            <span class="icon-bar"></span>

            <span class="icon-bar"></span>

            <span class="icon-bar"></span>

          </button>

          <a class="navbar-brand" href="#">Login Application</a>

        </div>

        <div id="navbar" class="navbar-collapse collapse">

          <ul class="nav navbar-nav">

          <li class="active"><a href="home.jsp">Home</a></li>

          <li><a href="profile">Profile</a></li>

          </ul>

          <ul class="nav navbar-nav navbar-right">

            <li role="presentation"><a href="login.jsp">Login</a></li>

            <li><a href="register.jsp">Register</a></li>

            <li><a href="logout">Logout</a></li>

          </ul>

        </div><!--/.nav-collapse -->

      </div>

    </nav>

header2.jsp

<nav class="navbar navbar-default navbar-fixed-top">

      <div class="container">

        <div class="navbar-header">

          <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">

            <span class="sr-only">Toggle navigation</span>

            <span class="icon-bar"></span>

            <span class="icon-bar"></span>

            <span class="icon-bar"></span>

          </button>

          <a class="navbar-brand" href="#">Login Application</a>

        </div>

        <div id="navbar" class="navbar-collapse collapse">

          <ul class="nav navbar-nav">

            <li class="active" ><a href="profile">Profile</a></li>

          </ul>

          <ul class="nav navbar-nav navbar-right">

            <li><a href="logout">Logout</a></li>

          </ul>

        </div><!--/.nav-collapse -->

      </div>

    </nav>

home.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<link href="bootstrap.min.css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Home</title>
</head>
<body>
<jsp:include page="header.jsp" />
<div class="container">
<div class="jumbotron">
<jsp:include page="error.jsp" />
<h1>This is a Home Page</h1>
</div>
</div>

</body>
</html>

login.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Login</title>

<link href="bootstrap.min.css" rel="stylesheet">

<link href="signin.css" rel="stylesheet">

</head>

<body>

<jsp:include page="header.jsp" />

<div class="container">

<div class="jumbotron">

<jsp:include page="error.jsp" />

<form class="form-signin" action="login" method="post">

<h2 class="form-signin-heading">Please sign in</h2>

<label for="inputEmail" class="sr-only">Email</label> <input

type="email" name="email" id="inputEmail" class="form-control"

placeholder="Email address" required autofocus /> <label

for="inputPassword" class="sr-only">Password</label> <input

type="password" name="password" id="inputPassword"

class="form-control" placeholder="Password" required />

<button class="btn btn-lg btn-primary btn-block" type="submit">Sign

in</button>

</form>

</div>

</div>

</body>

</html>

register.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<link href="bootstrap.min.css" rel="stylesheet">

<link href="signin.css" rel="stylesheet">

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Home</title>

</head>

<body>

<jsp:include page="header.jsp" />

<div class="container">

<div class="jumbotron">

<jsp:include page="error.jsp" />

<form class="form-signin" action="register" method="post">

<h2 class="form-signin-heading">Please Register</h2>

<label for="name" class="sr-only">Name</label> 

<input type="text" name="name" id="name" class="form-control" placeholder="Name" required autofocus /> 

<label for="inputEmail" class="sr-only">Email</label> 

<input type="email" name="email" id="inputEmail" class="form-control" placeholder="Email address" required /> 

<label for="contact" class="sr-only">Contact no</label> 

<input type="text" name="contact" id="contact" class="form-control" placeholder="Contact no" required />

<label for="inputPassword" class="sr-only">Password</label> 

<input type="password" name="password" id="password" class="form-control" placeholder="Password" required/> 

<label for="inputPassword" class="sr-only">Confirm Password</label> 

<input type="password" name="confirmpassword" id="confirmpassword" class="form-control" placeholder="Confirm Password"required/> 

<button class="btn btn-lg btn-primary btn-block" type="submit">Sign up</button>

</form>

</div>

</div>

</body>

</html>

welcome.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<link href="bootstrap.min.css" rel="stylesheet">

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Welcome</title>

</head>

<body>

<jsp:include page="header2.jsp" />

<div class="container">

<div class="jumbotron">

<h1 Style="color:Green"> This is a Profile Page: </h1>

<jsp:include page="error.jsp" />

</div>

</div>

</body>

</html>

error.jsp

<h3 Style="color: RED">

<%

   if (null != request.getAttribute("message")) {

       out.println(request.getAttribute("message"));

   }

%>

</h3>

Create all Servlets/ Java files

User.java

package com.masterjee.model;

public class User {

    private int id;

    private String name;

    private String email;

    private String contact;

    private String password;

    private String passwordConfirm;

    public int getId() {

        return id;

    }

    public void setId(int id) {

        this.id = id;

    }

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

    public String getEmail() {

        return email;

    }

    public void setEmail(String email) {

        this.email = email;

    }

    public String getPassword() {

        return password;

    }

    public void setPassword(String password) {

        this.password = password;

    }

    public String getContact() {

        return contact;

    }

    public void setContact(String contact) {

        this.contact = contact;

    }

    public String getPasswordConfirm() {

        return passwordConfirm;

    }

    public void setPasswordConfirm(String passwordConfirm) {

        this.passwordConfirm = passwordConfirm;

    }

}

LoginServlet.java

package com.masterjee.servlet;

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import com.masterjee.dao.LoginDao;

import com.masterjee.model.User;

public class LoginServlet extends HttpServlet {

    private static final long serialVersionUID = 4752123867015170472L;

    public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {

        response.setContentType("text/html;charset=UTF-8");

        String email = request.getParameter("email");

        String password = request.getParameter("password");

        User user = LoginDao.userLogin(email, password);

        if (user!=null &&user.getName() !=null) {

            HttpSession session = request.getSession();

            session.setAttribute("user", user.getName());

            request.setAttribute("message", "Welcome: "+user.getName());

            request.getRequestDispatcher("/welcome.jsp").include(request, response);

        } else {

            request.setAttribute("message", "Invalid username/password");

            request.getRequestDispatcher("login.jsp").include(request, response);

        }

    }

}

LogoutServlet.java

package com.masterjee.servlet;

import java.io.IOException;

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 LogoutServlet extends HttpServlet{

    private static final long serialVersionUID = 1L;

    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{

        response.setContentType("text/html");

        HttpSession session =request.getSession();

        session.invalidate();

        request.getRequestDispatcher("/home.jsp").forward(request, response);

    }

}

ProfileServlet.java

package com.masterjee.servlet;

import java.io.IOException;

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 ProfileServlet extends HttpServlet {

    private static final long serialVersionUID = -8668025769937825140L;

    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        response.setContentType("text/html");

        HttpSession session = request.getSession(false);

        if (session != null && session.getAttribute("user") != null) {

            request.setAttribute("message", "Welcome "+session.getAttribute("user"));

            request.getRequestDispatcher("/welcome.jsp").include(request, response);

        } else {

            request.setAttribute("message", "Please login first.....");

            request.getRequestDispatcher("/login.jsp").include(request, response);

        }

    }

}

RegisterServlet.java

package com.masterjee.servlet;

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.masterjee.dao.RegisterDao;

import com.masterjee.model.User;

public class RegisterServlet extends HttpServlet {

    private static final long serialVersionUID = 3597895668111903509L;

    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        response.setContentType("text/html");

        User user = new User();

        user.setName(request.getParameter("name"));

        user.setEmail(request.getParameter("email"));

        user.setContact(request.getParameter("contact"));

        user.setPassword(request.getParameter("password"));

        user.setPasswordConfirm(request.getParameter("confirmpassword"));

        if (!user.getPassword().equals(user.getPasswordConfirm())) {

            request.setAttribute("message", "Password and confirm password should be same..");

            request.getRequestDispatcher("register.jsp").include(request, response);

        } else {

            if (RegisterDao.register(user)) {

                request.setAttribute("message", "Records created successfully");

                request.getRequestDispatcher("login.jsp").include(request, response);

            } else {

                request.setAttribute("message", "error from database while inserting records....");

                request.getRequestDispatcher("register.jsp").include(request, response);

            }

        }

    }

}

ConnectionProvider.java

package com.masterjee.dao;

import java.sql.Connection;

import java.sql.DriverManager;

public class ConnectionProvider {

    private static ConnectionProvider connectionProvider = null;

    private static String DRIVER_NAME = "com.mysql.jdbc.Driver";

    private static String URL = "jdbc:mysql://localhost:3306/masterjee";

    private static String USER_NAME = "root";

    private static String PASSWORD = "root";

    private ConnectionProvider() {

    }

    public Connection getConnection() throws Exception {

        Class.forName(DRIVER_NAME);

        return DriverManager.getConnection(URL, USER_NAME, PASSWORD);

    }

    public static ConnectionProvider getInstance() {

        if (connectionProvider == null) {

            connectionProvider = new ConnectionProvider();

            return connectionProvider;

        }

        return connectionProvider;

    }

}

LoginDao.java

package com.masterjee.dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import com.masterjee.model.User;

public class LoginDao {

    public static User userLogin(String email, String password) {

        Connection connection = null;

        PreparedStatement preparedStatement = null;

        User user =null;

        try {

            connection = ConnectionProvider.getInstance().getConnection();

            preparedStatement = connection.prepareStatement("select * from user where email=? and password=?");

            preparedStatement.setString(1, email);

            preparedStatement.setString(2, password);

            ResultSet resultSet = preparedStatement.executeQuery();

            

            if (resultSet != null) {

                while(resultSet.next()){

                    user =new User();

                    user.setName(resultSet.getString(2));

                }

            }

        } catch (Exception e) {

            System.out.println(e);

        } finally {

            try {

                if (preparedStatement != null) {

                    preparedStatement.close();

                }

                if (connection != null) {

                    connection.close();

                }

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

        return user;

    }

}

RegisterDao.java

package com.masterjee.dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import com.masterjee.model.User;

public class RegisterDao {

    public static boolean register(User user) {

        Connection connection = null;

        PreparedStatement preparedStatement = null;

        try {

            connection = ConnectionProvider.getInstance().getConnection();

            preparedStatement = connection.prepareStatement("insert into user(name, email, password, contact) values(?,?,?,?)");

            preparedStatement.setString(1, user.getName());

            preparedStatement.setString(2, user.getEmail());

            preparedStatement.setString(3, user.getPassword());

            preparedStatement.setString(4, user.getContact());

            preparedStatement.executeUpdate();

            return true;

        } catch (Exception e) {

            System.out.println(e);

        } finally {

            try {

                if (preparedStatement != null) {

                    preparedStatement.close();

                }

                if (connection != null) {

                    connection.close();

                }

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

        return false;

    }

}