SpringBoot集成-Mybatis

SpringBoot整合之Mybatis

1. Mybatis起步依赖和mysql连接驱动依赖

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.0</version>
        </dependency>
	    <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

 	

2. application.properties配置数据库信息和添加pojo包扫描、加载mybatis映射文件

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/db3?useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123456

mybatis.type-aliases-package=com.example.pojo
mybatis.mapper-locations=classpath:mapper/*Mapper.xml

3. bean类

package com.example.pojo;

import org.springframework.stereotype.Controller;

@Controller
public class Student {
    private String name;
    private String number;

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getNumber() {
        return number;
    }

    public void setNumber(String number) {
        this.number = number;
    }

    @Override
    public String toString() {
        return "Student{" +
                "name='" + name + '\'' +
                ", number='" + number + '\'' +
                '}';
    }
}

4. 映射关系：StudentMapper.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.example.dao.StudentMapper">
    <select id="findAllStudent" resultType="com.example.pojo.Student">
        select * from student
    </select>

</mapper>

5. 接口类

package com.example.dao;

import com.example.pojo.Student;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Controller;

import java.util.List;

@Mapper
public interface StudentMapper {

    public List<Student> findAllStudent();
}

6. Controller测试类

package com.example.controller;

import com.example.dao.StudentMapper;
import com.example.pojo.Student;
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 ControllerTest {

    @Autowired
    private StudentMapper studentMapper;

    @RequestMapping("/show")
    @ResponseBody
    public List<Student> showStudent(){
        return studentMapper.findAllStudent();
    }
}

测试结果：

项目Demo结构