Complete Spring 7 & Spring Boot 4 course from beginner to Advance using first thought principle.
Curated by: Coder Army (29 videos)
In this Spring JDBC tutorial, we will understand how Spring simplifies database operations while still giving us complete control over SQL. We begin by examining the problems with raw JDBC, such as manually creating connections, preparing statements, closing resources, and handling SQLException. We then replace this repetitive workflow with Spring JDBC and JdbcTemplate. You will learn: Problems with raw JDBC How Spring JDBC works internally Template Method idea behind JdbcTemplate DriverManager vs DataSource What connection pooling is and why it is required How HikariCP manages database connections Spring Boot DataSource auto-configuration Configuring MySQL in application.properties Using JdbcTemplate Insert, read, update, and delete operations Using RowMapper to convert database rows into Java objects Difference between query() and queryForObject() Handling missing records with Optional Using BeanPropertyRowMapper Spring JDBC exception translation SQLException vs DataAccessException Common exceptions such as DuplicateKeyException, BadSqlGrammarException, and EmptyResultDataAccessException By the end of this video, you will be able to build a complete CRUD application using Spring Boot, Spring JDBC, JdbcTemplate, MySQL, and HikariCP. This tutorial is useful for anyone learning Spring Boot database connectivity before moving to Hibernate, JPA, and Spring Data JPA. JAVA Beginner to Advance Series : https://youtube.com/playlist?list=PLQEaRBV9gAFsR15tNo2QLF9d2qc-c018p&si=lNuF5lyt4nKz9Up7 Join System Design WhatsApp Group: https://www.whatsapp.com/channel/0029VbBF1XKF1YlMyYuPM23s Code and Notes: Github : https://github.com/adityatandon15/Spring-Framework-Full-Course We have paid courses on DSA, Web Development , Blockchain, System Design & GenAI. Join Courses: https://strikes.in/ Coder Army Website: https://coderarmy.in/#home Coder Army App: https://play.google.com/store/apps/details?id=com.rohit.negi Connect with Aditya Tandon Instagram : https://www.instagram.com/adityatandon2 LinkedIn : https://www.linkedin.com/in/adityatandon2 Twitter : https://x.com/adityatandon02 Timestamps: