Java Spring: Working with Data in Spring from Skillsoft

Online, Self-Paced

The Spring Framework is an open source framework and inversion of controller container for the Java platform. The Spring Framework is one of the most popular application development frameworks for creating enterprise Java applications. This course covers using databases in a Spring application. In this course, you will learn the basics of database access from within a Spring application, including how to create, retrieve, update, and delete database records, as well as how to deal with database exceptions.

Learning Objectives

Data Access Using Jdbc

start the course
recognize the various steps in configuring database access in a Spring application
set up a Jdbc driver class to help connect to a MySQL database
declare a datasource bean that can be used to connect to a running MySQL server
declare a datasource bean that gets its properties set from a properties file
declare a datasource bean that can provide a pool of database connections for an application to work with
create a Data Access Object class that will be used to perform database operations
recognize what the JdbcTemplate class is and some of the database access features it provides
use a Data Access Object to retrieve records from a database

Basic Database Operations Using Spring

recognize how to use Spring to support basic database operations
use named parameters when creating SQL queries
retrieve a record from the database converted to a domain object
use the update method of the JdbcTemplate class to insert records into a database
construct SQL queries directly from the properties of beans using BeanPropertySQLParameterSource
use the update method of the JdbcTemplate class to update records in a database
use the update method of the JdbcTemplate class to remove records from a database

Exceptions, Batch Updates, and Transactions

describe database exception handling in Spring applications
handle basic database exceptions in a Spring application
perform batch updates on a database from a Spring application
perform database transactions from a Spring application

SimpleJdbcClasses and Alternative Configurations

describe the SimpleJdbc classes provided by Spring for specific database operations
insert records into a MySQL table using the SimpleJdbcInsert class
call a stored procedure on a database using the SimpleJdbcCall class
use the queryForObject method to specify types for data being returned from a database
declare a Data Access Object in an XML configuration

Practice: Working with Data In Spring