Olá galera… tow com um probleminha aki pra inderir na minha tabela no banco !
na verdade comecei a pouko tempo com java…
olha, minha tabela tem 13 intens e assim q tow fazendo a inserção:
public void cadastrarProfissional(Profissional p) {
String sql = “insert into profissional values (?,?)”;
try {
PreparedStatement ps =
con.prepareStatement(sql);
ps.setString(1, p.getNome());
ps.setInt(2, p.getIdade());
ps.setString(3, p.getSexo());
ps.setString(4, p.getProfissao());
ps.setString(5, p.getRg());
ps.setString(6, p.getCpf());
ps.setString(7, p.getEndereco());
ps.setString(8, p.getComplemento());
ps.setInt(9, p.getDdd());
ps.setString(10, p.getTelefone());
ps.setString(11, p.getAtivo());
ps.setString(12, p.getLocadopara());
ps.setString(13, p.getObservacoes());
ps.execute();
} catch (SQLException e) {
e.printStackTrace();
}
}
qnd eu clico no botão cadastrar eu pego os dados assim:
jButtonCadastrarP.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
// pegar os dados
if (!jTextFieldNomeP.getText().equals("")) {
Profissional p = new Profissional();
p.setNome(jTextFieldNomeP.getText());
p.setIdade(Integer.parseInt(jTextFieldIdadeP
.getText()));
p.setSexo((String) jComboBoxSexoP
.getSelectedItem());
p.setProfissao((String) jComboBoxProfissaoP
.getSelectedItem());
p.setRg(jTextFieldRGP.getText());
p.setCpf(jTextFieldCpfP.getText());
p.setEndereco(jTextFieldEnderecoP.getText());
p.setComplemento(jTextFieldComplementoP
.getText());
p.setDdd(Integer.parseInt(jTextFieldDddP
.getText()));
p.setTelefone(jTextFieldTelefone.getText());
p.setAtivo((String) jComboBoxAtivoP
.getSelectedItem());
p.setLocadopara(jTextFieldCadastraLocadoparaP
.getText());
p.setObservacoes(jTextAreaObsP.getText());
bd.ProfissionalJDBC sup = new ProfissionalJDBC();
sup.cadastrarProfissional(p);
}
}
o erro q tá dando eh o seguinte:
org.postgresql.util.PSQLException: O índice da coluna está fora do intervalo: 3, número de colunas: 2.
at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:52)
at org.postgresql.core.v3.SimpleParameterList.setStringParameter(SimpleParameterList.java:117)
at org.postgresql.jdbc2.AbstractJdbc2Statement.bindString(AbstractJdbc2Statement.java:2118)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java:1241)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java:1227)
at bd.ProfissionalJDBC.cadastrarProfissional(ProfissionalJDBC.java:286)
at telas.MenuPrincipal$13.actionPerformed(MenuPrincipal.java:1194)
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)
por favor, vcs tem q me ajudar…
tenho q entregar este projeto no curso na segunda-feira !