简介.................................................................................................................................................4
关于本文..................................................................................................................................4
SQL Maps (com.
ibatis.sqlmap.*)......................................................................................................5
SQL Map的概念......................................................................................................................5
SQL Map如何工作？..............................................................................................................5
安装SQL Maps........................................................................................................................6
JAR文件和依赖性...................................................................................................................6
从1.x版本升级........................................................................................................................7
是否应该升级...................................................................................................................7
转换XML配置文件（从1.x到2.0）...........................................................................7
使用新的JAR文件..........................................................................................................8
SQL Map XML配置文件..............................................................................................................10
<properties>元素....................................................................................................................11
<setting>元素.........................................................................................................................11
<typeAlias>元素.....................................................................................................................13
<transactionManager>元素....................................................................................................13
<datasource>元素...........................................................................................................14
<sqlMap>元素........................................................................................................................15
SQL Map XML映射文件..............................................................................................................17
Mapped Statements.................................................................................................................18
Statement的类型............................................................................................................18
SQL 语句.......................................................................................................................19
自动生成的主键.............................................................................................................20
存储过程.........................................................................................................................20
parameterClass................................................................................................................21
parameterMap.................................................................................................................21
Inline Parameter简介.....................................................................................................22
resultClass......................................................................................................................22
resultMap.......................................................................................................................23
cacheModel.....................................................................................................................23
xmlResultName...............................................................................................................24
Parameter Map 和 Inline Parameter......................................................................................24
<parameter>元素............................................................................................................25
Inline Parameter Map......................................................................................................26
基本类型输入参数.........................................................................................................27
Map类型输入参数........................................................................................................28
Result Map.............................................................................................................................28
隐式的Result Map.........................................................................................................30
基本类型的Result（即String，Integer，Boolean）..................................................31
http://www.
ibatis.com Clinton Begin 著 刘涛(toleu@21cn.com) 译
开发指南
iBATIS SQL Maps Page 3 of 62
Map类型的Result.........................................................................................................31
复杂类型属性（即自定义类型的属性）.............................................................................32
避免N＋1 Select（1:1）.......................................................................................................33
延迟加载 VS 联合查询（1:1）...................................................................................33
复杂类型集合的属性.............................................................................................................34
避免N＋1 Select（1:M和M:N）........................................................................................34
组合键值或多个复杂参数属性.............................................................................................35
支持Parameter Map和Result Map的数据类型..................................................................36
缓存Mapped Statement结果集.............................................................................................36
只读 VS 可读写............................................................................................................37
Serializable可读写缓存.................................................................................................37
缓存类型.........................................................................................................................38
动态Mapped Statement..........................................................................................................41
二元条件元素.................................................................................................................42
一元条件元素.................................................................................................................43
其他元素.........................................................................................................................43
简单的动态SQL元素...................................................................................................44
使用SQL Map API编程................................................................................................................46
配置SQL Map........................................................................................................................46
事务处理................................................................................................................................46
自动的事务处理.............................................................................................................47
全局（分布式）事务.....................................................................................................48
批处理....................................................................................................................................49
用SqlMapClient执行SQL语句...........................................................................................49
代码例子................................................................................................................................52
例子1：执行update（insert，update，delete）.........................................................52
例子2：查询成对象（select）.....................................................................................52
例子3：用预赋值的结果对象查询成对象（select）.................................................52
例子4：查询成对象List（select）..............................................................................52
例子5：自动提交..........................................................................................................53
例子6：用结果集边界查询成对象List（select）......................................................53
例子7：用RowHandler执行查询（select）..............................................................53
例子8：查询成Paginated List（select）.....................................................................53
例子9：查询成Map（select）....................................................................................53
用Jakarta Commons Logging记录SQL Map日志......................................................................54
配置日志服务.........................................................................................................................54
Java Bean简易教程.......................................................................................................................56
Resources（com.
ibatis.common.resource.*）...............................................................................58
SimpleDataSource（com.
ibatis.common.jdbc.*）........................................................................60
ScriptRunner (com.
ibatis.common.jdbc.*).....................................................................................62
扫一扫
4099
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
