estou tentando gravar dados que sao inseridos em uma tabela segue o código a seguir
antes gravava só um registro e agora ta dando erro de sintaxe o que posso acrescentar neste código pra gravar mais de um registro e resolver este erro?
botao2.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
JTable tabela = new JTable(modelo);
//int linha = modelo.getRowCount();
//int col = modelo.getColumnCount();
try
{
//int i = modelo.getRowCount();
//int j = modelo.getColumnCount();
Class.forName("org.postgresql.Driver");
Connection con = DriverManager.getConnection ("jdbc:postgresql:TurmaN40","postgres","postgres");
System.out.println("Conexao OK");
Statement st = con.createStatement();
for (int i=0; i < modelo.getRowCount(); i++){
for (int j = 0; j < modelo.getColumnCount(); j++){
//for (int i = 0; i <= modelo.getRowCount();) {
ResultSet rs = st.executeQuery("INSERT into VendaProduto (codigo,descricao,qtde,valor,total) values ('"+
caixa5.getText() + "','" +
caixa6.getText() + "','" +
modelo.getValueAt(i,0)+"','"+
modelo.getValueAt(i,1)+"','"+
modelo.getValueAt(i,2)+"','"+
modelo.getValueAt(i,3)+"','"+
modelo.getValueAt(i,4)+"',"+
caixa7.getText() + "','" +
caixa8.getText() + "','" +
caixa9.getText()+"')'");
}
}
JOptionPane.showMessageDialog(null,"Gravação realizada com sucesso");
st.close();
con.close();
}catch (Exception e1){
e1.printStackTrace();
return;
}}
});
o erro que ocorre é esse
org.postgresql.util.PSQLException: ERRO: erro de sintaxe no fim da entrada
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1591)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1340)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)
at EfetuarVenda$2.actionPerformed(EfetuarVenda.java:199)
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.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(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)