Olá,
Meu código não aponta nenhum erro, contudo quando tento inserir
o código no banco, ele aponta as seguintes exceções:
SQLException: No suitable driver found for jdbc:mysql://localhost:aplicacao_comercial
SQLState: 08001
VendorError: 0
08/09/2007 13:29:54 aplicacaocomercial.FormFornecedor jButton1ActionPerformed
SEVERE: null
java.lang.NullPointerException
at aplicacaocomercial.FornecedorBD.gravar(FornecedorBD.java:19)
at aplicacaocomercial.FormFornecedor.jButton1ActionPerformed(FormFornecedor.java:282)
at aplicacaocomercial.FormFornecedor.access$100(FormFornecedor.java:10)
at aplicacaocomercial.FormFornecedor$2.actionPerformed(FormFornecedor.java:70)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
BUILD SUCCESSFUL (total time: 2 minutes 21 seconds)
Meu código da classe Conexão
public class Conexao
{
public Statement Conectar() throws InstantiationException, IllegalAccessException,
ClassNotFoundException, SQLException,IOException{
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conexao = DriverManager.getConnection("jdbc:mysql://localhost:aplicacao_comercial","user=root","password=");
Statement st = conexao.createStatement();
return st;
}
catch(SQLException ex){
System.err.println("SQLException: " + ex.getMessage());
System.err.println("SQLState: " + ex.getSQLState());
System.err.println("VendorError: " + ex.getErrorCode());
return null;
}
catch(Exception e){
JOptionPane.showMessageDialog(null,"Erro ao conectar com o banco de dados","Erro de " +
"Conexão",JOptionPane.ERROR_MESSAGE);
return null;
}
}
}//Fim da Classe
Uso em ClienteBD
public class ClienteBD extends Conexao {
Conexao con = new Conexao();
public ClienteBD() {
}
public void gravar( String nome,String cpf,String rg,String endereco,String bairro,
String municipio,String uf,String cep,String telefone,String fax,
String celular,String email) throws Exception{
PreparedStatement st;
st = (PreparedStatement) con.Conectar();
st.execute("INSERT INTO Cliente(nome,cpf,rg,endereco,bairro,municipio,uf,cep" +
"telefone,fax,celular,email) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)");
st.setString(1, nome);
st.setString(2, cpf);
st.setString(3, rg);
st.setString(4, endereco);
st.setString(5, bairro);
st.setString(6, municipio);
st.setString(7, uf);
st.setString(8, cep);
st.setString(9, telefone);
st.setString(10, fax);
st.setString(11, celular);
st.setString(12, email);
st.executeUpdate();
st.close();
}
Por favor Ajudem pessoal, obrigado.