iBATIS初学者必看学习资料文档格式.docx

iBATIS初学者必看学习资料文档格式.docx

《iBATIS初学者必看学习资料文档格式.docx》由会员分享，可在线阅读，更多相关《iBATIS初学者必看学习资料文档格式.docx（91页珍藏版）》请在冰点文库上搜索。

简介.................................................................................................................................................4

关于本文..................................................................................................................................4

SQLMaps（com.ibatis.sqlmap.*）......................................................................................................5

SQLMap的概念......................................................................................................................5

SQLMap如何工作？

..............................................................................................................5

安装SQLMaps........................................................................................................................6

JAR文件和依赖性...................................................................................................................6

从1.x版本升级........................................................................................................................7

是否应该升级...................................................................................................................7

转换XML配置文件（从1.x到2.0）...........................................................................7

使用新的JAR文件..........................................................................................................8

SQLMapXML配置文件..............................................................................................................10

<

properties>

元素....................................................................................................................11

setting>

元素.........................................................................................................................11

typeAlias>

元素.....................................................................................................................13

transactionManager>

元素....................................................................................................13

datasource>

元素...........................................................................................................14

sqlMap>

元素........................................................................................................................15

SQLMapXML映射文件..............................................................................................................17

MappedStatements.................................................................................................................18

Statement的类型............................................................................................................18

SQL语句.......................................................................................................................19

自动生成的主键.............................................................................................................20

存储过程.........................................................................................................................20

parameterClass................................................................................................................21

parameterMap.................................................................................................................21

InlineParameter简介.....................................................................................................22

resultClass......................................................................................................................22

resultMap.......................................................................................................................23

cacheModel.....................................................................................................................23

xmlResultName...............................................................................................................24

ParameterMap和InlineParameter......................................................................................24

parameter>

元素............................................................................................................25

InlineParameterMap......................................................................................................26

基本类型输入参数.........................................................................................................27

Map类型输入参数........................................................................................................28

ResultMap.............................................................................................................................28

隐式的ResultMap.........................................................................................................30

基本类型的Result（即String，Integer，Boolean）..................................................31

开发指南iBATISSQLMapsPage3of62

Map类型的Result.........................................................................................................31

复杂类型属性（即自定义类型的属性）.............................................................................32

避免N＋1Select（1:

1）.......................................................................................................33

延迟加载VS联合查询（1:

1）...................................................................................33

复杂类型集合的属性.............................................................................................................34

M和M:

N）........................................................................................34

组合键值或多个复杂参数属性.............................................................................................35

支持ParameterMap和ResultMap的数据类型..................................................................36

缓存MappedStatement结果集.............................................................................................36

只读VS可读写............................................................................................................37

Serializable可读写缓存.................................................................................................37

缓存类型.........................................................................................................................38

动态MappedStatement..........................................................................................................41

二元条件元素.................................................................................................................42

一元条件元素.................................................................................................................43

其他元素.........................................................................................................................43

简单的动态SQL元素...................................................................................................44

使用SQLMapAPI编程................................................................................................................46

配置SQLMap........................................................................................................................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：

查询成PaginatedList（select）.....................................................................53

例子9：

查询成Map（select）....................................................................................53

用JakartaCommonsLogging记录SQLMap日志......................................................................54

配置日志服务.........................................................................................................................54

JavaBean简易教程.......................................................................................................................56

Resources（mon.resource.*）...............................................................................58

SimpleDataSource（mon.jdbc.*）........................................................................60

ScriptRunner（mon.jdbc.*）.....................................................................................62

开发指南iBATISSQLMaps