MyBatis-Plus 全面教学指南<\/h1>

一、MyBatis-Plus 简介<\/h2>

1. 基本概念<\/h3>
MyBatis-Plus (简称 MP) 是一个 MyBatis 的增强工具，在 MyBatis 的基础上只做增强不做改变，为简化开发、提高效率而生。<\/p>

2. 核心特性<\/h3>

无侵入<\/strong>：只做增强不做改变，引入不会对现有工程产生影响<\/li>
损耗小<\/strong>：启动即自动注入基本 CURD，性能基本无损耗<\/li>
强大的 CRUD 操作<\/strong>：内置通用 Mapper、通用 Service<\/li>
Lambda 支持<\/strong>：通过 Lambda 表达式编写查询条件<\/li>
主键自动生成<\/strong>：支持 4 种主键策略（含分布式唯一 ID 生成器）<\/li>
ActiveRecord 模式<\/strong>：实体类继承 Model 类即可进行 CRUD<\/li>
自定义全局操作<\/strong>：支持全局通用方法注入<\/li>
代码生成器<\/strong>：快速生成 Mapper、Model、Service、Controller<\/li>
分页插件<\/strong>：基于 MyBatis 物理分页，支持多种数据库<\/li>
性能分析插件<\/strong>：输出 SQL 语句及执行时间<\/li>

全局拦截插件<\/strong>：全表 delete\/update 操作智能分析阻断<\/li> <\/ul>
二、快速入门<\/h2>
1. 开发环境准备<\/h3>

