Java Spring: Working with Data in Spring Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description
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.
Target Audience
Java developers seeking to learn the basics of integrating database access into their Spring applications
Prerequisites
None
Expected Duration (hours)
3.2
Lesson Objectives Java Spring: Working with Data in Spring
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
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
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
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
use a Spring application to access and modify data in a database
Course Number: jl_spng_a04_it_enus
Expertise Level
Intermediate