<%@ page language="java" import="java.util.*,java.sql.*,javax.servlet.http.*" %> <%@ include file="application.jsp" %> <%@ include file="header.jsp"%> <%@ include file="/shared/funcLibrary.jsp" %> <% try{ Connection conn = dbConnection.getConnection(); Statement state = conn.createStatement(); ResultSet rs=null; %> <% String err=""; err=request.getParameter("err"); if(err==null || err.equals("")) err="0"; String flagLout=""; flagLout=request.getParameter("flag"); if(flagLout==null || flagLout.equals("")){ }else{%> <%} if(request.getMethod().equals("GET")){ %>

Welcome to The Clients Section.
<% if(err.equals("2")){%> Please enter correct User ID and Password !! <%}else if(err.equals("3")){%> Your POP ID is not a valid POP. Please contact to administrator!! <%}else if(err.equals("1")){%> Login Id and Password can not be blank. Please enter values to Login!! <%}%>
Client Login Section
Login ID :
Password :
   
<%} if(request.getMethod().equals("POST")){ String loginId=request.getParameter("loginId"); String password=request.getParameter("password"); if(((loginId==null)||(loginId.equals("")))&&((password==null)||(password.equals("")))){ response.sendRedirect("userLogin.jsp?err=2"); }else{ String query1="Select * from client where loginId='"+ loginId +"' && password='"+ password +"'"; rs=state.executeQuery(query1); boolean flag=rs.isBeforeFirst(); if (flag) { while(rs.next()) { String LoginId=rs.getString("loginId"); String Password=rs.getString("password"); String Emailid=rs.getString("emailId"); String clientNo=rs.getString("clientNo"); if(LoginId.equals(loginId) && Password.equals(password)){ session.setAttribute("LoginId",LoginId); session.setAttribute("Emailid",Emailid); session.setAttribute("clientNo",clientNo); response.sendRedirect("assignment.select.jsp?log=client"); }else{ response.sendRedirect("userLogin.jsp?err=2"); } } } else { response.sendRedirect("userLogin.jsp?err=2"); } } rs.close(); state.close(); dbConnection.shutDown(); } }catch(Exception e){out.print(e);} %> <%@ include file="footer.jsp"%>