sPlus介绍

MP是一个MyBatis的增强工具在MyBatis的基础上只做增强不做改变为简化开发、提高效率而生。

MyBatisPlus的愿景是成为MyBatis最好的搭档。

润物无声

企业级模块支持分库分表、数据审计、字段加密、数据绑定、数据权限、表结构自动生成

SQL

RedisTemplate、Redission、Zookeeper

(opens

MyBatisPlus官方推荐在SpringBoot工程中使用Spring工程也可以使用MyBatisPlus首先我们在Spring中使用MyBatisPlus。

在Mysql中准备数据

--dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus/artifactIdversion3.4.2/version/dependency!--

mysql

--dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.27/version/dependency!--

junit

--dependencygroupIdjunit/groupIdartifactIdjunit/artifactIdversion4.12/versionscopetest/scope/dependency!--

druid

--dependencygroupIdcom.alibaba/groupIdartifactIddruid/artifactIdversion1.2.6/version/dependency!--

spring

--dependencygroupIdorg.springframework/groupIdartifactIdspring-context/artifactIdversion5.3.9/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-orm/artifactIdversion5.3.9/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-test/artifactIdversion5.3.9/version/dependency!--

lombok

--dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdversion1.18.22/version/dependency/dependencies

创建实体类

使用MyBatis时在编写Mapper接口后需要手动编写CRUD方法并需要在Mapper映射文件中手动编写每个方法对应的SQL语句。

而在MyBatisPlus中只需要创建Mapper接口并继承

BaseMapper此时该接口获得常用增删改查功能不需要自己手动编写Mapper配置文件

public

创建Spring配置文件applicationContext.xml

?xml

xmlnshttp://www.springframework.org/schema/beansxmlns:contexthttp://www.springframework.org/schema/contextxmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexmlns:phttp://www.springframework.org/schema/pxsi:schemaLocationhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsd!--

数据源

classcom.alibaba.druid.pool.DruidDataSourceproperty

nameusername

valuejdbc:mysql:///school/property

namedriverClassName

valuecom.mysql.cj.jdbc.Driver//bean!--

Mybatis-Plus提供SqlSessionFactory对象

--bean

classcom.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBeanproperty

namedataSource

自动扫描所有mapper接口将mapper接口生成代理注入spring

--bean

classorg.mybatis.spring.mapper.MapperScannerConfigurerp:basePackagecom.example.mpdemo1.mapperp:sqlSessionFactoryBeanNamesqlSessionFactory//beans测试Mapper方法

import

com.example.mpdemo1.pojo.Student;

import

org.springframework.beans.factory.annotation.Autowired;

import

org.springframework.test.context.ContextConfiguration;

import

org.springframework.test.context.junit4.SpringJUnit4ClassRunner;RunWith(SpringJUnit4ClassRunner.class)

classpath:applicationContext.xml)

public

studentMapper.selectById(3);System.out.println(students);}

测试结果

接下来我们在SpringBoot项目中使用MyBatisPlus

创建SpringBoot项目添加MyBatisPlus起步依赖

dependenciesdependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactId/dependency!--

mybatis-plus

--dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.5.0/version/dependency!--

lombok

--dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/scope/dependency/dependencies

配置数据源

spring:datasource:driver-class-name:

jdbc:mysql:///school?serverTimezoneUTCusername:

rootpassword:

同样使用MyBatisPlus时在编写Mapper接口后不需要手动编写CRUD方法并不需要在Mapper映射文件中手动编写每个方法对应的SQL语句。

因此MyBatisPlus中只需要创建Mapper接口并继承BaseMapper此时该接口获得常用增删改查功能不需要自己手动编写Mapper配置文件

import

com.baomidou.mybatisplus.core.mapper.BaseMapper;

import

com.example.mpdemo2.pojo.Student;public

interface

MapperScan(com.example.mpdemo2.mapper)

测试Mapper方法

studentMapper.selectById(1);System.out.println(student);}