Skip to main content
Hint

This article is generated by AI translation.

JdbcTemplate

JdbcTemplate is a database operation wrapper designed by dbVisitor specifically for SQL string scenarios. It is stateless and can be created and destroyed at any time.

Creation and Usage
JdbcTemplate jdbc = new JdbcTemplate(dataSource);

// Query
List<Map<String, Object>> rows = jdbc.queryForList("select * from users where age > ?", 18);

// Update
int affected = jdbc.executeUpdate("update users set name = ? where id = ?", "alice", 1);
Hint

How you obtain JdbcTemplate depends on your project architecture. See Framework Integration for details.

Principle​

JdbcTemplate is based on the Template pattern. Inside the template method, it automatically handles acquiring connections, releasing connections, and catching exceptions. Higher-level code only needs to focus on using the Connection.

Core Template Method
T result = jdbc.execute((ConnectionCallback<T>) con -> {
   // Use Connection directly
});

User Guide​

  • Query, execute SELECT or other statements with return results.
  • Update, execute INSERT, UPDATE, DELETE, or DDL.
  • Batch, execute batch operations.
  • Stored Procedure, call stored procedures/functions.
  • Rules, use rules to give SQL dynamic capabilities.
  • Multi-value, execute SQL with multiple statements and obtain all results.
  • Script, execute SQL script files or multiple statements.
  • Using Template, operate the database directly via template methods.
  • Advanced Features, JdbcTemplate-specific properties and features.
  • Arguments, learn about different ways to pass arguments.
  • Receiving Results, learn about different ways to receive results.