JSP

<%@ page errorPage="" %>
<tsx:dbconnect id="myDbConnection"
driver="COM.ibm.db2.jdbc.app.DB2Driver"
url="jdbc:db2:xxx"
userid="xxx"
passwd="xxx">
</tsx:dbconnect>
<tsx:dbquery connection="myDbConnection" id="Query000DBBean">
SELECT DISTINCT xx.code, xx.name FROM xx WHERE xx.TBLCD='xxx') ORDER BY 1</tsx:dbquery>
<CENTER>
<TABLE border="1">
<TBODY>
<TR>
<TH nowrap>TH</TH>
</TR>

<tsx:repeat>
<TR>
<TD nowrap><a href=#<tsx:getProperty name="Query000DBBean" property="code" />>
<tsx:getProperty name="Query000DBBean" property="name" /></a></TD>
</TR>
</tsx:repeat>
</TBODY>
</TABLE>
<br>

<tsx:repeat>
<P align="center"><a name=<tsx:getProperty name="Query000DBBean" property="code" /></a></P>
<TABLE border="1">
<TR>
<TH nowrap colspan="2"><tsx:getProperty name="Query000DBBean" property="name" /></TH>
</TR>
<TR>
<TH nowrap>code</TH>
<TH nowrap>name</TH>
</TR>

<tsx:dbquery connection="myDbConnection" id="Query100DBBean">
SELECT DISTINCT xx.code, xx.name FROM xx WHERE 
xx.code='<tsx:getProperty name="Query000DBBean" property="code" />' 
ORDER BY 1
</tsx:dbquery>

<tsx:repeat>
<TR>
<TD nowrap><tsx:getProperty name="Query100DBBean" property="code" /></TD>
<TD nowrap><tsx:getProperty name="Query100DBBean" property="name" /></TD>
</TR>
</tsx:repeat>

</TABLE>
<A href="javascript:history.back()">–ß‚é</A>
<br>
</tsx:repeat>