I want to subtract the data in the item_qty_rep column in table repair from the data in the item_qty_st in table Stock. I got the error (java.lang.ArrayIndexOutOfBoundsException:0).
private void update_stockActionPerformed(java.awt.event.ActionEvent evt) {
try{
String sql = "Insert into Stock (item_name_st, item_qty_st) values (?,?), (?,?), (?,?), (?,?), (?,?), (?,?), (?,?), (?,?), (?,?), (?,?)";
String sql1 = "UPDATE Stock SET item_qty_st = (SELECT item_qty_st FROM Stock EXCEPT SELECT item_qty_rep FROM repair)"; //by this part of the code I try to subtract the data in item_qty_rep (which is a column in a table called repair) from the data in item_qty_st ( which is a column in a table called Stock)
pst = conn.prepareStatement(sql);
pst = conn.prepareStatement(sql1);
pst.setString(1,handbrakesLabel.getText());
pst.setInt(2,Integer.parseInt(handbrakes_qtyAvailable.getText()));
pst.setString(3, acceleratorLabel15.getText());
pst.setInt(4,Integer.parseInt(accelerator_qtyAvailable.getText()));
pst.setString(5,sparkplugsLabel.getText());
pst.setInt(6,Integer.parseInt(sparkplugs_qtyAvailable.getText()));
pst.setString(7,doorlocksLabel.getText());
pst.setInt(8,Integer.parseInt(doorlocks_qtyAvailable.getText()));
pst.setString(9,propshaftLabel.getText());
pst.setInt(10,Integer.parseInt(propshaft_qtyAvailable.getText()));
pst.setString(11,gaugesLabel.getText());
pst.setInt(12,Integer.parseInt(gauges_qtyAvailable.getText()));
pst.setString(13,mirrorsLabel.getText());
pst.setInt(14,Integer.parseInt(mirrors_qtyAvailable.getText()));
pst.setString(15,seatsLabel.getText());
pst.setInt(16,Integer.parseInt(seats_qtyAvailable.getText()));
pst.setString(17,tiresLabel.getText());
pst.setInt(18,Integer.parseInt(tires_qtyAvailable.getText()));
pst.setString(19,rimsLabel.getText());
pst.setInt(20,Integer.parseInt(rims_qtyAvailable.getText()));
pst.execute();
JOptionPane.showMessageDialog(null,"Stock Availability");
}
catch(Exception e){
JOptionPane.showMessageDialog(null,e);
}
// Update_Table3();
}
Aucun commentaire:
Enregistrer un commentaire