Style Sheets
WebContent/css/stylesheet.css
@CHARSET "ISO-8859-1";
body {
font-family: Verdana, Arial, sans-serif;
font-size: smaller;
padding: 50px;
color: #555;
width: 650px;
}
h1 {
letter-spacing: 6px;
font-size: 1.6em;
color: #be7429;
font-weight: bold;
}
h2 {
text-align: left;
letter-spacing: 6px;
font-size: 1.4em;
color: #be7429;
font-weight: normal;
width: 450px;
}
table {
width: 550px;
padding: 10px;
background-color: #c5e7e0;
font-family: sans-serif;
}
td {
padding: 10px;
}
a {
color: #be7429;
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
.popupBox {
position: absolute;
top: 170px;
left: 140px;
}
.popupCell {
background-color: #fffafa;
}
.popupCell:hover {
background-color: #f5ebe9;
}
.popupItem {
color: #333;
text-decoration: none;
font-size: 1.2em;
}
*******************************************************************************
CREATE TABLE userlogindetails(
username CHAR(20),
password CHAR(20)
);
WebContent/jsp/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>
<link rel="stylesheet" type="text/css" href="css/stylesheet.css">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>User Login Screen</title>
<script type="text/javascript">
function validateForm() {
var username = document.getElementById("username").value;
var password = document.getElementById("password").value;
//var username=document.login.username.value;
//var password=document.login.password.value;
if (username == null || username == "" || password == null
|| password == "") {
if (username == null || username == "") {
alert("Please Enter User Name");
} else {
alert("Please Enter Password");
}
return false;
} else {
return true;
}
}
</script>
</head>
<body>
<h2>Sign in</h2>
<form action="Hello.do" name="login" id="login" method="post"
onSubmit="return validateForm()">
<table border="2" cellpadding="1">
<tbody>
<tr>
<td>User Name</td>
<td><input type="text" id="username" name="username"
value="" size="60" /></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" id="password"
name="password" value="" size="60" /></td>
</tr>
</tbody>
</table>
<br> <br> <br>
<h2>
Login
<input type="submit" value="Submit" name="submit" />
<input type="reset" value="Reset" name="reset" />
</h2>
</form>
</body>
</html>
WebContent/jsp/success.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 rel="stylesheet" type="text/css" href="css/stylesheet.css">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Success View</title>
</head>
<body>
<h1>Success Login</h1>
<h2>
<%
String user = (String) request.getAttribute("success");
out.print("Well Come " + user + " .....!!!!!!");
%>
You have Successful User Acccount for this System
</h2>
</body>
</html>
WebContent/jsp/fail.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>
<style type="text/css">
#para1 {
text-align: left;
letter-spacing: 6px;
font-size: 1.4em;
color: red;
font-weight: normal;
width: 450px;
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Fail View</title>
</head>
<body>
<span id="para1"> Sorry......... <br> Login Fail <br>
Invalid User Acccount
</span>
</body>
</html>
src/pojo/Login.java
package pojo;
public class Login {
private String userName;
private String password;
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
src/login/LoginManager.java
package login;
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;
import pojo.Login;
import dbhandler.DBHandler;
import dbutil.DBUtil;
public class LoginManager extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException,
IOException {
String redirectpath = "";
boolean success = false;
try {
String userName = request.getParameter("username");
String password = request.getParameter("password");
System.out.println("--User Name----->" + userName);
System.out.println("--Password----->" + password);
if (userName != null && !userName.equals("") && password != null
&& !password.equals("")) {
DBUtil dbHandler = new DBHandler();
Login login = new Login();
login.setUserName(userName.trim());
login.setPassword(password.trim());
success = dbHandler.loginOperation(login);
System.out.println("---Success---->" + success);
}
if (success) {
request.setAttribute("success", userName);
redirectpath = "/jsp/success.jsp";
} else {
redirectpath = "/jsp/fail.jsp";
}
RequestDispatcher requestDispatcher = getServletContext()
.getRequestDispatcher(redirectpath);
requestDispatcher.forward(request, response);
} catch (Exception e) {
e.printStackTrace();
}
}
}
src/dbutil/DBUtil.java
package dbutil;
import pojo.Login;
public interface DBUtil {
public boolean loginOperation(Login login);
}
src/dbhandler/DBConnection.java
package dbhandler;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnection {
String driverClass = "";
String url = "";
String dbuser = "";
String dbpass = "";
public Connection connection = null;
private static DBConnection dbconnection = null;
private DBConnection() {
driverClass = "org.postgresql.Driver";
url = "jdbc:postgresql://localhost/";
dbuser = "postgres";
dbpass = "admin";
try {
Class.forName(driverClass);
connection = DriverManager.getConnection(url, dbuser, dbpass);
} catch (ClassNotFoundException e) {
System.out.println("ClassNotFoundException ......" + e);
} catch (SQLException e) {
System.out.println("SQLException in connecting time...." + e);
}
}
public static Connection getConnection() {
if (dbconnection == null) {
dbconnection = new DBConnection();
}
return dbconnection.connection;
}
}
src/dbhandler/DBHandler.java
package dbhandler;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import pojo.Login;
import dbutil.DBUtil;
public class DBHandler implements DBUtil {
@Override
public boolean loginOperation(Login login) {
boolean success = false;
Connection connection = DBConnection.getConnection();
if (null != connection) {
try {
success = getUserData(connection, login);
} catch (SQLException e) {
e.printStackTrace();
}
}
return success;
}
public boolean getUserData(Connection connection, Login login)
throws SQLException {
boolean success = false;
String userName = "";
String password = "";
String query = "";
ResultSet resultQuary = null;
Statement stmt = null;
try {
if (null != connection && !connection.equals("")) {
stmt = (Statement) connection.createStatement();
query = "SELECT username, password FROM userlogindetails ";
resultQuary = stmt.executeQuery(query);
if (null != resultQuary && !resultQuary.equals("")) {
loop: while (resultQuary.next()) {
userName = resultQuary.getString("username");
password = resultQuary.getString("password");
System.out.println("---DB userName--->" +
userName);
System.out.println("---DB password--->" +
password);
if
(login.getUserName().equals(userName.trim())
&&
login.getPassword().equals(password.trim())) {
success = true;
break loop;
} else {
success = false;
}
}
}
}
} catch (SQLException e) {
System.out.println("SQLException in executing time...." + e);
} finally {
resultQuary.close();
stmt.close();
}
return success;
}
}
WebContent/WEB-INF/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" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
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>JspServletExample03</display-name>
<welcome-file-list>
<welcome-file>jsp/login.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>REG</servlet-name>
<servlet-class>login.LoginManager</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>REG</servlet-name>
<url-pattern>/Hello.do</url-pattern>
</servlet-mapping>
</web-app>
WebContent/css/stylesheet.css
@CHARSET "ISO-8859-1";
body {
font-family: Verdana, Arial, sans-serif;
font-size: smaller;
padding: 50px;
color: #555;
width: 650px;
}
h1 {
letter-spacing: 6px;
font-size: 1.6em;
color: #be7429;
font-weight: bold;
}
h2 {
text-align: left;
letter-spacing: 6px;
font-size: 1.4em;
color: #be7429;
font-weight: normal;
width: 450px;
}
table {
width: 550px;
padding: 10px;
background-color: #c5e7e0;
font-family: sans-serif;
}
td {
padding: 10px;
}
a {
color: #be7429;
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
.popupBox {
position: absolute;
top: 170px;
left: 140px;
}
.popupCell {
background-color: #fffafa;
}
.popupCell:hover {
background-color: #f5ebe9;
}
.popupItem {
color: #333;
text-decoration: none;
font-size: 1.2em;
}
*******************************************************************************
CREATE TABLE userlogindetails(
username CHAR(20),
password CHAR(20)
);
WebContent/jsp/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>
<link rel="stylesheet" type="text/css" href="css/stylesheet.css">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>User Login Screen</title>
<script type="text/javascript">
function validateForm() {
var username = document.getElementById("username").value;
var password = document.getElementById("password").value;
//var username=document.login.username.value;
//var password=document.login.password.value;
if (username == null || username == "" || password == null
|| password == "") {
if (username == null || username == "") {
alert("Please Enter User Name");
} else {
alert("Please Enter Password");
}
return false;
} else {
return true;
}
}
</script>
</head>
<body>
<h2>Sign in</h2>
<form action="Hello.do" name="login" id="login" method="post"
onSubmit="return validateForm()">
<table border="2" cellpadding="1">
<tbody>
<tr>
<td>User Name</td>
<td><input type="text" id="username" name="username"
value="" size="60" /></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" id="password"
name="password" value="" size="60" /></td>
</tr>
</tbody>
</table>
<br> <br> <br>
<h2>
Login
<input type="submit" value="Submit" name="submit" />
<input type="reset" value="Reset" name="reset" />
</h2>
</form>
</body>
</html>
WebContent/jsp/success.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 rel="stylesheet" type="text/css" href="css/stylesheet.css">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Success View</title>
</head>
<body>
<h1>Success Login</h1>
<h2>
<%
String user = (String) request.getAttribute("success");
out.print("Well Come " + user + " .....!!!!!!");
%>
You have Successful User Acccount for this System
</h2>
</body>
</html>
WebContent/jsp/fail.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>
<style type="text/css">
#para1 {
text-align: left;
letter-spacing: 6px;
font-size: 1.4em;
color: red;
font-weight: normal;
width: 450px;
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Fail View</title>
</head>
<body>
<span id="para1"> Sorry......... <br> Login Fail <br>
Invalid User Acccount
</span>
</body>
</html>
src/pojo/Login.java
package pojo;
public class Login {
private String userName;
private String password;
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
src/login/LoginManager.java
package login;
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;
import pojo.Login;
import dbhandler.DBHandler;
import dbutil.DBUtil;
public class LoginManager extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException,
IOException {
String redirectpath = "";
boolean success = false;
try {
String userName = request.getParameter("username");
String password = request.getParameter("password");
System.out.println("--User Name----->" + userName);
System.out.println("--Password----->" + password);
if (userName != null && !userName.equals("") && password != null
&& !password.equals("")) {
DBUtil dbHandler = new DBHandler();
Login login = new Login();
login.setUserName(userName.trim());
login.setPassword(password.trim());
success = dbHandler.loginOperation(login);
System.out.println("---Success---->" + success);
}
if (success) {
request.setAttribute("success", userName);
redirectpath = "/jsp/success.jsp";
} else {
redirectpath = "/jsp/fail.jsp";
}
RequestDispatcher requestDispatcher = getServletContext()
.getRequestDispatcher(redirectpath);
requestDispatcher.forward(request, response);
} catch (Exception e) {
e.printStackTrace();
}
}
}
src/dbutil/DBUtil.java
package dbutil;
import pojo.Login;
public interface DBUtil {
public boolean loginOperation(Login login);
}
src/dbhandler/DBConnection.java
package dbhandler;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnection {
String driverClass = "";
String url = "";
String dbuser = "";
String dbpass = "";
public Connection connection = null;
private static DBConnection dbconnection = null;
private DBConnection() {
driverClass = "org.postgresql.Driver";
url = "jdbc:postgresql://localhost/";
dbuser = "postgres";
dbpass = "admin";
try {
Class.forName(driverClass);
connection = DriverManager.getConnection(url, dbuser, dbpass);
} catch (ClassNotFoundException e) {
System.out.println("ClassNotFoundException ......" + e);
} catch (SQLException e) {
System.out.println("SQLException in connecting time...." + e);
}
}
public static Connection getConnection() {
if (dbconnection == null) {
dbconnection = new DBConnection();
}
return dbconnection.connection;
}
}
src/dbhandler/DBHandler.java
package dbhandler;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import pojo.Login;
import dbutil.DBUtil;
public class DBHandler implements DBUtil {
@Override
public boolean loginOperation(Login login) {
boolean success = false;
Connection connection = DBConnection.getConnection();
if (null != connection) {
try {
success = getUserData(connection, login);
} catch (SQLException e) {
e.printStackTrace();
}
}
return success;
}
public boolean getUserData(Connection connection, Login login)
throws SQLException {
boolean success = false;
String userName = "";
String password = "";
String query = "";
ResultSet resultQuary = null;
Statement stmt = null;
try {
if (null != connection && !connection.equals("")) {
stmt = (Statement) connection.createStatement();
query = "SELECT username, password FROM userlogindetails ";
resultQuary = stmt.executeQuery(query);
if (null != resultQuary && !resultQuary.equals("")) {
loop: while (resultQuary.next()) {
userName = resultQuary.getString("username");
password = resultQuary.getString("password");
System.out.println("---DB userName--->" +
userName);
System.out.println("---DB password--->" +
password);
if
(login.getUserName().equals(userName.trim())
&&
login.getPassword().equals(password.trim())) {
success = true;
break loop;
} else {
success = false;
}
}
}
}
} catch (SQLException e) {
System.out.println("SQLException in executing time...." + e);
} finally {
resultQuary.close();
stmt.close();
}
return success;
}
}
WebContent/WEB-INF/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" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
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>JspServletExample03</display-name>
<welcome-file-list>
<welcome-file>jsp/login.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>REG</servlet-name>
<servlet-class>login.LoginManager</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>REG</servlet-name>
<url-pattern>/Hello.do</url-pattern>
</servlet-mapping>
</web-app>
No comments:
Post a Comment