and error handling JdbcTemplate Examples of JdbcTemplate class usage Querying (SELECT) Updating (INSERT/UPDATE/DELETE) with JdbcTemplate Other JdbcTemplate operations JdbcTemplate best practices Na DataSourceTransactionManager NativeJdbcExtractor JDBC batch operations Basic batch operations with the JdbcTemplate Batch operations with a List of objects Batch operations with multiple batches Simplifying JDBC ApplicationContext, for performing explicit bean lookups or testing the state of the context as a whole. A JdbcTemplate, for executing SQL statements to query the database. Such queries can be used to confirm database

and error handling JdbcTemplate Examples of JdbcTemplate class usage Querying (SELECT) Updating (INSERT/UPDATE/DELETE) with jdbcTemplate Other jdbcTemplate operations JdbcTemplate best practices Na DataSourceTransactionManager NativeJdbcExtractor JDBC batch operations Basic batch operations with the JdbcTemplate Batch operations with a List of objects Batch operations with multiple batches Simplifying JDBC ApplicationContext, for performing explicit bean lookups or testing the state of the context as a whole. A JdbcTemplate, for executing SQL statements to query the database. Such queries can be used to confirm database

Configure a DataSource Embedded Database Support Connection to a production database Using JdbcTemplate JPA and “Spring Data” Entity Classes Spring Data JPA Repositories Creating and dropping JPA databases Framework provides extensive support for working with SQL databases. From direct JDBC access using JdbcTemplate to complete “object relational mapping” technologies such as Hibernate. Spring Data provides an datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. Using JdbcTemplate Spring’s JdbcTemplate and NamedParameterJdbcTemplate classes are auto- configured and you can @Autowire them

Configure a DataSource Embedded Database Support Connection to a production database Using JdbcTemplate JPA and “Spring Data” Entity Classes Spring Data JPA Repositories Creating and dropping JPA databases Framework provides extensive support for working with SQL databases. From direct JDBC access using JdbcTemplate to complete “object relational mapping” technologies such as Hibernate. Spring Data provides an datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. Using JdbcTemplate Spring’s JdbcTemplate and NamedParameterJdbcTemplate classes are auto- configured and you can @Autowire them

Configure a DataSource Embedded Database Support Connection to a production database Using JdbcTemplate JPA and “Spring Data” Entity Classes Spring Data JPA Repositories Creating and dropping JPA databases Framework provides extensive support for working with SQL databases. From direct JDBC access using JdbcTemplate to complete “object relational mapping” technologies such as Hibernate. Spring Data provides an datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. Using JdbcTemplate Spring’s JdbcTemplate and NamedParameterJdbcTemplate classes are auto- configured and you can @Autowire them

Configure a DataSource Embedded Database Support Connection to a production database Using JdbcTemplate JPA and “Spring Data” Entity Classes Spring Data JPA Repositories Creating and dropping JPA databases Framework provides extensive support for working with SQL databases. From direct JDBC access using JdbcTemplate to complete “object relational mapping” technologies such as Hibernate. Spring Data provides an datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. Using JdbcTemplate Spring’s JdbcTemplate and NamedParameterJdbcTemplate classes are auto- configured and you can @Autowire them

Configure a DataSource Embedded Database Support Connection to a production database Using JdbcTemplate JPA and “Spring Data” Entity Classes Spring Data JPA Repositories Creating and dropping JPA databases Framework provides extensive support for working with SQL databases. From direct JDBC access using JdbcTemplate to complete “object relational mapping” technologies such as Hibernate. Spring Data provides an datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. Using JdbcTemplate Spring’s JdbcTemplate and NamedParameterJdbcTemplate classes are auto- configured and you can @Autowire them

Configure a DataSource Embedded Database Support Connection to a production database Using JdbcTemplate JPA and ‘Spring Data’ Entity Classes Spring Data JPA Repositories Creating and dropping JPA databases Framework provides extensive support for working with SQL databases. From direct JDBC access using JdbcTemplate to complete ‘object relational mapping’ technologies such as Hibernate. Spring Data provides an datasource.driverClassName=com.mysql.jdbc.Driver then that class has to be loadable. Using JdbcTemplate Spring’s JdbcTemplate and NamedParameterJdbcTemplate classes are auto- configured and you can @Autowire them

Embedded Database Support Connection to a production database Connection to a JNDI DataSource Using JdbcTemplate JPA and ‘Spring Data’ Entity Classes Spring Data JPA Repositories Creating and dropping JPA databases Framework provides extensive support for working with SQL databases. From direct JDBC access using JdbcTemplate to complete ‘object relational mapping’ technologies such as Hibernate. Spring Data provides an defined DataSource: spring.datasource.jndi-name=java:jboss/datasources/customers Using JdbcTemplate Spring’s JdbcTemplate and NamedParameterJdbcTemplate classes are auto- configured and you can @Autowire them

Embedded Database Support Connection to a production database Connection to a JNDI DataSource Using JdbcTemplate JPA and ‘Spring Data’ Entity Classes Spring Data JPA Repositories Creating and dropping JPA Framework provides extensive support for working with SQL databases. From direct JDBC access using JdbcTemplate to complete ‘object relational mapping’ technologies such as Hibernate. Spring Data provides an defined DataSource: spring.datasource.jndi-name=java:jboss/datasources/customers Using JdbcTemplate Spring’s JdbcTemplate and NamedParameterJdbcTemplate classes are auto- configured and you can @Autowire them