工程結構

├─java
│  └─com
│      └─claroja
│          │  App.java
│          │
│          ├─controller
│          │      MybatisController.java
│          │
│          ├─dao
│          │      UserMapper.java
│          │
│          └─model
│                  User.java
│
└─resourcesapplication.yml

數據準備

CREATE DATABASE `test`;DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (`id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(50) DEFAULT NULL,`password` varchar(50) DEFAULT NULL,`name` varchar(50) DEFAULT NULL,PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;INSERT INTO `user` VALUES ('1', 'zhangsan', '123', '張三');
INSERT INTO `user` VALUES ('2', 'lisi', '123', '李四');

resources

resources/application.yml

spring:datasource: # 配置數據路連接驅動driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://192.168.2.222:3306/test?useUnicode=true&characterEncoding=utf8username: rootpassword: 123456#mybatis: # 開啟注解后不需要再配置mybatis
#  type-aliases-package: com.claroja.model # 模型所在目錄,xml中的resultType就不用寫全類名了
#  mapper-locations: classpath:mapper/*Mapper.xml # mapper.xml所在目錄

java.com.claroja

java/com/claroja/App.java

package com.claroja;import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;@SpringBootApplication
@MapperScan(basePackages = "com.claroja.dao") //開啟注解
public class App {public static void main(String[] args) {SpringApplication.run(App.class, args);}
}

java/com/claroja/controller/MybatisController.java

package com.claroja.controller;import com.claroja.dao.UserMapper;
import com.claroja.model.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;import java.util.List;@Controller
public class MybatisController {@Autowiredprivate UserMapper userMapper;@RequestMapping("/query")@ResponseBodypublic List<User> queryUserList(){List<User> users = userMapper.queryUserList();return users;}
}

mybatis mongodb。java/com/claroja/dao/UserMapper.java

package com.claroja.dao;import com.claroja.model.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;import java.util.List;@Mapper
public interface UserMapper {@Select("select * from user")public List<User> queryUserList();
}

java/com/claroja/model/User.java

package com.claroja.model;public class User {private Long id;private String username;private String password;private String name;public Long getId() {return id;}public void setId(Long id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public String getName() {return name;}public void setName(String name) {this.name = name;}@Overridepublic String toString() {return "User{" +"id=" + id +", username='" + username + '\'' +", password='" + password + '\'' +", name='" + name + '\'' +'}';}
}

POM

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.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.2</version><relativePath/> <!-- lookup parent from repository --></parent><groupId>com.claroja</groupId><artifactId>springboot-mybatis</artifactId><version>0.0.1-SNAPSHOT</version><name>springboot-mybatis</name><description>Demo project for Spring Boot</description><properties><java.version>1.8</java.version></properties><dependencies><dependency><!--web依賴--><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><!--熱啟動依賴--><groupId>org.springframework.boot</groupId><artifactId>spring-boot-devtools</artifactId></dependency><dependency><!--測試依賴--><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><dependency><!--mybatis依賴--><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.1.3</version></dependency><dependency><!--數據庫驅動依賴--><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.22</version></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId></plugin></plugins></build></project>

測試編寫

com.claroja.controller.MybatisControllerTest.java

package com.claroja.controller;import com.claroja.dao.UserMapper;
import com.claroja.model.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;import java.util.List;@SpringBootTest
class MybatisControllerTest {@Autowiredprivate UserMapper userMapper;@Testvoid queryUserList() {List<User> users = userMapper.queryUserList();System.out.println(users);}
}