Springboot整合Mybatis详细步骤

spring boot整合mybatis

1、添加依赖

<!-- 整合mysql 与mybatis  开始 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>
        <dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.1.2</version>
		</dependency>
<!-- 整合mysql 与mybatis 结束-->

2、application.yml中添加配置

3、添加mybatis-config.xml文件
路径：

内容：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING" />
    </settings>
</configuration>

4、创建mapper包及xml文件

UserMapper.java :

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

UserMapper.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.mythical.rosefinch.business.mapper.UserMapper">
    <select id="getAllUser" resultType="com.mythical.rosefinch.entity.bean.User">
        select * from t_user;
    </select>
</mapper>

5、启动类扫描mapper包 @MapperScan

@SpringBootApplication
@MapperScan("com.mythical.rosefinch.business.mapper")
public class RosefinchBusinessApplication {

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

}

6、开始测试
service层代码：

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

controller层代码：

@RestController
@RequestMapping("/user")
public class UserController {
	@Autowired
	private UserService userService;
	@RequestMapping("/getAllUser")
    public List<User> getAllUser() {
        return userService.getAllUser();
    }
}

页面访问：
http://127.0.0.1:8081/user/getAllUser
结果：