How do I connect Spring Boot to a database?

How do I connect Spring Boot to a database?

To connect Spring Boot to a database, you need to configure your application properties and include the necessary dependencies.

What dependencies do I need to add?

You typically need to add 'spring-boot-starter-data-jpa' and the database driver, like 'mysql-connector-java' for MySQL.

Can you show me an example of the application.properties file?

Sure! Here's a basic example:

spring.datasource.url=jdbc:mysql://localhost:3306/yourdbname
spring.datasource.username=root
spring.datasource.password=yourpassword
spring.jpa.hibernate.ddl-auto=update

Make sure to replace the placeholders with your actual database details.

What if I want to use PostgreSQL instead?

If you're using PostgreSQL, you would change the dependency to 'postgresql' and update the URL in your properties file accordingly.