SQL Query for table creation and data
create table user(id INT NOT NULL AUTO_INCREMENT, username varchar(255) NOT NULL, password varchar(255) NOT NULL, primary key(id))
insert into user values(2,'anil','anil');
insert into user values(2,'test','test');
Add jars inside WebContent/WEB-INF/lib
- javax.servlet-api-3.1.0.jar
- mysql-connector-java-5.1.42-bin.jar
index.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>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Servlet example</title>
</head>
<body>
<h1>Login app using Cookie</h1>
<a href="login.jsp">Login</a>|
<a href="logout">Logout</a>|
<a href="profile">Profile</a>
</form>
</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>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Servlet example</title>
</head>
<body>
<h1>Login Page</h1>
<form action="login" method="post">
UserName: <input type="text" name="username"/><br/><br/>
Password : <input type="text" name="password"/><br/><br/>
<input type="submit" value="Login"/>
</form>
</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>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Welcome</title>
</head>
<body>
<h1>Welcome to this page</h1>
<h2 style="color: green;">Congratulation: Correct user name or password</h2><br/>
<a href="index.jsp">Index Page</a>
</body>
</html>
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>LoginAppCookies</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>LoginServlet</servlet-name>
<servlet-class>com.masterjee.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>LoginServlet</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>LogOutServlet</servlet-name>
<servlet-class>com.masterjee.LogOutServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>LogOutServlet</servlet-name>
<url-pattern>/logout</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>ProfileServlet</servlet-name>
<servlet-class>com.masterjee.ProfileServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ProfileServlet</servlet-name>
<url-pattern>/profile</url-pattern>
</servlet-mapping>
</web-app>
LoginServlet .java
package com.masterjee;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class LoginServlet extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 4944251896777042838L;
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String username = request.getParameter("username");
String password = request.getParameter("password");
RequestDispatcher dispatcher = null;
if (Validator.validate(username, password) && LoginDao.validate(username, password)) {
out.print("You are successfully logged in!");
out.print("<br>Welcome, " + username);
Cookie cookie = new Cookie("username", username);
response.addCookie(cookie);
dispatcher = request.getRequestDispatcher("/welcome.jsp");
dispatcher.include(request, response);
} else {
out.print("sorry, username or password error!");
dispatcher =request.getRequestDispatcher("index.jsp");
dispatcher.include(request, response);
}
}
}
LoginDao.java
package com.masterjee;import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class LoginDao {
public static boolean validate(String username, String password) {
Connection connection = null;
PreparedStatement preparedStatement = null;
try {
connection = ConnectionProvider.getInstance().getConnection();
preparedStatement = connection.prepareStatement("select username from user where username=? and password=?");
preparedStatement.setString(1, username);
preparedStatement.setString(2, password);
System.out.println("preparedStatement:"+preparedStatement);
ResultSet resultSet = preparedStatement.executeQuery();
if (resultSet != null) {
return resultSet.next();
}
} catch (Exception e) {
System.out.println(e);
} finally {
try {
if (preparedStatement != null) {
preparedStatement.close();
}
if(connection !=null){
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
System.out.println("resultSet user name password not exist.....");
return false;
}
}
ConnectionProvider.java
package com.masterjee;
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;
}
}
Validator .java
package com.masterjee;
public class Validator {
public static boolean validate(String username, String password ){
if(username !=null && !username.equals("") && password !=null && !password.equals("") ){
return true;
}
return false;
}
}
LogOutServlet.java
package com.masterjee;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class LogOutServlet extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 4944251896777042838L;
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out=response.getWriter();
Cookie cookie =new Cookie("username", "");
cookie.setMaxAge(0);
response.addCookie(cookie);
out.print("you are successfully logged out!");
RequestDispatcher dispatcher = request.getRequestDispatcher("/index.jsp");
dispatcher.include(request, response);
}
}
ProfileServlet.java
package com.masterjee;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.Arrays;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ProfileServlet extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 4944251896777042838L;
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
RequestDispatcher requestDispatcher=null;
Cookie cookie[]=request.getCookies();
if(cookie !=null){
if(!Arrays.asList(cookie).isEmpty() && Arrays.asList(cookie).stream().filter(c->c.getName().equals("username")).findFirst().isPresent()){
requestDispatcher =request.getRequestDispatcher("welcome.jsp");
requestDispatcher.include(request, response);
}else{
out.print("Please login first");
requestDispatcher =request.getRequestDispatcher("index.jsp");
requestDispatcher.include(request, response);
}
}
}
}
No comments:
Post a Comment