tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eddie Barna" <eba...@purityinc.com>
Subject Re: Tag List
Date Fri, 14 Feb 2003 18:01:29 GMT
You can pass the value from your search form to the page which you have
listed in your email.  For example:  You have a search form with a text box
titled search

Here's what the page that queries the db would look like now

> <sql:query var="productQuery"  dataSource="${productDS}"  >
>         SELECT * FROM CD WHERE CDTITLE = ?
<sql:param value="${param.search}"/>
> </sql:query>
You can also expand on this by using the OR statement in your query.  For
example:

> <sql:query var="productQuery"  dataSource="${productDS}"  >
>         SELECT * FROM CD WHERE CDTITLE = ? OR ARTIST = ?
<sql:param value="${param.search}"/>
<sql:param value="${param.search}"/>
> </sql:query>

For every condition in your query you must add a <sql;param/> tag.

Hope this helps.  I really do recomend that you get Shawn Bayern's book
titled JSTL in Action.  It explains all this in great detail, plus
everything else.


----- Original Message -----
From: "Scott Taylor" <scott.taylor@4i-dotcom.com>
To: <taglibs-user@jakarta.apache.org>
Sent: Friday, February 14, 2003 9:31 AM
Subject: Tag List


> I am trying to find a list of tags to help me modify the CD Shop Cart web
> application from Sun One.
>
> For example, how do I insert tags that provide a search form (and entry
> form) rather than simply list everything.
>
> Here is what the code looks like so far:
>
> <%@page contentType="text/html"%>
> <html>
> <head><title>CD Catalog List</title></head>
> <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
> <%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>
> <body>
> <h1> CD Catalog List </h1>
> <sql:setDataSource var="productDS"
>        url="jdbc:postgresql://localhost:5432/recruitment"
>        driver="org.postgresql.Driver"
>        user="scott" password="" />
>
> <sql:query var="productQuery"  dataSource="${productDS}"  >
>         SELECT * FROM CD
> </sql:query>
>
> <TABLE border=1>
>   <TR>
>     <TH>ID</TH>
>     <TH>CD Title</TH>
>     <TH>Artist</TH>
>     <TH>Country</TH>
>     <TH>Price</TH>
>   </TR>
>
> <c:forEach var="row" items="${productQuery.rows}">
>   <TR>
>     <TD><c:out value="${row.ID}"/></TD>
>     <TD><c:out value="${row.CDTITLE}"/></TD>
>     <TD><c:out value="${row.ARTIST}"/></TD>
>     <TD><c:out value="${row.COUNTRY}"/></TD>
>     <TD><c:out value="${row.PRICE}"/></TD>
>     <TD>
>     <form method=get action="ShopCart.jsp">
>       <input type=hidden name=cdId value="<c:out value="${row.ID}"/>">
>       <input type=hidden name=cdTitle value="<c:out
> value="${row.CDTITLE}"/>">
>       <input type=hidden name=cdPrice value="<c:out
value="${row.PRICE}"/>">
>       <input type=submit name=operation value=Add>
>     </form>
>     </TD>
>   </TR>
> </c:forEach>
> </TABLE>
> </body>
> </html>
>
> Regards
>
> Scott
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: taglibs-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org


Mime
View raw message