JDK 1.8+<\/li>
MySQL 5.7+<\/li>
Spring Boot 2.x<\/li> <\/ul>
2. 数据库准备<\/h3>
CREATE<\/span> DATABASE<\/span> `<\/span>mp_study`<\/span> DEFAULT<\/span> CHARACTER SET<\/span> utf8mb4; <\/span><\/span>USE `<\/span>mp_study`<\/span>; <\/span><\/span> <\/span><\/span>CREATE<\/span> TABLE<\/span> `<\/span>user<\/span>`<\/span> ( <\/span><\/span> `<\/span>id`<\/span> bigint(20<\/span>) NOT<\/span> NULL<\/span> COMMENT<\/span> '主键ID'<\/span>, <\/span><\/span> `<\/span>name`<\/span> varchar(30<\/span>) DEFAULT<\/span> NULL<\/span> COMMENT<\/span> '姓名'<\/span>, <\/span><\/span> `<\/span>age`<\/span> int(11<\/span>) DEFAULT<\/span> NULL<\/span> COMMENT<\/span> '年龄'<\/span>, <\/span><\/span> `<\/span>email`<\/span> varchar(50<\/span>) DEFAULT<\/span> NULL<\/span> COMMENT<\/span> '邮箱'<\/span>, <\/span><\/span> PRIMARY<\/span> KEY<\/span> (`<\/span>id`<\/span>) <\/span><\/span>) ENGINE=<\/span>InnoDB DEFAULT<\/span> CHARSET=<\/span>utf8; <\/span><\/span> <\/span><\/span>INSERT<\/span> INTO<\/span> user<\/span> (id, name, age, email) VALUES<\/span> <\/span><\/span>(1<\/span>, 'Jone'<\/span>, 18<\/span>, 'test1@baomidou.com'<\/span>), <\/span><\/span>(2<\/span>, 'Jack'<\/span>, 20<\/span>, 'test2@baomidou.com'<\/span>), <\/span><\/span>(3<\/span>, 'Tom'<\/span>, 28<\/span>, 'test3@baomidou.com'<\/span>), <\/span><\/span>(4<\/span>, 'Sandy'<\/span>, 21<\/span>, 'test4@baomidou.com'<\/span>), <\/span><\/span>(5<\/span>, 'Billie'<\/span>, 24<\/span>, 'test5@baomidou.com'<\/span>); <\/span><\/span><\/code><\/pre>3. Spring Boot 工程创建<\/h3> 依赖配置<\/h4> <dependencies><\/span> <\/span><\/span> <dependency><\/span> <\/span><\/span> <groupId><\/span>org.springframework.boot<\/groupId><\/span> <\/span><\/span> <artifactId><\/span>spring-boot-starter<\/artifactId><\/span> <\/span><\/span> <\/dependency><\/span> <\/span><\/span> <dependency><\/span> <\/span><\/span> <groupId><\/span>org.springframework.boot<\/groupId><\/span> <\/span><\/span> <artifactId><\/span>spring-boot-starter-test<\/artifactId><\/span> <\/span><\/span> <scope><\/span>test<\/scope><\/span> <\/span><\/span> <\/dependency><\/span> <\/span><\/span> <dependency><\/span> <\/span><\/span> <groupId><\/span>com.baomidou<\/groupId><\/span> <\/span><\/span> <artifactId><\/span>mybatis-plus-boot-starter<\/artifactId><\/span> <\/span><\/span> <version><\/span>3.5.1<\/version><\/span> <\/span><\/span> <\/dependency><\/span> <\/span><\/span> <dependency><\/span> <\/span><\/span> <groupId><\/span>org.projectlombok<\/groupId><\/span> <\/span><\/span> <artifactId><\/span>lombok<\/artifactId><\/span> <\/span><\/span> <optional><\/span>true<\/optional><\/span> <\/span><\/span> <\/dependency><\/span> <\/span><\/span> <dependency><\/span> <\/span><\/span> <groupId><\/span>mysql<\/groupId><\/span> <\/span><\/span> <artifactId><\/span>mysql-connector-java<\/artifactId><\/span> <\/span><\/span> <scope><\/span>runtime<\/scope><\/span> <\/span><\/span> <\/dependency><\/span> <\/span><\/span><\/dependencies><\/span> <\/span><\/span><\/code><\/pre>配置文件<\/h4> # DataSource Config<\/span> <\/span><\/span>spring<\/span>: <\/span><\/span> datasource<\/span>: <\/span><\/span> driver-class-name<\/span>: com.mysql.cj.jdbc.Driver<\/span> <\/span><\/span> url<\/span>: jdbc:mysql:\/\/localhost:3306\/mp_study?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8<\/span> <\/span><\/span> username<\/span>: root<\/span> <\/span><\/span> password<\/span>: 1234<\/span> <\/span><\/span> <\/span><\/span># MyBatis-Plus 配置<\/span> <\/span><\/span>mybatis-plus<\/span>: <\/span><\/span> configuration<\/span>: <\/span><\/span> log-impl<\/span>: org.apache.ibatis.logging.stdout.StdOutImpl<\/span> <\/span><\/span><\/code><\/pre>启动类配置<\/h4> @MapperScan<\/span>(<\/span>"com.example.mapper"<\/span>)<\/span> <\/span><\/span>@SpringBootApplication<\/span> <\/span><\/span>public<\/span> class<\/span> MybatisPlusStudyApplication<\/span> {<\/span> <\/span><\/span> public<\/span> static<\/span> void<\/span> main<\/span>(<\/span>String[]<\/span> args)<\/span> {<\/span> <\/span><\/span> SpringApplication.<\/span>run<\/span>(<\/span>MybatisPlusStudyApplication.<\/span>class<\/span>,<\/span> args);<\/span> <\/span><\/span> }<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>4. 基础代码编写<\/h3> 实体类<\/h4> @Data<\/span> <\/span><\/span>public<\/span> class<\/span> User<\/span> {<\/span> <\/span><\/span> private<\/span> Long id;<\/span> <\/span><\/span> private<\/span> String name;<\/span> <\/span><\/span> private<\/span> Integer age;<\/span> <\/span><\/span> private<\/span> String email;<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>Mapper 接口<\/h4> public<\/span> interface<\/span> UserMapper<\/span> extends<\/span> BaseMapper<<\/span>User><\/span> {<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>测试用例<\/h4> @SpringBootTest<\/span> <\/span><\/span>class<\/span> UserMapperTest<\/span> {<\/span> <\/span><\/span> <\/span><\/span> @Autowired<\/span> <\/span><\/span> private<\/span> UserMapper userMapper;<\/span> <\/span><\/span> <\/span><\/span> @Test<\/span> <\/span><\/span> void<\/span> testSelectList<\/span>()<\/span> {<\/span> <\/span><\/span> List<<\/span>User><\/span> users =<\/span> userMapper.<\/span>selectList<\/span>(<\/span>null<\/span>);<\/span> <\/span><\/span> users.<\/span>forEach<\/span>(<\/span>System.<\/span>out<\/span>::<\/span>println);<\/span> <\/span><\/span> }<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>三、基本 CRUD 操作<\/h2> 1. 插入操作<\/h3> @Test<\/span> <\/span><\/span>void<\/span> testInsert<\/span>()<\/span> {<\/span> <\/span><\/span> User user =<\/span> new<\/span> User(<\/span>null<\/span>,<\/span> "lisi"<\/span>,<\/span> 22<\/span>,<\/span> "aaa@qq.com"<\/span>);<\/span> <\/span><\/span> int<\/span> result =<\/span> userMapper.<\/span>insert<\/span>(<\/span>user);<\/span> <\/span><\/span> System.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>"受影响行数: "<\/span> +<\/span> result);<\/span> <\/span><\/span> System.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>"生成ID: "<\/span> +<\/span> user.<\/span>getId<\/span>());<\/span> \/\/ 基于雪花算法生成 <\/span><\/span><\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>2. 删除操作<\/h3> 根据 ID 删除<\/h4> @Test<\/span> <\/span><\/span>void<\/span> testDeleteById<\/span>()<\/span> {<\/span> <\/span><\/span> int<\/span> result =<\/span> userMapper.<\/span>deleteById<\/span>(<\/span>1L<\/span>);<\/span> <\/span><\/span> System.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>"受影响行数: "<\/span> +<\/span> result);<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>批量删除<\/h4> @Test<\/span> <\/span><\/span>void<\/span> testDeleteBatchIds<\/span>()<\/span> {<\/span> <\/span><\/span> List<<\/span>Long><\/span> ids =<\/span> Arrays.<\/span>asList<\/span>(<\/span>2L<\/span>,<\/span> 3L<\/span>,<\/span> 4L<\/span>);<\/span> <\/span><\/span> int<\/span> result =<\/span> userMapper.<\/span>deleteBatchIds<\/span>(<\/span>ids);<\/span> <\/span><\/span> System.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>"受影响行数: "<\/span> +<\/span> result);<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>条件删除<\/h4> @Test<\/span> <\/span><\/span>void<\/span> testDeleteByMap<\/span>()<\/span> {<\/span> <\/span><\/span> Map<<\/span>String,<\/span> Object><\/span> map =<\/span> new<\/span> HashMap<>();<\/span> <\/span><\/span> map.<\/span>put<\/span>(<\/span>"age"<\/span>,<\/span> 22<\/span>);<\/span> <\/span><\/span> map.<\/span>put<\/span>(<\/span>"name"<\/span>,<\/span> "lisi"<\/span>);<\/span> <\/span><\/span> int<\/span> result =<\/span> userMapper.<\/span>deleteByMap<\/span>(<\/span>map);<\/span> <\/span><\/span> System.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>"受影响行数: "<\/span> +<\/span> result);<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>3. 更新操作<\/h3> @Test<\/span> <\/span><\/span>void<\/span> testUpdateById<\/span>()<\/span> {<\/span> <\/span><\/span> User user =<\/span> new<\/span> User(<\/span>10L<\/span>,<\/span> "hello"<\/span>,<\/span> 12<\/span>,<\/span> null<\/span>);<\/span> <\/span><\/span> int<\/span> result =<\/span> userMapper.<\/span>updateById<\/span>(<\/span>user);<\/span> <\/span><\/span> System.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>"受影响行数: "<\/span> +<\/span> result);<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>4. 自动填充功能<\/h3> 实体类配置<\/h4> @Data<\/span> <\/span><\/span>public<\/span> class<\/span> User<\/span> {<\/span> <\/span><\/span> private<\/span> Long id;<\/span> <\/span><\/span> private<\/span> String name;<\/span> <\/span><\/span> private<\/span> Integer age;<\/span> <\/span><\/span> private<\/span> String email;<\/span> <\/span><\/span> <\/span><\/span> @TableField<\/span>(<\/span>fill =<\/span> FieldFill.<\/span>INSERT<\/span>)<\/span> <\/span><\/span> private<\/span> Date createTime;<\/span> <\/span><\/span> <\/span><\/span> @TableField<\/span>(<\/span>fill =<\/span> FieldFill.<\/span>INSERT_UPDATE<\/span>)<\/span> <\/span><\/span> private<\/span> Date updateTime;<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>元对象处理器<\/h4> @Component<\/span> <\/span><\/span>public<\/span> class<\/span> MyMetaObjectHandler<\/span> implements<\/span> MetaObjectHandler {<\/span> <\/span><\/span> @Override<\/span> <\/span><\/span> public<\/span> void<\/span> insertFill<\/span>(<\/span>MetaObject metaObject)<\/span> {<\/span> <\/span><\/span> this<\/span>.<\/span>strictInsertFill<\/span>(<\/span>metaObject,<\/span> "createTime"<\/span>,<\/span> LocalDateTime.<\/span>class<\/span>,<\/span> LocalDateTime.<\/span>now<\/span>());<\/span> <\/span><\/span> }<\/span> <\/span><\/span> <\/span><\/span> @Override<\/span> <\/span><\/span> public<\/span> void<\/span> updateFill<\/span>(<\/span>MetaObject metaObject)<\/span> {<\/span> <\/span><\/span> this<\/span>.<\/span>strictUpdateFill<\/span>(<\/span>metaObject,<\/span> "updateTime"<\/span>,<\/span> LocalDateTime.<\/span>class<\/span>,<\/span> LocalDateTime.<\/span>now<\/span>());<\/span> <\/span><\/span> }<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>5. 查询操作<\/h3> 基本查询<\/h4> @Test<\/span> <\/span><\/span>void<\/span> testSelect<\/span>()<\/span> {<\/span> <\/span><\/span> \/\/ 根据ID查询 <\/span><\/span><\/span><\/span> User user =<\/span> userMapper.<\/span>selectById<\/span>(<\/span>1L<\/span>);<\/span> <\/span><\/span> <\/span><\/span> \/\/ 批量查询 <\/span><\/span><\/span><\/span> List<<\/span>User><\/span> users =<\/span> userMapper.<\/span>selectBatchIds<\/span>(<\/span>Arrays.<\/span>asList<\/span>(<\/span>1L<\/span>,<\/span> 2L<\/span>,<\/span> 3L<\/span>));<\/span> <\/span><\/span> <\/span><\/span> \/\/ 条件查询 <\/span><\/span><\/span><\/span> Map<<\/span>String,<\/span> Object><\/span> map =<\/span> new<\/span> HashMap<>();<\/span> <\/span><\/span> map.<\/span>put<\/span>(<\/span>"name"<\/span>,<\/span> "Tom"<\/span>);<\/span> <\/span><\/span> List<<\/span>User><\/span> users =<\/span> userMapper.<\/span>selectByMap<\/span>(<\/span>map);<\/span> <\/span><\/span> <\/span><\/span> \/\/ 查询所有 <\/span><\/span><\/span><\/span> List<<\/span>User><\/span> users =<\/span> userMapper.<\/span>selectList<\/span>(<\/span>null<\/span>);<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>四、通用 Service 封装<\/h2> 1. Service 接口定义<\/h3> public<\/span> interface<\/span> UserService<\/span> extends<\/span> IService<<\/span>User><\/span> {<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>2. Service 实现<\/h3> @Service<\/span> <\/span><\/span>public<\/span> class<\/span> UserServiceImpl<\/span> extends<\/span> ServiceImpl<<\/span>UserMapper,<\/span> User><\/span> implements<\/span> UserService {<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>3. Service 使用示例<\/h3> 查询记录数<\/h4> @Test<\/span> <\/span><\/span>void<\/span> testGetCount<\/span>()<\/span> {<\/span> <\/span><\/span> long<\/span> count =<\/span> userService.<\/span>count<\/span>();<\/span> <\/span><\/span> System.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>"总记录数: "<\/span> +<\/span> count);<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>批量插入<\/h4> @Test<\/span> <\/span><\/span>void<\/span> testSaveBatch<\/span>()<\/span> {<\/span> <\/span><\/span> ArrayList<<\/span>User><\/span> users =<\/span> new<\/span> ArrayList<>();<\/span> <\/span><\/span> for<\/span> (<\/span>int<\/span> i =<\/span> 0<\/span>;<\/span> i <<\/span> 5<\/span>;<\/span> i++)<\/span> {<\/span> <\/span><\/span> User user =<\/span> new<\/span> User();<\/span> <\/span><\/span> user.<\/span>setName<\/span>(<\/span>"lyl"<\/span>+<\/span>i);<\/span> <\/span><\/span> user.<\/span>setAge<\/span>(<\/span>20<\/span>+<\/span>i);<\/span> <\/span><\/span> users.<\/span>add<\/span>(<\/span>user);<\/span> <\/span><\/span> }<\/span> <\/span><\/span> userService.<\/span>saveBatch<\/span>(<\/span>users);<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>五、高级特性<\/h2> 1. 条件构造器<\/h3> @Test<\/span> <\/span><\/span>void<\/span> testQueryWrapper<\/span>()<\/span> {<\/span> <\/span><\/span> QueryWrapper<<\/span>User><\/span> queryWrapper =<\/span> new<\/span> QueryWrapper<>();<\/span> <\/span><\/span> queryWrapper <\/span><\/span> .<\/span>select<\/span>(<\/span>"id"<\/span>,<\/span> "name"<\/span>,<\/span> "age"<\/span>)<\/span> <\/span><\/span> .<\/span>like<\/span>(<\/span>"name"<\/span>,<\/span> "J"<\/span>)<\/span> <\/span><\/span> .<\/span>between<\/span>(<\/span>"age"<\/span>,<\/span> 20<\/span>,<\/span> 30<\/span>)<\/span> <\/span><\/span> .<\/span>orderByDesc<\/span>(<\/span>"id"<\/span>);<\/span> <\/span><\/span> <\/span><\/span> List<<\/span>User><\/span> users =<\/span> userMapper.<\/span>selectList<\/span>(<\/span>queryWrapper);<\/span> <\/span><\/span> users.<\/span>forEach<\/span>(<\/span>System.<\/span>out<\/span>::<\/span>println);<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>2. Lambda 条件构造器<\/h3> @Test<\/span> <\/span><\/span>void<\/span> testLambdaQueryWrapper<\/span>()<\/span> {<\/span> <\/span><\/span> LambdaQueryWrapper<<\/span>User><\/span> lambdaQueryWrapper =<\/span> new<\/span> LambdaQueryWrapper<>();<\/span> <\/span><\/span> lambdaQueryWrapper <\/span><\/span> .<\/span>select<\/span>(<\/span>User::<\/span>getId,<\/span> User::<\/span>getName,<\/span> User::<\/span>getAge)<\/span> <\/span><\/span> .<\/span>like<\/span>(<\/span>User::<\/span>getName,<\/span> "J"<\/span>)<\/span> <\/span><\/span> .<\/span>between<\/span>(<\/span>User::<\/span>getAge,<\/span> 20<\/span>,<\/span> 30<\/span>)<\/span> <\/span><\/span> .<\/span>orderByDesc<\/span>(<\/span>User::<\/span>getId);<\/span> <\/span><\/span> <\/span><\/span> List<<\/span>User><\/span> users =<\/span> userMapper.<\/span>selectList<\/span>(<\/span>lambdaQueryWrapper);<\/span> <\/span><\/span> users.<\/span>forEach<\/span>(<\/span>System.<\/span>out<\/span>::<\/span>println);<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>3. 分页查询<\/h3> @Test<\/span> <\/span><\/span>void<\/span> testPage<\/span>()<\/span> {<\/span> <\/span><\/span> Page<<\/span>User><\/span> page =<\/span> new<\/span> Page<>(<\/span>1<\/span>,<\/span> 2<\/span>);<\/span> \/\/ 当前页，每页大小 <\/span><\/span><\/span><\/span> IPage<<\/span>User><\/span> userPage =<\/span> userMapper.<\/span>selectPage<\/span>(<\/span>page,<\/span> null<\/span>);<\/span> <\/span><\/span> System.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>"总页数: "<\/span> +<\/span> userPage.<\/span>getPages<\/span>());<\/span> <\/span><\/span> System.<\/span>out<\/span>.<\/span>println<\/span>(<\/span>"总记录数: "<\/span> +<\/span> userPage.<\/span>getTotal<\/span>());<\/span> <\/span><\/span> userPage.<\/span>getRecords<\/span>().<\/span>forEach<\/span>(<\/span>System.<\/span>out<\/span>::<\/span>println);<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>六、代码生成器<\/h2> 1. 添加依赖<\/h3> <dependency><\/span> <\/span><\/span> <groupId><\/span>com.baomidou<\/groupId><\/span> <\/span><\/span> <artifactId><\/span>mybatis-plus-generator<\/artifactId><\/span> <\/span><\/span> <version><\/span>3.5.1<\/version><\/span> <\/span><\/span><\/dependency><\/span> <\/span><\/span><dependency><\/span> <\/span><\/span> <groupId><\/span>org.freemarker<\/groupId><\/span> <\/span><\/span> <artifactId><\/span>freemarker<\/artifactId><\/span> <\/span><\/span> <version><\/span>2.3.31<\/version><\/span> <\/span><\/span><\/dependency><\/span> <\/span><\/span><\/code><\/pre>2. 代码生成器配置<\/h3> public<\/span> class<\/span> CodeGenerator<\/span> {<\/span> <\/span><\/span> public<\/span> static<\/span> void<\/span> main<\/span>(<\/span>String[]<\/span> args)<\/span> {<\/span> <\/span><\/span> \/\/ 代码生成器 <\/span><\/span><\/span><\/span> AutoGenerator mpg =<\/span> new<\/span> AutoGenerator();<\/span> <\/span><\/span> <\/span><\/span> \/\/ 全局配置 <\/span><\/span><\/span><\/span> GlobalConfig gc =<\/span> new<\/span> GlobalConfig();<\/span> <\/span><\/span> String projectPath =<\/span> System.<\/span>getProperty<\/span>(<\/span>"user.dir"<\/span>);<\/span> <\/span><\/span> gc.<\/span>setOutputDir<\/span>(<\/span>projectPath +<\/span> "\/src\/main\/java"<\/span>);<\/span> <\/span><\/span> gc.<\/span>setAuthor<\/span>(<\/span>"yourname"<\/span>);<\/span> <\/span><\/span> gc.<\/span>setOpen<\/span>(<\/span>false<\/span>);<\/span> <\/span><\/span> gc.<\/span>setSwagger2<\/span>(<\/span>true<\/span>);<\/span> <\/span><\/span> mpg.<\/span>setGlobalConfig<\/span>(<\/span>gc);<\/span> <\/span><\/span> <\/span><\/span> \/\/ 数据源配置 <\/span><\/span><\/span><\/span> DataSourceConfig dsc =<\/span> new<\/span> DataSourceConfig();<\/span> <\/span><\/span> dsc.<\/span>setUrl<\/span>(<\/span>"jdbc:mysql:\/\/localhost:3306\/mp_study?useSSL=false"<\/span>);<\/span> <\/span><\/span> dsc.<\/span>setDriverName<\/span>(<\/span>"com.mysql.cj.jdbc.Driver"<\/span>);<\/span> <\/span><\/span> dsc.<\/span>setUsername<\/span>(<\/span>"root"<\/span>);<\/span> <\/span><\/span> dsc.<\/span>setPassword<\/span>(<\/span>"1234"<\/span>);<\/span> <\/span><\/span> mpg.<\/span>setDataSource<\/span>(<\/span>dsc);<\/span> <\/span><\/span> <\/span><\/span> \/\/ 包配置 <\/span><\/span><\/span><\/span> PackageConfig pc =<\/span> new<\/span> PackageConfig();<\/span> <\/span><\/span> pc.<\/span>setParent<\/span>(<\/span>"com.example"<\/span>);<\/span> <\/span><\/span> pc.<\/span>setModuleName<\/span>(<\/span>"demo"<\/span>);<\/span> <\/span><\/span> mpg.<\/span>setPackageInfo<\/span>(<\/span>pc);<\/span> <\/span><\/span> <\/span><\/span> \/\/ 策略配置 <\/span><\/span><\/span><\/span> StrategyConfig strategy =<\/span> new<\/span> StrategyConfig();<\/span> <\/span><\/span> strategy.<\/span>setNaming<\/span>(<\/span>NamingStrategy.<\/span>underline_to_camel<\/span>);<\/span> <\/span><\/span> strategy.<\/span>setColumnNaming<\/span>(<\/span>NamingStrategy.<\/span>underline_to_camel<\/span>);<\/span> <\/span><\/span> strategy.<\/span>setEntityLombokModel<\/span>(<\/span>true<\/span>);<\/span> <\/span><\/span> strategy.<\/span>setRestControllerStyle<\/span>(<\/span>true<\/span>);<\/span> <\/span><\/span> strategy.<\/span>setInclude<\/span>(<\/span>"user"<\/span>);<\/span> \/\/ 表名 <\/span><\/span><\/span><\/span> strategy.<\/span>setControllerMappingHyphenStyle<\/span>(<\/span>true<\/span>);<\/span> <\/span><\/span> strategy.<\/span>setTablePrefix<\/span>(<\/span>pc.<\/span>getModuleName<\/span>()<\/span> +<\/span> "_"<\/span>);<\/span> <\/span><\/span> mpg.<\/span>setStrategy<\/span>(<\/span>strategy);<\/span> <\/span><\/span> <\/span><\/span> \/\/ 执行生成 <\/span><\/span><\/span><\/span> mpg.<\/span>execute<\/span>();<\/span> <\/span><\/span> }<\/span> <\/span><\/span>}<\/span> <\/span><\/span><\/code><\/pre>七、最佳实践<\/h2> 实体类设计<\/strong>：<\/p> 使用 Lombok 简化代码<\/li> 合理使用自动填充字段<\/li> 遵循 Java 命名规范<\/li> <\/ul> <\/li> Mapper 设计<\/strong>：<\/p> 继承 BaseMapper 获取基础 CRUD 能力<\/li> 自定义方法使用 @Mapper 注解<\/li> 复杂查询使用 XML 配置<\/li> <\/ul> <\/li> Service 设计<\/strong>：<\/p> 继承 IService 获取通用服务能力<\/li> 业务逻辑放在 Service 层<\/li> 事务管理使用 @Transactional<\/li> <\/ul> <\/li> 性能优化<\/strong>：<\/p> 合理使用索引<\/li> 避免全表扫描<\/li> 使用分页查询大数据集<\/li> 启用 SQL 日志分析慢查询<\/li> <\/ul> <\/li> 安全考虑<\/strong>：<\/p> 使用参数化查询防止 SQL 注入<\/li> 启用全表操作阻断插件<\/li> 敏感数据加密存储<\/li> <\/ul> <\/li> <\/ol> MyBatis-Plus 通过简化 CRUD 操作、提供丰富的功能插件和代码生成工具，可以显著提高开发效率。合理运用其特性，可以在保证性能的同时减少样板代码，让开发者更专注于业务逻辑的实现。<\/p>

MyBatis-Plus 全面教学指南<\/h1>

一、MyBatis-Plus 简介<\/h2>

1. 基本概念<\/h3> MyBatis-Plus (简称 MP) 是一个 MyBatis 的增强工具，在 MyBatis 的基础上只做增强不做改变，为简化开发、提高效率而生。<\/p>

二、快速入门<\/h2>

3. Spring Boot 工程创建<\/h3>

4. 基础代码编写<\/h3>

三、基本 CRUD 操作<\/h2>

2. 删除操作<\/h3>

4. 自动填充功能<\/h3>

5. 查询操作<\/h3>

四、通用 Service 封装<\/h2>

3. Service 使用示例<\/h3>

五、高级特性<\/h2>

六、代码生成器<\/h2>

1. 基本概念<\/h3>
MyBatis-Plus (简称 MP) 是一个 MyBatis 的增强工具，在 MyBatis 的基础上只做增强不做改变，为简化开发、提高效率而生。<\/p>