Notice: Constant WP_MEMORY_LIMIT already defined in /home/javawith/public_html/codesjava.com/wp-config.php on line 107

Notice: Constant WP_MAX_MEMORY_LIMIT already defined in /home/javawith/public_html/codesjava.com/wp-config.php on line 108
Spring jdbc tutorial - CodesJava

CodesJava

Easy learning with example program codes

spring jdbc tutorial


Notice: Undefined variable: footnotelist in /home/javawith/public_html/codesjava.com/wp-content/plugins/latex2html/inc/core.php on line 475

Problems with JDBC API:

We have to write unnecessary code for creating database connections, SQL statement executions, exception handling, transaction handling and closing database connections etc.

Spring JDBC Framework:

In case of Spring JDBC Framework it takes care of all things like creating database connections, executing SQL statements, handling exceptions, handling transactions and closing database connections etc.

Spring JDBC Approaches:

  • JdbcTemplate
  • NamedParameterJdbcTemplate
  • SimpleJdbcTemplate
  • SimpleJdbcInsert
  • SimpleJdbcCall

Note: The most popular approach uses JdbcTemplate class.

JdbcTemplate Class:

JdbcTemplate is the central class in the JDBC core package. It takes care of creating and closing the database connections. It executes the sql queries, updates and store procedures etc. It handles JDBC exceptions and translating them to the generic message.

Commonly user methods of JdbcTemplate class:

  • public int update(String query): Issue a single SQL update operation (such as an insert, update or delete statement).
  • public int update(String query,Object… args): Issue a single SQL update operation (such as an insert, update or delete statement) via a prepared statement, binding the given arguments.
  • public void execute(String query): Issue a single SQL execute, typically a DDL statement.
  • public T execute(String sql, PreparedStatementCallback action): Execute a JDBC data access operation, implemented as callback action working on a JDBC PreparedStatement.
  • public T query(String sql, ResultSetExtractor rse): Execute a query given static SQL, reading the ResultSet with a ResultSetExtractor.
  • public List query(String sql, RowMapper rse): Execute a query given static SQL, mapping each row to a Java object via a RowMapper.

Note: JdbcTemplate class objects are threadsafe.

We are using Spring boot here.

Example

package com.codesjava.SpringDB;
 
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.ApplicationContext;
 
@SpringBootApplication
public class SpringDbApplication {
    private static ApplicationContext applicationContext;
    public static void main( String[] args ) {
    	applicationContext = SpringApplication.run(SpringDbApplication.class, args);  
    	performDBOperation();
    }
 
    private static void performDBOperation(){
    	JDBCController jdbcController = (JDBCController) applicationContext.getBean("jDBCController");
    	jdbcController.insertData();
    }
}
package com.codesjava.SpringDB;
 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
 
@Repository("jDBCController")
public class JDBCController {
    @Autowired  
    JdbcTemplate jdbc;  
 
    public void insertData(){  
        jdbc.execute("insert into users(seq,user_name, password)values(12,'hkumar', 'h123')");  
        System.out.println("Data inserted Successfully");  
    }  
}
spring.datasource.url=jdbc:mysql://localhost:3306/test_schema?useSSL=false
spring.datasource.username=root
spring.datasource.password=********
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

Output

Data inserted Successfully

Related topics

Please follow and like us:
error

Spring Tutorial








Copyright © 2019 CodesJava DMCA.com Protection Status