04 Spring Boot 整合MyBatis

整合MyBatis

注意点

1. 在相应Mapper接口上通过@Mapper注解进行注入；或在程序入口添加@MapperScan(com.hxh.Mapper)，这其中的所有接口都会被扫描
2. XXXXMapper.xml存放在resources/MyBatis/mapper目录下

整合方法

1. 配置整合依赖

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

2. 修改yaml配置文件，进行数据库连接配置

   spring:
     datasource:
       username: root
       password: 123456
       #?serverTimezone=UTC解决时区的报错
       url: jdbc:mysql://localhost:3306/db_test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
       driver-class-name: com.mysql.cj.jdbc.Driver
       type: com.alibaba.druid.pool.DruidDataSource
   mybatis:
     type-aliases-package: com.hxh.pojo
   

3. 创建mapper目录以及相应Mapper接口

   //@Mapper : 表示本类是一个 MyBatis 的 Mapper
   @Mapper
   @Repository
   public interface DepartmentMapper {
       // 获取所有部门信息
   	List<Department> getDepartments();
   	// 通过id获得部门
   	Department getDepartment(Integer id);
   }
   

4. 建立对应Mapper映射文件（与接口同名）

   <?xml version="1.0" encoding="UTF-8" ?>
   <!DOCTYPE mapper
           PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
           "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
   <mapper namespace="com.hxh.springboot05mybatis.mapper.BlogTypeMapper">
       <select id="blogTypeList" resultType="BlogType">
           Select * from t_blogtype
       </select>
       <insert id="addBlogType">
           insert into t_blogtype values(null, '测试',6);
       </insert>
       <update id="updateBlogType" parameterType="BlogType">
           update t_blogtype set typeName=#{typeName},orderNo=#{orderNo} where id=#{id}
       </update>
       <delete id="delBlogType" parameterType="Integer">
           delete from t_blogtype where id=#{id}
       </delete>
   
   </mapper>