Servlet Help

OK I am new and am still learning so if you have any tips or suggestions please tell me
THis is what I currently have

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.sql.*;
 
public class wifi_login extends HttpServlet {
public void doGet(HttpServletRequest request,
 HttpServletResponse response)
 throws ServletException, IOException {
 PrintWriter out = response.getWriter();
 String nxsid ="";
 
String ora ="jdbc :-o	 racle:thin:@localhost:1521:methos";
String oraun="scott";
String orapass="tiger";
 
 try{
 nxsid = request.getParameter("nxsid");
 if (nxsid==null)
 nxsid="";
 }
 catch(Exception e){System.out.println("getParameter failed - "+e);}
if (nxsid.equals("") || nxsid.equals("invalid")||nxsid.equals("null"))
{
 out.println("<html><head>");
 out.println("<title>WiFi Ticket Tool</title></head>");
 out.println("<body bgcolor=#f5f5f5>");
 out.println("");
 if (nxsid.equals("invalid"))
 out.println("Invalid Login Entered Please Retry");
if (nxsid.equals("null"))
 out.println("Logged in as null. Please update Favorite to deleted.....
 out.println("Wifi Ticketing Tool");
 out.println("<body><form action=wifi_login method=post>");
 out.println("Enter your Nextel Standard ID (begins with 'ed') <input type=text size=20 name=nxsid maxlength=20");
 out.println("");
 out.println("</body></html>");
}
else
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
 Connection conn = DriverManager.getConnection(ora,oraun,orapass);
 Statement stmt = conn.createStatement();
 ResultSet rs = stmt.executeQuery("select first, last from nx_wifi_employee where nxsid='"+nxsid+"'");
 if(rs.next())
{
String name=rs.getString("first") + " "+rs.getString("last");
out.println(name);
response.sendRedirect("/wifi_menu?nxsid="+nxsid+"&name="+name);
}
else
response.sendRedirect("/wifi_login?nxsid=invalid");
}
 catch(Exception e){}
 }
 }
 
 public void doPost(HttpServletRequest request,
 HttpServletResponse response)
 throws ServletException, IOException {
 doGet(request, response);
 }
 
}

what I would like to do is find a way to send this to /wifi_menu without having all the stuff on the end of the URL.
I have tried using a dispatcher but it would never send the name /wifi_menu would never even see the attribute there.
I am doing this with the extra at the end of the url many times in other places and I really do not like it.
THank you in advance
Ben

[ May 18, 2005: Message edited by: Ben ]
[ May 19, 2005: Message edited by: Ben ]

Tips:
- Use MVC Model 2 architecture. Or atleast use servlet as a controller and JSp as a view.

- Dont mess your JDBC code up with your servlet. Servlet should only care about request/response mechanism.

Answer would be:

you can bind your attributes with your request object, using request.setAttribute(name, value).

Cheers.

Originally posted by Adeel Ansari:
Tips:
- Use MVC Model 2 architecture. Or atleast use servlet as a controller and JSp as a view.

- Dont mess your JDBC code up with your servlet. Servlet should only care about request/response mechanism.

Answer would be:

you can bind your attributes with your request object, using request.setAttribute(name, value).

Cheers.

I have absolutely no idea what Use MVC Model 2 architecture is.

I have actually never used JSP's I have tried to do request.setAttribute(name,value) but it does not work. Well I actually tried request.setAttribute("name",name)
where the second name is actually a string with there name.
I then tried to do a
dispatcher.forward(request,response)
and on the wifi_menu servlet the only parameter it gets is nxsid
Is this wrong?
[ May 19, 2005: Message edited by: Ben ]

"Ben",

There aren't may rules that have been put into place here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
Forum Bartender

If you want to chain to a new resource within the same request (so that request-scoped attributes are available in the second resource) you need to use a dispatcher and perform a forward operation. A redirect will always create a new request and any request attributes will be reclaimed when the first request goes out of scope.