Step-by-Step Guide to Building a Spring Boot Project with MyBatis and MySQL

The article provides a comprehensive tutorial for building a Spring Boot web application that integrates MyBatis and MySQL, and uses Thymeleaf for the front‑end.

First, a new Spring Boot project is generated via Spring Initializr, selecting dependencies such as Spring Web, Thymeleaf, Spring Data JDBC, MySQL Driver, and Lombok.

The <project>...</project> Maven pom.xml is shown with the required dependencies and the Spring Boot Maven plugin.

Configuration files are created under src/main/resources : an application.yml (or application.properties ) that defines the datasource URL, driver class, username, password, and MyBatis mapper locations.

A POJO UserLogin is defined in the pojo package, annotated with Lombok’s @Data , @AllArgsConstructor , and @NoArgsConstructor to hold username and password fields.

A MySQL database named mybatis is created with a userLogin table containing username and password columns.

The data access layer consists of a UserLoginMapper interface annotated with @Mapper and @Repository , declaring methods for querying all users, inserting a user, and querying by username. Corresponding SQL statements are placed in UserLoginMapper.xml under resources/mapper .

The service layer defines an interface UserLoginServicesI and an implementation UserLoginServicesImpl (annotated with @Service ) that delegates to the mapper.

The controller MyController (annotated with @Controller ) provides endpoints for navigating to the login page, handling login success, navigating to the registration page, and handling registration success. It uses Spring MVC’s Model to pass messages to the view.

Three Thymeleaf templates are created under templates :

login.html – a simple login form that posts to /LoginSuccess and includes a link to the registration page.

register.html – a registration form that posts to /RegisterSuccess .

success.html – an empty placeholder page displayed after a successful login.

Finally, a test class demonstrates how to obtain a DataSource bean, open a connection, and invoke the mapper methods to verify the setup.