//vallidate user n pwd by validservlet
package active;
import javax.servlet.*;
import java.io.*;
import java.sql.*;
public class validservlet extends GenericServlet
{
Connection conn;
ServletConfig sc;
ServletContext scont;
public void init() throws ServletException
{
try{
sc=getServletConfig();
scont=sc.getServletContext();
String driver=scont.getInitParameter("driver");
String url=scont.getInitParameter("url");
String UNAME=sc.getInitParameter("UNAME");
String PWD=sc.getInitParameter("PWD");
Class.forName(driver);
conn=DriverManager.getConnection(url,UNAME,PWD);
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}
public void service(ServletRequest req, ServletResponse res) throws IOException,ServletException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
try{
String uname=req.getParameter("uname");
String pwd=req.getParameter("pwd");
String sql="SELECT * FROM userlogin UNAME=? and PWD=?";
PreparedStatement pst=conn.prepareStatement(sql);
pst.setString(1,UNAME);
pst.setString(2,PWD);
ResultSet rs=pst.executeQuery();
if(rs.next())
{
RequestDispatcher rd=req.getRequestDispatcher("Admin.java");
rd.forward(req,res);
}
else
{
RequestDispatcher rd=req.getRequestDispatcher("userlogin.html");
//rd.forward(req,res);
rd.include(req,res);
System.out.println("<center><font color=red>invalid</font></center>");
}
}
catch(Exception e){}
}
public void destroy()
{
try
{conn.close();
}catch(Exception e){}
}
}
//Admin
package active;
import javax.servlet.*;
import java.io.*;
import java.sql.*;
public class Admin extends GenericServlet
{
public void service(ServletRequest req,ServletResponse res)throws IOException,ServletException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
System.out.println("<center> welcome to Admin </center>");
}
}
<web-app>
<content-param>
<param-name>driver</param-name>
<param-value>
sun.jdbc.odbc.JdbcOdbcDriver
</param-value>
</content-param>
<content-param>
<param-name>url</param-name>
<param-value>
jdbc:odbc:mydsn
</param-value>
</content-param>
<servlet>
<servlet-name>validservlet</servlet-name>
<servlet-class>active.validservlet</servlet-class>
<init-param>
<param-name>user</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>password</param-name>
<param-value>rammohan</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>validservlet</servlet-name>
<url-pattern>/ss</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>Admin</servlet-name>
<servlet-class>active.Admin</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Admin</servlet-name>
<url-pattern>/admin</url-pattern>
</servlet-mapping>
</web-app>
//validate login.html
<html>
<body>
<body bgcolor="wheat">
<center>
<h1>Login Form</h1>
<form action="ss">
<Table>
<tr>
<td>enter name</td>
<td><Input Type="text" name="uname"></td>
</tr>
<tr>
<td>enter password</td>
<td><Input Type="password" name="pwd"></td>
</tr>
<tr>
<td><Input type="button" value="tick">remember my password</td>
</tr>
<tr>
<td><Input type="submit" value="submit"></td>
</tr>
<tr>
<td><Input type="reset" value="clear"></td>
</tr>
</Table>
</form>
</center>
</body>
</html>
1)login.html:
<h1>Login Form</h1> <form action="http://localhost:8080/examples/validservlet"> <Table> <tr> <td>enter name</td> <td><Input Type="text" name="uname"></td> </tr> <tr> <td>enter password</td> <td><Input Type="password" name="pwd"></td> </tr> <tr> <td><Input type="checkbox" value="tick">remember my password</td> </tr> <tr> <td><Input type="submit" value="submit"></td> </tr> <tr> <td><Input type="reset" value="clear"></td> </tr> </Table> </form>
2)validservlet.java:
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
public class validservlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PrintWriter pw = response.getWriter();
String uname=request.getParameter("uname");
String pwd=request.getParameter("pwd");
String username=getServletConfig().getInitParameter("user");
String password=getServletConfig().getInitParameter("password");
System.out.println(username+" "+password);
if((uname.equals(username))&&(pwd.equals(password))){
response.sendRedirect("Admin");
}
else{
response.sendRedirect("/examples/jsp/login.html");
}
}
}
3)Admin.java:
import javax.servlet.*;
import java.io.*;
import javax.servlet.http.*;
public class Admin extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PrintWriter pw = response.getWriter();
response.setContentType("text/html");
PrintWriter out=response.getWriter();
pw.println("welcome to Admin");
}
}
4)Add following code to web.xml:
<servlet>
<init-param>
<param-name>user</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>password</param-name>
<param-value>rammohan</param-value>
</init-param>
<servlet-name>validservlet</servlet-name>
<servlet-class>validservlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>validservlet</servlet-name>
<url-pattern>/validservlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>Admin</servlet-name>
<servlet-class>Admin</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Admin</servlet-name>
<url-pattern>/Admin</url-pattern>
</servlet-mapping>