bases de donnees javaRésolu

Question

bonjour a tous je debute en java et souhaite supprimer un enregistrement de ma table voici l erreur generee:
Result Set not updatable.This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one table, can not use functions and must select all primary keys from that table. See the JDBC 2.1 API Specification, section 5.6 for more details.This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one table, can not use functions and must select all primary keys from that table. See the JDBC 2.1 API Specification, section 5.6 for more details.

et voici mon code:

 private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
try {Class.forName("com.mysql.jdbc.Driver");
        url="jdbc:mysql://localhost/mabase";
        con = DriverManager.getConnection(url, "root", "stockaj");
        pr con.prepareStatement("SELECT nom AS n, email AS e, prenom AS p, pass AS p1 FROM mabase.identif WHERE (matricule'"+jTextField6.getText()+"')ORDER BY n DESC");
        rec=pr.executeQuery();
        rec.deleteRow();
              
        pr.executeUpdate();
}
 catch(SQLException ex){System.out.println("SQL Error:" + ex.getMessage());}
        catch(ClassNotFoundException cnfe){
        System.out.println(cnfe.getMessage());
        }
    }

Merci de me repondre!!!!

cs_DARKSIDIOUS · Accepted Answer

Salut,

Exécute directement une requête DELETE, ca ira bien plus vite :
con.execute("DELETE FROM mabase.identif WHERE (matricule
='"+jTextField6.getText()+"')");

Et si tu ne veux supprimer que le premier :
con.execute("DELETE FROM mabase.identif WHERE (matricule= '"+jTextField6.getText()+"') limit 1");

______________________________________
DarK Sidious

Bases de donnees java

1 réponse

Votre réponse

Discussions similaires