tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scott Taylor" <scott.tay...@4i-dotcom.com>
Subject Re: Tag List
Date Fri, 14 Feb 2003 18:23:06 GMT
Thanks...how about an entry form?

Also, if I want to do JSP's easier are Struts better?

I will get the book though

Thanks

Scott


----- Original Message -----
From: "Eddie Barna" <ebarna@purityinc.com>
To: "Tag Libraries Users List" <taglibs-user@jakarta.apache.org>
Sent: Friday, February 14, 2003 6:01 PM
Subject: Re: Tag List


> 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
>


---------------------------------------------------------------------
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