Java: How to execute preparedStatement in jdbc with multiple parameters in sql query?

Question

This is what I want to do:

PreparedStatement query2 = 
conn.prepareStatement ("UPDATE report SET Name = ? WHERE Id = ?");

String blah = "Jane";
int id = 1;

query2.setString(1, blah);
query2.setInt(2, id);
query2.executeQuery();

But I'm getting this error:

The statement did not return a result set.

I am new to the whole jdbc world. Where am I going wrong here?

Saj · Accepted Answer · 2015-10-02 00:42:33Z

5

You should use executeUpdate.

"Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement."

answered Oct 2, 2015 at 0:42

Saj

18.8k12 gold badges55 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

Java: How to execute preparedStatement in jdbc with multiple parameters in sql query?

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