java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0) problems

Question

this is my button

 btnSil.addActionListener(new ActionListener() {

        public void actionPerformed(ActionEvent arg0) {

            String sorgu="DELETE FROM muhasebe Where MuhasebeAdi='?', MuhasebeSoyadi='?', kul_adi='?' ,sifre='?'  ";
            DBConnection.KullaniciSil(muhasebe_ad.getText(), muhasebe_soyad.getText(), muhasebe_kul_adi.getText(), muhasebe_sifre.getText(), sorgu);
        }
    }

and this is my connection and i think problems THERE but i dont find

public static void KullaniciSil(String ad, String soyad, String kadi, String sifre,String sorgu1){

connection();

try
{
    Connection connect = DriverManager.getConnection(host, username , pass);
    PreparedStatement statement = (PreparedStatement) connect.prepareStatement(sorgu1);

    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();

}

}

Eran · Accepted Answer · 2015-05-25 15:09:32Z

1

You should unquote all the place holders (?) and add conditions to your WHERE clause :

String sorgu="DELETE FROM muhasebe Where MuhasebeAdi=? AND MuhasebeSoyadi=? AND kul_adi=?  AND sifre=?";

answered May 25, 2015 at 15:09

Eran

395k57 gold badges726 silver badges793 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0) problems

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related