Não acho o erro de jeito nenhum [RESOLVIDO]

29 de janeiro de 2012 9 respostas

angelopppp 29 de janeiro de 2012

Jan 29, 2012 11:23:17 PM gerenciador.add jButton1ActionPerformed
Grave: null
java.sql.SQLException: Column count doesn't match value count at row 1
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)
	at bancodedados.comandoprincipal.adiciona(comandoprincipal.java:42)
	at gerenciador.add.jButton1ActionPerformed(add.java:282)
	at gerenciador.add.access$100(add.java:23)
	at gerenciador.add$2.actionPerformed(add.java:108)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
	at java.awt.Component.processMouseEvent(Component.java:6504)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
	at java.awt.Component.processEvent(Component.java:6269)
	at java.awt.Container.processEvent(Container.java:2229)
	at java.awt.Component.dispatchEventImpl(Component.java:4860)
	at java.awt.Container.dispatchEventImpl(Container.java:2287)
	at java.awt.Component.dispatchEvent(Component.java:4686)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
	at java.awt.Container.dispatchEventImpl(Container.java:2273)
	at java.awt.Window.dispatchEventImpl(Window.java:2713)
	at java.awt.Component.dispatchEvent(Component.java:4686)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
	at java.awt.EventQueue.access$000(EventQueue.java:101)
	at java.awt.EventQueue$3.run(EventQueue.java:666)
	at java.awt.EventQueue$3.run(EventQueue.java:664)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
	at java.awt.EventQueue$4.run(EventQueue.java:680)
	at java.awt.EventQueue$4.run(EventQueue.java:678)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:121)
	at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)
	at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)
	at java.awt.Dialog.show(Dialog.java:1072)
	at java.awt.Component.show(Component.java:1650)
	at java.awt.Component.setVisible(Component.java:1602)
	at java.awt.Window.setVisible(Window.java:1013)
	at java.awt.Dialog.setVisible(Dialog.java:1003)
	at gerenciador.principal.jButton2ActionPerformed(principal.java:142)
	at gerenciador.principal.access$300(principal.java:27)
	at gerenciador.principal$3.actionPerformed(principal.java:76)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
	at java.awt.Component.processMouseEvent(Component.java:6504)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
	at java.awt.Component.processEvent(Component.java:6269)
	at java.awt.Container.processEvent(Container.java:2229)
	at java.awt.Component.dispatchEventImpl(Component.java:4860)
	at java.awt.Container.dispatchEventImpl(Container.java:2287)
	at java.awt.Component.dispatchEvent(Component.java:4686)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
	at java.awt.Container.dispatchEventImpl(Container.java:2273)
	at java.awt.Window.dispatchEventImpl(Window.java:2713)
	at java.awt.Component.dispatchEvent(Component.java:4686)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
	at java.awt.EventQueue.access$000(EventQueue.java:101)
	at java.awt.EventQueue$3.run(EventQueue.java:666)
	at java.awt.EventQueue$3.run(EventQueue.java:664)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
	at java.awt.EventQueue$4.run(EventQueue.java:680)
	at java.awt.EventQueue$4.run(EventQueue.java:678)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Ele da este erro vou postar o codigo dos meus comandos em sql

