Boa noite, estou fazendo um exercicio da apostila da Caelum, porém ao tentar realizar a operação.
Ele aparece a seguinte mensagem no console:
WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
E da Erro 404 na pagina.
Segue a connectionFactory:
package br.com.caelum.agenda;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionFactory {
public Connection getConnection(){
try{
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
return DriverManager.getConnection("jdbc:mysql://localhost/fj21","root","senha");
}catch (SQLException e){
throw new RuntimeException(e);
}
}
}
Tenho uma pagina de cadastrs de contatos, e quero remover um contato.
Classe RemoveContatoLogic:
package br.com.caelum.mvc.logica;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import br.com.caelum.agenda.dao.ContatoDao;
import br.com.caelum.agenda.modelo.Contato;
public class RemoveContatoLogic implements Logica{
@Override
public String executa(HttpServletRequest req, HttpServletResponse res)
throws Exception {
//Recebendo o id pelo request
long id = Long.parseLong(req.getParameter("id"));
Contato contato = new Contato();
contato.setId(id);
ContatoDao dao = new ContatoDao();
dao.remove(contato);
System.out.println("Removendo contato ....");
return "lista-contatos.jsp";
}
}
Segue pagina jsp lista-contatos:
< %@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
< %@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
< body>
< !-- Instanciando a classe ContatoDao -->
< jsp:useBean id=“dao” class=“br.com.caelum.agenda.dao.ContatoDao”/>
< c:import url=“cabecalho.jsp”/>
< table border=“1”>
< !-- Percorrendo os contatos da linha da tabela -->
< c:forEach var=“contato” items="${dao.lista}" varStatus=“id”>
< tr bgcolor="#${id.count %2==1 ? ‘aaee88’ : ‘ffffff’}">
< th>LOGICA
< td>Remover
< th>ID
< td>${id.count}
< th>NOME
< td>${contato.nome}
< th>EMAIL
< td>
< c:choose>
< c:when test="${not empty contato.email}">
< a href=“mailto:${contato.email}”/>${contato.email}
< /c:when>
< c:otherwise>
E-mail não informado
< /c:otherwise>
< /c:choose>
< /td>
< th>ENDEREÇO
< td>${contato.endereco}
< th>DATA NASCIMENTO
< td><fmt:formatDate value="${contato.dataNascimento.time}"
pattern=“dd/MM/yyyy” />
< /c:forEach>
< /table>
< c:import url=“rodape.jsp”/>
< /body>
Segue interface Logica:
package br.com.caelum.mvc.logica;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public interface Logica {
String executa(HttpServletRequest req, HttpServletResponse res) throws Exception;
}