SpringBoot整合MyBatis

1.添加MyBatis的起步依赖

<!--mybatis起步依赖-->
<dependency>
	<groupId>org.mybatis.spring.boot</groupId>
	<artifactId>mybatis-spring-boot-starter</artifactId>
	<version>1.1.1</version>
</dependency>

2.添加数据库驱动坐标，以MySQL为例

<!-- MySQL连接驱动 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

3.添加数据库连接信息

  在application.properties文件中添加数据库的连接信息：

# 数据库配置信息
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/demo?useSSL=false
useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=root

4.创建user表

CREATE DATABASE demo CHARACTER SET utf8 COLLATE utf8_general_ci;
USE demo;
CREATE TABLE user (
  id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  username varchar(256) NOT NULL COMMENT '用户名',
  password varchar(256) NOT NULL COMMENT '密码'
)CHARACTER SET utf8 COLLATE utf8_general_ci;

INSERT INTO user VALUES (1, 'Atlantis', '123');
INSERT INTO user VALUES (2, '安徒生', '123a');
INSERT INTO user VALUES (3, 'Olivia', '123');

5.创建实体Bean

package com.atlantis.domain;

public class User {
    private Integer id;
    private String username;
    private String password;
    
	//省略getter和setter方法 .. ..
}

6.编写Mapper

import com.atlantis.domain.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface UserMapper {
    public List<User> findAllUser();
}

注意：@Mapper标记该类是一个mybatis的mapper接口，可以被spring boot自动扫描到spring上下文中。

7.配置Mapper映射文件

  在src\main\resources\mapper路径下加入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.atlantis.dao.UserMapper">
    <select id="findAllUser" resultType="user">
        select * from user
    </select>
</mapper>

8.在application.properties中添加MyBatis的信息

# Spring集成MyBatis环境
# pojo别名扫描包
mybatis.type-aliases-package=com.atlantis.domain
# 加载Mybatis映射文件
mybatis.mapper-locations=classpath:mapper/*Mapper.xml

9.编写测试Controller

package com.atlantis.controller;

import com.atlantis.dao.UserMapper;
import com.atlantis.domain.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 DemoController {
    @Autowired
    private UserMapper userMapper;

    @RequestMapping(value = "/demo")
    @ResponseBody
    public List<User> demo(){
        List<User> users = userMapper.findAllUser();
        return users;
    }
}

10.测试结果