<%
     String n=request.getParameter("username");
     String p=request.getParameter("password");


     if(p!=null && n!=null)
     {
         session.setAttribute("name",n);
         session.setAttribute("pass",p);
         if(n.equals("Dor") && p.equals("123456") )
         {
             session.setAttribute("status","admin");
             response.sendRedirect("AdminArea.jsp");
         }
         else
         {
             String result[][] = db.select("select * from members where username='"+n+"' and password='"+p+"'");
             if(result.length>0){

                 session.setAttribute("status","member");
                 response.sendRedirect("UserArea.jsp");}
             else
             {
                 session.setAttribute("status","guest");
                 response.sendRedirect("login.jsp");
             }

          }


     }
%>