Chapter9 - Chapter13

9.事务
---9.1 事务边界和自动提交(Auto-commit)
------9.1.1 禁用自动提交模式
---9.2 事务隔离级别
------9.2.1 使用setTransactionIsolation方法
------9.2.2 性能考虑
---9.3 保存点(Savepoints)
------9.3.1 设置和回滚保存点
------9.3.2 释放(release)保存点
10.连接
---10.1 驱动程序分类
---10.2 Driver接口
-------10.2.1 加载一个实现了java.sql.Driver接口的驱动
---10.3 DriverManager类
-------10.3.1 SQLPermission类
---10.4 DataSource接口
-------10.4.1 DataSource属性
-------10.4.2 JNDI类库和应用移植能力(Application Portability)
-------10.4.3 用DataSource对象获得连接
11.连接池
---11.1 ConnectionPoolDataSource类和PooledConnection类
---11.2 连接事件
---11.3 三层架构中的连接池
---11.4 DataSource的实现和连接池
---11.5 部署
---11.6 用池连接(Pooled Connections)实现语句(Statement)重用
-------11.6.1 使用池语句(Pooled Statement)
-------11.6.2 关闭池语句
---11.7 ConnectionPoolDataSource类的属性
12.分布式事务
---12.1 基础设施
---12.2 XADataSource和XAConnection接口
-------12.2.1 部署一个XADataSource对象
-------12.2.2 获得一个连接
---12.3 XAResource接口
---12.4 事务管理
-------12.4.1 两阶段提交
---12.5 关闭连接
---12.6 XAResource接口的局限
13.语句(Statements)
---13.1 Statement接口
-------13.1.1 创建Statements
-------------13.1.1.1 设置ResultSet的相关特征
-------13.1.2 执行Statement
-------------13.1.2.1 返回ResultSet对象
-------------13.1.2.2 返回影响行数(Update Count)
-------------13.1.2.3 使用execute方法
-------13.1.3 关闭Statement
---13.2 PreparedStatement接口
-------13.2.1 创建PreparedStatement对象
-------------13.2.1.1 设置ResultSet的相关特征
-------13.2.2 参数设置
-------------13.2.2.1 类型转换
-------------13.2.2.2 本地字符集转换(National Character Set Conversions)
-------------13.2.2.3 使用setObject方法进行类型转换
-------------13.2.2.4 设置NULL参数
-------13.2.3 描述PreparedStatement的输出和输入
-------13.2.4 执行PreparedStatement
-------------13.2.4.1 返回ResultSet对象
-------------13.2.4.2 返回影响行数
-------------13.2.4.3 使用execute方法
---13.3 CallableStatement接口
-------13.3.1 创建CallableStatement对象
-------13.3.2 参数设置
-------------13.3.2.1 IN参数
-------------13.3.2.2 OUT参数
-------------13.3.2.3 INOUT参数
-------13.3.3 执行CallableStatement
-------------13.3.3.1 返回单个ResultSet对象
-------------13.3.3.2 返回影响行数
-------------13.3.3.3 返回Unknown或多个结果
---13.4 转义语法(Escape Syntax)
-------13.4.1 标量方法(Scalar Functions)
-------13.4.2 日期和时间字符串
-------13.4.3 外联结(Outer Joins)
-------13.4.4 存储过程
-------13.4.5 LIKE转义符
---13.5 性能提示(Hints)
---13.6 获取由数据库自动生成的关键字

英文原文：
9. Transactions 53
9.1 Transaction Boundaries and Auto-commit 53
9.1.1 Disabling Auto-commit Mode 54
9.2 Transaction Isolation Levels 55
9.2.1 Using the setTransactionIsolation Method 56
9.2.2 Performance Considerations 56
9.3 Savepoints 57
9.3.1 Setting and Rolling Back to a Savepoint 57
9.3.2 Releasing a Savepoint 58

10. Connections 59
10.1 Types of Drivers 60
10.2 The Driver Interface 60
10.2.1 Loading a driver that implements java.sql.Driver 61
10.3 The DriverManager Class 61
10.3.1 The SQLPermission Class 63
10.4 The DataSource Interface 63
10.4.1 DataSource Properties 64
10.4.2 The JNDI API and Application Portability 65
10.4.3 Getting a Connection with a DataSource Object 66

11. Connection Pooling 67
11.1 ConnectionPoolDataSource and PooledConnection 69
11.2 Connection Events 70
11.3 Connection Pooling in a Three-tier Environment 71
11.4 DataSource Implementations and Connection Pooling 72
11.5 Deployment 74
11.6 Reuse of Statements by Pooled Connections 75
11.6.1 Using a Pooled Statement 76
11.6.2 Closing a Pooled Statement 77
11.7 ConnectionPoolDataSource Properties 78

12. Distributed Transactions 81
12.1 Infrastructure 81
12.2 XADataSource and XAConnection 84
12.2.1 Deploying an XADataSource Object 85
12.2.2 Getting a Connection 86
12.3 XAResource 86
12.4 Transaction Management 87
12.4.1 Two-phase Commit 88
12.5 Closing the Connection 90
12.6 Limitations of the XAResource Interface 90

13. Statements 93
13.1 The Statement Interface 93
13.1.1 Creating Statements 93
13.1.1.1 Setting ResultSet Characteristics 94
13.1.2 Executing Statement Objects 94
13.1.2.1 Returning a ResultSet object 95
13.1.2.2 Returning an Update Count 95
13.1.2.3 Using the Method execute 95
13.1.3 Closing Statement Objects 96
13.2 The PreparedStatement Interface 97
13.2.1 Creating a PreparedStatement Object 97
13.2.1.1 Setting ResultSet Characteristics 97
13.2.2 Setting Parameters 98
13.2.2.1 Type Conversions 98
13.2.2.2 National Character Set Conversions 99
13.2.2.3 Type Conversions Using the Method setObject 99
13.2.2.4 Setting NULL Parameters 100
13.2.3 Describing Outputs and Inputs of a PreparedStatement
Object 101
13.2.4 Executing a PreparedStatement Object 102
13.2.4.1 Returning a ResultSet Object 102
13.2.4.2 Returning a Row Count 102
13.2.4.3 Using the Method execute 103
13.3 The CallableStatement Interface 103
13.3.1 Creating a CallableStatement Object 104
13.3.2 Setting Parameters 104
13.3.2.1 IN Parameters 105
13.3.2.2 OUT Parameters 105
13.3.2.3 INOUT Parameters 106
13.3.3 Executing a CallableStatement Object 106
13.3.3.1 Returning a Single ResultSet Object 107
13.3.3.2 Returning a Row Count 107
13.3.3.3 Returning Unknown or Multiple Results 107
13.4 Escape Syntax 109
13.4.1 Scalar Functions 110
13.4.2 Date and Time Literals 111
13.4.3 Outer Joins 111
13.4.4 Stored Procedures 112
13.4.5 LIKE Escape Characters 113
13.5 Performance Hints 113
13.6 Retrieving Auto Generated Keys 113

欢迎提出修改意见