Setting up Spring Boot 3 + Maven + MySQL + JDBC Example

Once all is set, you can click on, Generate button at the bottom to download the project zip file.

Step 2: Importing the JDBC Project to IDE

Extract the zip project and open your IDE (Eclipse, IntelliJ, NetBeans or VSCode) to import the project, we will demonstrate using IDEA IntelliJ.



1. Unzip the project file we downloaded at Step 1.
2. Open IntelliJ IDE.
3. Go to Menu: File -> New -> Project From Existing Source...
4. Now select your project folder and click Open
5. Keep clicking next, and "Please select project SDK" choose your JDK (in my case JDK 20)
6. Right-click on your project and select Maven -> Download Sources

Quick alternative: you can close the project and be on the Welcome Screen and click on Open and choose your application folder.

Step 3: Setting up MySQL Database.

Make sure you have download and installed MySQL Database. We will first create our test database.

create DATABASE jdbctest;

Next lets create a simple database table.

CREATE TABLE `jdbctest`.`message` (`message` VARCHAR(100) NOT NULL ) ENGINE = InnoDB;

Next, lets insert a record.

INSERT INTO `message` (`message`) VALUES ('Hello Spring JDBC');

Finally lets check the record was inserted properly.

SELECT * FROM message;

message
Hello Spring JDBC

We are all set with the MySQL Database for our tutorial!

Step 4: Configuration for MySQL with Spring Boot

Open the applications.properties files in your project that you will find under src -> main -> resources and add the below details.

spring.datasource.url=jdbc:mysql://localhost/jdbctest
spring.datasource.username=root
spring.datasource.password=your-db-password-can-be-blank-by-default
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

Next open the pom.xml file add the MySQL connector dependency.

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.14</version>
</dependency>

We are all set with the JDBC configuration!

Step 5: Creating our CommandLineRunner Class

Let's first create a Pojo Message,

package org.code2care.springboot.jdbctutorial;

public class Message {

    private String message;

    public String getMessage() {
        return message;
    }

    public void setMessage(String message) {
        this.message = message;
    }

    @Override
    public String toString() {
        return "Message{" +
                "message='" + message + '\'' +
                '}';
    }
}

Now we are all set for the final class that we need, we call it JDBCRunner




package org.code2care.springboot.jdbctutorial;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.CommandLineRunner;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public class JDBCRunner implements CommandLineRunner {

    private String query = "Select * from message";

    @Autowired
    JdbcTemplate jdbcTemplate;

    @Override
    public void run(String... args) throws Exception {

       List<Message> messages = jdbcTemplate.query(query, new BeanPropertyRowMapper<>(Message.class));
        System.out.println(messages.get(0).getMessage());
    }
}

Code Explanation

---

We have created a Java class named JDBCRunner that implements the CommandLineRunner interface which is marked with the Spring @Component annotation so that it is managed by Spring IoC, so it will be automatically detected and instantiated by the Spring framework during runtime.

The class has a private field named query which is a SQL query to retrieve our "Hello Spring JDBC" message

The @Autowired annotation is used to inject a JdbcTemplate object into the class. This object is a Spring JDBC abstraction that simplifies the use of JDBC and eliminates the need for boilerplate code.

As we have implemented the CommandLineRunner interface, so the run method will be executed when the Spring application is started and execute the SQL query and retrieve a list of Message objects.

Step 6: Running your Hello JDBC Project

Go to the JdbctutorialApplication file and hit run, you should see "Hello Spring JDBC" printed in your IDE Console.

Hello Spring JDBC

Comments & Discussion

Facing issues? Have questions? Post them here! We're happy to help!

Load Comments

Provide Feedback For This Article

We take your feedback seriously and use it to improve our content. Thank you for helping us serve you better!

Helpful Not Helpful

Thanks for your feedback! If you have time, please provide details by selecting options below.

Submit Feedback

😊 Thanks for your time, your feedback has been registered!