使用IDEA构建Spring boot2.0+版本+MyBatis（properties文件配置）

最新推荐文章于 2026-06-13 16:44:21 发布

原创最新推荐文章于 2026-06-13 16:44:21 发布 · 3k 阅读

6 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#java #Springboot

本文介绍了如何在Spring Boot 2.0+项目中使用IDEA构建并配置MyBatis，包括创建项目、设置pom.xml、配置application.properties以及建立entity、mapper、service、controller和mapper XML文件的详细步骤。最后展示了SpringBoot整合Mybatis的prop文件配置，并分享了项目源码链接。

最近项目从SSM转SpringBoot,但是不是用MyBatis而是用Spring JDBC
这篇博文也算记录我SpringBoot的搭建

1、Intellij idea菜单栏File->new->project
选择左侧栏中spring initializr，右侧选择jdk版本，以及默认的Service URL，点击next。
在这里插入图片描述
2、然后填写项目的Group、Artifact等信息，然后点击next

3、我这边是选择了Web->Web和Core->Aspects ,然后点击next

4、填写Project name 等信息，然后点击Finish。

maven web项目就这样创建好了

配置pom.xml:

    <!-- Springboot jar-->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-aop</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-tomcat</artifactId>
        <scope>provided</scope>
    </dependency>


    <!-- mybatis jar -->
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>1.3.1</version>
    </dependency>



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

    </dependency>

</dependencies>

application.properties

spring.datasource.url:jdbc:mysql://数据库地址:3306/test?useUnicode=true&characterEncoding=utf-8&noDatetimeStringSync=true&serverTimezone=Hongkong
spring.datasource.driverClassName:com.mysql.jdbc.Driver
spring.datasource.username:root
spring.datasource.password:root
server.port=8081


mybatis.mapper-locations:classpath:mapper/*.xml
#配置模型路径
mybatis.type-aliases-package=com.

然后把项目的entity,mapper,service,controller创建出来，整体架构如图:
在这里插入图片描述

entity里面User：

public class User {

    private int id;

    private String userName;

    public int getId() {
        return id;
    }

    public User setId(int id) {
        this.id = id;
        return this;
    }

    public String getUserName() {
        return userName;
    }

    public User setUserName(String userName) {
        this.userName = userName;
        return this;
    }
}

mapper里面的UserMapper：

@Mapper
public interface UserMapper {

    void add(User user);

    List<User> listAll(User user);
}

service里面的UserService：

@Service
public class UserService {


    @Autowired
    private UserMapper userMapper;

    public List<User> listAll(User user) {
        return userMapper.listAll(user);
    }

    public void add(User user){
        userMapper.add(user);
    }
}

controller里面的UserController:

@Controller
@RequestMapping(value = "/user")
public class UserController {

    @Autowired
    private UserService userService;

    @RequestMapping(value = "index")
    @ResponseBody
    public List<User> index(User user){

        return userService.listAll(user);
    }
}

resoures->mappe文件里面的UserMapper.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://www.mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lwj.springboot.mapper.UserMapper">

    <resultMap id="UserResultMap" type="com.lwj.springboot.entity.User">
        <id column="id" property="id"/>
        <result column="user_name" property="userName"/>
    </resultMap>

    <insert id="add" parameterType="com.lwj.springboot.entity.User">
        insert into user(user_name)
        values (#{userName})
    </insert>

    <select id="listAll" parameterType="com.lwj.springboot.entity.User" resultMap="UserResultMap">
        select * from user
    </select>
</mapper>

SpringBoot整合Mybatis主要是在prop文件配置：在这里插入图片描述