一篇超详细的Spring Boot整合Mybatis文章

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

<project xmlns= "http://maven.apache.org/pom/4.0.0" xmlns:xsi= "http://HdhCmsTestw3.org/2001/xmlschema-instance"

          xsi:schemalocation= "http://maven.apache.org/pom/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd" >

     <modelversion> 4.0 . 0 </modelversion>

     <parent>

         <groupid>org.springframework.boot</groupid>

         <artifactid>spring-boot-starter-parent</artifactid>

         <version> 2.4 . 4 </version>

         <relativepath/> <!-- lookup parent from repository -->

     </parent>

     <groupid>com.keafmd</groupid>

     <artifactid>spring-boot- 09 -mybatis</artifactid>

     <version> 0.0 . 1 -snapshot</version>

     <name>spring-boot- 09 -mybatis</name>

     <description>demo project for spring boot</description>

     <properties>

         <java.version> 1.8 </java.version>

     </properties>

     <dependencies>

         <dependency>

             <groupid>org.springframework.boot</groupid>

             <artifactid>spring-boot-starter-jdbc</artifactid>

         </dependency>

         <dependency>

             <groupid>org.springframework.boot</groupid>

             <artifactid>spring-boot-starter-web</artifactid>

         </dependency>

         <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>

         <dependency>

             <groupid>org.springframework.boot</groupid>

             <artifactid>spring-boot-starter-test</artifactid>

             <scope>test</scope>

         </dependency>

     </dependencies>

     <build>

         <plugins>

             <plugin>

                 <groupid>org.springframework.boot</groupid>

                 <artifactid>spring-boot-maven-plugin</artifactid>

             </plugin>

         </plugins>

     </build>

</project>

server:

   port: 80

# 配置数据源

spring:

   datasource:

     url: jdbc:mysql: //127.0.0.1:3306/ssm-java1?usessl=false

     driver- class -name: com.mysql.cj.jdbc.driver

     username: root

     password: 18044229

# 整合mybatis

mybatis:

   #  typealiasespackage: com.neuedu.entity

   mapper-locations: classpath*:com/neuedu/boot/mapper/*.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.keafmd.mapper.usermapper" >

     <select id= "list" resulttype= "map" >

         select * from user

     </select>

</mapper>

package com.keafmd.mapper;

import org.apache.ibatis.annotations.mapper;

import java.util.list;

/**

  * keafmd

  *

  * @classname: usermapper

  * @description:

  * @author: 牛哄哄的柯南

  * @date: 2021-04-08 16:09

  * @blog: https://keafmd.blog.csdn.net/

  */

public interface usermapper {

     list list();

}

# 整合mybatis

mybatis:

   #  typealiasespackage: com.neuedu.entity

   mapper-locations: classpath*:com/neuedu/boot/mapper/*.xml

package com.keafmd;

import org.mybatis.spring.annotation.mapperscan;

import org.springframework.boot.springapplication;

import org.springframework.boot.autoconfigure.springbootapplication;

@springbootapplication

@mapperscan ( "com.keafmd.mapper" )

public class springboot09mybatisapplication {

     public static void main(string[] args) {

         springapplication.run(springboot09mybatisapplication. class , args);

     }

}

package com.keafmd.mapper;

import com.keafmd.springboot09mybatisapplication;

import org.junit.jupiter.api.test;

import org.springframework.beans.factory.annotation.autowired;

import org.springframework.boot.test.context.springboottest;

import java.util.list;

import static org.junit.jupiter.api.assertions.*;

@springboottest (classes = springboot09mybatisapplication. class )

class usermappertest {

     @autowired

     usermapper usermapper;

     @test

     void list(){

         list list = usermapper.list();

         for (object o : list) {

             system.out.println(o);

         }

     }

}