'Based upon the code in Jason Hunters book'.
I'm not sure why this isn't working, the error that brings up when
running the servlet (compiles fine) is,
400 post is not supported by this url 69.
Would it be something to do with the fact that I'm redirecting to
another servlet?
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/*
A servlet to login the users.
Redirects to a protected page, if it is accessed before logging in.
Available to all DBowner types.
*/
public class login extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
try {
Class.forName( "oracle.jdbc.driver.OracleDriver" );
}
catch (java.lang.ClassNotFoundException e) {
throw new UnavailableException(this, "Couldn't load Oracle
Driver");
}
}
public void dopost (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html");
PrintWriter os=res.getWriter();
//Gets the parameters
String user= req.getParameter("User");
String passwd=req.getParameter("Password");
//Sets up the connection, statement, and resultsets
String url = "jdbc:oracle:thin:@computer:1521:orcl";
Connection con=null;
Statement stmt=null;
ResultSet Downer=null;
String DBowner = (("Select ROLE from sam.DBOWNERS WHERE USERNAME =
'") + user + ("'"));
try {
con = DriverManager.getConnection( url, user, passwd );
stmt = con.createStatement();
//valid login
HttpSession session=req.getSession(true);
Downer = stmt.executeQuery(DBowner);
String DBownertype=null;
while (Downer.next()) {
DBownertype = Downer.getString("ROLE");
}
session.putValue("logon.isDone", user); // just a marker
object
session.putValue("login.user", user);
session.putValue("login.password", passwd);
session.putValue("login.DBownertype", DBownertype);
// Try redirecting the client to the page he first tried to access
try {
String target = (String)
session.getValue("login.target");
if (target != null)
res.sendRedirect(target);
return;
}
catch (Exception ignored) { }
// Couldn't redirect to the target. Redirect to the site's home
page.
String dblogin = ("HTTP://tb187.info.bt.co.uk/vdb/dblogin");
res.sendRedirect(dblogin);
}
catch(SQLException ex) {
//invalid login
os.println("<HTML><HEAD><TITLE>Access Denied</TITLE></HEAD>");
os.println("<BODY>Your login and password are
invalid.<BR>");
os.println("You may want to <A HREF=\"/login.html\">try
again</A>");
os.println("</BODY></HTML>");
}
finally {
try {
if (con != null) con.close();
if (stmt != null) stmt.close();
if (Downer !=null) Downer.close();
}
catch (SQLException ignored) {}
}
os.flush();
}
public void destroy() {
super.destroy();
}
}
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
