QuestionAsk Questions?
View Answers
May 23, 2009 at 1:16 PM
Hi Friend,
It seems that the jsp file you are executing or you are calling is not saved with that name.
Any ways, follow these steps to login:
1) Create login.jsp:
<%@ page language ="java" import="java.sql.*" %>
<html>
<body bgcolor="#666666#">
<form name="f1" method="post" >
<table align="center">
<tr>
<td>User Name</td><td><input type="text" name="t1" ></td>
</tr>
<td>Password</td>
<td><input type="password" name="t2"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="b1" value="LogIn"></td>
</tr>
</table>
<%
String user=request.getParameter("t1");
String pass=request.getParameter("t2");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:access");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select username,password from user");
if(rs.next()){
String username=rs.getString(1);
String password=rs.getString(2);
if(user.equals(username) && pass.equals(password))
{
%>
<jsp:forward page="loginSuccess.jsp" />
<%}
else
out.println("Login Failed,Please try Again");
%>
<%
}
}catch(Exception e1)
{}
%>
</form>
</body>
</html>
2) create loginSuccess.jsp and print the mesage You have successfully login.
Thanks
It seems that the jsp file you are executing or you are calling is not saved with that name.
Any ways, follow these steps to login:
1) Create login.jsp:
<%@ page language ="java" import="java.sql.*" %>
<html>
<body bgcolor="#666666#">
<form name="f1" method="post" >
<table align="center">
<tr>
<td>User Name</td><td><input type="text" name="t1" ></td>
</tr>
<td>Password</td>
<td><input type="password" name="t2"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="b1" value="LogIn"></td>
</tr>
</table>
<%
String user=request.getParameter("t1");
String pass=request.getParameter("t2");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:access");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select username,password from user");
if(rs.next()){
String username=rs.getString(1);
String password=rs.getString(2);
if(user.equals(username) && pass.equals(password))
{
%>
<jsp:forward page="loginSuccess.jsp" />
<%}
else
out.println("Login Failed,Please try Again");
%>
<%
}
}catch(Exception e1)
{}
%>
</form>
</body>
</html>
2) create loginSuccess.jsp and print the mesage You have successfully login.
Thanks
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
