unable to execute "delete" query in java

Question

in a swing button I set a action that it execute delete query and execute another class. here's my code:

JButton btnScanMyPc = new JButton("SCAN MY PC");
    btnScanMyPc.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent arg0) {

            try{
                String q="DELETE FROM `search` WHERE 1=1 ";
                PreparedStatement st=connection.prepareStatement(q);
                ResultSet rs=st.executeQuery();
                ReadDir rd = new ReadDir();
                ReadDir.main(null);
            }
            catch(Exception e)
            {JOptionPane.showMessageDialog(null, e);}


        }

when i execute this query in database it works perfectly. but in java it shows some error like:

java.sql.SQLException: Can not issue data manipulation Statement with executeQuery().

@RakibAlHasan The error message is extremely clear, if you would just read it. It clearly explains what you are doing incorrectly. — Kon
– Kon, Commented May 1, 2015 at 3:34
sorry sir i did not understand what you said first. but now its clear. and sir i am learning so its not so much easy for me to understand . — Rakibul Hasan
– Rakibul Hasan, Commented May 1, 2015 at 3:40

Akash Thakare · Accepted Answer · 2015-05-01 03:22:33Z

4

You have to use executeUpdate() instead of executeQuery() for data manipulation like Insert,Update or Delete.

answered May 1, 2015 at 3:22

Akash Thakare

23k11 gold badges64 silver badges89 bronze badges

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

2 Comments

Rakibul Hasan Over a year ago

sir i tried but its not working.. error: type mismatch cannot convert from int to ResultSet.

Akash Thakare Over a year ago

Yes as this method does not return resultset.You will get the number of rows affected by your query as a result.So store result of executeUpdate in int variable.Please go to the executeUpdate link for more detail.

user4815100 · Accepted Answer · 2015-05-01 03:37:33Z

1

try this one

 "DELETE FROM search WHERE 1=1 "

 st.executeUpdate(q);

answered May 1, 2015 at 3:37

user4815100

Collectives™ on Stack Overflow

unable to execute "delete" query in java

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related