Erro em login

[marceloamerico]

Olá, estou tentando fazer uma validação de login e esta dando erro, abaixo coloco o erro e os códigos, alguém poderia me dar uma força?

Formulário de acesso

[quote]<%@ page language=“java” contentType="text/html; charset=ISO-8859-1"
pageEncoding=“ISO-8859-1”%>

Sistema

Acesse o sistema

			<form action="efetuaLogin" method="post" id="form">
				<p class="label">Login:</p><input type="text" name="login" /><br /><br />
				<p class="label">Senha:</p><input type="password" name="senha"/><br />
				<input type="submit" value="Entrar no sistema" class="submit">
				
			</form>
		</div>
	</div>
</div>

[/quote]

Classe Usuario:

[quote]package br.com.sapatos.sapatos.model;

import javax.validation.constraints.NotNull;

public class Usuario {

@NotNull
private Long id;

private String nome;
private String login;
private String senha;

public Long getId() {
	return id;
}

public void setId(Long id) {
	this.id = id;
}

public String getNome() {
	return nome;
}

public void setNome(String nome) {
	this.nome = nome;
}

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;
}

}
[/quote]

LoginController:

[quote]package br.com.sapatos.sapatos.controller;

import javax.servlet.http.HttpSession;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import br.com.sapatos.sapatos.dao.UsuarioDAO;
import br.com.sapatos.sapatos.model.Usuario;

@Controller
public class LoginController {

@RequestMapping("loginForm")
public String loginForm() {
	return "formulario-login";
}

@RequestMapping("efetuaLogin")
public String efetuaLogin(Usuario usuario, HttpSession session) {
	if (new UsuarioDAO().existeUsuario(usuario)) {
		session.setAttribute("usuarioLogado", usuario);
		return "principal";
	}
	return "redirect:loginForm";
}

}
[/quote]

UsuarioDAO:

package br.com.sapatos.sapatos.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import br.com.sapatos.sapatos.ConnectionFactory;
import br.com.sapatos.sapatos.model.Usuario;

public class UsuarioDAO {
private final Connection connection;

public UsuarioDAO() {
	try {
		this.connection = new ConnectionFactory().getConnection();
	} catch (SQLException e) {
		throw new RuntimeException(e);
	}
}

public void adiciona(Usuario usuario) {
	String sql = "insert into usuario(id, nome, login, senha) values(?,?,?,?)";
	PreparedStatement stmt;
	try {
		stmt = connection.prepareStatement(sql);
		stmt.setLong(1, usuario.getId());
		stmt.setString(2, usuario.getNome());
		stmt.setString(3, usuario.getLogin());
		stmt.setString(4, usuario.getSenha());
		stmt.execute();
	} catch (SQLException e) {
		throw new RuntimeException(e);
	}
}

public void remove(Usuario usuario) {
	if (usuario.getId() == null) {
		throw new IllegalStateException("Id nao podeser nulo.");
	}

	String sql = "DELETE from usuario where id = ?";
	PreparedStatement stmt;
	try {
		stmt = connection.prepareStatement(sql);
		stmt.setLong(1, usuario.getId());
		stmt.execute();

	} catch (SQLException e) {
		throw new RuntimeException(e);
	}
}
public void altera(Usuario usuario) {
	String sql = "update usuario set id = ?, nome = ?, login = ?,  senha = ? where id = ?";
	PreparedStatement stmt;
	try {
		stmt = connection.prepareStatement(sql);
		stmt.setLong(1, usuario.getId());
		stmt.setString(2, usuario.getNome());
		stmt.setString(3, usuario.getLogin());
		stmt.setString(4, usuario.getSenha());
		

		stmt.execute();
	} catch (SQLException e) {
		throw new RuntimeException(e);
	}
}

public List<Usuario> lista() {
	try {
		List<Usuario> usuarios = new ArrayList<Usuario>();
		PreparedStatement stmt = this.connection
				.prepareStatement("select * from usuario");

		ResultSet rs = stmt.executeQuery();

		while (rs.next()) {
			// adiciona a produto na lista
			usuarios.add(populaUsuario(rs));
		}

		rs.close();
		stmt.close();

		return usuarios;
	} catch (SQLException e) {
		throw new RuntimeException(e);
	}
}

private Usuario populaUsuario(ResultSet rs) throws SQLException {
	Usuario usuario = new Usuario();

	// popula o objeto produto
	usuario.setId(rs.getLong("id"));
	usuario.setNome(rs.getString("nome"));
	usuario.setLogin(rs.getString("login"));
	usuario.setSenha(rs.getString("senha"));
	
	return usuario;

}

public Usuario buscaPorId(Long id) {

	if (id == null) {
		throw new IllegalStateException(
				"Id do usuario não deve ser nulo.");
	}

	try {
		PreparedStatement stmt = this.connection
				.prepareStatement("select * from usuario where id = ?");
		stmt.setLong(1, id);

		ResultSet rs = stmt.executeQuery();

		if (rs.next()) {
			return populaUsuario(rs);
		}

		rs.close();
		stmt.close();

		return null;
	} catch (SQLException e) {
		throw new RuntimeException(e);
	}
}

public boolean existeUsuario(Usuario usuario) {

	try{
		PreparedStatement stmt = this.connection.prepareStatement("select * from usuario where login = ? and senha = ?");
		stmt.setString(1, usuario.getLogin());
		stmt.setString(2, usuario.getSenha());
		
		ResultSet rs = stmt.executeQuery();
		if(rs.equals(usuario)){
			return true;
		}
		rs.close();
		stmt.close();
		
		return false;
		
	}catch(SQLException e){
		throw new RuntimeException(e);
	}
}

}

