title: problems with the transfer of patient records for data at the table archives
body: <p>please I have a little problem with the transfer of patient records for data at the table
    the code using it  :</p>
  
  <pre><code> try {
          //Statement mystt = (Statement) conn.createStatement();
          int row= affichagetable_pt.getSelectedRow();
          String Table_click=( affichagetable_pt.getModel().getValueAt(row, 0).toString());
          String query="insert into archives_pt (numfiche_pt,datefiche_pt,nom_pt,prenom_pt,datenaissance_pt,gsm_pt,cin_pt,profession_pt,sexe_pt,adresse_pt,nomsons_pt,cinsons_pt) select numfiche_pt,datefiche_pt,nom_pt,prenom_pt,datenaissance_pt,gsm_pt,cin_pt,profession_pt,sexe_pt,adresse_pt,nomsons_pt,cinsons_pt from patient where  patient.numfiche_pt='"+Table_click+"'";
          pst=conn.prepareStatement(query);
          rs=pst.executeQuery();
           JOptionPane.showMessageDialog(null,"Effacement OK");
          pst.close();
      } catch (Exception e2) {
          // TODO: handle exception
           JOptionPane.showMessageDialog(null,e2);
  
      }
  </code></pre>
  
  <p>the error : </p>
  
  <p><a href="https://i.stack.imgur.com/ZsQ0x.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZsQ0x.png" alt="enter image description here"></a></p>
  
  <p>e2 message is "the statement did not return the result set"</p>