Veja bem criei niveis de acesso validando o acesso porem quando envio uma requisição ele não vai se alguem me ajudar obrigado
segue projeto completo com Banco
Ja Que o War e o Sql Segue onde da erro
Admacesso.jsp
<%@page contentType="text/html" pageEncoding="windows-1252"%>
<%@include file="WEB-INF/jspf/Cabec.jspf"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>xdocs</title>
<script type="text/javascript" language="JavaScript" src="js/webvalida.js"></script>
<style type="text/css">
<head>
<LINK REL="SHORTCUT ICON" href="logo.ico">
body { font: normal 62.5% verdana; }
ul.menubar{
margin: 0px;
padding: 0px;
background-color: #FFFFFF; /* IE6 Bug */
font-size: 100%;
}
ul.menubar .submenu{
margin: 0px;
padding: 0px;
list-style: none;
background-color: #FFFFFF;
border: 1px solid #ccc;
float:left;
}
ul.menubar ul.menu{
display: none;
position: absolute;
margin: 0px;
}
ul.menubar a{
padding: 5px;
display:block;
text-decoration: none;
color: #777;
padding: 5px;
}
ul.menu, ul.menu ul{
margin: 0;
padding: 0;
border-bottom: 1px solid #ccc;
width: 150px; /* Width of Menu Items */
background-color: #FFFFFF; /* IE6 Bug */
}
ul.menu li{
position: relative;
list-style: none;
border: 0px;
}
ul.menu li a{
display: block;
text-decoration: none;
border: 1px solid #ccc;
border-bottom: 0px;
color: #777;
padding: 5px 10px 5px 5px;
}
ul.menu li sup{
font-weight:bold;
font-size:7px;
color: red;
}
/* Fix IE. Hide from IE Mac \*/
* html ul.menu li { float: left; height: 1%; }
* html ul.menu li a { height: 1%; }
/* End */
ul.menu ul{
position: absolute;
display: none;
left: 149px; /* Set 1px less than menu width */
top: 0px;
}
ul.menu li.submenu ul { display: none; } /* Hide sub-menus initially */
ul.menu li.submenu { background: transparent url(arrow.gif) right center no-repeat; }
ul.menu li a:hover { color: #E2144A; }
</style>
</head>
<h5><body onload="horizontal();">
<ul id="menu_dropdown" class="menubar">
<li class="submenu"><a href="menu.jsp">Home</a></li>
<li class="submenu"><a href="#">Cadastrar</a>
<ul class="menu">
<li><a href='/xdocs/servletweb?acao=ListarCliente'>Clientes</a></li>
<li><a href='/xdocs/servletweb?acao=GravarAlteracaoCidade'>Estados</a></li>
<li><a href='/xdocs/servletweb?acao=ListarCidade'>Cidades</a></li>
<li><a href='/xdocs/servletweb?acao=ListarVeiculo'>Veiculos</a></li>
<li><a href='/xdocs/servletweb?acao=ListarCategoria'>Categorias</a></li>
<li><a href='/xdocs/servletweb?acao=ListarVeiculoCliente'>Veiculos Clientes</a></li>
<li><a href='/xdocs/servletweb?acao=ListarMarca'>Marcas</a></li>
<li><a href='/xdocs/servletweb?acao=ListarModelo'>Modelos</a></li>
</ul>
</li>
<li class="submenu"><a href="#">RH</a>
<ul class="menu">
<li><a href='/xdocs/servletweb?acao=ListarUsuario'>Cadastro Funcionarios</a></li>
</ul>
</li>
<li class="submenu"><a href="#">Administração do Sistema</a>
<ul class="menu">
<li><a href="#">Importar Arquivos</a></li>
<li><a href="#">Exportar Arquivos</a></li>
</ul>
</li>
<li class="submenu"><a href="#">Controle Operacional</a>
<ul class="menu">
<li><a href="#">Produção</a></li>
<li><a href="#">Manutenção Supplies</a></li>
<li><a href="#">Modelo e Soluções Tecnologicas</a></li>
</ul>
</li>
<li class="submenu"><a href="#">Produção</a>
<ul class="menu">
<li><a href="#">Movimento no Estoque</a></li>
<li><a href="#">Entrada de Volumes</a></li>
<li><a href="#">Chamados Tecnicos</a></li>
<li><a href="#">Requisição</a></li>
</ul>
</li>
<li class="submenu"><a href="#">Outros</a>
<ul class="menu">
<li><a href="#">Controle de Cobertura</a></li>
</ul>
</li>
<li class="submenu"><a href="#">Espelho da Fatura</a></li>
<li class="submenu"><a href="#">Relatórios</a>
<ul class="menu">
<li><a href="#">Produção</a></li>
<li><a href="#">Manutenção</a></li>
<li><a href="#">Supplies</a></li>
<li><a href="#">Controle de Perdas</a></li>
</ul>
</li>
<li class="submenu"><a href="#">Ajuda</a>
<ul class="menu">
<li><a href="#">Versão</a></li>
<li><a href="#">Novidades da Versão</a></li>
<li><a href="#">Contatos</a></li>
<li><a href="#">Criar Reportes do sistema</a></li>
<li><a href="/xdocs/FinalizarSessao">Sair</a></li>
</ul>
</li>
</h5>
</body>
</html>
Home.jsp
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page language="java" import="java.util.*" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="f"%>
<!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>Locadora xxx</title>
<link rel="stylesheet" type="text/css" href="css/principal.css" />
<script type="text/javascript" language="JavaScript" src="js/webvalida.js"></script>
<META name="Revisit-after" content="15">
</head>
<body>
<div id="principal">
<div id="titulo">
<h4><f:formatDate value="<%= new Date()%>" type="both" /></h4>
</div>
<h5>
<form name="frmLogin" method='post'>
<label>Usuário:
<input type="text" name="login" id="login" maxlength="10" size="12">
</label><br />
<br />
<label>Senha:
<input type="password" name="senha" id="senha" maxlength="10" size="12">
</label><br />
<br />
</h5>
<button type="button" onclick="validarCamposLogin()">Acessar</button>
<button type="reset" value="Limpa dados">Apagar</button>
</form>
<div id="rodape">
<h4> Designer: João Luiz Alves dos Anjos</h4>
</div>
</body>
</html>
/webvalida.js
function validarCamposLogin(){
var frm = document.frmLogin;
var login = frm.login.value;
var senha = frm.senha.value;
if(login == ""){
alert("Favor, preencha o campo usuario!");
frm.login.focus();
return false;
}else if(senha == ""){
alert("Favor, preencha o campo senha!");
frm.senha.focus();
return false;
}else{
caminhourl = "/xdocs/servletweb?acao=Logar";
document.forms[0].action = caminhourl;
window.document.forms[0].submit();
return true;
}
}
Servlet Login
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package controller;
/**
*
* @autho
*/
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Dao.LoginDAO;
public class Login {
@SuppressWarnings("static-access")
public static String execute(HttpServletRequest request) {
String erro="";
String jsp="";
String Login = request.getParameter("login");
String senha = request.getParameter("senha");
Login usr = new Login();
LoginDAO usrDAO = new LoginDAO();
try {
usr = usrDAO.getUserLogin(Login, senha);
if(usr == null){
erro="Usuário não encontrado!";
request.setAttribute("erro", erro);
jsp = "/erro.jsp";
}
else{
request.getSession().setAttribute("nome", usrDAO);
jsp = "/AdmAcesso.jsp";
}
} catch (Exception e) {
e.printStackTrace();
jsp = "";
}
return jsp;
}
public static void validarSessao(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
String nome = (String) request.getSession().getAttribute("nome");
String jsp="";
if(nome == null ){
jsp = "/home.jsp";
//Redirecionando pagina
RequestDispatcher rd = request.getRequestDispatcher(jsp);
rd.forward(request, response);
}
}
}
Dao
package Dao;
/**
*
* @author
*/
import java.sql.*;
import java.util.ArrayList;
import model.Login;
public class LoginDAO {
private static PreparedStatement pstmt = null;
private static ResultSet rs = null;
public static controller.Login getUserLogin(String Login, String senha){
try {
Object user = null;
pstmt = Conexao.getConnection().prepareStatement(
"Select * From tablogin Where Login=? AND Senha=? ");
pstmt.setString(1, Login);
pstmt.setString(2, senha);
rs = pstmt.executeQuery();
if(rs.next()){
user = new Login();
((Login) user).setLogin(rs.getString("Login"));
((Login) user).setSenha(rs.getString("Senha"));
((Login) user).setNome(rs.getString("nome"));
((Login) user).setStatus(rs.getString("status"));
}
return (controller.Login) user;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
}
model
package model;
/**
*
* @author
*/
public class Login {
private String login;
private String senha;
private String nome;
private String status;
public String getLogin() {
return login;
}
public void setLogin(String login) {
this.login = login;
}
public String getSenha() {
return senha;
}
public void setSenha(String senha) {
this.senha = senha;
}
public String getNome() {
return nome;
}
public void setNome(String nome) {
this.nome = nome;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = status;
}
}
Servlet controle
package controller;
import java.io.*;
import java.net.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author
* @version
*/
import Dao.Conexao;
public class ServletWeb extends HttpServlet {
private ServletContext sc;
private String jsp = "";
public void init(ServletConfig config) throws ServletException {
super.init(config);
sc = config.getServletContext();
Conexao.conectar(sc.getInitParameter("url"), sc.getInitParameter("usuario"),
sc.getInitParameter("senha"), sc.getInitParameter("driver"));
}
/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String acao = request.getParameter("acao");
if(acao.equals("Logar"))
jsp = Login.execute(request);
else if (acao.equals("ListarEstados"))
jsp = ListarEstados.execute(request);
else if (acao.equals("AlterarEstado"))
jsp = AlterarEstado.execute(request);
else if (acao.equals("GravarAlteracaoEstado"))
jsp = GravarAlteracaoEstado.execute(request);
else if (acao.equals("GravarInsercaoEstado"))
jsp = GravarInsercaoEstado.execute(request);
else if (acao.equals("ExcluirEstado"))
jsp = ExcluirEstado.execute(request);
else if (acao.equals("ListarCidade"))
jsp = ListarCidade.execute(request);
else if (acao.equals("InserirCidade"))
jsp = InserirCidade.execute(request);
else if (acao.equals("AlterarCidade"))
jsp = AlterarCidade.execute(request);
else if (acao.equals("GravarAlteracaoCidade"))
jsp = GravarAlteracaoCidade.execute(request);
else if (acao.equals("GravarInsercaoCidade"))
jsp = GravarInsercaoCidade.execute(request);
else if (acao.equals("ExcluirCidade"))
jsp = ExcluirCidade.execute(request);
else if (acao.equals("ListarCliente"))
jsp = ListarCliente.execute(request);
else if (acao.equals("InserirCliente"))
jsp = InserirCliente.execute(request);
else if (acao.equals("AlterarCliente"))
jsp = AlterarCliente.execute(request);
else if (acao.equals("GravarAlteracaoCliente"))
jsp = GravarAlteracaoCliente.execute(request);
else if (acao.equals("GravarInsercaoCliente"))
jsp = GravarInsercaoCliente.execute(request);
else if (acao.equals("ExcluirCliente"))
jsp = ExcluirCliente.execute(request);
else if (acao.equals("ListarVeiculo"))
jsp = ListarVeiculo.execute(request);
else if (acao.equals("InserirVeiculo"))
jsp = InserirVeiculo.execute(request);
else if (acao.equals("AlterarVeiculo"))
jsp = AlterarVeiculo.execute(request);
else if (acao.equals("GravarAlteracaoVeiculo"))
jsp = GravarAlteracaoVeiculo.execute(request);
else if (acao.equals("GravarInsercaoVeiculo"))
jsp = GravarInsercaoVeiculo.execute(request);
else if (acao.equals("ExcluirVeiculo"))
jsp = ExcluirVeiculo.execute(request);
else if (acao.equals("ListarModelo"))
jsp = ListarModelo.execute(request);
else if (acao.equals("AlterarModelo"))
jsp = AlterarModelo.execute(request);
else if (acao.equals("GravarAlteracaoModelo"))
jsp = GravarAlteracaoModelo.execute(request);
else if (acao.equals("GravarInsercaoModelo"))
jsp = GravarInsercaoModelo.execute(request);
else if (acao.equals("ExcluirModelo"))
jsp = ExcluirModelo.execute(request);
else if (acao.equals("ListarMarca"))
jsp = ListarMarca.execute(request);
else if (acao.equals("AlterarMarca"))
jsp = AlterarMarca.execute(request);
else if (acao.equals("GravarAlteracaoMarca"))
jsp = GravarAlteracaoMarca.execute(request);
else if (acao.equals("GravarInsercaoMarca"))
jsp = GravarInsercaoMarca.execute(request);
else if (acao.equals("ExcluirMarca"))
jsp = ExcluirMarca.execute(request);
else if (acao.equals("ListarCategoria"))
jsp = ListarCategoria.execute(request);
else if (acao.equals("AlterarCategoria"))
jsp = AlterarCategoria.execute(request);
else if (acao.equals("GravarAlteracaoCategoria"))
jsp = GravarAlteracaoCategoria.execute(request);
else if (acao.equals("GravarInsercaoCategoria"))
jsp = GravarInsercaoCategoria.execute(request);
else if (acao.equals("ExcluirCategoria"))
jsp = ExcluirCategoria.execute(request);
else if (acao.equals("ListarUsuario"))
jsp = ListarUsuario.execute(request);
else if (acao.equals("AlterarUsuario"))
jsp = AlterarUsuario.execute(request);
else if (acao.equals("GravarAlteracaoUsuario"))
jsp = GravarAlteracaoUsuario.execute(request);
else if (acao.equals("GravarInsercaoUsuario"))
jsp = GravarInsercaoUsuario.execute(request);
else if (acao.equals("ExcluirUsuario"))
jsp = ExcluirUsuario.execute(request);
else if (acao.equals("ListarVeiculoCliente"))
jsp = ListarVeiculoCliente.execute(request);
else if (acao.equals("InserirVeiculoCliente"))
jsp = InserirVeiculoCliente.execute(request);
else if (acao.equals("AlterarVeiculoCliente"))
jsp = AlterarVeiculoCliente.execute(request);
else if (acao.equals("GravarAlteracaoVeiculoCliente"))
jsp = GravarAlteracaoVeiculoCliente.execute(request);
else if (acao.equals("GravarInsercaoVeiculoCliente"))
jsp = GravarInsercaoVeiculoCliente.execute(request);
else if (acao.equals("ExcluirVeiculoCliente"))
jsp = ExcluirVeiculoCliente.execute(request);
//
//Redirecionando pagina
RequestDispatcher rd = request.getRequestDispatcher(jsp);
rd.forward(request, response);
}
public void destroy() {
Conexao.destroy();
}
}
Conexao
package Dao;
/**
*
* @author
*/
import java.sql.*;
public class Conexao {
private static Connection conn;
public static void conectar(String url, String usuario, String senha, String driver) {
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, usuario, senha);
}
catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
return conn;
}
public static void destroy() {
try {
conn = null;
}
catch (Exception e) {
e.printStackTrace();
}
}
public static int getAutoInc(String Generator) {
int Codigo = 0;
try {
PreparedStatement pstmt = conn.prepareStatement(
"Select Gen_ID("+Generator+",1) From RDB$Database");
//pstmt.setString(1, Generator);
ResultSet rs = pstmt.executeQuery();
rs.next();
Codigo = rs.getInt(1);
}
catch (Exception e) {
e.printStackTrace();
}
return Codigo;
}
}
XML
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
<context-param>
<param-name>url</param-name>
<param-value>jdbc:postgresql://localhost:5432/gerdocs</param-value>
</context-param>
<context-param>
<param-name>usuario</param-name>
<param-value>postgres</param-value>
</context-param>
<context-param>
<param-name>senha</param-name>
<param-value>admin</param-value>
</context-param>
<context-param>
<param-name>driver</param-name>
<param-value>org.postgresql.Driver</param-value>
</context-param>
<servlet>
<servlet-name>ServletWeb</servlet-name>
<servlet-class>controller.ServletWeb</servlet-class>
</servlet>
<servlet>
<servlet-name>Login</servlet-name>
<servlet-class>controller.Login</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ServletWeb</servlet-name>
<url-pattern>/servletweb</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>Login</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
<session-config>
<session-timeout>30</session-timeout>
</session-config>
<welcome-file-list>
<welcome-file>home.jsp</welcome-file>
</welcome-file-list>
</web-app>