title: Data truncation: Truncated incorrect DOUBLE value
body: <pre><code>// my button
  public void actionPerformed(ActionEvent arg0) {               
    String sorgu="UPDATE calisan SET CalisanAdi=? AND CalisanSoyadi=? AND kul_adi=? AND sifre=? WHERE idcalisan=? ";
    DBConnection.KullaniciGuncelle(calisan_ad.getText(), calisan_soyad.getText(),calisan_kul_adi.getText(), calisan_sifre.getText(), sorgu);
  }
  </code></pre>
  
  <p>What's wrong? If I add column this show problems</p>
  
  <blockquote>
    <p>parameter index out of range (1 > number of parameters, which is 0)</p>
  </blockquote>
  
  <pre><code>public static void KullaniciGuncelle(String ad, String soyad, String kadi, String sifre,String sorgu){
  
  connection();
  
  try
  {
      Connection connect = DriverManager.getConnection(host, username , pass);
      PreparedStatement statement = (PreparedStatement) connect.prepareStatement(sorgu);
  
      statement.setString(1, ad);
      statement.setString(2, soyad);
      statement.setString(3, kadi);
      statement.setString(4, sifre);
  
      statement.executeUpdate();
      statement.close();
      connect.close();   
  }
  catch(SQLException e)
  {
      e.printStackTrace();  
  }
  </code></pre>