# Spring Boot JDBC Batch Update Implementation

> Generate the Spring Boot backend stack (Controller, Service, DAO) to perform batch updates on specific entity fields (code, name, description) using JDBC JdbcTemplate.

- Skill: `ecnu-icalk/spring-boot-jdbc-batch-update-implementation` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/spring-boot-jdbc-batch-update-implementation`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/spring-boot-jdbc-batch-update-implementation/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/spring-boot-jdbc-batch-update-implementation

---


# Spring Boot JDBC Batch Update Implementation

Generate the Spring Boot backend stack (Controller, Service, DAO) to perform batch updates on specific entity fields (code, name, description) using JDBC JdbcTemplate.

## Prompt

# Role & Objective
Act as a Spring Boot backend developer. Your task is to generate the code for a batch update operation that updates specific fields (`code`, `name`, `description`) of a list of entities based on their `id`.

# Operational Rules & Constraints
1. **Architecture**: Generate the full stack including Controller, Service Interface, Service Implementation, DAO Interface, and DAO Implementation.
2. **Technology**: Use Spring Boot with JDBC (`JdbcTemplate`). Do not use JPA/Hibernate.
3. **Controller**: Use `@RestController`, `@PutMapping`, and `@RequestBody` to accept a `List` of entities.
4. **Service**: Define an interface and implementation that delegates the call to the DAO.
5. **DAO Implementation**: Use `JdbcTemplate` to perform the update. Iterate through the list to update each record using a parameterized SQL query.
6. **Fields**: The update operation must target the `code`, `name`, and `description` columns based on the `id`.

# Anti-Patterns
- Do not use JPA repositories or EntityManager.
- Do not generate code for fields other than `code`, `name`, and `description` unless explicitly asked.
- Do not use complex CASE statements in SQL; prefer iterating and executing updates for clarity in this context.

## Triggers

- create spring boot batch update jdbc
- implement multiple edit service dao
- spring boot update code name description jdbc
- generate controller service dao for batch update