[quote=quintacs]Este é o log de erro.
[code]java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1645)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1491)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at br.com.jdbc.JDBC.getConnection(JDBC.java:14)
at br.com.dao.ClienteDAO.(ClienteDAO.java:20)
at br.com.servlet.Adiciona.service(Adiciona.java:72)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/sistemadevendas
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at br.com.jdbc.JDBC.getConnection(JDBC.java:20)
at br.com.dao.ClienteDAO.(ClienteDAO.java:20)
at br.com.servlet.Adiciona.service(Adiciona.java:72)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Essa é a classe de acesso ao banco.
package br.com.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JDBC {
private Connection connection;
public Connection getConnection()throws SQLException{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("classe nao encontrada");
e.printStackTrace();
}
return connection = DriverManager.getConnection("jdbc:mysql://localhost/sistemadevendas","root","654321");
}
}
Essa é a classe ClienteDAO.
package br.com.dao;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import br.com.jdbc.JDBC;
import br.com.modelo.ClienteModel;
public class ClienteDAO {
private Connection connection;
public ClienteDAO(){
try {
connection = new JDBC().getConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void adiciona(ClienteModel cliente){
String insere="insert into cliente (cpf,nome,email,data_cadastro) values(?,?,?,?)";
try {
PreparedStatement pstm = connection.prepareStatement(insere);
pstm.setLong(1,cliente.getCpf());
pstm.setString(2,cliente.getNome());
pstm.setString(3,cliente.getEmail());
pstm.setDate(4,new Date (cliente.getData_cadastro().getTimeInMillis()));
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
Esse é o servlet Adiciona.
package br.com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import br.com.dao.ClienteDAO;
import br.com.modelo.ClienteModel;
/**
-
Servlet implementation class Adiciona
*/
public class Adiciona extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
-
@see HttpServlet#HttpServlet()
*/
public Adiciona() {
super();
// TODO Auto-generated constructor stub
}
/**
-
@see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
-
@see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
public void service(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
PrintWriter out= response.getWriter();
String nome=request.getParameter(“nome”);
long cpf=Long.parseLong(request.getParameter(“cpf”));
String email=request.getParameter(“email”);
String dataEmTexto=request.getParameter(“data”);
Calendar data=null;
try {
Date date=new SimpleDateFormat(“dd/MM/yyyy”).parse(dataEmTexto);
data = Calendar.getInstance();
data.setTime(date);
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ClienteModel clienteModel =new ClienteModel();
clienteModel.setCpf(cpf);
clienteModel.setData_cadastro(data);
clienteModel.setNome(nome);
clienteModel.setEmail(email);
ClienteDAO dao = new ClienteDAO();
dao.adiciona(clienteModel);
out.print("");
out.print("");
out.print("<OK "+clienteModel.getNome());
out.print("OK "+clienteModel.getCpf());
out.print(“OK “+clienteModel.getEmail());
out.print(“OK “+clienteModel.getData_cadastro());
out.print(””);
out.print(””);
}
}
Essa é a pagina.
Insert title here
Nome:
E-mail:
CPF:
Danta:
E esse é o xml.
<?xml version="1.0" encoding="UTF-8"?>
sistema
index.html
index.htm
index.jsp
default.html
default.htm
default.jsp
Adiciona
Adiciona
br.com.servlet.Adiciona
Adiciona
/Adiciona
[/code]
Segue tamém uma print da disposição de como estão organizadas as pastas.
Valeu pela ajuda.[/quote]
Pessoal ta acontecendo um erro muito estranho.
Eu reconstrui todo o sistema minuciosamente e o mesmo erro contiua acontecendo.
Coloquei o driver do mysql no build path do projeto e o erro persiste.
Alguém pode me ajudar.
Grato.