<?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="reference" />
<meta name="DC.Title" content="Example: Using RecordListRowData" />
<meta name="abstract" content="" />
<meta name="description" content="" />
<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="recdtout" />
<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>Example: Using RecordListRowData</title>
</head>
<body id="recdtout"><a name="recdtout"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Example: Using RecordListRowData</h1>
<div><p></p>
<div class="section"><p>This example has three parts:</p>
</div>
<div class="section"><ul><li> <a href="#recdtout__javarecordlistrowdata">Java™ source</a> that shows how the RecordListRowData
class works</li>
<li> <a href="#recdtout__htmlrecordlistrowdata">HTML source</a> generated
from the Java source by the using <a href="tablconv.htm#tablconv">HTMLTableConverter</a></li>
<li> <a href="#recdtout__displayrecordlistrowdata">How a browser displays
the generated HTML</a></li>
</ul>
</div>
<div class="section"><div class="p"><strong><span class="synph" id="recdtout__javarecordlistrowdata"><a name="recdtout__javarecordlistrowdata"><!-- --></a><span class="kwd"></span></span>Java source
that shows how the RecordListRowData class works</strong> <pre> // Create a server object.
AS400 mySystem = new AS400 ("mySystem.myComp.com", "UserId", "Password");
// Get the path name for the file.
QSYSObjectPathName file = new QSYSObjectPathName(myLibrary, myFile, "%first%", "mbr");
String ifspath = file.getPath();
// Create a file object that represents the file.
SequentialFile sf = new SequentialFile(mySystem, ifspath);
// Retrieve the record format from the file.
AS400FileRecordDescription recordDescription = new AS400FileRecordDescription(mySystem, ifspath);
RecordFormat recordFormat = recordDescription.retrieveRecordFormat()[0];
// Set the record format for the file.
sf.setRecordFormat(recordFormat);
// Get the records in the file.
Record[] records = sf.readAll();
// Create a RecordListRowData object and add the records.
RecordListRowData rowData = new RecordListRowData(recordFormat);
for (int i=0; i < records.length; i++)
{
rowData.addRow(records[i]);
}
// Create an HTML converter object and convert the rowData to HTML.
HTMLTableConverter conv = new HTMLTableConverter();
conv.setMaximumTableSize(3);
HTMLTable[] html = conv.convertToTables(rowData);
// Display the first HTML table generated by the converter.
System.out.println(html[0]);</pre>
<strong><span class="synph" id="recdtout__htmlrecordlistrowdata"><a name="recdtout__htmlrecordlistrowdata"><!-- --></a><span class="kwd"></span></span>HTML
source generated from the Java source by the using HTMLTableConverter</strong></div>
</div>
<div class="section"><p>Using the <a href="tablconv.htm#tablconv">HTMLTableConverter</a> class
in the Java source example above generates the following HTML
code.</p>
</div>
<div class="section"><div class="p"><pre><table>
<tr>
<th>CNUM</th>
<th>LNAM</th>
<th>INIT</th>
<th>STR</th>
<th>CTY</th>
<th>STATE</th>
<th>ZIP</th>
<th>CTLMT</th>
<th>CHGCOD</th>
<th>BDUE</th>
<th>CTDUE</th>
</tr>
<tr>
<td>938472</td>
<td>Henning </td>
<td>G K</td>
<td>4859 Elm Ave </td>
<td>Dallas</td>
<td>TX</td>
<td align="right">75217</td>
<td align="right">5000</td>
<td align="right">3</td>
<td align="right">37.00</td>
<td align="right">0.00</td>
</tr>
<tr>
<td>839283</td>
<td>Jones </td>
<td>B D</td>
<td>21B NW 135 St</td>
<td>Clay </td>
<td>NY</td>
<td align="right">13041</td>
<td align="right">400</td>
<td align="right">1</td>
<td align="right">100.00</td>
<td align="right">0.00</td>
</tr>
<tr>
<td>392859</td>
<td>Vine </td>
<td>S S</td>
<td>PO Box 79 </td>
<td>Broton</td>
<td>VT</td>
<td align="right">5046</td>
<td align="right">700</td>
<td align="right">1</td>
<td align="right">439.00</td>
<td align="right">0.00</td>
</tr>
</table></pre>
<strong><span class="synph" id="recdtout__displayrecordlistrowdata"><a name="recdtout__displayrecordlistrowdata"><!-- --></a><span class="kwd"></span></span>How
a browser displays the generated HTML</strong></div>
</div>
<div class="section"><p>The following table shows how the HTML source code looks when
viewed in a browser.</p>
</div>
<div class="section"><div class="p">
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" frame="void" border="0" rules="none"><thead align="left"><tr><th valign="top" width="5.769230769230769%" id="d0e94">CNUM</th>
<th valign="top" width="8.241758241758241%" id="d0e96">LNAM</th>
<th valign="top" width="5.21978021978022%" id="d0e98">INIT</th>
<th valign="top" width="16.208791208791208%" id="d0e100">STR</th>
<th valign="top" width="6.868131868131869%" id="d0e102">CTY</th>
<th valign="top" width="6.868131868131869%" id="d0e104">STATE</th>
<th valign="top" width="7.6923076923076925%" id="d0e106">ZIP</th>
<th align="right" valign="top" width="12.637362637362637%" id="d0e108">CTLMT</th>
<th valign="top" width="10.164835164835164%" id="d0e110">CHGCOD</th>
<th align="right" valign="top" width="9.89010989010989%" id="d0e112">BDUE</th>
<th align="right" valign="top" width="10.43956043956044%" id="d0e114">CTDUE</th>
</tr>
</thead>
<tbody><tr><td valign="top" width="5.769230769230769%" headers="d0e94 ">938472</td>
<td valign="top" width="8.241758241758241%" headers="d0e96 ">Henning</td>
<td valign="top" width="5.21978021978022%" headers="d0e98 ">G K</td>
<td valign="top" width="16.208791208791208%" headers="d0e100 ">4859 Elm Ave</td>
<td align="left" valign="top" width="6.868131868131869%" headers="d0e102 ">Dallas</td>
<td align="left" valign="top" width="6.868131868131869%" headers="d0e104 ">TX</td>
<td align="left" valign="top" width="7.6923076923076925%" headers="d0e106 ">75217</td>
<td align="right" valign="top" width="12.637362637362637%" headers="d0e108 ">5000</td>
<td align="center" valign="top" width="10.164835164835164%" headers="d0e110 ">3</td>
<td align="right" valign="top" width="9.89010989010989%" headers="d0e112 ">37.00</td>
<td align="right" valign="top" width="10.43956043956044%" headers="d0e114 ">0.00</td>
</tr>
<tr><td valign="top" width="5.769230769230769%" headers="d0e94 ">839283</td>
<td valign="top" width="8.241758241758241%" headers="d0e96 ">Jones</td>
<td valign="top" width="5.21978021978022%" headers="d0e98 ">B D</td>
<td valign="top" width="16.208791208791208%" headers="d0e100 ">21B NW 135 St</td>
<td align="left" valign="top" width="6.868131868131869%" headers="d0e102 ">Clay</td>
<td valign="top" width="6.868131868131869%" headers="d0e104 ">NY</td>
<td align="left" valign="top" width="7.6923076923076925%" headers="d0e106 ">13041</td>
<td align="right" valign="top" width="12.637362637362637%" headers="d0e108 ">400</td>
<td align="center" valign="top" width="10.164835164835164%" headers="d0e110 ">1</td>
<td align="right" valign="top" width="9.89010989010989%" headers="d0e112 ">100.00</td>
<td align="right" valign="top" width="10.43956043956044%" headers="d0e114 ">0.00</td>
</tr>
<tr><td valign="top" width="5.769230769230769%" headers="d0e94 ">392859</td>
<td valign="top" width="8.241758241758241%" headers="d0e96 ">Vine</td>
<td valign="top" width="5.21978021978022%" headers="d0e98 ">S S</td>
<td valign="top" width="16.208791208791208%" headers="d0e100 ">PO Box 79</td>
<td align="left" valign="top" width="6.868131868131869%" headers="d0e102 ">Broton</td>
<td valign="top" width="6.868131868131869%" headers="d0e104 ">VT</td>
<td align="left" valign="top" width="7.6923076923076925%" headers="d0e106 ">5046</td>
<td align="right" valign="top" width="12.637362637362637%" headers="d0e108 ">700</td>
<td align="center" valign="top" width="10.164835164835164%" headers="d0e110 ">1</td>
<td align="right" valign="top" width="9.89010989010989%" headers="d0e112 ">439.00</td>
<td align="right" valign="top" width="10.43956043956044%" headers="d0e114 ">0.00</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
</html>