Sample Login Form With Database Connection and Using Servlet
login.html
<html>
<head>login page</head>
<body>
<form action="./LoginSer" method="POST">
<table>
<tr><td> Login here </td></tr>
<tr><td>Enter User Id :</td>
<td><input type="text" name="uid" value="" /> </td></tr>
<tr><td>Enter Password :</td>
<td><input type="password" name="psw" value="" /> </td></tr>
<tr><td> </td><td><input type="submit" value="Login" /></td></tr>
</table>
</form>
</body>
</html>
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
@WebServlet(name = "LoginSer", urlPatterns = {"/LoginSer"})
public class LoginSer extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {
String uid,psw;
uid=request.getParameter("uid");
psw=request.getParameter("psw");
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname","db user","db password");
String q="select * from reg1 where (uid='"+uid+"'and psw='"+psw+"')";
Statement stmt1=con.createStatement();
ResultSet rs=stmt1.executeQuery(q);
String tuid="",tpsw="";
while(rs.next())
{
tuid=rs.getString("uid");
tpsw=rs.getString("psw");
}
if(uid.equals(tuid)&&psw.equals(tpsw))
{
HttpSession session=request.getSession(true);
session.setAttribute("uid",uid);
RequestDispatcher rd1=request.getRequestDispatcher("home.html");
request.setAttribute("uid", uid);
rd1.forward(request, response);
}
else
{
RequestDispatcher rd1=request.getRequestDispatcher("login.html");
rd1.forward(request, response);
}
}
catch(Exception e)
{out.println(e);
}finally {
out.close();
}
}
home.html
login.html
<html>
<head>login page</head>
<body>
<form action="./LoginSer" method="POST">
<table>
<tr><td> Login here </td></tr>
<tr><td>Enter User Id :</td>
<td><input type="text" name="uid" value="" /> </td></tr>
<tr><td>Enter Password :</td>
<td><input type="password" name="psw" value="" /> </td></tr>
<tr><td> </td><td><input type="submit" value="Login" /></td></tr>
</table>
</form>
</body>
</html>
LoginSer.java
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
@WebServlet(name = "LoginSer", urlPatterns = {"/LoginSer"})
public class LoginSer extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {
String uid,psw;
uid=request.getParameter("uid");
psw=request.getParameter("psw");
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname","db user","db password");
String q="select * from reg1 where (uid='"+uid+"'and psw='"+psw+"')";
Statement stmt1=con.createStatement();
ResultSet rs=stmt1.executeQuery(q);
String tuid="",tpsw="";
while(rs.next())
{
tuid=rs.getString("uid");
tpsw=rs.getString("psw");
}
if(uid.equals(tuid)&&psw.equals(tpsw))
{
HttpSession session=request.getSession(true);
session.setAttribute("uid",uid);
RequestDispatcher rd1=request.getRequestDispatcher("home.html");
request.setAttribute("uid", uid);
rd1.forward(request, response);
}
else
{
RequestDispatcher rd1=request.getRequestDispatcher("login.html");
rd1.forward(request, response);
}
}
catch(Exception e)
{out.println(e);
}finally {
out.close();
}
}
home.html
<html>
<body>
<head> welcome page</head>
<h1> Hi Welcome To India</h1>
</body>
</html>
No comments:
Post a Comment