ResultSet processing in functional flavor (select3.jy)
函数风格的结果集处理（select3.jy）
Use RowSet which in JDBC expand package to cache ResultSet;
使用JDBC扩展包中的行集来缓存结果集；
Obviously, a stored procedure doesn't have to return a resultset.
显然，存储过程不一定非要返回结果集。
Each value retrieved via the enumerator should correspond with one row of the resultset.
通过枚举器检索的每个值都应与结果集的一行对应。
The code snippet in Listing 4 shows the SQL query used as the basis for creating a ResultSet.
列表4中的代码片段显示了一段SQL查询，该SQL查询是建立ResultSet的基础。
JDK 6.0 also provides updater methods in the ResultSet interface to update SQLXML values.
JD K 6.0 Beta还在ResultSet接口中提供了一些updater方法来更新sqlxml值。
In our case, the business logic is maintained directly in the SIAPI Query and ResultSet objects.
本例中，业务逻辑是直接在SIAPIQuery和ResultSet对象中维护的。
Using an updateable ResultSet, this process is relatively straightforward, as shown in Listing 3.
使用可更新的 ResultSet，这个过程是相对简单的，如清单 3 所示。
For example, the ResultSet returns six fields and only the 1, 4, 6 are used by this CMP EJB bean.
例如，ResultSet返回6个字段，只有1、4、6供这个CMPEJBbean使用。
The key concept is the introduction of a new, special row in the ResultSet, called the insert row.
主要思想是把一个特殊的新行引入到ResultSet中，称为insert row。
The ResultSet interface provides a number of techniques for accessing the data returned from your query.
ResultSet接口提供了大量技术，可用于访问查询返回的数据。
The SQL statement was then used to create a resultset, which was used to write the appropriate data to DB2.
然后使用该sql语句来创建结果集，该结果集用于将适当的数据写到DB2。
This returns a resultset object, and you need the first value returned by this process to get the new unique ID.
这将返回一个resultset对象，您需要这个过程所返回的第一个值，以获得新的唯一的ID。
This is necessary, because any previous warnings on a ResultSet are cleared each time a new row is accessed.
这是必要的，因为每次访问一个新行都会清除以前所有关于ResultSet的警告。
Underneath, you can visualize a JDBC ResultSet object being returned and its contents being passed into a for loop.
在底层，您可以看到返回了JDBCResultSet对象，它的内容被传递进for循环。
Although you won't do so in this article, if you re-execute a JDBC query, any underlying ResultSet object is reused.
虽然在本文中您不会这样做，但是如果要重新执行JDBC查询，则将重用所有底层ResultSet对象。
In this example, that's before the first row, so a call to the next method retrieves the first row in the ResultSet.
在本例中，那是在第一行之前，因此调用next方法将检索到ResultSet中的第一行。
An inner class has been implemented for query (lines 31-44) to map returned the ResultSet object to the User object.
为查询实现了一个内部类(31 - 44行)以将ResultSet对象映射到User对象。
This will re-populate the resultset in the DataSet, so the contents of the DataGrid will automatically be updated.
这将重新填充DataSet中的结果集，因此DataGrid的内容将自动更新。
This is ideal when the entire resultset is not actually required, since it more effectively uses the available memory.
当实际上并不需要整个结果集时，这将是理想的，因为它能够更有效地使用可用内存。
Retrieve a list of all your queues, which returns a resultset object that is essentially a Python list, as shown in Listing 6.
获取所有队列的列表，这返回一个结果集对象，它实际上是一个Python列表，见清单6。
Unlike the standard JDBC 2.0 ResultSet, with the CachedRowSet, the continuous use of a database connection is not required.
与标准JDBC 2.0ResultSet不一样，利用CachedRowSet不再需要连续使用数据库连接。
In an EJB finder, the return value is a ResultSet, but it has a different number of fields than in the current CMP EJB component.
在EJB查找程序中，返回值是ResultSet，但是与当前的CMPEJ b组件相比，字段的数量不同。
As you may imagine, a common business need is to modify specific column values as you iterate through the rows in a ResultSet.
正如您想象的那样，常见的业务需求是在循环访问ResultSet中的行时修改特定的列值。
You can populate a CachedRowSet using either an existing ResultSet object or by specifying connection information and an SQL query.
您可以通过使用现有的ResultSet对象，或者通过指定连接连接信息和SQL查询，来填充CachedRowSet。
After performing our offline Join, we can see the data in our JoinRowSet object using getter methods like we do with ResultSet objects.
在执行离线join之后，我们可以像使用ResultSet对象一样，通过getter方法查看JoinRowSet对象中的数据。
The ResultSet allows you to iterate over each QuerySolution returned by the query, providing access to each bound variable's value.
ResultSet支持在查询返回的每个QuerySolution上进行迭代，这提供了对每个绑定变量值的访问。
Then we can populate the new row using update methods given to us by our parent (or more appropriately, our grandparent) ResultSet interface.
然后，我们可以用“父（更确切地说是‘祖父’）ResultSet接口”给予我们的更新方法来填充新行。
A limitation of the JDBC 2 specification is that statements that return multiple results must have only one ResultSet open at any given time.
JDBC2规范的一个局限是，在任意时刻，返回多重结果的语句只能打开一个ResultSet。
A limitation of the JDBC 2 specification is that statements that return multiple results must have only one ResultSet open at any given time.
JDBC2规范的一个局限是，在任意时刻，返回多重结果的语句只能打开一个ResultSet。
应用推荐