Problems on deleting a user from my DB

Hi i just don�t get the servlets and jsp...

[Edit: removed not-so-nice text. Please be more circumspect in future posts.]

So i was wondering why i can�t delete a user from my DB(i�m using mySQL).

First here is my jsp

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
 
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Baja de Usuarios</title>
    </head>
    <body>
        <form action="valForm" name="bU" method="POST">
            <input type="hidden" name="redireccion" value="bUsuario">
            <center><h1>Baja de Usuarios</h1></center>
            
            <center>Type the username to delete</center>
            <table>
                <tr>
                    <td>User:</td>
                    <td><input type="text" size="10" maxlength="15" name="usuario"></td>
                </tr>
                <tr>
                    <td><input type="submit" name="enNombre" value="ELIMINATE"></td>
                    <td><input type="reset" name="caNombre" value="CANCEL"></td>
                </tr>
            </table>
        </form>
    </body>
</html>

I�m calling my servlet Valida to look if the username typed by the admin exists in my DB

package servlet.validacion;
 
import java.io.*;
import java.net.*;
import javax.servlet.*;
import javax.servlet.http.*;
 
import dao.usuario.*;
import bean.usuario.*;
 
public class Valida extends HttpServlet {
  
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
     
        String pagina = request.getParameter("redireccion");
        
        if(pagina.equals("bUsuario")){
            existenciaUsr(request,response);
            System.out.println(pagina);
        }  
        
    }
    
    public void existenciaUsr(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException{
        
        //obtiene valor de la variable usuario en jsp
        String usuario = request.getParameter("usuario");
        
        UsuarioDAO usuarioDAO = new UsuarioDAO();
        //busco si usuario existe en BD
        boolean existeU = usuarioDAO.valNombre(usuario);
        
        HttpSession sesion = request.getSession();
         boolean ban = false;
        if(existeU == true){
            ban = usuarioDAO.eliUsr(usuario);
            if(ban== true){
            sesion.setAttribute("msg","Usuario Eliminado");
            response.sendRedirect("BajaUsuario.jsp");}
        }else{
            sesion.setAttribute("msg","Error al eliminar");            
            response.sendRedirect("ghj.jsp");
        }
    }
    
    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }
    
    /** Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }
    
    /** Returns a short description of the servlet.
     */
    public String getServletInfo() {
        return "Short description";
    }
    // </editor-fold>
}

And here it is where i validate that the user exists and then delete it.

package dao.usuario;
 
import java.sql.*;
import bd.conectar.*;
import dao.usuario.*;
import bean.usuario.*;
 
public class UsuarioDAO extends Conexion {
    
    /** Creates a new instance of UsuarioDAO */
    public UsuarioDAO() {
    }
    
    public  boolean valNombre(String nombre){
        
        boolean existeUsr = false;
        
        try{
            String sql = "select *  from usuario where usr ? and estatus = 1 ";
            Connection c = super.obtenerConexion();
            PreparedStatement stm = c.prepareStatement(sql);
            stm.setString(1,nombre);
            
            ResultSet res = stm.executeQuery();
            if(res.next()){
                existeUsr = true;
            }
            
            stm.close();
            res.close();
            super.cerrarConexion(c);
        }catch(Exception e){
            e.printStackTrace();
        }
        return existeUsr;
    }
    
    public boolean eliUsr(String usEliminar){
        boolean eliminado = false;
        
        try{
            String sql = "delete from usuario where usr ? and estatus = 1 ";
            Connection c = super.obtenerConexion();
            PreparedStatement stm = c.prepareStatement(sql);
            stm.setString(1,usEliminar);
            
            int res = stm.executeUpdate();
            if(res > 0){
                eliminado = true;
            }
            
            stm.close();
           
            super.cerrarConexion(c);
        }catch(Exception e){
            e.printStackTrace();
        }
        return eliminado;
    }
}

But i always get redirect to ghj.jsp even if the user exists.
[ July 25, 2007: Message edited by: Bear Bibeault ]