Quote:
Originally Posted by r035198x
How did you call the methods?
[HTML] <%@ include file="connLib.jsp" %>
<%@ page contentType="text/html;charset=windows-1252"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
</head>
<body bgcolor="#1c80dd" onkeypress="acceptEnter()">
<script language="javascript">
function acceptEnter()
{
if(window.event.keyCode==13)
{
validate();
}
}
function validate()
{
if(login.txtId.value=="" )
{
alert("The Id cannot be kept blank");
login.txtId.focus();
return false;
}
if(login.txtPwd.value=="")
{
alert("The Password cannot be kept blank");
login.txtPwd.focus();
return false;
}
login.loginhidden.value="login";
}
</script>
<%
String id="",pwd="",area="";
int flag=0;
connectionMe();
java.sql.ResultSet rslogin=null;
if(request.getParameter("loginhidden")!=null)
{
if(request.getParameter("loginhidden").equals("log in"))
{
id=request.getParameter("txtId");
pwd=request.getParameter("txtPwd");
rslogin=getAllData("select * from login where username='"+id+"' and password='"+pwd+"'");
while(rslogin.next())
{
flag=1;
out.print("Login Successfully....");
response.sendRedirect("process.jsp");
}
if(flag==0)
{
session.setAttribute("message","Invalid UserName or Password");
}
}
}
%>
<center>
<hr><font color="white" size=5 ><b>LOGIN PAGE</font></b><hr>
</center>
<form name="login" action="" method="post">
<center>
<table>
<tr><td><font color="black" size=3><b>User Login Page </font></b></td></tr>
</table><br>
<table border=1 bgcolor="#1c80dd">
<tr>
<td><font color="white" face="Times New Roman"><b>User ID :-</td>
<td><input type="text" name="txtId" ></td>
</tr>
<tr>
<td><font color="white" face="Times New Roman"><b>Password :-</td>
<td><input type="password" name="txtPwd" ></td>
</tr>
<td colspan=6 bgcolor="#1c80dd" align="center">
&n bsp; &nbs p;
<input type="submit" name="btnLogin" value="Login" onclick="return validate()">
<input type="reset" name="btnReset" value="Reset" >
<input type="hidden" name="loginhidden">
</table>
<br>
<table>
<tr><td align="center"><font color="#1c80dd" face="arial"><b>
<%
if(session.getAttribute("message")!=null)
{
out.print("<font color=white>"+session.getAttribute("message"));
}
%></b></font></td></tr>
</table>
<br><br>
<hr>
<table><tr>
</tr></table>
</center>
</form>
</body>
</html>
[/HTML]
This is the program where iam calling the result set,connection object all..
