cmp5.html

j2eePDF格式的电子书

<a name="wp81537"> </a><div class="pSmartList2"><li>For the <code class="cCode">findByPositionAndName</code> method enter:</li></div>
<a name="wp81614"> </a><p class="pBodyRelative">
&nbsp;&nbsp;<code class="cCode">select distinct object(p) from Player p<br />&nbsp;&nbsp;where p.position = ?1 and p.name = ?2</code>
</p>
<a name="wp81542"> </a><div class="pSmartList2"><li>For the <code class="cCode">findBySalaryRange</code> method enter:</li></div>
<a name="wp81624"> </a><p class="pBodyRelative">
&nbsp;&nbsp;<code class="cCode">select distinct object(p) from Player p<br />&nbsp;&nbsp;where p.salary between ?1 and ?2</code>
</p>
<a name="wp81547"> </a><div class="pSmartList2"><li>For the <code class="cCode">findBySport</code> method enter:</li></div>
<a name="wp81631"> </a><p class="pBodyRelative">
&nbsp;&nbsp;<code class="cCode">select distinct object(p) from Player p,<br />&nbsp;&nbsp;in (p.teams) as t<br />&nbsp;&nbsp;where t.league.sport = ?1</code>
</p>
<a name="wp81559"> </a><div class="pSmartList2"><li>For the <code class="cCode">findByTest</code> method enter:</li></div>
<a name="wp81647"> </a><p class="pBodyRelative">
&nbsp;&nbsp;<code class="cCode">select distinct object(p) from Player p<br />&nbsp;&nbsp;where p.name = ?1</code>
</p>
<a name="wp81648"> </a><div class="pSmartList2"><li>For the <code class="cCode">findNotOnTeam</code> method enter:</li></div>
<a name="wp81653"> </a><p class="pBodyRelative">
&nbsp;&nbsp;<code class="cCode">select object(p) from Player p<br />&nbsp;&nbsp;where p.teams is empty</code>
</p>
</ol></div>
<a name="wp81696"> </a><div class="pSmartList1"><li>Select Select Methods:</li></div>
<div class="pSmartList2"><ol type="a" class="pSmartList2">
<a name="wp81702"> </a><div class="pSmartList2"><li>For the <code class="cCode">ejbSelectLeagues</code> method enter:</li></div>
<a name="wp81726"> </a><p class="pBodyRelative">
&nbsp;&nbsp;<code class="cCode">select distinct t.league<br />&nbsp;&nbsp;from Player p, in (p.teams) as t<br />&nbsp;&nbsp;where p = ?1</code>
</p>
<a name="wp81710"> </a><div class="pSmartList2"><li>For the <code class="cCode">ejbSelectSports</code> method enter:</li></div>
<a name="wp81742"> </a><p class="pBodyRelative">
&nbsp;&nbsp;<code class="cCode">select distinct t.league.sport<br />&nbsp;&nbsp;from Player p, in (p.teams) as t<br />&nbsp;&nbsp;where p = ?1</code>
</p>
<a name="wp82729"> </a><div class="pSmartList2"><li>Under Return EJBs of Type select None for <code class="cCode">ejbSelectSports</code>.</li></div>
</ol></div>
<a name="wp81718"> </a><div class="pSmartList1"><li>Click OK.</li></div>
<a name="wp82739"> </a><div class="pSmartList1"><li>Select File<span style="font-family: Symbol"><img src="images/arrwrite.gif" border="0" alt="Right Arrow"></span>Save.</li></div>
</ol></div>
<a name="wp82127"> </a><h4 class="pHeading3">
Creating the Field Mappings
</h4>
<div class="pSmartList1"><ol type="1" class="pSmartList1">
<a name="wp82128"> </a><div class="pSmartList1"><li>Select TeamJAR from the tree in deploytool.</li></div>
<a name="wp82129"> </a><div class="pSmartList1"><li>Select the General tabbed pane.</li></div>
<a name="wp82130"> </a><div class="pSmartList1"><li>Click Sun-specific Settings.</li></div>
<a name="wp82131"> </a><div class="pSmartList1"><li>In the Sun-specific Settings dialog:</li></div>
<div class="pSmartList2"><ol type="a" class="pSmartList2">
<a name="wp82132"> </a><div class="pSmartList2"><li>In the JNDI Name field enter <code class="cCode">jdbc/ejbTutorialDB</code>.</li></div>
<a name="wp82133"> </a><div class="pSmartList2"><li>Click Create Field Mappings.</li></div>
</ol></div>
<a name="wp82134"> </a><div class="pSmartList1"><li>In the Create Field Mappings dialog:</li></div>
<div class="pSmartList2"><ol type="a" class="pSmartList2">
<a name="wp82135"> </a><div class="pSmartList2"><li>Select Map to Tables in Database Schema File.</li></div>
<a name="wp82136"> </a><div class="pSmartList2"><li>Select <code class="cCode">cmproster.dbschema</code> under Database Schema Files in Module.</li></div>
<a name="wp82137"> </a><div class="pSmartList2"><li>Click OK.</li></div>
</ol></div>
<a name="wp82138"> </a><div class="pSmartList1"><li>You will be prompted with a dialog informing you that this will remove all current field mappings for the enterprise beans in TeamJAR. Click OK to continue. LeageEJB, PlayerEJB, and TeamEJB will have their fields automatically mapped to columns in the tables in the database resource <code class="cCode">jdbc/ejbTutorialDB</code>.</li></div>
<a name="wp82139"> </a><div class="pSmartList1"><li>Click Close.</li></div>
</ol></div>
<a name="wp81385"> </a><h4 class="pHeading3">
Establishing Relationships Between Enterprise Beans
</h4>
<a name="wp81113"> </a><p class="pBody">
To create the container-managed relationships between the enterprise beans, do the following:
</p>
<div class="pSmartList1"><ol type="1" class="pSmartList1">
<a name="wp81759"> </a><div class="pSmartList1"><li>Select TeamJAR in the tree in deploytool.</li></div>
<a name="wp81763"> </a><div class="pSmartList1"><li>Select the Relationships tabbed pane.</li></div>
<a name="wp81764"> </a><div class="pSmartList1"><li>Click Add.</li></div>
<a name="wp81765"> </a><div class="pSmartList1"><li>In the Add Relationship dialog:</li></div>
<div class="pSmartList2"><ol type="a" class="pSmartList2">
<a name="wp81766"> </a><div class="pSmartList2"><li>In the Multiplicity field select <code class="cCode">Many to Many (*:*)</code>.</li></div>
<a name="wp81770"> </a><div class="pSmartList2"><li>In the Enterprise Bean A section:</li></div>
<div class="pSmartList3"><ol type="1" class="pSmartList3">
<a name="wp81787"> </a><div class="pSmartList3"><li>In the Enterprise Bean Name field, select <code class="cCode">TeamEJB</code>.</li></div>
<a name="wp81791"> </a><div class="pSmartList3"><li>In the Field Referencing Bean B field, select <code class="cCode">players</code>.</li></div>
<a name="wp81804"> </a><div class="pSmartList3"><li>In the Field Type field, select <code class="cCode">java.util.Collection</code>.</li></div>
</ol></div>
<a name="wp81773"> </a><div class="pSmartList2"><li>In the Enterprise Bean B section:</li></div>
<div class="pSmartList3"><ol type="1" class="pSmartList3">
<a name="wp81798"> </a><div class="pSmartList3"><li>In the Enterprise Bean Name field, select <code class="cCode">PlayerEJB</code>.</li></div>
<a name="wp81803"> </a><div class="pSmartList3"><li>In the Field Referencing Bean A field, select <code class="cCode">teams</code>.</li></div>
<a name="wp81805"> </a><div class="pSmartList3"><li>In the Field Type field, select <code class="cCode">java.util.Collection</code>.</li></div>
</ol></div>
<a name="wp81781"> </a><div class="pSmartList2"><li>Click OK.</li></div>
</ol></div>
<a name="wp81835"> </a><div class="pSmartList1"><li>Click Add.</li></div>
<a name="wp81850"> </a><div class="pSmartList1"><li>In the Add Relationship dialog:</li></div>
<div class="pSmartList2"><ol type="a" class="pSmartList2">
<a name="wp81851"> </a><div class="pSmartList2"><li>In the Multiplicity field select <code class="cCode">One to Many (1:*)</code>.</li></div>
<a name="wp81852"> </a><div class="pSmartList2"><li>In the Enterprise Bean A section:</li></div>
<div class="pSmartList3"><ol type="1" class="pSmartList3">
<a name="wp81853"> </a><div class="pSmartList3"><li>In the Enterprise Bean Name field, select <code class="cCode">LeagueEJB</code>.</li></div>
<a name="wp81854"> </a><div class="pSmartList3"><li>In the Field Referencing Bean B field, select <code class="cCode">teams</code>.</li></div>
<a name="wp81855"> </a><div class="pSmartList3"><li>In the Field Type field, select <code class="cCode">java.util.Collection</code>.</li></div>
</ol></div>
<a name="wp81856"> </a><div class="pSmartList2"><li>In the Enterprise Bean B section:</li></div>
<div class="pSmartList3"><ol type="1" class="pSmartList3">
<a name="wp81857"> </a><div class="pSmartList3"><li>In the Enterprise Bean Name field, select <code class="cCode">TeamEJB</code>.</li></div>
<a name="wp81873"> </a><div class="pSmartList3"><li>In the Field Referencing Bean A field, select <code class="cCode">league</code>.</li></div>
<a name="wp82761"> </a><div class="pSmartList3"><li>Check Delete When Bean A Is Deleted.</li></div>
</ol></div>
<a name="wp81875"> </a><div class="pSmartList2"><li>Click OK.</li></div>
</ol></div>
</ol></div>
<a name="wp82142"> </a><h4 class="pHeading3">
Mapping the Container-Managed Relationship Fields
</h4>
<div class="pSmartList1"><ol type="1" class="pSmartList1">
<a name="wp82146"> </a><div class="pSmartList1"><li>Select TeamJAR in deploytool's tree.</li></div>
<a name="wp82438"> </a><div class="pSmartList1"><li>Select the Relationships tabbed pane.</li></div>
<a name="wp82439"> </a><div class="pSmartList1"><li>Click Sun-specific Settings.</li></div>
<a name="wp82440"> </a><div class="pSmartList1"><li>Under Persistent Field Mappings in the Enterprise Bean field select <code class="cCode">LeagueEJB</code>.</li></div>
<a name="wp82441"> </a><div class="pSmartList1"><li>In the Persistent Field Mapping table select the <code class="cCode">teams</code> row.</li></div>
<a name="wp82445"> </a><div class="pSmartList1"><li>Click the ellipses (<code class="cCode">...</code>) button after <code class="cCode">&lt;</code><code class="cVariable">unmapped relationship</code><code class="cCode">&gt;</code> to open the Map Relationship Field wizard.</li></div>
<a name="wp82446"> </a><div class="pSmartList1"><li>In the Map Relationship wizard:</li></div>
<div class="pSmartList2"><ol type="a" class="pSmartList2">
<a name="wp82456"> </a><div class="pSmartList2"><li>Select Link the Mapped Tables Directly.</li></div>
<a name="wp82460"> </a><div class="pSmartList2"><li>Click Next.</li></div>
<a name="wp82461"> </a><div class="pSmartList2"><li>Verify that under Key Column Pairs Local Column has the value <code class="cCode">LEAGUE.ID</code> and Foreign Column has the value <code class="cCode">TEAM.LEAGUE_ID</code>.</li></div>
<a name="wp82462"> </a><div class="pSmartList2"><li>Click Finish</li></div>
<a name="wp83190"> </a><p class="pBodyRelative">
Notice that TeamEJB's <code class="cCode">league</code> field was automatically mapped.
</p>
</ol></div>
<a name="wp82468"> </a><div class="pSmartList1"><li>Under Persistent Field Mappings in the Enterprise Bean field select <code class="cCode">PlayerEJB</code>.</li></div>
<a name="wp82472"> </a><div class="pSmartList1"><li>In the Persistent Field Mapping table select the <code class="cCode">teams</code> row.</li></div>
<a name="wp82476"> </a><div class="pSmartList1"><li>Click the ellipses (<code class="cCode">...</code>) button after <code class="cCode">&lt;</code><code class="cVariable">unmapped relationship</code><code class="cCode">&gt;</code> to open the Map Relationship Field wizard.</li></div>
<a name="wp82477"> </a><div class="pSmartList1"><li>In the Map Relationship wizard:</li></div>
<div class="pSmartList2"><ol type="a" class="pSmartList2">
<a name="wp82466"> </a><div class="pSmartList2"><li>Select Link the Mapped Tables Using a Join Table.</li></div>
<a name="wp82483"> </a><div class="pSmartList2"><li>Click Next.</li></div>
<a name="wp82484"> </a><div class="pSmartList2"><li>Verify that under Key Column Pairs Local Column has the value <code class="cCode">PLAYER.ID</code> and Join Table Column has the value <code class="cCode">TEAM_PLAYER.PLAYER_ID</code>.</li></div>
<a name="wp82495"> </a><div class="pSmartList2"><li>Click Next.</li></div>
<a name="wp82498"> </a><div class="pSmartList2"><li>Verify that under Key Column Pairs Join Table Column has the value <code class="cCode">TEAM_PLAYER.TEAM_ID</code> and Foreign Column has the value <code class="cCode">TEAM.ID</code>.</li></div>
<a name="wp82496"> </a><div class="pSmartList2"><li>Click Finish.</li></div>
</ol></div>
<a name="wp82526"> </a><div class="pSmartList1"><li>Click Close.</li></div>
</ol></div>
<a name="wp82341"> </a><h4 class="pHeading3">
Setting RosterEJB's Transaction Attributes
</h4>
<div class="pSmartList1"><ol type="1" class="pSmartList1">
<a name="wp82342"> </a><div class="pSmartList1"><li>Select RosterEJB in deploytool's tree.</li></div>
<a name="wp82343"> </a><div class="pSmartList1"><li>Click the Transactions tabbed pane.</li></div>
<a name="wp82344"> </a><div class="pSmartList1"><li>In the Transaction Management field click Container-Managed.</li></div>
</ol></div>
<a name="wp82345"> </a><h4 class="pHeading3">
Setting the Enterprise Bean References
</h4>
<a name="wp82777"> </a><p class="pBody">
First, you'll set the enterprise bean reference for <code class="cCode">ejb/SimpleLeague</code>.
</p>
<div class="pSmartList1"><ol type="1" class="pSmartList1">
<a name="wp82346"> </a><div class="pSmartList1"><li>Select RosterEJB in deploytool's tree.</li></div>
<a name="wp82347"> </a><div class="pSmartList1"><li>Click the EJB Refs tabbed pane.</li></div>
<a name="wp82348"> </a><div class="pSmartList1"><li>Click Add.</li></div>
<a name="wp82349"> </a><div class="pSmartList1"><li>In the Add Enterprise Bean Reference dialog:</li></div>