JdbcTemplate is the central class in the JDBC core package. It takes care of creating and closing the database connections. It executes the sql queries, updates and store procedures etc. It handles JDBC exceptions and translating them to the generic message.

Commonly user methods of JdbcTemplate class:

public int update(String query): Issue a single SQL update operation (such as an insert, update or delete statement).

public int update(String query,Object… args): Issue a single SQL update operation (such as an insert, update or delete statement) via a prepared statement, binding the given arguments.

public void execute(String query): Issue a single SQL execute, typically a DDL statement.