java.sql.Statement#executeUpdate() vs execute()?

Question

If I don't care about the number of rows updated, is there any advantage gained by using java.sql.Statement#executeUpdate() instead of java.sql.Statement#execute() for an UPDATE statement?

PSR · Accepted Answer · 2013-06-03 05:53:15Z

3

The return value differs. ExecuteUpdate() returns the number of rows updated, which can be useful when running an update statement. but you do not needed that one.So you can use any of them .Nothing you will get advantage.

answered Jun 3, 2013 at 5:53

PSR

40.4k43 gold badges115 silver badges154 bronze badges

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

Comments

MaVRoSCy · Accepted Answer · 2013-06-03 05:50:54Z

1

My opinion is that there is no difference.

You will not find in any document about the Statement class that states that there is a performance difference between the two commands. Also as discussed in OTN people agree that there is no difference between the two.

answered Jun 3, 2013 at 5:50

MaVRoSCy

17.9k15 gold badges87 silver badges129 bronze badges

Collectives™ on Stack Overflow

java.sql.Statement#executeUpdate() vs execute()?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related