How can I test database integration in a Spring application?

How can I test database integration in a Spring application?

You can use Spring's testing support along with JUnit to test database integration. Would you like a code example?

Yes, please provide a code example.

Here's a simple example using @DataJpaTest annotation to test your repository:

@RunWith(SpringRunner.class)
@DataJpaTest
public class UserRepositoryTest {

    @Autowired
    private UserRepository userRepository;

    @Test
    public void testFindByUsername() {
        User user = new User("testuser");
        userRepository.save(user);
        User found = userRepository.findByUsername("testuser");
        assertEquals(user.getUsername(), found.getUsername());
    }
}

What dependencies do I need for this to work?

You will need Spring Boot Starter Data JPA and a database driver like H2 for in-memory testing. Add these to your pom.xml.