dimanche 4 janvier 2015

Java sqlite last_insert_rowid() return 0

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