Ola,
estou com problemas para fazer insert no postgre. Esse insert utiliza parametro pasados pelo usuario atraves de JTextField.
segue o metodo inserirFuncionario()
public void inserirFuncionario(){
cadastrarFuncionario cf = new cadastrarFuncionario();
conexaoBanco cb = new conexaoBanco();
String cd = cf.jTextcodigoFuncionario.getText();
String nm = cf.jTextnomeFuncionario.getText();
cb.executeUpdate("INSERT INTO empregado (cd_empregado, nm_empregado) values (" + cd + ",'"+nm+"')");
}
}
ja tentei fazer cast de cd para inteiro, por que codigo do funcionario é inteiro, mesmo assim nao deu.
se eu faço o insert sem utilizar os parametros passados pelos JTextField, com valores fixos, o insert funciona.
abaixo segue o erro
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at inserirDados.inserirFuncionario(inserirDados.java:16)
at cadastrarFuncionario$salvar.actionPerformed(cadastrarFuncionario.java:361)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Agradeço a ajuda
vlww