Cyber Data team is working on a project which uses Spring JDBC with Spring Boot. Help the team to identify, which of the below operations are supported and will be automatically handled by Spring Boot JDBC$?$

Setting up loop for iterating over results.

$$ Specifying SQL statements, declaring parameters and providing values.

Defining connection parameters like driver class name, database URL, username and password.

Opening connection, Preparing and executing statements, Processing exceptions, Handling Transactions, Closing connections, statement and result set.