You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Sameer <sk...@srijansoft.com> on 2000/11/24 11:45:54 UTC
Login Page
Hi everybody,
Following is the code for a login.jsp page developed in JRun. What changes
would be required to have the same page running in Tomcat Server.
Please help.....
<html>
<body bgcolor="#ffffff">
<%@
import="javax.servlet.*,javax.servlet.http.*,java.util.Date,java.text.DateFo
rmat,java.io.*,java.net.*,java.sql.*,com.livesoftware.jrun.plugins.jsp.JSPSe
ssion" %>
<%
HttpSession session = request.getSession(true);
%>
<%
int content_length=0;
String url = "jdbc:odbc:Booking";
Statement stmt = null;
String EmpIdAll = "";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(url, "", "");
stmt = con.createStatement();
}
catch(java.lang.Exception e)
{
out.println ("e:" +e);
}
%>
<%
int validated = 0;
String temp[] = new String[5];
if (!Request.ServerVariables("Content_Length").equals(""))
{
content_length =
Integer.parseInt(Request.ServerVariables("Content_Length"));
}
if (content_length > 0)
{
try
{
String EmpPasswdAll = null;
String EmpRolesAll = null;
int flag = 0;
ResultSet rsEmp = stmt.executeQuery("select UserId, Password, Roles from
Employee");
while(rsEmp.next())
{
EmpIdAll = rsEmp.getString("UserId");
EmpPasswdAll = rsEmp.getString("Password");
EmpRolesAll = rsEmp.getString("Roles");
if(EmpIdAll.equals(Request.Form("UserId")) &&
EmpPasswdAll.equals(Request.Form("Password")))
{
session.putValue("EmpId", ""+EmpIdAll);
session.putValue("EmpRole", ""+EmpRolesAll);
response.sendRedirect("contents.jsp");
}
else
{
flag = 1;
}
}
if(flag == 1)
{
EmpIdAll = Request.Form("UserId");
out.println("<center><font color=red><b> Incorrect login or password.
Please Login again. </b></font>");
}
}
catch (SQLException ex)
{
out.println ("\n\n\n*** SQLException caught ***\n\n\n");
out.println ("ex: " +ex);
}
}
%>
<center>
<form name=login method=post action="login.jsp">
<table width=600 border=1 bgcolor="#dddddd">
<tr>
<td colspan=2 align=center>
<font size=+2 face=arial><b> Login Screen
</td>
</tr>
<tr>
<td>
<font size=2 face=arial><b> Employee Id
</td>
<td>
<input type=text size=10 name=UserId value="<%=EmpIdAll%>">
</td>
</tr>
<tr>
<td>
<font size=2 face=arial><b> Password
</td>
<td>
<input type=password size=10 name=Password>
</td>
</tr>
<tr>
<td align=center>
<input type="submit" value="Submit">
</td>
<td align=center>
<input type="reset" value="Reset">
</td>
</tr>
</table>
</form>
</body>
</html>
Thanks in anticipation,
Sameer