In the above mentioned title login page not working properly.
**1.login.jsp**
<%@ page language="java" %>
<%@ page session="true" %>
<%@ page import="java.sql.*,java.io.*,com.minglespot.MyFunctions"%>
<%! String ErrCode="0",LoginCode="A";%>
<HTML>
<HEAD>
<script LANGUAGE="Javascript" SRC="Images/validate.js"></script>
<LINK href="styles.css" type="text/css" rel="stylesheet">
<script LANGUAGE="Javascript" SRC="Images/calender.js"></script>
<script LANGUAGE="Javascript" >
function ChkMandatoryField(F,T){
var val= F.value;
if(val==""){alert(T+" is mandatory");return false;}
}
function ChkNumField(F,T){
var val = F.value;
if(isNaN(val)==true||val==""){alert("Please enter numbers for "+T);return false;}
}
function ChkAlphaNumericField(F,T){
var val = F.value;
var pattern = /^([a-zA-Z0-9]{1,250})$/;
if(!(pattern.test(val)==true)){alert("Please enter alphabets or numbers for "+T);return false;}
}
function ChkAlphaField(F,T){
var val = F.value;
var pattern = /^([a-zA-Z ]{1,250})$/;
if(!(pattern.test(val)==true)){alert("Please enter text for "+T);return false;}
}
function ChkEmailField(F,T){
var val = F.value;
var pattern = /^([a-zA-Z0-9\_\.]{4,25})$/;
if(!(pattern.test(val)==true)){alert("Please enter valid email for "+T);return false;}
}
function ChkDateField(F,T)
{
var val = F.value;
var pattern = /^[0-9]{4}-[0-9]{2}-[0-9]{2}$/;
if(!(pattern.test(val)==true)){alert("Please enter valid date format (yyyy-mm-dd) for "+T);return false;}
}
function validate()
{
var frm = document.forms(0);
if(ChkMandatoryField(frm.UserID,'UserID')==false) return false;
if(ChkAlphaField(frm.UserID,'UserID')==false) return false;
if(ChkMandatoryField(frm.uPassword,'Password')==false) return false;
if(ChkAlphaNumericField(frm.uPassword,'Password')==false) return false;
}
function fnValidate(s){
var frm = document.forms(0);
var UserID=frm.UserID.value;
//if(UserID==""){alert("User ID is mandatory");return false;}
var uPassword=frm.uPassword.value;
//if(uPassword==""){alert("Password is mandatory");return false;}
s.href = "Validate.jsp?UserID="+UserID+"&Password="+uPassword;
s.target="HomeFrame";
}
</script>
</HEAD>
<Body Class='Grad'>
<FORM name="Login">
<%
ErrCode = request.getParameter("ErrCode");
LoginCode = request.getParameter("LoginCode");
if(ErrCode!=null){
if(ErrCode.equals("1")){
%><script>alert("Login failed..please try again");</script><%
}
}
%>
<fieldset style="padding: 3;">
<legend><FONT COLOR="" Face='verdana' size='2'><B>Login</B></FONT></Legend>
<TABLE align=center width="60%" class="notepad">
<TR class="row_title">
<TH align="center" colspan=3><FONT SIZE="4" COLOR="#AA2504" face='monotype corsiva'>Login</FONT></TH>
</TR>
<tr>
<TD align="left"><FONT SIZE="2" COLOR="#AA2504" face='monotype corsiva'>User ID</FONT><FONT COLOR="red">*</FONT></TD>
<TD><Input type=text name='UserID' value='' size=8></TD></tr>
<tr><TD align="left"><FONT SIZE="2" COLOR="#AA2504" face='monotype corsiva'>Password<FONT COLOR="red">*</FONT></TD>
<TD><Input type=password name='uPassword' value='' size=8></TD>
<TD><a href="" onclick="fnValidate(this)"><img border="0" name="Go" src="Images/Go0.jpg" onmouseover="document['Go'].src='Images/Go1.jpg'" onmouseout="document['Go'].src='Images/Go0.jpg'" ></a></tr>
</TABLE>
</fieldset>
<BR><BR>
<fieldset style="padding: 3;">
<legend><FONT COLOR="" Face='verdana' size='2'><B>Register</B></FONT></Legend>
<P align=center><FONT SIZE="4" COLOR="#AA2504" face='monotype corsiva'>If you are not a registered user <Font COLOR="#AE0000"><B>Register Now</B></Font> its free</FONT></P>
<table align=center>
<tr align=center><TD><A HREF="Register0.jsp" target="HomeFrame"><img border="0" name="Register" src="Images/Register0.jpg" onmouseover="document['Register'].src='Images/Register1.jpg'" onmouseout="document['Register'].src='Images/Register0.jpg'" ></A></TD>
</tr>
</Table>
</fieldset>
</FORM>
</BODY>
**2.validate.jsp**
<%@ page language="java" %>
<%@ page session="true" %>
<%@ page import="java.sql.*,java.io.*,java.util.Random"%>
<HEAD>
<script LANGUAGE="Javascript" SRC="Images/validate.js"></script>
<LINK href="styles.css" type="text/css" rel="stylesheet">
</HEAD>
<BODY class="Sess">
<%
Connection con=null;
ResultSet rs=null,rs1=null;
Statement stmt=null,stmt1=null;
String UserID = request.getParameter("UserID");
String Password = request.getParameter("Password");
session.setAttribute("UserID",UserID);
int flag=0;
try{
con = com.minglespot.ConnectionPool.getConnection();
stmt = con.createStatement();
stmt1 = con.createStatement();
String Query = "select * from login where UserID = '"+UserID+"' and Password='"+Password+"'";
System.out.println(Query);
rs = stmt.executeQuery(Query);
System.out.println(rs);
if(rs!=null){
String Query1="Select * from basicdetails where UserID='"+UserID+"' and Password='"+Password+"'";
System.out.println(Query1);
rs1=stmt1.executeQuery(Query1);
System.out.println(rs1);
if(rs1!=null)
{
while(rs1.next()){
String PhotoPath=rs1.getString(4);
System.out.println("-------------------"+PhotoPath);
session.setAttribute("PhotoPath",PhotoPath);
}
}
}
if(rs.next())
{
String Auth=rs.getString(3);
session.setAttribute("Auth",new Integer(Auth));
flag=1;
if(Auth.equals("0")){
//Show Admin Menu
%>
<jsp:forward page="AdminMenu.jsp"/>
<%
}else if(Auth.equals("1")){
//Show user Menu
%>
<jsp:forward page="UserHome.jsp"/>
<%
}
}
else
{
flag=0;
%>
<jsp:forward page="Login.jsp"/>
<%
}
stmt.close();
con.close();
}catch(Exception e){
stmt.close();
con.close();
%><%=e%><%
}
%>
</BODY>
Ads
