Hackforge Academy

Explanation

AWS RDS provides a managed relational database without requiring developers to manually install and maintain the database server.

Code:

Spring Boot Application
        |
        v
AWS RDS Endpoint
        |
        v
MySQL Database

Explanation

Add the required database driver and Spring Data JPA dependency to the Spring Boot project.

Code:

<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

<dependency>
  <groupId>com.mysql</groupId>
  <artifactId>mysql-connector-j</artifactId>
  <scope>runtime</scope>
</dependency>

Explanation

Configure the RDS database endpoint, username, password, and JPA properties in the application configuration.

Code:

spring.datasource.url=jdbc:mysql://RDS_ENDPOINT:3306/employeedb
spring.datasource.username=${DB_USERNAME}
spring.datasource.password=${DB_PASSWORD}
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true

Explanation

Create an entity class to map Java objects to database tables in AWS RDS.

Code:

@Entity
public class Employee {

    @Id
    @GeneratedValue
    private Long id;

    private String name;
    private String department;
}

Explanation

Create a repository interface to perform database operations through Spring Data JPA.

Code:

public interface EmployeeRepository
        extends JpaRepository<Employee, Long> {
}

// Example usage:
employeeRepository.save(employee);
employeeRepository.findAll();