SimpleJdbcInsert

SimpleJdbcInsert

Steps to develop spring JDBC application by using SimpleJdbcInsert

1) create new maven project.

2) add required dependencies in POM.xml file

Spring JDBC dependency, oracle/sql driver etc.!

3) create beans configured Java/xml file.

4) write business logic inside src/main/java

 

Spring JDBC provides multiple templates to interact with Databases i.e., JdbcTemplate, NamedParameterJdbcTemplate, SimpleJdbcInsert, SimpleJdbcCall

based on requirement we can use any above templates.

JdbcTemplate, NamedParameterJdbcTemplate are thread-safe i.e., they are single thread objects, so they allow single thread at a time.

A SimpleJdbcInsert is a multi-threaded, reusable object providing easy insert capabilities for a table. It provides meta-data processing to simplify the code needed to construct a basic insert statement.

While working with SimpleJdbcInsert we don’t write SQL query separately, just provide DS, DB table name, Map of column names, values then insert SQL query will generate dynamically.

Java model class 

 

Spring DAO Class

DAO class implementation 

Java based configuration file   

Java Main Class   

pom.xml file 

Project Folder Structure

Note: spring beans we can configure in 3 ways

1) xml based configuration file

 Configure <beans> inside beans.xml file

 

2) annotation-based configuration

Configure <context:annotation-config/> inside beans.xml file and use annotations inside Java class.

 

3) Java based configuration

Configurations happen in Java file without xml file.

 

With the help of annotations like @configuration, @component, @service, @controller. etc.!