简介.................................................................................................................................................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
剩余61页未读,继续阅读
- 粉丝: 16
- 资源: 15
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
- 1
- 2
- 3
- 4
- 5
- 6
前往页