You are viewing a plain text version of this content. The canonical link for it is here.
Posted to taglibs-user@tomcat.apache.org by "Hughes, Matt" <ma...@merck.com> on 2002/06/03 17:23:46 UTC
Using Dynamic Variables as Attributes for Custom Tags...?
Ok, so I've got my nesting problem fixed (see below if interested) but I'm
still stuck on one thing. I've got three nested tables:
Company (primary key: company_id)
Addresses (primary key: address_id)
Contacts (primary key: contact_id)
So...for each company there could be multiple addresses, and with each
address there could be multiple contacts. My tags are set up as follows.
<ResultSet id="rs1" source="company" parameter="10001">
<ResultSet id="rs2" source="address" parameter="10001">
<ResultSet id="rs3" source="contact" parameter"">
As you can see I'm only selecting one company row on each page. The
parameter for address ResultSet is the same as company, since it's all the
addresses for that company. But the parameter for the contacts needs to be
dynamic. For each address it needs to list all the contacts underneath it,
so it needs to know the address_id of it's parent. Something like:
<ResultSet id="rs3" source="contact" parameter="<column
rs="rs2">address_id</column>">
This doesn't seem to work. Neither does just inserting regular variables
like
<ResultSet id="rs3" source="contact" parameter="<%= address_id %>">
The tags and JSP seem to be evaluated at the same time so everything I put
in quotes for the parameter stays in quotes. Any ideas?
-----Original Message-----
From: Hans Bergsten [mailto:hans@gefionsoftware.com]
Sent: Thursday, May 30, 2002 2:06 PM
To: Tag Libraries Users List
Subject: Re: Nested Tag Libraries
Just adding to what Shawn said, you may also want to try a joined
query instead of repeatedly accessing the database. It should be more
efficient in most databases. With the JSTL actions, you can then
take care of the display details when you render the table instead:
<sql:query var="addrs">
SELECT * FROM Names, Addresses, Phone
WHERE Names.Id = Addresses.Name_Id AND
Addresses.Id = Phone.Address_id
ORDER BY Names.Id, Addressed.Id
</sql:query>
<c:forEach items="$addrs.rows" var="current">
<c:if test="${name != current['Names.Id']}">
<c:set var="name" value="$current['Names.Id']}" />
Name: <c:out value="${current.name}" />
</c:if>
<c:if test="${address != current['Addresses.Id']}">
<c:set var="address" value="$current['Addresses.Id']}" />
Address: <c:out value="${current.address}" />
</c:if>
Phone: <c:out value="${current.phone}" />
</c:forEach>
Note that you may have to use an explicit column list in the SELECT
list instead of "*" and assign aliases to the Id columns in all tables,
and then adjust the names used in the rest of the example accordingly.
The syntax for aliases varies a bit between databases but many support
something like
SELECT Names.Id AS Names_Id, Addresses.Id AS Addresses_Id ...
Hans
Hughes, Matt wrote:
> Ok basically I want to do something really simple but I'm not exactly sure
> how to do it with tag libraries. I have three tables: name, address,
phone.
> Each name can have multiple addresses, and each address can have multiple
> phones. So using plain old jsp it would look something like:
>
> rs1 = "select * from names";
> while (rs1.next()) {
> rs2 = "select * from addresses where name_id = names.id";
> while(rs2.next()) {
> rs3 = "select * from phone where address_id = addresses.id";
> while (rs3.next()) {
> }
> }
> }
>
> So that the output would look something like:
>
> Matt Hughes
> Address 1
> Phone 1
> Phone 2
> Address 2
> etc...etc...
>
> Yeah, it's really very pseudocode, but I think it's understandable. So
I've
> created three generic tags: connection, resultset, and column. How do I
> recreate those kinds of nested while loops using tags. I almost want to
put
> the beginning of the while loop in the doStartTag and the end bracket in
the
> doEndTag...if only it were that easy. Any suggestions on how I could make
> the tags work to something like below:
>
> <Connection id="conn1">
> <resultset conn="conn1" id="rs1">
> <column rs="rs1">first_name</column>
> <resultset conn="conn1" id="rs2">
> <column rs="rs2">address_1</column>
> <resultset conn="conn1" id="rs3">
> <column rs="rs3">phone_1</column>
> </resultset>
> </resultset>
> </resultset>
> </connection>
>
>
> The other problem I'm having with this is how to pass the field_id from
the
> second table into the third tag. Ideally it should look something like:
>
> ...
> <resultset conn="conn1" id="rs3" QueryParameter="<resultset
> conn="conn1" id="rs2">field_id</resultset>
> <column rs="rs3">contact name</column>
> </resultset>
>
>
----------------------------------------------------------------------------
--
> Notice: This e-mail message, together with any attachments, contains
information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA) that
may be confidential, proprietary copyrighted and/or legally privileged, and
is intended solely for the use of the individual or entity named on this
message. If you are not the intended recipient, and have received this
message in error, please immediately return this by e-mail and then delete
it.
>
>
============================================================================
==
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
--
Hans Bergsten hans@gefionsoftware.com
Gefion Software http://www.gefionsoftware.com
JavaServer Pages http://TheJSPBook.com
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
------------------------------------------------------------------------------
Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA) that may be confidential, proprietary copyrighted and/or legally privileged, and is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please immediately return this by e-mail and then delete it.
==============================================================================
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Using Dynamic Variables as Attributes for Custom Tags...?
Posted by Paul DuBois <pa...@snake.net>.
At 11:23 -0400 6/3/02, Hughes, Matt wrote:
>Ok, so I've got my nesting problem fixed (see below if interested) but I'm
>still stuck on one thing. I've got three nested tables:
>
>Company (primary key: company_id)
> Addresses (primary key: address_id)
> Contacts (primary key: contact_id)
>
>So...for each company there could be multiple addresses, and with each
>address there could be multiple contacts. My tags are set up as follows.
>
><ResultSet id="rs1" source="company" parameter="10001">
> <ResultSet id="rs2" source="address" parameter="10001">
> <ResultSet id="rs3" source="contact" parameter"">
Do you actually use tags that look like this, or is this some kind of
pseudocode that you're using the describe what you're trying to do?
If the latter, and you're really using the JSTL tags to perform the
retrievals, note that the <sql:query> tag allows you to specify placeholders
with ? in the query string, and you can use <sql:param> tags to bind
values to the placeholders. You can use this fact in your inner queries
to refer to values retrieved by outer queries.
>
>As you can see I'm only selecting one company row on each page. The
>parameter for address ResultSet is the same as company, since it's all the
>addresses for that company. But the parameter for the contacts needs to be
>dynamic. For each address it needs to list all the contacts underneath it,
>so it needs to know the address_id of it's parent. Something like:
> <ResultSet id="rs3" source="contact" parameter="<column
>rs="rs2">address_id</column>">
>
>This doesn't seem to work. Neither does just inserting regular variables
>like
>
> <ResultSet id="rs3" source="contact" parameter="<%= address_id %>">
>
>The tags and JSP seem to be evaluated at the same time so everything I put
>in quotes for the parameter stays in quotes. Any ideas?
>
>
>-----Original Message-----
>From: Hans Bergsten [mailto:hans@gefionsoftware.com]
>Sent: Thursday, May 30, 2002 2:06 PM
>To: Tag Libraries Users List
>Subject: Re: Nested Tag Libraries
>
>
>Just adding to what Shawn said, you may also want to try a joined
>query instead of repeatedly accessing the database. It should be more
>efficient in most databases. With the JSTL actions, you can then
>take care of the display details when you render the table instead:
>
> <sql:query var="addrs">
> SELECT * FROM Names, Addresses, Phone
> WHERE Names.Id = Addresses.Name_Id AND
> Addresses.Id = Phone.Address_id
> ORDER BY Names.Id, Addressed.Id
> </sql:query>
>
> <c:forEach items="$addrs.rows" var="current">
> <c:if test="${name != current['Names.Id']}">
> <c:set var="name" value="$current['Names.Id']}" />
> Name: <c:out value="${current.name}" />
> </c:if>
> <c:if test="${address != current['Addresses.Id']}">
> <c:set var="address" value="$current['Addresses.Id']}" />
> Address: <c:out value="${current.address}" />
> </c:if>
> Phone: <c:out value="${current.phone}" />
> </c:forEach>
>
>Note that you may have to use an explicit column list in the SELECT
>list instead of "*" and assign aliases to the Id columns in all tables,
>and then adjust the names used in the rest of the example accordingly.
>The syntax for aliases varies a bit between databases but many support
>something like
>
> SELECT Names.Id AS Names_Id, Addresses.Id AS Addresses_Id ...
>
>Hans
>
>Hughes, Matt wrote:
>> Ok basically I want to do something really simple but I'm not exactly sure
>> how to do it with tag libraries. I have three tables: name, address,
>phone.
>> Each name can have multiple addresses, and each address can have multiple
>> phones. So using plain old jsp it would look something like:
>>
>> rs1 = "select * from names";
>> while (rs1.next()) {
>> rs2 = "select * from addresses where name_id = names.id";
>> while(rs2.next()) {
>> rs3 = "select * from phone where address_id = addresses.id";
>> while (rs3.next()) {
>> }
>> }
> > }
>>
>> So that the output would look something like:
>>
>> Matt Hughes
>> Address 1
>> Phone 1
>> Phone 2
>> Address 2
>> etc...etc...
>>
>> Yeah, it's really very pseudocode, but I think it's understandable. So
>I've
>> created three generic tags: connection, resultset, and column. How do I
>> recreate those kinds of nested while loops using tags. I almost want to
>put
>> the beginning of the while loop in the doStartTag and the end bracket in
>the
>> doEndTag...if only it were that easy. Any suggestions on how I could make
>> the tags work to something like below:
>>
>> <Connection id="conn1">
>> <resultset conn="conn1" id="rs1">
>> <column rs="rs1">first_name</column>
>> <resultset conn="conn1" id="rs2">
>> <column rs="rs2">address_1</column>
>> <resultset conn="conn1" id="rs3">
>> <column rs="rs3">phone_1</column>
>> </resultset>
>> </resultset>
>> </resultset>
>> </connection>
>>
>>
>> The other problem I'm having with this is how to pass the field_id from
>the
>> second table into the third tag. Ideally it should look something like:
>>
>> ...
>> <resultset conn="conn1" id="rs3" QueryParameter="<resultset
>> conn="conn1" id="rs2">field_id</resultset>
>> <column rs="rs3">contact name</column>
>> </resultset>
>>
>>
>----------------------------------------------------------------------------
>--
>> Notice: This e-mail message, together with any attachments, contains
>information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA) that
>may be confidential, proprietary copyrighted and/or legally privileged, and
>is intended solely for the use of the individual or entity named on this
>message. If you are not the intended recipient, and have received this
>message in error, please immediately return this by e-mail and then delete
>it.
>>
>>
>============================================================================
>==
>>
>>
>> --
>> To unsubscribe, e-mail:
><ma...@jakarta.apache.org>
>> For additional commands, e-mail:
><ma...@jakarta.apache.org>
>>
>
>
>--
>Hans Bergsten hans@gefionsoftware.com
>Gefion Software http://www.gefionsoftware.com
>JavaServer Pages http://TheJSPBook.com
>
>
>--
>To unsubscribe, e-mail:
><ma...@jakarta.apache.org>
>For additional commands, e-mail:
><ma...@jakarta.apache.org>
>
>
>------------------------------------------------------------------------------
>Notice: This e-mail message, together with any attachments, contains
>information of Merck & Co., Inc. (Whitehouse Station, New Jersey,
>USA) that may be confidential, proprietary copyrighted and/or
>legally privileged, and is intended solely for the use of the
>individual or entity named on this message. If you are not the
>intended recipient, and have received this message in error, please
>immediately return this by e-mail and then delete it.
>
>==============================================================================
>
>
>--
>To unsubscribe, e-mail: <ma...@jakarta.apache.org>
>For additional commands, e-mail: <ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>