springboot整合mybatis

学习文档：http://mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/

先看一下MyBatis-Spring-Boot-Starter、 MyBatis-Spring、Spring Boot、Java它们之间的版本关系

之后是mybatis的配置

整体的目录结构

导入依赖

<dependency>
     <groupId>org.mybatis.spring.boot</groupId>
     <artifactId>mybatis-spring-boot-starter</artifactId>
     <version>2.1.4</version>
 </dependency>

yaml文件的配置

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/test?serverTimezone=UTC&characterEncoding=utf-8&useUnicode=true
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456

mybatis:
  type-aliases-package: com.zkw.pojo  # 给实体类起别名
  mapper-locations: classpath:mybatis/mapper/*.xml  # mapper.xml文件的位置

先来一个user实体类

package com.zkw.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private int id;
    private String name;
    private String pwd;
}

然后写出对应的mapper和mapper.xml

package com.zkw.mapper;

import com.zkw.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper //标注这类是一个mybatis的mapper类
@Repository //和@Component 作用一样
public interface UserMapper {

    //查询所有用户
    public List<User> selectUser();

    //查询一个用户
    public User selectUserById(@Param("id") int id);

    //增加一个用户
    public void addUser(User user);

    //删除用户
    public void deleteUser(@Param("id") int id);

    //修改用户
    public void  updateUser(User user);
}

<?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.zkw.mapper.UserMapper">

    <select id="selectUser" resultType="User">
        select * from test.user
    </select>

    <select id="selectUserById" parameterType="int" resultType="User">
        select * from test.user where id = #{id}
    </select>

    <insert id="addUser" parameterType="User">
        insert into test.user (id,name,pwd)
        values (#{id},#{name},#{pwd});
    </insert>

    <delete id="deleteUser" parameterType="_int">
        delete from test.user where id = #{id}
    </delete>

    <update id="updateUser" parameterType="User">
        update test.user set name=#{name},pwd=#{pwd}
        where id = #{id}
    </update>
</mapper>

最后来一个controller

package com.zkw.controller;

import com.zkw.mapper.UserMapper;
import com.zkw.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class UserController {


    @Autowired
    UserMapper userMapper;

    @RequestMapping("/userAll")
    public List<User> selectUser(){
        List<User> userList = userMapper.selectUser();
        return userList;
    }

    @RequestMapping("/user/{id}")
    public String selectUserById(@PathVariable("id") int id){
        User user = userMapper.selectUserById(id);
        return user.toString();
    }

    @RequestMapping("/insert")
    public String insert(){
        User user = new User(10, "罗翔", "123456");
        userMapper.addUser(user);
        return "insert-ok";
    }

    @RequestMapping("/delete/{id}")
    public String delete(@PathVariable("id")int id){
        userMapper.deleteUser(id);
        return "delete-ok";
    }

    @RequestMapping("/update")
    public String update(){
        User user = new User(10, "罗翔", "666666");
        userMapper.updateUser(user);
        return "insert-ok";
    }
}

测试
对于@RunWith(SpringRunner.class)：的解释，参考：《SpringBoot测试jdbc时dataSource.getClass()出现空指针异常》

package com.zkw;

import com.zkw.controller.UserController;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.sql.SQLException;

@SpringBootTest
@RunWith(SpringRunner.class)
public class Springboot07MybatisApplicationTests {
    @Autowired
    UserController userController;

    @Test
    public void contextLoads() throws SQLException {
    
        System.err.println("查询所有的用户："+userController.selectUser());
        
        System.out.println("==========删除10号用户==========");
        userController.delete(10);
        System.err.println(userController.selectUser());

        System.out.println("==========插入10号用户==========");
        userController.insert();
        System.err.println(userController.selectUser());

        System.out.println("==========修改10号用户密码==========");
        userController.update();
        System.err.println(userController.selectUser());
    }
}

结果如下：