private Connection conexao;
    public comandoprincipal() throws ClassNotFoundException, SQLException{
    this.conexao= conexao2.getConexao();
    }
    public void adiciona(principalcmd contas) throws SQLException{
    String comandosql="Insert into cadastro(numeroprodutor,produtor,algodoeira,lote,lotealgodoeira,pesoalgodoeira,pesoliquido,quantidadeembarcada,quantidadesaldo,empresatakeup,hvi,datatakeup,datasaida) values (?,?,?,?,?,?,?,?,?,?,?,?,?)";
    PreparedStatement stmt=conexao.prepareStatement(comandosql);
    stmt.setString(1, contas.getNprodutor());
    stmt.setString(2, contas.getProdutor());
    stmt.setString(3, contas.getAlgodoeira());
    stmt.setString(4, contas.getLote());
    stmt.setString(5, contas.getLotealg());
    stmt.setString(6, contas.getPesoalg());
    stmt.setString(7, contas.getPesoliqu());
    stmt.setString(8, contas.getQembarcada());
    stmt.setString(9, contas.getQsaldo() );
    stmt.setString(10, contas.getEmpresatakeup()  );
    stmt.setString(11, contas.getHvi());
    stmt.setString(12, contas.getDatatakeup() );
    stmt.setString(13, contas.getDatasaida() );
    stmt.execute();
    stmt.close();
   
    }
    public List<principalcmd> getLista() throws SQLException{
    String sql="select * from cadastro";
    PreparedStatement stmt=conexao.prepareCall(sql);
    ResultSet rs=stmt.executeQuery();
    List<principalcmd> minhalista=new ArrayList<principalcmd>();
    while(rs.next()){
    principalcmd c1= new principalcmd();
    c1.setId(Long.valueOf(rs.getString("id")));
    c1.setNprodutor(rs.getString("numeroprodutor"));
    c1.setProdutor(rs.getString("produtor"));
    c1.setAlgodoeira(rs.getString("algodoeira"));
    c1.setLote(rs.getString("lote"));
    c1.setLotealg(rs.getString("lotealgodoeira"));
    c1.setPesoalg(rs.getString("numeroprodutor"));
    c1.setPesoliqu(rs.getString("produtor"));
    c1.setQembarcada(rs.getString("algodoeira"));
    c1.setQsaldo(rs.getString("lote"));
    c1.setEmpresatakeup(rs.getString("lotealgodoeira"));
    c1.setHvi(rs.getString("algodoeira"));
    c1.setDatatakeup(rs.getString("lote"));
    c1.setDatasaida(rs.getString("lotealgodoeira"));
    minhalista.add(c1);
    }
    rs.close();
    stmt.close();
    return minhalista;
   
    }
    
    public List<principalcmd> getLista2(String usuario) throws SQLException{
    String sql="select * from cadastro where usuario like ?";
    PreparedStatement stmt=conexao.prepareCall(sql);
    stmt.setString(1, usuario);
    ResultSet rs=stmt.executeQuery();
    List<principalcmd> minhalista=new ArrayList<principalcmd>();
    while(rs.next()){
    principalcmd c1= new principalcmd();
    c1.setId(Long.valueOf(rs.getString("id")));
    c1.setNprodutor(rs.getString("numeroprodutor"));
    c1.setProdutor(rs.getString("produtor"));
    c1.setAlgodoeira(rs.getString("algodoeira"));
    c1.setLote(rs.getString("lote"));
    c1.setLotealg(rs.getString("lotealgodoeira"));
    c1.setPesoalg(rs.getString("numeroprodutor"));
    c1.setPesoliqu(rs.getString("produtor"));
    c1.setQembarcada(rs.getString("algodoeira"));
    c1.setQsaldo(rs.getString("lote"));
    c1.setEmpresatakeup(rs.getString("lotealgodoeira"));
    c1.setHvi(rs.getString("algodoeira"));
    c1.setDatatakeup(rs.getString("lote"));
    c1.setDatasaida(rs.getString("lotealgodoeira"));
    
    minhalista.add(c1);
    }
    rs.close();
    stmt.close();
    return minhalista;
   
    }
    
    public void altera(principalcmd conta) throws SQLException{
    String sql="update cadastro set numeroprodutor=?,produtor=?,algodoeira=?,lote=?,lotealgodoeira=?,pesoalgodoeira=?"
            + "pesoliquido=?,quantidadeembarcada=?,quantidadesaldo=?,empresatakeup=?,hvi=?,datatakeup=?,datasaida=? where id=?";
    PreparedStatement stmt= conexao.prepareStatement(sql);
    stmt.setString(1, conta.getNprodutor());
    stmt.setString(2, conta.getProdutor());
    stmt.setString(3, conta.getAlgodoeira());
    stmt.setString(4, conta.getLote());
    stmt.setString(5, conta.getLotealg());
    stmt.setString(6, conta.getPesoalg());
    stmt.setString(7, conta.getPesoliqu());
    stmt.setString(8, conta.getQembarcada());
    stmt.setString(9, conta.getQsaldo() );
    stmt.setString(10, conta.getEmpresatakeup()  );
    stmt.setString(11, conta.getHvi());
    stmt.setString(12, conta.getDatatakeup() );
    stmt.setString(13, conta.getDatasaida() );
    stmt.setLong(14, conta.getId());
   stmt.execute();
    stmt.close();
  
    }
    
    public void remove(principalcmd conta) throws SQLException{
    String sql="delete  from cadastro where id=?";
    PreparedStatement stmt= conexao.prepareStatement(sql);
    
    stmt.setLong(1, conta.getId());
   
    stmt.execute();
    stmt.close();
    }

