基于Springboot搭建java项目（二十）—— Springboot集成Mybatis/MybatisPlus

Springboot集成Mybatis/MybatisPlus

一、Springboot集成Mybatis

1、添加maven依赖

pom文件中添加以下依赖

	<!--mysql & mybatis-->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>

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

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>

2、添加配置文件

在配置文件中添加MySQL连接的基本参数和mapper文件的扫描路径

spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/db_booking?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=admin
mybatis.mapper-locations= classpath:com.it520.bookkepping.dao.mapper/*.xml

3、创建数据表

CREATE TABLE `t_user` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

4、创建实体类

package com.it520.bookkeeping.dao.entity;

import lombok.Data;

import java.sql.Timestamp;

@Data
public class UserEntity {
    private Integer id;

    private String name;

    private String password;
    
    private Timestamp createTime;
    
    private Timestamp updateTime;
}

5、创建映射关系

<?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.it520.bookkeeping.dao.mapper.UserMapper">

    <resultMap id="BaseResultMap" type="com.it520.bookkeeping.dao.entity.UserEntity">
        <id column="id" property="id" />
        <result column="name" property="name" />
        <result column="password" property="password" />
        <result column="create_time" property="createTime" />
        <result column="update_time" property="updateTime" />
    </resultMap>

    <select id="selectAll" resultType="com.it520.bookkeeping.dao.entity.UserEntity">
        select * from t_user
    </select>

</mapper>

6、编写执行接口

package com.it520.bookkeeping.dao.mapper;

import com.it520.bookkeeping.dao.entity.UserEntity;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface UserMapper {

    List<UserEntity> selectAll();
}

二、Springboot集成MybatisPlus

1、添加maven依赖

pom文件中添加以下依赖

		<!--Mybatis-Plus 注意版本-->
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-boot-starter</artifactId>
			<version>3.4.1</version>
		</dependency>
		<!--数据库连接驱动 连接配置修改时间-->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>

2、创建实体类

package com.it520.bookkeeping.web.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

import java.sql.Timestamp;

@Data
@TableName("t_user")//对应表的名称
public class UserEntity {

    @TableId(type = IdType.AUTO) //对应id的生成规则
    private Integer id;

    private String name;

    private String password;

    private Timestamp createTime;

    private Timestamp updateTime;
}

3、编写执行接口

package com.it520.bookkeeping.web.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.it520.bookkeeping.web.entity.UserEntity;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserMapper extends BaseMapper<UserEntity> {
}

这个接口有基础的增删改查的功能，可根据需求来扩展

三、总结

以上是Springboot集成Mybatis/MybatisPlus的简单集成，具体的业务拓展后续会做个详解，从集成的过程当中会发现mybatisPlus会更加简单