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 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>
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
id="WebApp_ID" version="3.0">
<display-name>ServletLoginApp</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>
</web-app>
LoginServlet.java
package com.masterjee;
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
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");
String username = request.getParameter("username");
String password = request.getParameter("password");
RequestDispatcher dispatcher = null;
if (Validator.validate(username, password) && LoginDao.validate(username, password)) {
dispatcher = request.getRequestDispatcher("/welcome.jsp");
dispatcher.forward(request, response);
} else {
dispatcher = request.getRequestDispatcher("/error.jsp");
dispatcher.forward(request, response);
}
}
}
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;
}
}
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;
}
}
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;
}
}
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>
error.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>Error</title>
</head>
<body>
<h1>Welcome to error page</h1>
<h2 style="color: red;">Wrong Username or Password</h2><br/>
<a href="index.jsp">Index Page</a>
</body>
</html>
No comments:
Post a Comment