Sunday, 10 March 2019

Spring - Inserting data using SimpleJdbcInsert and SqlParameterSource | Spring JDBC tutorial

🚀 Want to Master Spring & Java Development?

Subscribe to Ram N Java for beginner-friendly coding tutorials and practical guides!

Inserting Data with SimpleJdbcInsert and SqlParameterSource

When working with database persistence in Spring applications, SimpleJdbcInsert provides a clean way to insert records without writing repetitive SQL queries. Pairing it with the SqlParameterSource interface makes parameter binding structured, type-safe, and effortless.

1. What is SqlParameterSource?

In Spring JDBC, SqlParameterSource is an interface designed to provide named parameter values for SQL operations. Instead of manually putting entries into a standard Java Map, it provides structured mechanisms to supply parameter values:

MapSqlParameterSource: A flexible implementation that allows chaining parameter name-value pairs fluently via .addValue().
BeanPropertySqlParameterSource: Directly binds properties from a Java Bean or POJO to database column names using reflection.
Type Safety: Provides better support for explicit SQL type mapping when inserting custom or nullable types.

2. Using MapSqlParameterSource with SimpleJdbcInsert

MapSqlParameterSource is ideal when inserting dynamic data or when your data fields do not directly map to a single entity object:

Fluently Add Values: Use new MapSqlParameterSource().addValue("columnName", value) to map database fields.
Direct Execution: Pass the parameter source instance directly into simpleJdbcInsert.execute(parameters).
Cleaner Syntax: Avoids manual hash map instantiations and repetitive put() calls.

3. Simplifying POJO Inserts with BeanPropertySqlParameterSource

If you already have a domain object (such as an Employee or User bean):

Wrap the bean with new BeanPropertySqlParameterSource(myBean).
Spring automatically extracts getter properties and aligns them with matching table column names.
Minimizes boilerplate code and makes domain-driven persistence seamless.

4. Key Advantages

Combining SimpleJdbcInsert with SqlParameterSource gives you:

Zero Boilerplate SQL: No need to craft explicit INSERT INTO statements.
Less Human Error: Reduces typo risks associated with positional parameter placeholders (?).
Enhanced Maintainability: Code is cleaner, concise, and easier to test across enterprise data layers.

📺 Explore More Spring JDBC Tutorials

Continue expanding your Java and Spring knowledge with these related tutorials from our channel: