servlet

print("code sample");
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*; 
import java.sql.*;
public class Login extends HttpServlet
{
  public void doGet(HttpServletRequest req, HttpServletResponse res)throws ServletException, IOException
  { 
   PrintWriter pw=res.getWriter();
   res.setContentType("text/html");
   pw.println("Hello"); 
    try 
       {
        Class.forName("com.mysql.jdbc.Driver");
        Connection con=DriverManager.getConnection("jdbc:mysql://localhost/latha","root","root");
      String uid=req.getParameter("Userid"); 
        String un=req.getParameter("Username"); 
        String p=req.getParameter("Password"); 

 PreparedStatement p1=con.prepareStatement("select * from Logintab where Userid=? and Username=? and  Password=?");
    p1.setString(1,uid);
    p1.setString(2,un);
    p1.setString(3,p);
    ResultSet r=p1.executeQuery();
   boolean b=r.next();


  if(b=true)

{
res.sendRedirect("http://localhost:8080/lata/Pms.html");

}

 else
  {

    pw.println("login is not successful");

      }

   con.close();
    }
      catch (Exception e)
      {
        pw.println(e);
      }
    }

}

this is the code for .java servlet am able to run sucessful but when i give wrong login it won't display login is not sucessful .instead it redirect to pms.html

View Answers

January 7, 2011 at 5:10 PM

Hello Friend,

The sendRedirect()method redirects the page so your message is not getting displayed. IF you want this, then try the following code:

1)login.jsp:

<html>
<script>
function validate(){
var username=document.form.user.value;
var password=document.form.pass.value;
if(username==""){
 alert("Enter Username!");
  return false;
}
if(password==""){
 alert("Enter Password!");
  return false;
}
return true;
}
</script>
<form name="form" method="post" action="../Login" onsubmit="javascript:return validate();">
<table>
<tr><td>Username:</td><td><input type="text" name="user"><label id="lab1"></label></td></tr>
<tr><td>Password:</td><td><input type="password" name="pass"><label id="lab2"></label></td></tr>
<tr><td></td><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>
<%String msg=request.getParameter("msg");
if(msg!=null){
    %>
<label><font color="red"><%=msg%></font></label> 
<%
}
    %>

2)Login.java:

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

public class Login extends HttpServlet{

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    try{
        response.setContentType("text/html");
        PrintWriter out=response.getWriter();
       String user=request.getParameter("user");
       String pass=request.getParameter("pass");
           Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from login where username='"+user+"' and password='"+pass+"'");
           int count=0;
           while(rs.next()){
           count++;
           }
           if(count>0){
            out.println("welcome "+user);
           }
          else{
              String msg="Login is not successful";
            response.sendRedirect("/examples/jsp/login.jsp?msg="+msg);
          }
    }catch (Exception e){
    e.printStackTrace();
    }
}
}

Hope that it will be helpful for you.

Thanks

Advertisements

servlet
servlet is there any way to include pdf's in servlet

servlet
servlet How many times the servlet is accessed

servlet
servlet what are the methods and interfaces in the servlet api ? Servlet Tutorials

servlet
servlet what are the all necessary configuration to run a servlet

servlet
servlet how to interact with a servlet from a swing program

servlet
servlet I designed 1 html form & a servlet but when I click on form I don't get output of servlet Please help

servlet
servlet i want to create a login page with servlet using database mysql? only in servlet not in jsp plzz help me out

Servlet
override Service method in the servlet when you extend GenericServlet to create servlet as it is mandatory to override it. But, when you extend HttpServlet to create a servlet then you can't override service method as there is a need to override

Servlet
Servlet What must be implemented by all Servlets? The Servlet Interface must be implemented by all servlets

servlet
servlet how to create a login form using servlet using submit,edit delete button

servlet
servlet dear sir servlet and html not run on eclips plz help me

servlet
servlet i want a program for counting the no of times the servlet has been invoked

servlet
servlet can i stoar record in variable which selected from table in servlet

servlet
of the Servlet API. It contains the classes necessary for a standard, protocol-independent servlet. Every servlet must implement the Servlet interface in one

Servlet
Servlet I want to know the steps to write a simple servlet program... . Hello Friend, Follow these steps: Put servlet-api.jar inside the lib folder of apache tomcat. 1)create a servlet. import java.io.*; import

