User's Autentication/Login Page Using Java Servlet and M.S.Access/SQL Database [Advanced Java Programming]

Home	»	Java	»	Advance Java	»	Java Servlet	»	User's Autentication Page

Today, in programming everybody wants login page of own website, where a user simple enter own UserName and Password and then further.... here required of users , very simple java programms. The following are two programs one Java Servlet Server side and one HTML Client Side. HTML Program Admin/User's Autentication Page where Admin/User will enter own UserName and Password, If both are correct then records will open from M.S.Acces's Table [Authenticated] and welcome page will open, If both are incorrect then error page will open and try again message will display. Both programs are very simple & easy to use, For this first of all you need to create a M.S.Access database or SQL... but in this example I'm using M.S.Access. Create one table in M.S Access as shown below:

Table Definitions:

Table Name	: [Authenticated.mdb] - Download
Primary Key	: ID
Foreign Key	: Nil

Column Definition:

Column Name	Data Type
ID	AutoNumber
UserName	Text
Password	Text

Table Description:

Column Name	Description
ID	Create AutoNumber for UserID
UserName	for a UserName for example Bintu or something....
Password	for a Password for example 123456 or something...

User's Autentication Table

All_Classes_2011_12 Table

After create table in M.S. Access database now you will create DSN.

Login.HTML

<!--
===========================================================
File Name : Login.html
WebSite : http://javaproglang.blogspot.in/
Facebook : https://www.facebook.com/AdvanceJavaProgramming
Twitter ID : https://twitter.com/AdvanceJava
Created By : Bintu Chaudhary
===========================================================
-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>School-Management System-User Authentication Form</Title>
<link rel="stylesheet" type="text/css" href="style/style.css" />
<link rel="stylesheet" type="text/css" href="style/w3.css" /> 
</head>

<body background="http://localhost:8080/school/school_images/background.JPG">
<br><br><br>

<center>
<h2>
<b>Admin/User's Autentication Page</B></h2>
</Center>
<form method=Post onSubmit="return verfiy(this.form)" action="http://localhost:8080/examples/servlet/UserLogin">
<br><br>

<table align=center cellspacing=0 cellpadding=5 bordercolor=darkcyan border=1 class="w3-ul w3-margin-top">
<tr><th>

<table Border=0 CellPaddingg="5" CellSpacing="0" width=550px; height=220px; align=Center bgcolor=organge>
<tr><th></TH></TR>
<tr><th><font size=4>School-Management-System</Font></Th></Tr>
<tr><th></TH></TR>
<tr><td><input Type=text class="w3-input w3-border" Name=UserName placeholder="UserName" required></Td></Tr>
<tr><td><input Type=Password class="w3-input w3-border" Name="Password" placeholder="Password" required></Td></Tr>
<tr><th></Th></Tr>
<tr><th></Th></Tr>
<tr><th></Th></Tr>
<tr><th></Th></Tr>
<tr>
<th colspan=2>
 <input Type=Submit class="w3-btn w3-teal" value="    Login    ">
 <input Type=Reset class="w3-btn w3-teal" Value="    Reset    ">
</Th>
</Tr>
</Table>
</Th></Tr>
</Table>
</Form>

<br><br><br><br><br><br><br>
<center>
<font size=2 color=gray>
Copyright © 2010, School-Management System, Developed by <a Href="MailTo:bintu.chaudhary.mks@gmail.com"> <b><font color=gray>Bintu Chaudhary </Font></b></A>  | Disclaimer
<br>Best viewed at 1024 x 768 resolution with Google Chrome or Mozila Firefox 3.6 and higher not Internet Explorer
</Body>
</html>

Now, second java servlet program...

UserLogin.java

/*
===========================================================
File Name : UserLogin.java 
WebSite : http://javaproglang.blogspot.in/
Facebook : https://www.facebook.com/AdvanceJavaProgramming
Twitter ID : https://twitter.com/AdvanceJava
Created By : Bintu Chaudhary
===========================================================
UserLogin Class to Check that User's Name and Password wrong or right
*/

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.Calendar;

