🍃🎓 SPRING CERTIFICATION QUESTION: What is the Template design 📏📐 pattern and what is the JDBC template?

Answer:

𝐓𝐞𝐦𝐩𝐥𝐚𝐭𝐞 design pattern, commonly known as 𝐭𝐞𝐦𝐩𝐥𝐚𝐭𝐞 𝐦𝐞𝐭𝐡𝐨𝐝 defines series of steps 🪜 which are executed in a particular order.

This order cannot be changed ❌🔄️, but some of the steps can be altered or are required to be implemented by a subclass.

𝐽𝑑𝑏𝑐𝑇𝑒𝑚𝑝𝑙𝑎𝑡𝑒 is a class that implements template method design pattern and performs some boilerplate JDBC operations 🧮.

Thus the user is only required to define SQL statements and result set custom mappings 🔗.

Operations that are performed by the Jdbc template:

- Open 📭 the connection

1. Prepare, and execute ⚡ statements
2. Iterate ▶️ through the result set
3. Exception 🪲 processing
4. Transaction handling
5. Close 📴 connection, statement, the result set

Operations that should be performed by the Jdbc template client:

1. Define connection 🔌 parameters
2. Specify SQL statement and its parameters
3. Specify mappings 🔗 for each result set iteration

Examples of mentioned terms:

𝑓𝑖𝑛𝑑𝐵𝑦𝐶𝑢𝑠𝑡𝑜𝑚𝑒𝑟𝐼𝑑 - demonstrates a basic example of a template method design pattern.👇👇👇