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 Sun, 16 Feb 2003 15:41:40 GMT
Yes I want to enter into the database using a form

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:46 PM
Subject: Re: Tag List


> Are you trying to do an entry form that stores the data in the db?  Please
> clarify.
>
> As for Struts:  I am not familiar with those.  I am actually not that
> familiar with JSP itself.  That is why i decided to start with JSTL (it
> makes things easier).  Sorry.
>
> Eddie B.
>
> ----- Original Message -----
> From: "Scott Taylor" <scott.taylor@4i-dotcom.com>
> To: "Tag Libraries Users List" <taglibs-user@jakarta.apache.org>
> Sent: Friday, February 14, 2003 10:23 AM
> Subject: Re: Tag List
>
>
> > 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
>
>
> ---------------------------------------------------------------------
> 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