E aqui o codigo que está no meu botão de adicionar

principalcmd cmd= new principalcmd();
    cmd.setNprodutor(jTextField1.getText());
      cmd.setProdutor(jTextField2.getText());
      cmd.setAlgodoeira(jTextField3.getText());
      cmd.setLote(jTextField4.getText());
      cmd.setLotealg(jTextField5.getText());
      cmd.setPesoalg(jTextField6.getText());
      cmd.setPesoliqu(jTextField7.getText());
      cmd.setQembarcada(jTextField8.getText());
      cmd.setQsaldo(jTextField9.getText());
      cmd.setEmpresatakeup(jTextField10.getText());
       cmd.setHvi(jTextField11.getText());
      cmd.setDatatakeup(jTextField12.getText());
      cmd.setDatasaida(jTextField13.getText());
comandoprincipal ex = null;
        try {
            ex = new comandoprincipal();
        } catch (ClassNotFoundException ex1) {
            Logger.getLogger(add.class.getName()).log(Level.SEVERE, null, ex1);
        } catch (SQLException ex1) {
            Logger.getLogger(add.class.getName()).log(Level.SEVERE, null, ex1);
        }
        try {
            ex.adiciona(cmd);
        } catch (SQLException ex1) {
            Logger.getLogger(add.class.getName()).log(Level.SEVERE, null, ex1);
        }

9 Respostas

kritiuns 30 de jan. de 2012

Brow!

ve se é esse problema que vc está tendo

http://www.gsmfans.com.br/index.php?topic=23294.0

Fexx 30 de jan. de 2012

Esse erro:

java.sql.SQLException: Column count doesn't match value count at row 1

Quer dizer:
Contagem de colunas não confere com a contagem de valores na linha 1

Normalmente quando ocorre este tipo de erro, a primeira coisa a ser feita é verificar se o numero de valores que vai para os campos da tabela corresponde ao numero de colunas que ira receber estes valores.
Exemplo:

Se você for inserir numeroprodutor, produtor, algodoeira, lote, algodoeira os valore pode ser: 1222, jjjjj, ddddd, 1212 e esquecer os valores de algodoeira, esse mesmo erro ocorre.

verifique o seu banco e os dados a serem enviados.

Boa sorte.

mausexdd 30 de jan. de 2012

Quer dizer:
Contagem de colunas não confere com a contagem de valores na linha 1

Normalmente quando ocorre este tipo de erro, a primeira coisa a ser feita é verificar se o numero de valores que vai para os campos da tabela corresponde ao numero de colunas que ira receber estes valores.
Exemplo:

Se você for inserir numeroprodutor, produtor, algodoeira, lote, algodoeira os valore pode ser: 1222, jjjjj, ddddd, 1212 e esquecer os valores de algodoeira, esse mesmo erro ocorre.

verifique o seu banco e os dados a serem enviados.

Boa sorte.

Como o amigo já disse , Seu código não reflete suas tabelas no BD , verifique e confira os parametros que estão sendo passados.

angelopppp 30 de jan. de 2012

blz galera descobri o erro era que eu não estava setando o id na hora de colocar os dados agora funfando porém á outro erro

Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2308)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
	at java.sql.DriverManager.getConnection(DriverManager.java:579)
	at java.sql.DriverManager.getConnection(DriverManager.java:221)
	at bd.mysqlconection.getConexao(mysqlconection.java:19)
	at bd.comandosprincipal.<init>(comandosprincipal.java:19)
	at gerenciador.algo.GerenciadorAlgo.main(GerenciadorAlgo.java:37)
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:69)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:337)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:198)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
	at java.net.Socket.connect(Socket.java:579)
	at java.net.Socket.connect(Socket.java:528)
	at java.net.Socket.<init>(Socket.java:425)
	at java.net.Socket.<init>(Socket.java:241)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
	... 16 more