[fabiocortolan]

Posta o erro!

[marceloamerico]

Faltou o erro:

ype Exception report

message Request processing failed; nested exception is java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:681)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585)
javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause

java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
br.com.sapatos.sapatos.dao.UsuarioDAO.(UsuarioDAO.java:20)
br.com.sapatos.sapatos.controller.LoginController.efetuaLogin(LoginController.java:21)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585)
javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
java.lang.reflect.Constructor.newInstance(Unknown Source)
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
com.mysql.jdbc.MysqlIO.(MysqlIO.java:344)
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2333)
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:792)
com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
java.lang.reflect.Constructor.newInstance(Unknown Source)
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
br.com.sapatos.sapatos.ConnectionFactory.getConnection(ConnectionFactory.java:18)
br.com.sapatos.sapatos.dao.UsuarioDAO.(UsuarioDAO.java:18)
br.com.sapatos.sapatos.controller.LoginController.efetuaLogin(LoginController.java:21)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585)
javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause

java.net.ConnectException: Connection refused: connect
java.net.TwoStacksPlainSocketImpl.socketConnect(Native Method)
java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
java.net.AbstractPlainSocketImpl.connect(Unknown Source)
java.net.PlainSocketImpl.connect(Unknown Source)
java.net.SocksSocketImpl.connect(Unknown Source)
java.net.Socket.connect(Unknown Source)
java.net.Socket.connect(Unknown Source)
java.net.Socket.(Unknown Source)
java.net.Socket.(Unknown Source)
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
com.mysql.jdbc.MysqlIO.(MysqlIO.java:294)
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2333)
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:792)
com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
java.lang.reflect.Constructor.newInstance(Unknown Source)
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
br.com.sapatos.sapatos.ConnectionFactory.getConnection(ConnectionFactory.java:18)
br.com.sapatos.sapatos.dao.UsuarioDAO.(UsuarioDAO.java:18)
br.com.sapatos.sapatos.controller.LoginController.efetuaLogin(LoginController.java:21)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585)
javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.32 logs.

[Ramon_Pires]

Verifica se a vc consegue acessar a sua instancia do mysql , pois o erro que ocorre é devido ao fato de não estar conseguindo acessar o mysql.

[marceloamerico]

Verifica se a vc consegue acessar a sua instancia do mysql , pois o erro que ocorre é devido ao fato de não estar conseguindo acessar o mysql.

Realmente não estou conseguindo listar nada do meu banco e nem inserir. Pelo meu código acima o problema pode estar nele, ou algo que tenho que fazer no próprio mysql?

Obrigado.

[jaboot]

Pelo seu código não há nada errado, mas verifica se o seu usuário tem permissões nesse banco/tabela

[marceloamerico]

Continua dando o mesmo erro alguém poderia me ajudar?

[fabiocortolan]

Os dados para conexão estão corretos, url, login, senha, etc?