73 lines
5.4 KiB
HTML
73 lines
5.4 KiB
HTML
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<!DOCTYPE html
|
||
|
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
||
|
|
<html lang="en-us" xml:lang="en-us">
|
||
|
|
<head>
|
||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<meta name="security" content="public" />
|
||
|
|
<meta name="Robots" content="index,follow" />
|
||
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
||
|
|
<meta name="DC.Type" content="concept" />
|
||
|
|
<meta name="DC.Title" content="ResultSets" />
|
||
|
|
<meta name="abstract" content="The ResultSet interface provides access to the results generated by running queries. Conceptually, data of a ResultSet can be thought of as a table with a specific number of columns and a specific number of rows. By default, the table rows are retrieved in sequence. Within a row, column values can be accessed in any order." />
|
||
|
|
<meta name="description" content="The ResultSet interface provides access to the results generated by running queries. Conceptually, data of a ResultSet can be thought of as a table with a specific number of columns and a specific number of rows. By default, the table rows are retrieved in sequence. Within a row, column values can be accessed in any order." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="jdbc.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rsltchar.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rsltcurs.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rsltdata.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rsltchng.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rsltclse.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="resultex.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="rsltsets" />
|
||
|
|
<meta name="DC.Language" content="en-us" />
|
||
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
|
<!-- US Government Users Restricted Rights -->
|
||
|
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
|
<title>ResultSets</title>
|
||
|
|
</head>
|
||
|
|
<body id="rsltsets"><a name="rsltsets"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">ResultSets</h1>
|
||
|
|
<div><p>The ResultSet interface provides access to the results generated
|
||
|
|
by running queries. Conceptually, data of a ResultSet can be thought of as
|
||
|
|
a table with a specific number of columns and a specific number of rows. By
|
||
|
|
default, the table rows are retrieved in sequence. Within a row, column values
|
||
|
|
can be accessed in any order.</p>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rsltchar.htm">ResultSet characteristics</a></strong><br />
|
||
|
|
This topic discusses ResultSet characteristics such ResultSet types, concurrency, ability to close the ResultSet by committing the connection object, and specification of ResultSet characteristics.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rsltcurs.htm">Cursor movement</a></strong><br />
|
||
|
|
The iSeries™ Java™ Database
|
||
|
|
Connectivity (JDBC) drivers support scrollable ResultSets. With a scrollable
|
||
|
|
ResultSet, you can process rows of data in any order using a number of cursor-positioning
|
||
|
|
methods.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rsltdata.htm">Retrieve ResultSet data</a></strong><br />
|
||
|
|
The ResultSet object provides several methods for obtaining column
|
||
|
|
data for a row. All are of the form get<<em>Type</em>>, where <<em>Type</em>>
|
||
|
|
is a Java™ data
|
||
|
|
type. Some examples of these methods include getInt, getLong, getString, getTimestamp,
|
||
|
|
and getBlob. Nearly all of these methods take a single parameter that is either
|
||
|
|
the column index within the ResultSet or the column name.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rsltchng.htm">Change ResultSets</a></strong><br />
|
||
|
|
With the iSeries™ JDBC drivers, you can change ResultSets by
|
||
|
|
performing several tasks.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rsltclse.htm">Create ResultSets</a></strong><br />
|
||
|
|
To create a ResultSet object, you can use executeQuery methods, or other methods. This article describes options for creating ResultSets.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="resultex.htm">Example: ResultSet interface for IBM Developer Kit for Java</a></strong><br />
|
||
|
|
This is an example of how to use the ResultSet interface.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="jdbc.htm" title="The IBM Developer Kit for Java JDBC driver, also known as the "native" driver, provides programmatic access to iSeries database files. Using the Java Database Connectivity (JDBC) API, applications written in the Java language can access JDBC database functions with embedded Structured Query Language (SQL), run SQL statements, retrieve results, and propagate changes back to the database. The JDBC API can also be used to interact with multiple data sources in a distributed, heterogeneous environment.">Access your iSeries database with the IBM Developer Kit for Java JDBC driver</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|