Java Result: 1

sendo meu comando de adicionar

public void adiciona(guetereseterprincipal cadastros) throws SQLException{
        String comandosql="INSERT INTO  cadastro (`id` ,`numeroprodutor` ,`produtor` ,`algodoeira` ,"+
"`lote` ,`lotealgodoeira` ,`pesoalgodoeira` ,`pesoliquido` ,`quantidadeembarcada` ,`quantidadesaldo` ,`empresatakeup` ,"+
"`hvi` ,`datatakeup` ,`datasaida`)"+
"VALUES (NULL ,?,?,?,?, ?,?,?,?,?,?,?,?,?);";
   PreparedStatement stmt=conexao.prepareStatement(comandosql);
    stmt.setString(1, cadastros.getNunprodutor());
    stmt.setString(2, cadastros.getProd());
    stmt.setString(3,cadastros.getAlgod());
    stmt.setString(4, cadastros.getLot());
    stmt.setString(5, cadastros.getLotalg());
    stmt.setString(6,cadastros.getPesalg());
    stmt.setString(7, cadastros.getPesliqu());
    stmt.setString(8, cadastros.getQembarc());
    stmt.setString(9,cadastros.getQsal());
    stmt.setString(10, cadastros.getEmprtakeup());
    stmt.setString(11, cadastros.getHv());
    stmt.setString(12,cadastros.getDattakeup());
    stmt.setString(13,cadastros.getDatsaida());
    stmt.execute();
    stmt.close();
   
    
    }

mausexdd 30 de jan. de 2012

xception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: [b]Communications link failure  [/b]
  
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Você abriu sua conexão com o BD antes de tentar isto?

PreparedStatement stmt=conexao.prepareStatement(comandosql);

mausexdd 30 de jan. de 2012

xception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure 
  
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Você abriu sua conexão com o BD antes de tentar isto?

PreparedStatement stmt=conexao.prepareStatement(comandosql);

angelopppp 30 de jan. de 2012

Resolvido com uma pesquisa rapida no guj eu esqueci de por a port do meu servidor na conexão

mausexdd 30 de jan. de 2012

Não se esqueça de colocar resolvido no titulo do POST

Boa Sorte.

angelopppp 30 de jan. de 2012

angelopppp:

Jan 29, 2012 11:23:17 PM gerenciador.add jButton1ActionPerformed
Grave: null
java.sql.SQLException: Column count doesn't match value count at row 1
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)
	at bancodedados.comandoprincipal.adiciona(comandoprincipal.java:42)
	at gerenciador.add.jButton1ActionPerformed(add.java:282)
	at gerenciador.add.access$100(add.java:23)
	at gerenciador.add$2.actionPerformed(add.java:108)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
	at java.awt.Component.processMouseEvent(Component.java:6504)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
	at java.awt.Component.processEvent(Component.java:6269)
	at java.awt.Container.processEvent(Container.java:2229)
	at java.awt.Component.dispatchEventImpl(Component.java:4860)
	at java.awt.Container.dispatchEventImpl(Container.java:2287)
	at java.awt.Component.dispatchEvent(Component.java:4686)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
	at java.awt.Container.dispatchEventImpl(Container.java:2273)
	at java.awt.Window.dispatchEventImpl(Window.java:2713)
	at java.awt.Component.dispatchEvent(Component.java:4686)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
	at java.awt.EventQueue.access$000(EventQueue.java:101)
	at java.awt.EventQueue$3.run(EventQueue.java:666)
	at java.awt.EventQueue$3.run(EventQueue.java:664)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
	at java.awt.EventQueue$4.run(EventQueue.java:680)
	at java.awt.EventQueue$4.run(EventQueue.java:678)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:121)
	at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)
	at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)
	at java.awt.Dialog.show(Dialog.java:1072)
	at java.awt.Component.show(Component.java:1650)
	at java.awt.Component.setVisible(Component.java:1602)
	at java.awt.Window.setVisible(Window.java:1013)
	at java.awt.Dialog.setVisible(Dialog.java:1003)
	at gerenciador.principal.jButton2ActionPerformed(principal.java:142)
	at gerenciador.principal.access$300(principal.java:27)
	at gerenciador.principal$3.actionPerformed(principal.java:76)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
	at java.awt.Component.processMouseEvent(Component.java:6504)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
	at java.awt.Component.processEvent(Component.java:6269)
	at java.awt.Container.processEvent(Container.java:2229)
	at java.awt.Component.dispatchEventImpl(Component.java:4860)
	at java.awt.Container.dispatchEventImpl(Container.java:2287)
	at java.awt.Component.dispatchEvent(Component.java:4686)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
	at java.awt.Container.dispatchEventImpl(Container.java:2273)
	at java.awt.Window.dispatchEventImpl(Window.java:2713)
	at java.awt.Component.dispatchEvent(Component.java:4686)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
	at java.awt.EventQueue.access$000(EventQueue.java:101)
	at java.awt.EventQueue$3.run(EventQueue.java:666)
	at java.awt.EventQueue$3.run(EventQueue.java:664)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
	at java.awt.EventQueue$4.run(EventQueue.java:680)
	at java.awt.EventQueue$4.run(EventQueue.java:678)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Ele da este erro vou postar o codigo dos meus comandos em sql

