JDBC Template and Spring Boot Exam Notes
Access Operations with JDBC Template and Spring
1. JDBC
JDBC (Java Database Connectivity) is a Java API used to connect Java applications with databases.
Problems with Traditional JDBC:
- Too much boilerplate code
- Manual exception handling
- Connection management complexity
2. Spring JDBC
Spring JDBC simplifies database programming using JdbcTemplate.
Advantages:
- Less code
- Automatic exception handling
- Better resource management
- Faster development
3. JdbcTemplate
JdbcTemplate is a Spring class that simplifies JDBC operations.
CRUD Operations:
- Create
- Read
- Update
- Delete
Insert Example:
String sql = "insert into student values(?,?,?)";
[Link](sql, 1, "Rahul", 85);
Read Example:
String sql = "select * from student";
Update Example:
String sql = "update student set marks=? where id=?";
Delete Example:
String sql = "delete from student where id=?";
Important Methods:
- update()
- query()
- queryForObject()
- execute()
- batchUpdate()
4. Modeling JDBC Operations
Layers:
Controller -> Service -> DAO -> Database
Model Class:
Represents database table.
DAO Layer:
Handles database operations.
Service Layer:
Contains business logic.
Controller Layer:
Handles HTTP requests.
5. Java Objects in Spring JDBC
POJO = Plain Old Java Object
BeanPropertyRowMapper converts rows into Java objects.
6. Spring Boot and Database
Advantages:
- Auto configuration
- Embedded server
- Starter dependencies
- Fast development
Database Configuration:
[Link]=jdbc:mysql://localhost:3306/college
[Link]=root
[Link]=root
7. Spring Boot Web Application Development
Components:
- Controller
- Service
- Repository
- Model
Common Annotations:
- @SpringBootApplication
- @RestController
- @Autowired
- @Repository
- @Service
- @GetMapping
- @PostMapping
8. Differences
JDBC vs JdbcTemplate:
JDBC -> More coding
JdbcTemplate -> Less coding
Spring vs Spring Boot:
Spring -> Manual configuration
Spring Boot -> Auto configuration
9. Important Exam Topics
- Dependency Injection
- IoC Container
- REST API
- MVC Architecture
- Spring Data JPA
- Autowiring
- Exception Handling
10. Revision Trick
Controller -> Service -> DAO -> Database