Course details

Java Spring: Working with Data in Spring

Java Spring: Working with Data in Spring

Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

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


Expected Duration (hours)

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:

    Expertise Level