Spring Boot 整合 Mybatis （一） mybatis-spring-boot-starter

我会带着你远行 2022-03-11 14:50 496阅读 0赞

***mybatis-spring-boot-autoconfigure ***：***[http://www.mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/index.html][http_www.mybatis.org_spring-boot-starter_mybatis-spring-boot-autoconfigure_index.html]***

***mybatis：[http://www.mybatis.org/mybatis-3/zh/index.html][http_www.mybatis.org_mybatis-3_zh_index.html]***

**1.maven依赖**

<?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 http://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.0.3.RELEASE</version>
    		<relativePath/> 
    	</parent>
    	<groupId>priv.gitonlie.mybatis</groupId>
    	<artifactId>mybatis</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<name>springboot-mybatis</name>
    	<description>mybatis project for Spring Boot</description>
    
    	<properties>
    		<java.version>1.8</java.version>
    		<mybatis.springboot.version>1.3.2</mybatis.springboot.version>
    	</properties>
    
    	<dependencies>
    		<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>${mybatis.springboot.version}</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    		</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>
    			<plugin>
    		        <groupId>org.apache.maven.plugins</groupId>
    		        <artifactId>maven-surefire-plugin</artifactId>
    		        <configuration>
    		          <skipTests>true</skipTests>
    		        </configuration>
    		     </plugin>
    		</plugins>
    	</build>
    
    </project>

**2.application.yml配置**

spring:
      application:
        name: mybatis-server
      datasource:
        driverClassName: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/flowable_demo?useUnicode=true&characterEncoding=utf-8
        username: root
        password: admin123456
     
    server:
      port: 8081
    
    mybatis:
      type-aliases-package: priv.gitonlie.mybatis.entity
      mapper-locations:
      - classpath:mapper/*.xml

**3.实体类**

public class User {
    	
    	private String id;
    	
    	private String name;
    	
    	private String password;
    	
    	private String token;
    
    	public String getId() {
    		return id;
    	}
    
    	public void setId(String id) {
    		this.id = id;
    	}
    
    	public String getName() {
    		return name;
    	}
    
    	public void setName(String name) {
    		this.name = name;
    	}
    
    	public String getPassword() {
    		return password;
    	}
    
    	public void setPassword(String password) {
    		this.password = password;
    	}
    
    	public String getToken() {
    		return token;
    	}
    
    	public void setToken(String token) {
    		this.token = token;
    	}
    
    }

**4.Mapper接口**

public interface UserMapper {
    	
    	List<User> queryAllUser();
    }

**5.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="priv.gitonlie.mybatis.mapper.UserMapper">
    	<select id="queryAllUser" resultType="User">
    		select * from user
    	</select>
    </mapper>

**6.service服务层**

@Service
    public class UserService {
    	
    	@Autowired
    	private UserMapper userMapper;
    	
    	public List<User> queryAll(){
    		return userMapper.queryAllUser();
    	}
    }

**7.controller控制层**

@RestController
    public class UserController {
    	
    	@Autowired
    	private UserService service;
    	
    	@GetMapping("demo")
    	public List<User> queryAll(){
    		List<User> list = service.queryAll();
    		return list;
    	}
    }

**8.启动访问**

![20190308113745741.png][]

![20190308113828754.png][]

[http_www.mybatis.org_spring-boot-starter_mybatis-spring-boot-autoconfigure_index.html]: http://www.mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/index.html
[http_www.mybatis.org_mybatis-3_zh_index.html]: http://www.mybatis.org/mybatis-3/zh/index.html
[20190308113745741.png]: /images/20220311/161f0a9b61ec40b380bb09023baf7c49.png
[20190308113828754.png]: /images/20220311/56b0045b29a54a808a1d73f7c6a45c2f.png