How to get the number of rows affected from a JdbcTemplate?

Question

I use spring JdbcTemplateto execute an SQL query:

JdbcTemplate template = new JdbcTemplate(ds);
template.execute(sqlInsert); //returns void

How can I get the number of rows, how execute()does the method return void?

Answer 1

Call the update method JdbcTemplate. It will give you the number of rows processed as the return value.

Answer 2

You can use JdbcTemplate.update()for this occasion. this will return the number of updated or deleted rows.