Installation is complete when this is complete. Next, let's create a project.

2. Create a Spring Boot Project

1. Launch IntelliJ. You may be asked for a plug-in, but I will proceed without doing anything.

2. Click ** Create New Project **.

3. Select ** Gradle **, check ** Java **, and click ** Next **. * For the SDK, select the JDK you installed earlier.

4. Enter ** GroupId ** and ** ArtifactId ** and click ** Next **. (Please make each ID as you like)

• What are GroupId and ArtifactId

5. After that, click ** Next ** without changing any settings and proceed to ** Finish **.

If you proceed to this point, you should have created a project. (Even if an error occurs, you can ignore it) Next, I want to put in the necessary dependencies, so let's use Spring Initializer.

3. Use Spring Initializer to inject the required dependencies

1. Use ** Sprinig Initializer ** to change the build.gradle settings for Spring Boot. Please access here.

2. Change the select box at the top of the screen to ** Generate a Gradle Project with java and Spring Boot 2.1.0 **.

3. Change the GroupId and ArtifactId so that they are the same as when the project was created.

4. In ** Dependencies **, select the required dependencies. This time, search for ** MySQL ** and ** MyBatis ** and select them.

5. The final screen will look like the one below. Click ** Generate Project ** when you are done.

6. Open the downloaded zip file and copy and paste ** build.gradle ** in it to build.gradle that exists on your project. Then run ** Refresh ** at the top right of the screen to recapture the dependencies. Even if you get an error when creating your first project, you should be able to complete it successfully at this time.

If you come to this point, you will have a rest. In the current state, the DB connection settings have not been made, so the app will not start. Let's modify application.yml (or properties).

4. Modify application.yml (properties) to connect to DB

4-1. Create a table in DB

1. Open ** MySQL Command Line Client ** and log in. (password is set at the time of installation)

2. Anything is fine, so create an appropriate DB.

3. Next, create the table. In addition, put the data appropriately.

4. Set the time zone as well. Please refer to here, add the settings to my.ini, and restart MySQL Server.

4-2. Describe the connection information in application.yml

1. Enter the DB information in application.yml. The item must have at least ** url, username and password . - url ** is * jdbc: mysql: // localhost / sample_db (table name) . -* username ** should be * root . (If you have created another user, that is fine) -* password ** is the password * of the user entered in * username.

2. Now, let's execute ** ○○ Application.java ** under src / main of the project once. If the log ** Started 〇〇 Application ** appears, the settings have been read normally and it is successful.

Please also refer to here for the settings.

5. Actually get the value from the DB (although it deviates a little from the environment settings)

1. Let's write Java appropriately and get the value from DB. (I will write more about this area separately)
2. As a result of hitting with postman, I got it!

Impressions I tried myself

**… Isn't there an easier way? ** ** Spring Boot is convenient! I thought it would go more smoothly, so I felt a little uncomfortable. But now you can connect to the DB!

Finally

"There is a better way!" "You should set this here!" We look forward to your comments!

Next, I would like to introduce how to write a program that actually connects to the DB. ⇒ ** Article has been uploaded! ** I made an API to connect to MySQL from Spring Boot Thank you for reading to the end!

[^ 1]: Please see here for the difference between paid and free. By the way, the author uses the Community for business because of the license, but there is no problem at all. ** Community (free) is recommended for trial **.