public class UserLogin extends HttpServlet
{
        Connection conn;
        PrintWriter pw;
        public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
        {
                res.setContentType("text/html");
                pw=res.getWriter();
                String url="jdbc:odbc:khokhar";

                try
                {
                        String username =req.getParameter("UserName");
                        String password =req.getParameter("Password");

                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        conn=DriverManager.getConnection(url);
                        Statement stmt= conn.createStatement();
                        ResultSet rs=stmt.executeQuery("select * from Authenticated where UserName ='" +username+ "' and Password ='"+ password +"'");

                        if(rs.next()==false)
                        {
                                res.setContentType("text/html");
                                res.setStatus(HttpServletResponse.SC_OK);

                                pw.println("<html><head><title>User Authentication</Title></Head>");
                                pw.println("<body Background='http://localhost:8080/school/2011-12/background.bmp'>");

                                pw.println("<table width=100% align=center>");
                                pw.println("
<tr><th align=left><img src='http://localhost:8080/school/2011-12/schoollogo2.JPG' alt=schoollogo.jpg border=0 width=550 height=65></Th></Tr>
");
                                pw.println("</Table><hr>
");

                                //First Table
                                pw.println("<br><table width=50% align=center Border=0>");
                                pw.println("
<tr><th align=center><h3>
Sorry!!! Your User Name or Password Wrong</h3>
</Th></Tr>
");
                                pw.println("
<tr><th><input Type=Button value='   Try Again   ' onClick='history.back();'></Th></Tr>
");
                                pw.println("</Table>");

                                pw.println("<center>
<img src='http://localhost:8080/school/2011-12/schoollogo.JPG' alt=schoollogo.jpg border=0 width=350 height=300>");
                                
                                pw.println("<br><br><br><center>
");
                                pw.println("<font size=2 color=gray>");
                                pw.println("Copyright © 2011-12, School-Management System, Developed by <a Href='MailTo:bintu.chaudhary.mks@gmail.com'> <b><font color=gray>Bintu Chaudhary</Font> </b></A>  | Disclaimer");
                                pw.println("<br>Best viewed at 1024 x 768 resolution with Google Chrome or Mozila Firefox 3.6 and higher not Internet Explorer");

                                pw.println("</Body></html>");
                        }                
                        else
                        {
                                String sql_chk=("select * from Authenticated where UserName ='" +username+ "' and Password ='"+ password +"'");
                                rs=stmt.executeQuery(sql_chk);
                                
                                pw.println("<html><head><title>User Authentication</Title></Head>");
                                pw.println("<body Background='http://localhost:8080/school/2011-12/background.bmp'>");

                                pw.println("<table width=100% align=center>");
                                pw.println("
<tr><th align=left><img src='http://localhost:8080/school/2011-12/schoollogo2.JPG' alt=schoollogo.jpg border=0 width=550 height=65></Th></Tr>
");
                                pw.println("</Table><hr>
");
                                pw.println("<center>
<h2>
<marquee>Welcome "+username+"</Marquee></h2>
</Center>");

                                pw.println("<table align=center Border=0>");
                                pw.println("
<tr><th><a href='http://localhost:8080/school/2011-12/index2011_12.html'><input Type=button Value=' Session 2011-12 '></a></Th>");
                                pw.println("<form method=post action='http://localhost:8080/examples/servlet/EditPassword'>
");
                                pw.println("<input Type=hidden name=username value="+username+">");
                                pw.println("<th><u><input Type=submit Value='Change-Password'></u></Th></Form></Tr>
");
                                pw.println("</Tr>
</Table>");

                                pw.println("<center>
<img src='http://localhost:8080/school/2011-12/schoollogo.JPG' alt=schoollogo.jpg border=0 width=350 height=300>");
                                
                                pw.println("<br><br><br><center>
");
                                pw.println("<font size=2 color=gray>");
                                pw.println("Copyright © 2011-12, School-Management System, Developed by <a Href='MailTo:bintu.chaudhary.mks@gmail.com'> <b><font color=gray>Bintu Chaudhary</Font></b></A>  | Disclaimer");
                                pw.println("<br>Best viewed at 1024 x 768 resolution with Google Chrome or Mozila Firefox 3.6 and higher not Internet Explorer");
                                stmt.close();
                                conn.close();
                                pw.println("</Body></html>");                
                        }                                
                }
                catch(Exception e)
                {
                        pw.println(e.getMessage());
                }
        }
}

"Start -> All Programs -> Apache Tomcat 4.0 -> Start Tomcat." and minimize window

How to Install Apache Tomcat 4.0 then Click Here

and for Download Apache Tomcat 4.0 then Click Here

Now compile the above both code using javac compiler...

C:\jdk1.4\bin>javac UserLogin.java -classpath "C:/Program Files/Apache Tomcat 4.0/common/lib/servlet.jar"

C:\jdk1.4\bin>javac UserLogin.java -classpath "C:/Program Files/Apache Tomcat 4.0/common/lib/servlet.jar"

Now, copy "UserLogin.class" File from c:/jdk1.4/bin/ and then paste it under below dir...

"C:/Program Files/Apache Tomcat 4.0/webapps/examples/WEB-INF/classes/"

or use below command

C:\jdk1.4\bin>copy UserLogin.class "C:/Program Files/Apache Tomcat 4.0/webapps/examples/WEB-INF/classes/"

or you can use "*.class" for copy all classes...

C:\jdk1.4\bin>copy *.class "C:/Program Files/Apache Tomcat 4.0/webapps/examples/WEB-INF/classes/"

Now Open any web browser and type client side URL into address bar as below...

http://localhost:8080/Login.html

User's Autentication Page

Error Page (If Password is wrong)

Final Welcome Page of School-Management-System

Complete Source Code of USER-AUTENTICATION PAGE With Database - Download

30 comments:

GloryMarch 29, 2019 at 5:49 PM
Hi,
I read your article, you’re describing of expression is excellent and the most valuable thing is, your attracting topic declaration. I really enjoyed and great effort.
Thanks for sharing!
ReplyDelete
Replies
rbatecMay 17, 2019 at 11:22 AM
thanks for this informative tutorial.. I am really glad I have found this information
Hello world in C programming
ReplyDelete
Replies
gokulJune 10, 2019 at 4:57 AM
Thanks for sharing this tutorial.I would like to suggest
java training in velachery for better tutorial and job assistance
ReplyDelete
Replies
Venkatesh CSJune 13, 2019 at 9:19 PM
Thanks for sharing valuable information.
Java Training with Placements
ReplyDelete
Replies
Rahul ChauhanJune 27, 2019 at 12:24 AM
Thank you for sharing such knowledgeable post its not only helpful for the old but also new student for better preparation. I just share your post with my friends so that they can also read your post. Training Institute on Advance Java.
ReplyDelete
Replies
AnanditaJune 28, 2019 at 10:01 PM
It’s hard to come by experienced people about this subject, but you seem like you know what you’re talking about! Thanks
Java Training Center in Bangalore
ReplyDelete
Replies
developer rahulJuly 2, 2019 at 6:54 AM
Best Java development service in houston @ Affordable java developer service in USA
ReplyDelete
Replies
ACLJuly 15, 2019 at 6:16 AM
Very useful information provided. As a JAVA training institute ACL IT academy appreciate such blogs. Thanks and regards
ACL IT academy- Java Training Institute in Kolkata

ReplyDelete
Replies
pegasimediagroupJuly 17, 2019 at 3:04 AM
Very impressive article! The blog is highly informative and has answered all my questions. To introduce about our company and the activities, Pegasi Media Group is a database provider that helps you to boost your sales & grow your business through well-build Java user list
ReplyDelete
Replies
Raj SharmaJuly 26, 2019 at 11:27 PM
Awesome post. You Post is very informative. Thanks for Sharing.
Core Java Course in Noida
ReplyDelete
Replies
aishuAugust 17, 2019 at 12:32 AM
Hi there I am so thrilled I found your website, I really found you by mistake, while I was browsing on Yahoo for something else, Anyhow I am here now and would just like to say thanks a lot for a tremendous post and an all-round exciting blog (I also love the theme/design), I don’t have time to go through it all at the minute but I have saved it and also added in your RSS feeds, so when I have time I will be back to read more, Please do keep up the awesome job.Surya Informatics

ReplyDelete
Replies
RasiSeptember 9, 2019 at 11:15 PM
Thanks for sharing,nice article.
AWS Training in Hyderabad
Best AWS Training in Hyderabad
AWS Online Training
AWS Training Online
AWS Training In Bangalore
ReplyDelete
Replies
UnknownOctober 17, 2019 at 4:54 AM
Best devops online training institute.they are giving complete core subject of devops.and i am very thankfull for this institute.
ReplyDelete
Replies
ReethuDecember 9, 2019 at 2:33 AM
Thanks for sharing the good post.
Machine Learning training in Pallikranai Chennai
Pytorch training in Pallikaranai chennai
Data science training in Pallikaranai
Python Training in Pallikaranai chennai
Deep learning with Pytorch training in Pallikaranai chennai
Bigdata training in Pallikaranai chennai
Mongodb Nosql training in Pallikaranai chennai
Spark with ML training in Pallikaranai chennai
Data science Python training in Pallikaranai
Bigdata Spark training in Pallikaranai chennai
Sql for data science training in Pallikaranai chennai
Sql for data analytics training in Pallikaranai chennai
Sql with ML training in Pallikaranai chennai
ReplyDelete
Replies
ShasankarDecember 9, 2019 at 5:14 AM
Great Work thanks for sharing this article best java course center in coimbatore
java training in coimbatore
Top 10 java training institute in coimbatore
ReplyDelete
Replies
AtulDecember 27, 2019 at 4:25 AM
I'm too lazy to sign up an account just for comment your article. it's really good and helping dude. thanks!Java Training Institute in Delhi
ReplyDelete
Replies
Raj SharmaJanuary 2, 2020 at 2:52 AM
Good Post. I like your blog. Thanks for Sharing.
Core JAVA Training in Noida
ReplyDelete
Replies
JeniferJanuary 6, 2020 at 4:44 AM
It was a very good experience,Faculty members are very knowledgeable and cooperative. Specially My trainer teaching more as he focused upon practical rather than theory. All together it was an enlightening and informative course.

advanced java training institutes in bangalore

advanced java training in bangalore

best advanced java training institutes in bangalore

advanced java training course content

advanced java training interview questions

advanced java training & placement in bangalore

advanced java training center in bangalore

ReplyDelete
Replies
AVSVishalJuly 3, 2020 at 10:54 PM
https://www.vishalbhardwaj.com/2020/07/Commerce-Business-Administration.html

https://www.vishalbhardwaj.com/2020/07/Commerce-Notes.html

https://www.vishalbhardwaj.com/2020/06/what-is-data-structure.html

https://www.vishalbhardwaj.com/2020/07/CPP-in-Hindi.html
ReplyDelete
Replies
techmienews.blogspot.comOctober 27, 2020 at 3:03 AM
Hi, thanks for this informative tutorial.. We are technology/news/smartphone company, If you want to read such useful news then Visit us: https://techmie.com/
ReplyDelete
Replies
Aptron DelhiDecember 23, 2020 at 10:10 PM
Java Course in Delhi And Contact us:- +91-706-527-1000
ReplyDelete
Replies
Ria Training InstituteJanuary 22, 2021 at 3:32 AM
Thanks for sharing as it is an excellent post would love to read your future post Advance Java Training Institute In Bangalore | Dot Net Training Institute In Bangalore | Ms Access Training Institute In Bangalore
ReplyDelete
Replies
ManiJune 21, 2021 at 2:50 AM
Thanks for the post ,

Mobile Development Agency
ReplyDelete
Replies
Aptron GurgaonJune 25, 2021 at 4:23 AM
Thanks for sharing this Information. Java Training in Gurgaon
ReplyDelete
Replies
Asit MaharanaSeptember 5, 2021 at 8:52 PM
thank you bro
For core to advanced java and .net
ReplyDelete
Replies
SamOctober 10, 2021 at 11:40 PM
It was a very good experience,Faculty members are very knowledgeable and cooperative. Specially My trainer teaching more as he focused upon practical rather than theory.
Java Developer Jobs available in Chennai
ReplyDelete
Replies
AnonymousOctober 13, 2021 at 6:25 AM
It was so good seeing your website and your content is so accurately put which will be so useful for people to get some understanding quick, if such topics intrigue you you can check out data science course in bangalore
ReplyDelete
Replies
sam kirubakarNovember 16, 2021 at 4:34 AM
Thanks for sharing// article is good.Dot Net Developer Jobs available in Chennai
ReplyDelete
Replies
sam kirubakarNovember 22, 2021 at 6:01 AM
Thanks for sharing. article is good.

Java developer job available in Chennai
ReplyDelete
Replies
Welcome to Ducat IndiaFebruary 15, 2022 at 10:48 PM
Great Post. Very informative. Keep Sharing!!

Join Online Java Classes

For more details about the course fee, duration, classes, certification, and placement call our expert at 70-70-90-50-90
ReplyDelete
Replies

Add comment

Java Tutorials

	Section 1
	Home
	Introduction To Java
	Java Evolution
	Overview of Java
	Constants, Variables & Data Types
	Java Operators
	Branching Statements
	Looping Statements
	Section 2
	Classes, Objects & Methods
	Inheritance
	Array, String & Vectors
	Java Interfaces
	Java Packages
	Java Applet Programming
	Java Graphics Programming
Advance Java Programming
	Section 1
	Java AWT
	Java Event Handling
	Java File Handling
	Java MultiThreading
	Java Swing-I
	Java Swing-II
	Java Exception Handling
	Section 2
	Java Socket Programming
	Java Database Connectivity
	Java RMI
	Java Servlets
	Java Beans

User's Autentication/Login Page Using Java Servlet and M.S.Access/SQL Database [Advanced Java Programming]

30 comments:

Useful Links

Visitors

Java Tutorials

Follow by Email

Follow Advanced Java Programming on Facebook

Popular Programs

Follow Advanced Java Programming on Twitter