MySQL with Spring Boot

spring.datasource.url=jdbc:mysql://localhost:3306/db_name
spring.datasource.username=root
spring.datasource.password=your_password

// 1. application.properties
spring.datasource.url=jdbc:mysql://localhost:3306/springdb
spring.datasource.username=root
spring.datasource.password=root
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true

// 2. Entity Class
import jakarta.persistence.*;

@Entity
class User {

  @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  private Long id;
  private String name;
}

// 3. Repository
import org.springframework.data.jpa.repository.JpaRepository;

interface UserRepository extends JpaRepository<User, Long> {}

// 4. Service
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.*;

@Service
class UserService {

  @Autowired
  private UserRepository repo;

  public List<User> getAllUsers() {
    return repo.findAll();
  }

  public User saveUser(User user) {
    return repo.save(user);
  }
}

// 5. Controller
import org.springframework.web.bind.annotation.*;

@RestController
@RequestMapping("/users")
class UserController {

  @Autowired
  private UserService service;

  @GetMapping
  public List<User> getUsers() {
    return service.getAllUsers();
  }

  @PostMapping
  public User createUser(@RequestBody User user) {
    return service.saveUser(user);
  }
}

// Output:
// REST API connected with MySQL successfully

• 1 Integration of Spring Boot with MySQL database.
• 2 Uses JDBC driver and JPA.
• 3 Supports CRUD operations.
• 4 Common in enterprise apps.

• 1 Spring Data JPA
• 2 MySQL Driver
• 3 Spring Web
• 4 Spring Boot Starter

• 1 Add MySQL dependency.
• 2 Configure application.properties.
• 3 Create Entity class.
• 4 Create Repository interface.
• 5 Build Service and Controller.

• 1 Reliable relational database.
• 2 Easy integration with Spring.
• 3 Scalable backend systems.
• 4 Widely used in industry.