springBoot整合Mybatis (简易)

springBoot整合Mybatis (简易)

一、代码结构

二、 pom.xml

    4.0.0
    
        org.springframework.boot
        spring-boot-starter-parent
        2.4.4
         
    
    com.keafmd
    spring-boot-09-mybatis
    0.0.1-SNAPSHOT
    spring-boot-09-mybatis
    Demo project for Spring Boot
    
        1.8
    
    
        
            org.springframework.boot
            spring-boot-starter-jdbc
        
        
            org.springframework.boot
            spring-boot-starter-web
        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            1.3.2
        

        
            mysql
            mysql-connector-java
            runtime
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        
    

    
        
            
                org.springframework.boot
                spring-boot-maven-plugin
            
        
    

三、配置文件

application.properties

server.port=80
# 配置数据源
spring.datasource.url: jdbc:mysql://127.0.0.1:3306/ssm-java1?useSSL=false
spring.datasource.driver-class-name= com.mysql.cj.jdbc.Driver
spring.datasource.username= root
spring.datasource.password= 18044229

# 整合mybatis
mybatis.mapper-locations=classpath*:com/neuedu/boot/mapper/*.xml

四、UserMapper.xml

在resources中新建mappers文件夹里面是 mapper.xml

    
        select * from user
    

UserMapper.java

package com.alibaba.mapper;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;

public interface UserMapper {

    List list();
}

五、Main文件 在运行类上添加@MapperScan注解

package com.alibaba;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.alibaba.mapper")
public class SpringBoot09MybatisApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringBoot09MybatisApplication.class, args);
    }

}

 六、测试类

package com.fengqx.mapper;

import com.fengqx.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);
        }
    }

}

效果图

 完成连接数据库！