Wednesday, December 18, 2013

Login through JSTL

index.jsp

<div style="height:200px;width:350px;margin: 25px 0px 0px 23px;background: #f8f7df">
                        <div style="font:20px Verdana, Geneva, sans-serif;padding-left:10px">Admin Login Here : </div>       
                        <c:if test="${not empty param.message}">

                            <font color="red" size="3" face="Verdana" style="padding-left: 10px">
                            <c:out  value="${param.message}"></c:out>
                            </font>
                            <br/>
                        </c:if>
                    <br/>
                <form onsubmit='return formValidator();' action="loginAdmin.jsp"  name="loginform"  method="post" >
                   
                    <span style="font:18px Verdana, Geneva, sans-serif;padding-left:10px">Username : </span><input type="text" name="uname" id="input"/><br />
                    <span style="font:18px Verdana, Geneva, sans-serif;padding-left:10px">Password : </span> <input type="password" name="pass" id="input2"/>                   
                    <input type="submit" name="submit"  class="submit" value="Login" id="button"/>

                </form>
                </div>


loginAdmin.jsp


<%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<c:import url="include/connection.jsp"></c:import>
<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

    </head>

      <c:if test="${pageContext.request.method=='POST'}" >
          <c:catch var="exc">
              <c:if test="${empty param.uname or empty param.pass }">
                  <c:redirect url="index.jsp" >
                      <c:param name="message" value="Please fill all fields."></c:param>
                  </c:redirect>
              </c:if>
                 
             
        <c:if test="${not empty param.uname and not empty param.pass}">

            <sql:query dataSource="${ds}" var="selectQ">
                select count(*) as kount from tbl_admin where username='${param.uname}' &&  password='${param.pass}'
            </sql:query>
            <c:forEach items="${selectQ.rows}" var="r">
            <c:choose>
                <c:when test="${r.kount gt 0}">
                    <c:set scope="session" var="loginAdmin" value="${param.uname}"/>
                    <c:redirect url="home.jsp"></c:redirect>
                </c:when>

             <c:otherwise>

                <c:redirect url="index.jsp">
                    <c:param name="message" value="Wrong UserName and/or Password" />
                </c:redirect>
                
            </c:otherwise>
            </c:choose>
           
            </c:forEach>
        </c:if>
          </c:catch>
      </c:if>
               <c:if test="${exc!=null}">
                 <c:redirect url="index.jsp">
                     <c:param name="message" value="Wrong UserName and/or Password" />
                 </c:redirect>
               </c:if>           
</html>

No comments:

Post a Comment