Tagged articles
JdbcTemplate
11 articles · Page 1 of 1
This tutorial demonstrates Spring's JdbcTemplate and NamedParameterJdbcTemplate for database CRUD operations, covering Maven setup, Druid connection pooling, configuration classes, DAO implementations with both positional and named parameters, service layer, and JUnit tests, recommending NamedParameterJdbcTemplate for production use.
BeanPropertyRowMapperDruidJDBC
0 likes · 21 min read

This article introduces six Spring Boot approaches for JDBC data access—including JdbcTemplate, NamedParameterJdbcTemplate, JdbcClient, SimpleJdbcInsert/Call, Spring Data JDBC repositories, and JdbcAggregateTemplate—each illustrated with code samples and usage notes for Spring Boot 3.5.0.
JDBCJdbcAggregateTemplateJdbcClient
0 likes · 9 min read

This tutorial demonstrates how to configure Spring 6 with JdbcTemplate, create a MySQL database and table, define entity and datasource beans, and perform CRUD operations—including batch updates and callback functions—while also showing integration with the Druid connection pool.
BackendCRUDJava
0 likes · 26 min read

This article explains Spring's transaction core, showing how TransactionInterceptor and TransactionAspectSupport use AOP to bind a Connection to ThreadLocal, walks through key code snippets for creating, committing, and rolling back transactions, and demonstrates a JUC‑based solution for maintaining transaction consistency across multiple threads.
JavaJdbcTemplateMultithreading
0 likes · 9 min read

This tutorial walks through adding and initializing multiple Spring Boot data sources for JdbcTemplate, Spring Data JPA, and MyBatis, including property setup, configuration classes, bean definitions, testing code, and repository links for complete examples.
JdbcTemplateMulti Data SourceMyBatis
0 likes · 7 min read

Learn step‑by‑step how to set up multiple MySQL data sources in Spring Boot 2.2.2, configure corresponding JdbcTemplate beans, define entity and service layers, and run unit tests, with full Maven dependencies, property settings, Java configuration, and SQL DDL examples.
JavaJdbcTemplateMultiple DataSource
0 likes · 9 min read

Learn how to replace verbose JDBC code with Spring’s JdbcTemplate by first understanding JDBC basics, then adding the necessary Maven dependencies, configuring a connection pool, defining entity and repository classes, and writing unit tests, all illustrated with complete Java examples.
JDBCJavaJdbcTemplate
0 likes · 10 min read

This tutorial explains how to integrate JDBC into a Spring Boot project, covering Maven dependencies, MySQL driver setup, application.yml datasource configuration, Spring Boot's auto‑configuration mechanism, JdbcTemplate usage, Swagger documentation, CRUD endpoint implementation, and solutions to typical connection errors.
Auto-configurationJDBCJdbcTemplate
0 likes · 12 min read

This guide explains how to integrate JDBC into a Spring Boot project, covering Maven dependencies, datasource configuration, Spring Boot's auto‑configuration mechanism, JdbcTemplate usage, Swagger setup for API testing, CRUD examples on a MySQL department table, and solutions to typical connection errors.
JDBCJdbcTemplateMySQL
0 likes · 13 min read

This guide walks you through configuring data sources in Spring Boot, adding JDBC dependencies, using embedded databases, connecting to MySQL, defining entities and repositories with JdbcTemplate, and writing comprehensive unit tests to perform CRUD operations, illustrating a complete backend data access workflow.
BackendCRUDJava
0 likes · 9 min read

This article explains how to implement database read‑write splitting in a Spring Boot application using ShardingSphere, covering the creation of master‑slave MySQL databases, Maven dependency setup, multi‑data‑source configuration, load‑balance algorithms, and handling replication lag with HintManager.
DatabaseReplicationJdbcTemplateMySQL
0 likes · 8 min read
