I'm trying to update records in my sqlite database when the button is pressed. I've tried everything and I'm at wits end, please help Here's the button code c is a Connection variable, index is an integer variable that represents user's ID in the db
            @Override
            public void actionPerformed(ActionEvent e) {
                przelewKw = Double.parseDouble(kwotaF.getText());
                nazwaDoP = listaDoP.getItemAt(listaDoP.getSelectedIndex()).toString();
                try {
                    for (int i = 0; i < nazwiska.length; i++) {
                        if (nazwaDoP.contains(idKonta[i]) && nazwaDoP.contains(nazwiska[i])) {
                            if (stanK[index-1] >= przelewKw) {
                                double roznica = stanK[index-1] - przelewKw;
                                try {
                                    String url = "jdbc:sqlite:D:\\SQLiteDB\\Bank.db";
                                    c = DriverManager.getConnection(url);
                                    c.setAutoCommit(false);
                                    PreparedStatement pstmt = c.prepareStatement("update Konta set StanKonta='"+ roznica +"' where IDKonta=' " + index +"'");
                                    pstmt.executeUpdate();
                                    System.out.println(stanK[index-1]);
                                }
                                catch (Exception exc) {
                                    System.out.println(exc);
                                }
                                finally {
                                    try {
                                        if (c != null) {
                                            c.close();
                                        }
                                    }
                                    catch (Exception ex) {
                                        System.out.println(ex);
                                    }
                                }
                            }
                            else {
                                JOptionPane.showMessageDialog(framePrzelew, "Zbyt mało środków na koncie", "Uwaga", JOptionPane.WARNING_MESSAGE);
                            }
                        }
                    }
                }
                catch (Exception ex) {
                }
            }
        });```
 
    