Aparentemente o Classpath do driver não foi configurado corretamente.
A velha história do classpath…
Procura a parada aí…
O erro
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at cadastrocliente.FormCadClie.BtnGravarActionPerformed(FormCadClie.java:1119)
at cadastrocliente.FormCadClie.access$200(FormCadClie.java:48)
at cadastrocliente.FormCadClie$3.actionPerformed(FormCadClie.java:1012)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
at java.awt.Dialog$1.run(Dialog.java:515)
at java.awt.Dialog.show(Dialog.java:536)
at java.awt.Component.show(Component.java:1300)
at java.awt.Component.setVisible(Component.java:1253)
at cadastrocliente.FormCadClie$4.run(FormCadClie.java:1194)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at cadastrocliente.FormCadClie.BtnGravarActionPerformed(FormCadClie.java:1125)
at cadastrocliente.FormCadClie.access$200(FormCadClie.java:48)
at cadastrocliente.FormCadClie$3.actionPerformed(FormCadClie.java:1012)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
at java.awt.Dialog$1.run(Dialog.java:515)
at java.awt.Dialog.show(Dialog.java:536)
at java.awt.Component.show(Component.java:1300)
at java.awt.Component.setVisible(Component.java:1253)
at cadastrocliente.FormCadClie$4.run(FormCadClie.java:1194)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)Aqui esta o
try {
String vCODIGO = CODIGO.getText();
String vDATA_CADASTRO = "";
try {
vDATA_CADASTRO = (DATA_CADASTRO.getText(6, 4) + "-" + DATA_CADASTRO.getText(3, 2) + "-" + DATA_CADASTRO.getText(0, 2));
} catch (BadLocationException ex) {
ex.printStackTrace();
}
String vCOD_MATRIZ = COD_MATRIZ.getText();
String vRAZAO_SOCIAL = RAZAO_SOCIAL.getText();
String vNOME_FANTASIA = NOME_FANTASIA.getText();
String vNOME_REDUZ = NOME_REDUZ.getText();
String vCNPJ = CNPJ.getText();
String vINSCRICAO = INSCRICAO.getText();
String vCEP = CEP.getText();
String vENDERECO = ENDERECO.getText();
String vNUMERO = NUMERO.getText();
String vCOMPLEMENTO = COMPLEMENTO.getText();
String vCIDADE = CIDADE.getText();
String vESTADO = ESTADO.getText();
String vEMAIL = EMAIL.getText();
String vBAIRRO = BAIRRO.getText();
String vTELEFONE = TELEFONE.getText();
String vFAX = FAX.getText();
char vEMPRESA = EMPRESA.getItemAt(EMPRESA.getSelectedIndex()).toString().toCharArray()[0];
int vSISTEMA = (SISTEMA.getSelectedIndex() + 1);
String vDATA_LIBERACAO = "";
try {
vDATA_LIBERACAO = (DATA_LIBERACAO.getText(6, 4) + "-" + DATA_LIBERACAO.getText(3, 2) + "-" + DATA_LIBERACAO.getText(0, 2));
} catch (BadLocationException ex) {
ex.printStackTrace();
}
String vDIAS_USO = DIAS_USO.getText();
String vQTDE_FILIAIS = QTDE_FILIAIS.getValue().toString() ;
String vQTDE_TERMINAIS = QTDE_TERMINAIS.getValue().toString();
char vACESSO = ACESSO.getItemAt(ACESSO.getSelectedIndex()).toString().toCharArray()[0];
String vHOST = HOST.getText();
String vIP = IP.getText();
String vPORTA_FREENX = PORTA_FREENX.getText();
String vSENHA_FREENX = SENHA_FREENX.getText();
String vSENHA_ROOT_FREENX = SENHA_ROOT_FREENX.getText();
String vUSUARIO_FREENX = USUARIO_FREENX.getText();
String vUSUARIO_TS = USUARIO_TS.getText();
String vSENHA_TS = SENHA_TS.getText();
String vSENHA_ROOT_TS = SENHA_ROOT_TS.getText();
String vPORTA_TS = PORTA_TS.getText();
String vUSUARIO_SSH = USUARIO_SSH.getText();
String vSENHA_SSH = SENHA_SSH.getText();
String vSENHA_ROOT_SSH = SENHA_ROOT_SSH.getText();
String vPORTA_SSH = PORTA_SSH.getText();
String vSENHA_VNC = SENHA_VNC.getText();
String vPORTA_VNC = PORTA_VNC.getText();
String vUSUARIO_MYSQL = USUARIO_MYSQL.getText();
String vSENHA_MYSQL = SENHA_MYSQL.getText();
String vSENHA_ROOT_MYSQL = SENHA_ROOT_MYSQL.getText();
String vPORTA_MYSQL = PORTA_MYSQL.getText();
String nomeBanco = "*****";
String usuario = "root";
String senha = "senha";
try {
Class.forName("com.mysql.jdbc.Driver").getInterfaces(); //* driver do mysql para conexão */
}
catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + nomeBanco, usuario, senha);
Statement st = con.createStatement();
st.executeUpdate("INSERT INTO clientes (" +
"DATA_CADASTRO, RAZAO_SOCIAL, NOME_FANTASIA, NOME_REDUZ, COD_MATRIZ, CNPJ, INSCRICAO, CEP, ENDERECO, " +
"NUMERO, COMPLEMENTO, CIDADE, ESTADO, BAIRRO, EMAIL, TELEFONE, FAX, SISTEMA, EMPRESA, DATA_LIBERACAO, DIAS_USO, " +
"QTDE_FILIAIS, QTDE_TERMINAIS, ACESSO, HOST, IP, USUARIO_FREENX, SENHA_FREENX, SENHA_ROOT_FREENX, PORTA_FREENX," +
"USUARIO_TS, SENHA_TS, SENHA_ROOT_TS, PORTA_TS, USUARIO_SSH, SENHA_SSH, SENHA_ROOT_SSH, PORTA_SSH, SENHA_VNC, PORTA_VNC" +
"USUARIO_MYSQL, SENHA_MYSQL, SENHA_MYSQL, PORTA_MYSQL" +
") VALUES (" +
"'" + vDATA_CADASTRO + "', " +
"'" + vRAZAO_SOCIAL + "' , " +
"'" + vNOME_FANTASIA + "' , " +
"'" + vNOME_REDUZ + "' , " +
"'" + vCOD_MATRIZ + "' , " +
"'" + vCNPJ + "' , " +
"'" + vINSCRICAO + "' , " +
"'" + vCEP + "' , " +
"'" + vENDERECO + "' , " +
"'" + vNUMERO + "' , " +
"'" + vCOMPLEMENTO + "' , " +
"'" + vCIDADE + "' , " +
"'" + vESTADO + "' , " +
"'" + vBAIRRO + "' , " +
"'" + vEMAIL + "' , " +
"'" + vTELEFONE + "' , " +
"'" + vFAX + "', " +
"'" + vSISTEMA + "' , " +
"'" + vEMPRESA + "' , " +
"'" + vDATA_LIBERACAO + "' , " +
"'" + vDIAS_USO + "' , " +
"'" + vQTDE_FILIAIS + "' , " +
"'" + vQTDE_TERMINAIS + "' , " +
"'" + vACESSO + "' , " +
"'" + vHOST + "' , " +
"'" + vIP + "'," +
"'" + vUSUARIO_FREENX + "'," +
"'" + vSENHA_FREENX + "'," +
"'" + vSENHA_ROOT_FREENX + "'," +
"'" + vPORTA_FREENX + "'," +
"'" + vUSUARIO_TS + "'," +
"'" + vSENHA_TS + "'," +
"'" + vSENHA_ROOT_TS + "'," +
"'" + vPORTA_TS + "'," +
"'" + vUSUARIO_SSH + "'," +
"'" + vSENHA_SSH + "'," +
"'" + vSENHA_ROOT_SSH + "'," +
"'" + vPORTA_SSH + "'," +
"'" + vSENHA_VNC + "'," +
"'" + vPORTA_VNC + "'," +
"'" + vUSUARIO_MYSQL + "'," +
"'" + vSENHA_MYSQL + "'," +
"'" + vSENHA_ROOT_MYSQL + "'," +
"'" + vPORTA_MYSQL + "'," +
")");
JOptionPane.showMessageDialog(null,"Gravado",
"Aviso", JOptionPane.INFORMATION_MESSAGE);
}
catch (SQLException e1) {e1.printStackTrace();
}