login.html
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<form method="post" action="login">
User Name:<input type="text" name="name" /><br/>
Password:<input type="password" name="pass" /><br/>
<input type="submit" value="login" />
</form>
</body>
</html>
login.java
package Code;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author Dilip
*/
public class login 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 name = request.getParameter("name");
String pass = request.getParameter("pass");
request.setAttribute("user",name );
if(Validate1.checkUser(name, pass))
{
RequestDispatcher rs = request.getRequestDispatcher("Welcome1");
rs.forward(request, response);
}
else
{
out.println("Username or Password incorrect");
RequestDispatcher rs = request.getRequestDispatcher("login.html");
rs.include(request, response);
}
} finally {
out.close();
}
}
}
Welcome1.java
package Code;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author Dilip
*/
public class Welcome1 extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String n=(String)request.getAttribute("user");
try {
out.println("Welcome user:"+n);
} finally {
out.close();
}
}
}
Validate1.java
package Code;
import java.sql.*;
/**
*
* @author Dilip
*/
public class Validate1 {
public static boolean checkUser(String uname,String pass)
{
boolean st =false;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:mydb","sa","niitbpl123");
PreparedStatement ps =con.prepareStatement("select * from student where name=? and pass=?");
ps.setString(1, uname);
ps.setString(2, pass);
ResultSet rs =ps.executeQuery();
st = rs.next();
}catch(Exception e)
{
e.printStackTrace();
}
return st;
}
}
Output
If user is and password are correct then output will be
If user is and password are incorrect then output will be
Comments
Post a Comment