Erro de connection JSP com banco Mysql

Bom dia a todos. Estou com um problema quando executo o jsp com o codigo para carrega os dados do banco acontece esse erro alguem pode me ajudar.

29/06/2011 10:38:46 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet [jsp] in context with path [/Museu] threw exception [java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/Mcomputa] with root cause
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/Mcomputa
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at br.com.museu.computador.ConnectionFactory.getConnection(ConnectionFactory.java:17)
	at br.com.museu.computador.UsuarioDAO.<init>(UsuarioDAO.java:15)
	at org.apache.jsp.lista_002dcontado_jsp._jspService(lista_002dcontado_jsp.java:69)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:68)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:332)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:108)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:558)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:379)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:259)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:237)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:281)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

Essa e minha JSP.

<%@page import="br.com.site.museu.computador.carrega.os.dados.Usuarios"%>
<%@page import="java.util.List"%>
<%@page import="br.com.museu.computador.UsuarioDAO"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!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=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<table>
<%
UsuarioDAO dao = new UsuarioDAO();
List<Usuarios> user = dao.getList();

for (Usuarios usuario : user) {
%>
	<tr>
	<td><%=usuario.getId() %></td>
	<td><%=usuario.getNome() %></td>
	</tr>
	</tr>
	<%
	}
	%>

</table>

</body>
</html>

E essa e a minha DAO

public List<Usuarios> getList(){
			try {
				List<Usuarios> user = new ArrayList<Usuarios>();
				PreparedStatement stmt = this.connection.prepareStatement("select * from usuarios");
				ResultSet rs = stmt.executeQuery();
				
				while (rs.next()) {
					Usuarios usuario = new Usuarios();
					
					usuario.setId(rs.getString("id"));
					usuario.setNome(rs.getString("nome"));
					
					user.add(usuario);
				}
				rs.close();
				stmt.close();
				return user;
			} catch (SQLException e) {
				throw new RuntimeException(e);// TODO: handle exception
			}
			
		}

E essa e minha Connection

package br.com.museu.computador;

import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Connection;

import javax.swing.JOptionPane;
/**
 * @author Aquiles Ribeiro da Silva
 *
 */
public class ConnectionFactory {
	public Connection getConnection(){
System.out.println("Conectado funcionando");
		
		try {
			return DriverManager.getConnection("jdbc:mysql://localhost/*****","root","******");   
		} catch (Exception e) {
			JOptionPane.showMessageDialog(null, "Erro ao se conectar com banco de dados");
			throw new RuntimeException(e);
		}
	}

}

8 Respostas

Topicos relacionados