Servlet
Servlet Why is Servlet so popular? Because servlets are platform-independent Java classes that are compiled to platform-neutral byte code that can be loaded dynamically into and run by a Java technology-enabled Web

servlet
servlet i want to use servlet application on my web page then what should i do. I have already webspace. Hi Friend, Please visit the following link:ADS_TO_REPLACE_1 Servlet Tutorials Thanks

servlet
servlet how to read a file from different folder using filereader in servlet Hello Friend, Please visit the following link:ADS_TO_REPLACE_1 http://www.roseindia.net/servlets/servlet-read-file.shtml Here you

Servlet
Servlet Can a user defined function be included in a servlet? I need information regarding servlet syntax and not JSP. Yes, you can create user defined function in Servlets. Have a look at the following link: http

servlet
servlet I want the full coding for uploading a file in local drive D usin jsp,java class and servlet... help me thanks in advance.... ... and servlet please and thanks in advance

Servlet
Servlet Hi, Can any one please expalin me below topics SERVLET ENGINE 2.WHY SUPER.INIT(); Thanks alot in advance!! Regards: Akash

servlet
servlet Dear Deepak, is it compulsary to write the sevice() becoz i ve seen some example which does not ve sevice()..is it tue? plz replay me with thanks praveen

servlet
servlet plz can anyone give me the link of javax library jar file. i badly need that. thanks in advance Please visit the following link: Download Servlet API

servlet
servlet I want a fully readymade project on online voting system with code in java servlet and database backend as msaccess.can u plz send me as soon as possible

Servlet
the same error <web-app> <servlet> <servlet-name>InsertServlet</servlet-name> <servlet-class>InsertServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>

servlet
servlet file which prints out the user's inputs. I need to use the post method to pass the data from html to the java servlet and also use both doGet and doPost methods in the servlet. I think, but unfortunately I have a terrible teacher

SERVLET
to the servlet and if the user id is correct then a new page will be displayed with his... pass to the servlet and all the fields brlongs to that id will be appear... will be done by using jsp and servlet... Plz help me,im really tensed...........

servlet
servlet hi sir,this is ashok.i installed tomcat 6.0 and jdk-150.i checked the server it's working but when execute servlet program for the .class file it shows the errors javax.servlet is not exist.what can i do,please tell me

servlet
to servlet. So, if anyone can help me so I can see how to connect the two I would

servlet
servlet How do we define an application level scope for servlet? Application scope uses a single namespace, which means all your pages should be careful not to duplicate the names of application scope objects

servlet
servlet how to jsp integer are type cast int servlet page Hi Friend, Try the following code:ADS_TO_REPLACE_1 1)form.jsp: <form method="post" action="../Data"> Enter Number:<input type="text" name="num

servlet
servlet try { con=DaoPack.createConnection(); } catch(Exception e) { e.printStackTrace(); } if(request.getParameter("addproduct")!=null) { ProductBean bean=new ProductBean

servlet
com.ilp.tsi.pm.services.StockService; /** * Servlet implementation class AddServlet1 */ //Servlet for Adding the stock public class AddStockServlet extends...; import com.ilp.tsi.utils.*; /** * Servlet implementation class Changepwd

servlet
); } } } this is the code for .java servlet am able to run

servlet
com.ilp.tsi.um.bean.BankBean; import com.ilp.tsi.um.service.BankService; /** * Servlet

on servlet - JSP-Servlet
on servlet deployment What we'll get on servlet deployment

Servlet - JSP-Servlet
Servlet and Java Code Example and source code in Servlet and JSP

servlet - Servlet Interview Questions
Servlet Priority How to set priority for servlet? in web.xml file we can set priority of servlet. 1 2

servlet - Servlet Interview Questions
servlet what is the full form of servlet

servlet Service
servlet Service Defined servlet Service

servlet initialization
servlet initialization define servlet initialization

Servlet Context
Servlet Context Defined Servlet Context

servlet container
servlet container What is servlet container

Servlet chaining
Servlet chaining What is Servlet chaining

servlet - JSP-Servlet
servlet navigation problem Hi, i am facing problem in Servlet navigation

servlet

Questions by Category