private Connection conexao;
    public comandoprincipal() throws ClassNotFoundException, SQLException{
    this.conexao= conexao2.getConexao();
    }
    public void adiciona(principalcmd contas) throws SQLException{
    String comandosql="Insert into cadastro(numeroprodutor,produtor,algodoeira,lote,lotealgodoeira,pesoalgodoeira,pesoliquido,quantidadeembarcada,quantidadesaldo,empresatakeup,hvi,datatakeup,datasaida) values (?,?,?,?,?,?,?,?,?,?,?,?,?)";
    PreparedStatement stmt=conexao.prepareStatement(comandosql);
    stmt.setString(1, contas.getNprodutor());
    stmt.setString(2, contas.getProdutor());
    stmt.setString(3, contas.getAlgodoeira());
    stmt.setString(4, contas.getLote());
    stmt.setString(5, contas.getLotealg());
    stmt.setString(6, contas.getPesoalg());
    stmt.setString(7, contas.getPesoliqu());
    stmt.setString(8, contas.getQembarcada());
    stmt.setString(9, contas.getQsaldo() );
    stmt.setString(10, contas.getEmpresatakeup()  );
    stmt.setString(11, contas.getHvi());
    stmt.setString(12, contas.getDatatakeup() );
    stmt.setString(13, contas.getDatasaida() );
    stmt.execute();
    stmt.close();
   
    }
    public List<principalcmd> getLista() throws SQLException{
    String sql="select * from cadastro";
    PreparedStatement stmt=conexao.prepareCall(sql);
    ResultSet rs=stmt.executeQuery();
    List<principalcmd> minhalista=new ArrayList<principalcmd>();
    while(rs.next()){
    principalcmd c1= new principalcmd();
    c1.setId(Long.valueOf(rs.getString("id")));
    c1.setNprodutor(rs.getString("numeroprodutor"));
    c1.setProdutor(rs.getString("produtor"));
    c1.setAlgodoeira(rs.getString("algodoeira"));
    c1.setLote(rs.getString("lote"));
    c1.setLotealg(rs.getString("lotealgodoeira"));
    c1.setPesoalg(rs.getString("numeroprodutor"));
    c1.setPesoliqu(rs.getString("produtor"));
    c1.setQembarcada(rs.getString("algodoeira"));
    c1.setQsaldo(rs.getString("lote"));
    c1.setEmpresatakeup(rs.getString("lotealgodoeira"));
    c1.setHvi(rs.getString("algodoeira"));
    c1.setDatatakeup(rs.getString("lote"));
    c1.setDatasaida(rs.getString("lotealgodoeira"));
    minhalista.add(c1);
    }
    rs.close();
    stmt.close();
    return minhalista;
   
    }
    
    public List<principalcmd> getLista2(String usuario) throws SQLException{
    String sql="select * from cadastro where usuario like ?";
    PreparedStatement stmt=conexao.prepareCall(sql);
    stmt.setString(1, usuario);
    ResultSet rs=stmt.executeQuery();
    List<principalcmd> minhalista=new ArrayList<principalcmd>();
    while(rs.next()){
    principalcmd c1= new principalcmd();
    c1.setId(Long.valueOf(rs.getString("id")));
    c1.setNprodutor(rs.getString("numeroprodutor"));
    c1.setProdutor(rs.getString("produtor"));
    c1.setAlgodoeira(rs.getString("algodoeira"));
    c1.setLote(rs.getString("lote"));
    c1.setLotealg(rs.getString("lotealgodoeira"));
    c1.setPesoalg(rs.getString("numeroprodutor"));
    c1.setPesoliqu(rs.getString("produtor"));
    c1.setQembarcada(rs.getString("algodoeira"));
    c1.setQsaldo(rs.getString("lote"));
    c1.setEmpresatakeup(rs.getString("lotealgodoeira"));
    c1.setHvi(rs.getString("algodoeira"));
    c1.setDatatakeup(rs.getString("lote"));
    c1.setDatasaida(rs.getString("lotealgodoeira"));
    
    minhalista.add(c1);
    }
    rs.close();
    stmt.close();
    return minhalista;
   
    }
    
    public void altera(principalcmd conta) throws SQLException{
    String sql="update cadastro set numeroprodutor=?,produtor=?,algodoeira=?,lote=?,lotealgodoeira=?,pesoalgodoeira=?"
            + "pesoliquido=?,quantidadeembarcada=?,quantidadesaldo=?,empresatakeup=?,hvi=?,datatakeup=?,datasaida=? where id=?";
    PreparedStatement stmt= conexao.prepareStatement(sql);
    stmt.setString(1, conta.getNprodutor());
    stmt.setString(2, conta.getProdutor());
    stmt.setString(3, conta.getAlgodoeira());
    stmt.setString(4, conta.getLote());
    stmt.setString(5, conta.getLotealg());
    stmt.setString(6, conta.getPesoalg());
    stmt.setString(7, conta.getPesoliqu());
    stmt.setString(8, conta.getQembarcada());
    stmt.setString(9, conta.getQsaldo() );
    stmt.setString(10, conta.getEmpresatakeup()  );
    stmt.setString(11, conta.getHvi());
    stmt.setString(12, conta.getDatatakeup() );
    stmt.setString(13, conta.getDatasaida() );
    stmt.setLong(14, conta.getId());
   stmt.execute();
    stmt.close();
  
    }
    
    public void remove(principalcmd conta) throws SQLException{
    String sql="delete  from cadastro where id=?";
    PreparedStatement stmt= conexao.prepareStatement(sql);
    
    stmt.setLong(1, conta.getId());
   
    stmt.execute();
    stmt.close();
    }

