title: Update column database using java netbeans
body: <p>I am new in programming and i need to update <code>prix_cdf</code> which is equals to <code>prix_usd * rate</code>. I am able to update the <code>rate</code> column but i cannot update the <code>prix_cdf</code> column.</p>
  <p>Can anyone help me please? Here is my code and my database table:</p>
  <pre class="lang-java prettyprint-override"><code>private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                         
         
      String rate = txtrate.getText();
              
      ResultSet rs=Select.getData(&quot;select * from menu&quot;);
              
      String Query = null;
           
      Query=&quot;update menu set rate=&quot;+rate+&quot;&quot;;
      InsertUpdateDelete.setData(Query, &quot;&quot;);
              
      JOptionPane.showMessageDialog(this, &quot;Modifier avec succées!!!&quot;);
      setVisible(false);
      new addFoods().setVisible(true);
  }
  </code></pre>
  <p>Here is my database table - or look at
  <img src="https://i.stack.imgur.com/O54zJ.png" alt="screenshot" /></p>
  <p><img src="https://i.stack.imgur.com/EWlsk.png" alt="Screenshot" /></p>