String vuname=response.getParameter("username");
   String vpswd=response.getparameter("password");
        String vsql="select * from login where username = '" + vuname + "' and password = '" + vpswd + "'";
        System.out.println("----sql-----"+vsql);
        ResultSet rs = stmt.executeQuery(vsql);
        String check = rs.getString(1);/*i tried to check if my result set has any values*/
        String check1=rs.getString(2);
        out.println("This is result set "+check);
        if(!rs.next())
        {
            System.out.println("-----Failure------");
        }
        else
        {
            System.out.println("-----Success------");
            rd.forward(request,response);
        }
        }
        catch(Exception e)
        {}
    }

  }