spring boot整合mybatis框架

 时间:2026-02-13 19:56:53

1、推荐使用intellij idea作为开发工具,使用intellij idea创建spring boot框架,如下图所示,添加maven依赖,代码如下

                 <dependency>

                            <groupId>org.mybatis.spring.boot</groupId>

                            <artifactId>mybatis-spring-boot-starter</artifactId>

                            <version>1.3.2</version>

                   </dependency>


                   <dependency>

                            <groupId>mysql</groupId>

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

                            <scope>runtime</scope>

                   </dependency>

spring boot整合mybatis框架

2、创建一个TestMapper.java文件,代码如下

/**

 * Created by zuli on 2018/10/10.

 */

public interface TestMapper {


    int test();

}

3、在resources目录下创建TestMapper.xml文件,代码如下

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper

        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.zuli.mapper.TestMapper">

    <select id="test" resultType="int">

        SELECT 1 FROM DUAL

    </select>

</mapper>

spring boot整合mybatis框架

4、添加@MapperScan()注解,配置basePackages属性,代码如下

@SpringBootApplication

@MapperScan(basePackages = "com.zuli.mapper")

public class SpringBootMybatisApplication {

         public static void main(String[] args) {

                   ConfigurableApplicationContext context =

                                     SpringApplication.run(SpringBootMybatisApplication.class, args);

                   TestMapper testMapper = context.getBean(TestMapper.class);

                   System.out.println(testMapper.test());

         }

}

spring boot整合mybatis框架

5、修改application.properties配置文件,配置数据源,mapper xml文件路径等代码如下

spring.datasource.url=jdbc:mysql://localhost/test

spring.datasource.username=root

spring.datasource.password=123456

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

mybatis.mapper-locations=classpath:*Mapper.xml

spring boot整合mybatis框架

6、启动应用程序,调用TestMapper的test()方法,打印日志,如下图所示

spring boot整合mybatis框架

7、整体demo的项目结构如下图所示

spring boot整合mybatis框架

  • SpringBoot整合MyBatis开发框架
  • SpringBoot如何整合MyBatis?
  • spring boot整合mysql和mybatis
  • Spring boot集成mybatis和MySQL实现基础服务
  • springboot+mybatis+gradle
  • 热门搜索
    广州周边旅游景点 苏黎世旅游 雅安旅游景点大全 旅游英文 沙巴旅游 通化旅游 中国旅游资讯网 旅游资源分类表 厦门旅游景点介绍 美国旅游网