E aqui o codigo que está no meu botão de adicionar

principalcmd cmd= new principalcmd();
    cmd.setNprodutor(jTextField1.getText());
      cmd.setProdutor(jTextField2.getText());
      cmd.setAlgodoeira(jTextField3.getText());
      cmd.setLote(jTextField4.getText());
      cmd.setLotealg(jTextField5.getText());
      cmd.setPesoalg(jTextField6.getText());
      cmd.setPesoliqu(jTextField7.getText());
      cmd.setQembarcada(jTextField8.getText());
      cmd.setQsaldo(jTextField9.getText());
      cmd.setEmpresatakeup(jTextField10.getText());
       cmd.setHvi(jTextField11.getText());
      cmd.setDatatakeup(jTextField12.getText());
      cmd.setDatasaida(jTextField13.getText());
comandoprincipal ex = null;
        try {
            ex = new comandoprincipal();
        } catch (ClassNotFoundException ex1) {
            Logger.getLogger(add.class.getName()).log(Level.SEVERE, null, ex1);
        } catch (SQLException ex1) {
            Logger.getLogger(add.class.getName()).log(Level.SEVERE, null, ex1);
        }
        try {
            ex.adiciona(cmd);
        } catch (SQLException ex1) {
            Logger.getLogger(add.class.getName()).log(Level.SEVERE, null, ex1);
        }

Criado 29 de janeiro de 2012

Ultima resposta 30 de jan. de 2012

Respostas 9

Participantes 4

9 Respostas

Topicos relacionados