I have a problem with last_insert_rowid()
. It always returns 0.
String query = "SELECT last_insert_rowid() AS LAST FROM UGYFEL";
PreparedStatement pst1 = connection.prepareStatement(query);
ResultSet rs1 = pst1.executeQuery();
JOptionPane.showMessageDialog(null, rs1.getString("LAST"));
pst1.execute();
//JOptionPane.showMessageDialog(null, "Adat elmentve");
pst1.close();
rs1.close();
Aucun commentaire:
Enregistrer un commentaire