3.3.1 系统定义别名........................................................................................................................44
3.3.2 自定义别名............................................................................................................................47
3.4 typeHandler 类型处理器.............................................................................................................48
3.4.1 系统定义的typeHandler........................................................................................................49
3.4.2 自定义typeHandler................................................................................................................51
3.4.3 枚举类型typeHandler............................................................................................................55
3.5 ObjectFactory.................................................................................................................................62
3.6 插件..................................................................................................................................................65
3.7 environments 配置环境...............................................................................................................65
3.7.1 概述.......................................................................................................................................65
3.7.2 数据库事务............................................................................................................................66
3.7.3 数据源...................................................................................................................................67
3.8 databaseIdProvider 数据库厂商标识.......................................................................................68
3.8.1 使用系统默认规则................................................................................................................68
3.8.2 不使用系统默认规则............................................................................................................69
3.9 引入映射器的方法.......................................................................................................................71
第4 章 映射器..............................................................................................................................................73
4.1 映射器的主要元素.......................................................................................................................73
4.2 select 元素......................................................................................................................................74
4.2.1 概述.......................................................................................................................................74
4.2.2 简易数据类型的例子............................................................................................................75
4.2.3 自动映射...............................................................................................................................76
4.2.4 传递多个参数........................................................................................................................78
4.2.5 使用resultMap 映射结果集..................................................................................................81
4.3 insert 元素......................................................................................................................................82
4.3.1 概述.......................................................................................................................................82
4.3.2 主键回填和自定义................................................................................................................83
4.4 update 元素和delete 元素..........................................................................................................85
4.5 参数..................................................................................................................................................85
4.5.1 参数配置...............................................................................................................................86
4.5.2 存储过程支持........................................................................................................................86
4.5.3 特殊字符串替换和处理(#和$).........................................................................................87
4.6 sql 元素...........................................................................................................................................88
4.7 resultMap 结果映射集.................................................................................................................89
4.7.1 resultMap 元素的构成...........................................................................................................89
4.7.2 使用map 存储结果集............................................................................................................91
4.7.3 使用POJO 存储结果集.........................................................................................................91
4.7.4 级联.......................................................................................................................................92
4.8 缓存cache ....................................................................................................................................113
4.8.1 系统缓存(一级缓存和二级缓存)...................................................................................113
4.8.2 自定义缓存..........................................................................................................................117
第5 章 动态SQL ......................................................................................................................................119
5.1 概述................................................................................................................................................119
5.2 if 元素............................................................................................................................................120
5.3 choose、when、otherwise 元素..............................................................................................120
5.4 trim、where、set 元素..............................................................................................................121
5.5 foreach 元素.................................................................................................................................123
5.6 test 的属性....................................................................................................................................124
5.7 bind 元素.......................................................................................................................................125
第6 章 MyBatis 的解析和运行原理.....................................................................................................127
6.1 涉及的技术难点简介.................................................................................................................128
6.1.1 反射技术..............................................................................................................................129
6.1.2 JDK 动态代理......................................................................................................................130
6.1.3 CGLIB 动态代理.................................................................................................................133
6.2 构建SqlSessionFactory 过程...................................................................................................134
6.2.1 构建Configuration...............................................................................................................135
6.2.2 映射器的内部组成..............................................................................................................136
6.2.3 构建SqlSessionFactory........................................................................................................138
6.3 SqlSession 运行过程..................................................................................................................138
6.3.1 映射器的动态代理..............................................................................................................138
6.3.2 SqlSession 下的四大对象....................................................................................................142
6.3.3 SqlSession 运行总结............................................................................................................150
第7 章 插件.................................................................................................................................................152
7.1 插件接口.......................................................................................................................................152
7.2 插件的初始化..............................................................................................................................153
7.3 插件的代理和反射设计............................................................................................................154
7.4 常用的工具类——MetaObject................................................................................................157
7.5 插件开发过程和实例.................................................................................................................159
7.5.1 确定需要拦截的签名..........................................................................................................159
7.5.2 实现拦截方法......................................................................................................................161
7.5.3 配置和运行..........................................................................................................................162
7.5.4 插件实例..............................................................................................................................163
7.6 总结................................................................................................................................................166
第8 章 MyBatis-Spring...........................................................................................................................168
8.1 Spring 的基础知识......................................................................................................................168
8.1.1 Spring IOC 基础...................................................................................................................169
8.1.2 Spring AOP 基础..................................................................................................................171
8.1.3 Spring 事务管理...................................................................................................................173
8.1.4 Spring MVC 基础.................................................................................................................179
8.2 MyBatis-Spring 应用..................................................................................................................181
8.2.1 概述.....................................................................................................................................181
8.2.2 配置SqlSessionFactory........................................................................................................182
8.2.3 配置SqlSessionTemplate .....................................................................................................184
8.2.4 配置Mapper.........................................................................................................................188
8.2.5 配置事务..............................................................................................................................190
8.3 实例................................................................................................................................................191
8.3.1 环境准备..............................................................................................................................191
8.3.2 文件目录..............................................................................................................................193
8.3.3 Spring 配置文件...................................................................................................................194
8.3.4 MyBatis 框架相关配置........................................................................................................198
8.3.5 配置服务层..........................................................................................................................205
8.3.6 编写控制器..........................................................................................................................209
8.3.7 测试.....................................................................................................................................210
8.4 总结................................................................................................................................................210
第9 章 实用的场景...................................................................................................................................212
9.1 数据库BLOB 字段读写...........................................................................................................212
9.2 批量更新.......................................................................................................................................215
9.3 调用存储过程..............................................................................................................................217
9.3.1 存储过程in 和out 参数的使用..........................................................................................217
9.3.2 存储过程游标......................................................................................................................220
9.4 分表................................................................................................................................................225
9.5 分页................................................................................................................................................227
9.5.1 RowBounds 分页..................................................................................................................227
9.5.2 插件分页..............................................................................................................................229
9.6 上传文件到服务器.....................................................................................................................239
9.7 在映射中使用枚举.....................................................................................................................247
9.8 多对多级联..................................................................................................................................249
9.9 总结................................................................................................................................................253
附录A 数据库模型描述与级联学生关系建表语句.......................................................254