springBoot整合mybatis

项目构建需要mybatis启动器依赖 构建时也可以勾选mybatis

 

 

 

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

　　建立mapper文件夹/包放mapper接口和xml文件

接口:

package com.dang.springbootmybatis.mapper;

import com.dang.springbootmybatis.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface UserMapper {
    List<User> queryUserList();
    int addUser(User user);
}

　　

 

xml的配置

<?xml version="1.0" encoding="UTF8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--        mapperxml的写法和mybatis的配置文件写法不同-->
<!--        namespace绑定对应的一个dao/mapper接口    可以给com.dang.pojo.User起别名(在配置文件)使resultType直接=User-->
<mapper namespace="com.dang.springbootmybatis.mapper.UserMapper">
        <select id="queryUserList" resultType="User">
            select *from user
        </select>
        <insert id="addUser" parameterType="User">
            insert into user(UNAME, UPASSWORD) VALUES (#{Uname},#{Upassword})
        </insert>
</mapper>

　　

 

 

 

 

yaml配置mapper的xml路径和别名实体类包

mybatis:
  mapper-locations: classpath:mybatis/mapper/*.xml
  type-aliases-package: com.dang.springbootmybatis.pojo

controller测试接口

package com.dang.springbootmybatis.controller;

import com.dang.springbootmybatis.mapper.UserMapper;
import com.dang.springbootmybatis.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class UserController {
    @Autowired
    private UserMapper userMapper;

    @GetMapping("/1")
    public String print(){
        return "1";
    }

    @GetMapping("/query")
    public List<User> queryUserList(){
        List<User> users = userMapper.queryUserList();
        for (User user : users) {
            System.out.println(user);
        }
        return users;
    }
    @GetMapping("/add")
    public String add(){
        User user = new User(0,"肥佬","8888");
        userMapper.addUser(user);
        return "OK";
    }
}

数据库结构 Uid是自增

 

 

 

　

最后在浏览器地址栏测试能否查询或增加数据