Setting cookies variables in jsp

@tenerazzaSep 26.2004

<%@page contentType=”text/html”%>
<%@ page import = “java.io.*” %>
<%@ page import = “java.util.*” %>
<%@ page import = “javax.servlet.*” %>
<%@ page import = “javax.servlet.http.*” %>
<%@ page import = “java.sql.*” %>
<%@ page import=”java.lang.*” %>
<%@ page session=”true” %>
<%@ page import=”java.io.IOException.*” %>
<%@ page import=”java.io.PrintWriter.*” %>
<%@ page import=”javax.servlet.Servlet.*” %>
<%@ page import=”javax.servlet.ServletException.*” %>
<%@ page import=”javax.servlet.http.Cookie.*” %>
<%@ page import = “javax.servlet.http.HttpServlet.*” %>
<%@ page import=”javax.HttpServletRequest.*” %>
<%@ page import=”javax.HttpServletResponse.*” %>
<html>
<head>
<title> </title>
</head>
<body>

String Name, Password, formName, formPassword; int ID; long time;
try {
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

Connection C = DriverManager.getConnection(“jdbc:odbc:REX”);

Statement Stmt = C.createStatement();

String queryString;

ResultSet rs;

boolean check=false;

if(request.getParameter(“select”).equals(“Trader”))
{//if Trader Option
queryString=”SELECT TraderID,Name,Password FROM Trader”;
rs = Stmt.executeQuery(queryString);

while (rs.next()) { Name=rs.getString(“Name”); Password=rs.getString(“Password”); formName=request.getParameter(“username”); formPassword=request.getParameter(“password”); //out.println(“ Username:”+Name+” vs “+formName+” Password:”+Password+” vs “+formPassword);

if (formName.equals(Name) && formPassword.equals(Password)) {

check=true; // session.setAttribute(“update_trader”,”0″); response.sendRedirect(“Trader/TraderPage.htm”); break; } } rs.close();

}//if Trader Option

if(request.getParameter(“select”).equals(“Dealer”))
{//if Dealer Option
queryString=”SELECT DealerID,Name,Password FROM Dealer”;
rs = Stmt.executeQuery(queryString);

if (formName.equals(Name) && formPassword.equals(Password)) { Cookie userCookie = new Cookie(“user”, “uid1234”); Cookie.setMaxAge(24 * 60 * 60); response.addCookie(userCookie); ID=rs.getInt(“DealerID”); String sID=””+ID; check=true; session.setAttribute(“Name”,Name); session.setAttribute(“DealerID”,sID); response.sendRedirect(“Dealer/dealerpage.htm”); break; } } rs.close();

}//if Dealer Option

if(request.getParameter(“select”).equals(“Administrator”))
{//if Administrator Option
queryString=”SELECT AdministratorID,Name,Password FROM Administrator”;
rs = Stmt.executeQuery(queryString);

if (formName.equals(Name) && formPassword.equals(Password)) { check=true; // session.setAttribute(“update_dealer”,”0″); response.sendRedirect(“Admin/adminpage.htm”); break; } } rs.close();

}//if Administrator Option

if (check==false)
{
response.sendRedirect(“All_WrongPassword.html”);
}

Stmt.close();
C.close();
}
catch (ClassNotFoundException e1) {
// JDBC driver class not found, print error message to the console
System.out.println(e1.toString());
}
catch (SQLException e2) {
// Exception when executing java.sql related commands, print error message to the console
System.out.println(e2.toString());
}
catch (Exception e3) {
// other unexpected exception, print error message to the console
System.out.println(e3.toString());
}

%>
</body>
</html>

</body>
</html>

I set a cookie for dealer after verifying the username and pw. However if i wish to assign the userid (domain ) and dealerID (generated from the access table) to the cookie instead of typing in manually like what i’m doing now, how could i go about doing it?

2nd problem i’m facing is that i can’t verify login name and PW from the trader and administrator domain. Only the dealer is unaffected. I’m sure my tables are done correctly and the fields are correct.

Here is my source for the login page

<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN”>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″>
</head>

<form name=”form1″ method=”post” action=”passcheck.jsp”> <div align=”left”> <input type=”text” name=”username” size=”20″> User Name:</div> <div align=”left”> <input type=”text” name=”password” size=”20″> Password: <select name=”select”> <option>Dealer</option> <option>Trader</option> <option>Adminstrator</option> </select> <input type=”submit” name=”Submit” value=”Submit”> </div> </form>              </td> <td width=”833″ height=”212″ bgcolor=”#CCCCCC”> News Headlines Completion of 1st login page ^_^ Still sucks I’ll try and see what i can do.<a href=”#”></a>  </td>

</tr>
<tr>
<td bgcolor=”#CCCCCC”> Community 
4 members
 </td>
</tr>
</table>
 
 <a href=”Index.htm” style=”text-decoration: none”>Home Page</a> |
<a href=”Account%20registration.htm” style=”text-decoration: none”>Open an Account</a> |
<a href=”Contact%20us.htm” style=”text-decoration: none”>Contact 4Rex</a> |
<a href=”Riskdisclaimer.htm” style=”text-decoration: none”>Risk Disclaimer</a>
_______________________________________________________________________________________________________________________________
</body>
</html>

Someone please help thanks. T_T

~~[b]~~Moderators Note[/b]
Being moved to Java Forums.

to post a comment

Java

Setting cookies variables in jsp

1 Comments(s) _↴

Also in #Java _↴

Success!

Social

Version

Setting cookies variables in jsp

1 Comments(s) ↴

Also in #Java ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

1 Comments(s) _↴

Also in #Java _↴