十四.Springboot-MyBatis集成

14.1 步骤分析

1 准备一个Springboot项目
2 pom-引入Mybatis Stater
3 yml配置
4 入口类
5 写代码测试

14.2 实现

14.2.1 准备一个Springboot项目

14.2.2 pom-引入Mybatis Stater

<!-- spring-boot整合mybatis -->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>1.1.1</version>
</dependency>
<!-- mysql驱动 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.38</version>
</dependency>

<!-- https://mvnrepository.com/artifact/org.projectlombok/lombok
           导入这个jar后，编译后会自动生成相关方法
        -->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>1.18.8</version>
    <scope>provided</scope>
</dependency>

14.2.3 yml配置

​

server:
  port: 8080 #端口
spring:
  application:
    name: springboot-hello # 应用名称
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    username: root
    password: admin
    url: jdbc:mysql:///test?useUnicode=true&characterEncoding=UTF-8
mybatis:
  type-aliases-package: org.yaosang.org.domain,org.yaosang.org.query

14.2.4 入口类

​

package org.yaosang;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

//标识改项目为springboot项目
@SpringBootApplication //复合注解
@MapperScan("org.yaosang.*.mapper")
public class App {//可以是任何名称
    //springboot启动类，以后以main方法的方式就可以启动Springboot的项目。
    public static void main(String[] args) {
        SpringApplication.run(App.class,args);
    }
}

14.2.4 写代码测试

1. Domain

   package org.yaosang.org.domain;
   
   import lombok.Data;
   
   //实体类
   @Data
   public class Department {
       private Integer id;
       private String name;
   
       public Department(String name) {
           this.name = name;
       }
   
       public Department() {
       }
   }
   

2. Mapper&Mapper.xml

   package org.yaosang.org.mapper;
   
   import org.yaosang.org.domain.Department;
   
   import java.util.List;
   
   //Mapper接口
   public interface DepartmentMapper {
       //保存一个对象
       void save(Department department);
       //通过id移除一个对象
       void remove(Long id);
       //更新对象
       void update(Department department);
       //通过id加载对象
       Department loadById(Long id);
       //加载所有对象
       List<Department> loadAll();
   }
   
   

   <?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">
   <!--namespace和Mapper接口同包并同名-->
   <mapper namespace="org.yaosang.org.mapper.DepartmentMapper">
       <!--void save(Department department);-->
       <insert id="save" parameterType="Department">
           insert into t_department(name) values(#{name})
       </insert>
       <!--void remove(Long id);-->
       <delete id="remove" parameterType="long">
           delete from t_department where id = #{id}
       </delete>
   
       <!--void update(Department department);-->
       <update id="update" parameterType="Department">
           update t_department set name = #{name}
           where id = #{id}
       </update>
       <!--Department loadById(Long id);-->
       <select id="loadById" resultType="Department">
           select * from t_department where id = #{id}
       </select>
       <!--Department loadAll();-->
       <select id="loadAll" resultType="Department">
           select * from t_department
       </select>
   </mapper>
   

3. Service

   package org.yaosang.org.service;
   
   import org.yaosang.org.domain.Department;
   
   import java.util.List;
   
   //业务类接口
   public interface IDepartmentService {
       //添加一个对象
       void add(Department department);
       //通过id删除一个对象
       void del(Long id);
       //更新对象
       void update(Department department);
       //通过id获取对象
       Department getById(Long id);
       //获取所有对象
       List<Department> getAll();
   }
   
   
   package org.yaosang.org.service.impl;
   
   import org.springframework.beans.factory.annotation.Autowired;
   import org.springframework.stereotype.Service;
   import org.yaosang.org.domain.Department;
   import org.yaosang.org.mapper.DepartmentMapper;
   import org.yaosang.org.service.IDepartmentService;
   
   import java.util.List;
   
   //业务实现类
   @Service
   public class DepartmentServiceImpl implements IDepartmentService {
       @Autowired
       private DepartmentMapper departmentMapper;
       @Override
       public void add(Department department) {
   
           departmentMapper.save(department);
       }
   
       @Override
       public void del(Long id) {
   
           departmentMapper.remove(id);
       }
   
       @Override
       public void update(Department department) {
   
           departmentMapper.update(department);
       }
   
       @Override
       public Department getById(Long id) {
           return departmentMapper.loadById(id);
       }
   
       @Override
       public List<Department> getAll() {
           return departmentMapper.loadAll();
       }
   }
   
   

4. Test

   package org.yaosang.org.service.impl;
   
   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 org.yaosang.App;
   import org.yaosang.org.domain.Department;
   import org.yaosang.org.service.IDepartmentService;
   
   import static org.junit.Assert.*;
   
   @RunWith(SpringRunner.class)
   @SpringBootTest(classes = App.class)
   public class DepartmentServiceImplTest {
       @Autowired
       private IDepartmentService departmentService;
   
       @Test
       public void add() {
           departmentService.add(new Department("屌丝部"));
       }
   
       @Test
       public void del() {
           Department department = departmentService.getById(1L);
           System.out.println(department);
           departmentService.del(1L);
           department = departmentService.getById(1L);
           System.out.println(department);
   
       }
   
       @Test
       public void update() {
           Department department = departmentService.getById(1L);
           System.out.println(department);
           department.setName(department.getName()+"-edit");
           departmentService.update(department);
           department = departmentService.getById(1L);
           System.out.println(department);
       }
   
       @Test
       public void getById() {
           System.out.println(departmentService.getById(1L));
       }
   
       @Test
       public void getAll() {
           departmentService.getAll().forEach(System.out::println);
       }
   }
   

14.3 小结

​ 本章节通过Springboot集成了Mybatis