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 "PAZDZIOREK,LUKASZ (HP-Poland,ex1)" <lu...@hp.com> on 2003/08/06 12:14:03 UTC
DBTags Taglib
Hi Everybody,
I am trying to process web form and insert its values to the database using
DBTags.
This is what I am doing:
<%-- insert a row into the database --%>
<sql:preparedStatement id="stmt1" conn="conn">
<sql:query>
INSERT INTO CUSTOMER (CUST_PHONENO, CUST_NAME, CUST_SURNAME, CUST_TOWN,
CUST_EMAIL, CUST_USERNAME, CUST_PASSWORD, CUST_WWW_REGISTERED_DATE,
CUST_FK_CT_ID, CUST_FK_CS_ID) values (?,?,?,?,?,?,?,?,?,?)
</sql:query>
<sql:setColumn position="1">48<%=
CustomerBean.getPhone_no()%></sql:setColumn>
<sql:setColumn position="2"><%= CustomerBean.getName()%></sql:setColumn>
<sql:setColumn position="3"><%=
CustomerBean.getSurname()%></sql:setColumn>
<sql:setColumn position="4"><%= CustomerBean.getTown()%></sql:setColumn>
<sql:setColumn position="5"><%=
CustomerBean.getEmail()%></sql:setColumn>
<sql:setColumn position="6"><%=
CustomerBean.getLogin()%></sql:setColumn>
<sql:setColumn position="7"><%=
CustomerBean.getPasswd()%></sql:setColumn>
<sql:setColumn position="8"><%=
sqlDateTimeFormat_.format(Callendar_.getTime()) %> </sql:setColumn>
<sql:setColumn position="9">WWW</sql:setColumn>
<sql:setColumn position="10">ACTIVE</sql:setColumn>
<sql:execute/>
</sql:preparedStatement>
I have one problem: 3 fileds in the formcould be emtand I would like to live
these database fields set as NULL,
How can I do it? Is it possible to insert NULL value using
"preparedStatement" tag ?
thank you for your help.
regards,
lukas
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
Re: DBTags Taglib
Posted by Morgan Delagrange <md...@yahoo.com>.
If you are using a recent implementation of the
Servlet specification, you should use Apache's
implementation of the JSTL, not DBTags. DBTags has
been inactive since development on JSTL began, and it
should be considered deprecated for Servlet 2.3 or 2.4
containers.
- Morgan Delagrange
--- "PAZDZIOREK,LUKASZ (HP-Poland,ex1)"
<lu...@hp.com> wrote:
> Hi Everybody,
>
> I am trying to process web form and insert its
> values to the database using
> DBTags.
> This is what I am doing:
>
> <%-- insert a row into the database --%>
> <sql:preparedStatement id="stmt1" conn="conn">
> <sql:query>
> INSERT INTO CUSTOMER (CUST_PHONENO, CUST_NAME,
> CUST_SURNAME, CUST_TOWN,
> CUST_EMAIL, CUST_USERNAME, CUST_PASSWORD,
> CUST_WWW_REGISTERED_DATE,
> CUST_FK_CT_ID, CUST_FK_CS_ID) values
> (?,?,?,?,?,?,?,?,?,?)
> </sql:query>
> <sql:setColumn position="1">48<%=
> CustomerBean.getPhone_no()%></sql:setColumn>
> <sql:setColumn position="2"><%=
> CustomerBean.getName()%></sql:setColumn>
> <sql:setColumn position="3"><%=
> CustomerBean.getSurname()%></sql:setColumn>
> <sql:setColumn position="4"><%=
> CustomerBean.getTown()%></sql:setColumn>
> <sql:setColumn position="5"><%=
> CustomerBean.getEmail()%></sql:setColumn>
> <sql:setColumn position="6"><%=
> CustomerBean.getLogin()%></sql:setColumn>
> <sql:setColumn position="7"><%=
> CustomerBean.getPasswd()%></sql:setColumn>
> <sql:setColumn position="8"><%=
> sqlDateTimeFormat_.format(Callendar_.getTime()) %>
> </sql:setColumn>
> <sql:setColumn position="9">WWW</sql:setColumn>
> <sql:setColumn
> position="10">ACTIVE</sql:setColumn>
> <sql:execute/>
> </sql:preparedStatement>
>
> I have one problem: 3 fileds in the formcould be
> emtand I would like to live
> these database fields set as NULL,
> How can I do it? Is it possible to insert NULL value
> using
> "preparedStatement" tag ?
>
> thank you for your help.
>
> regards,
> lukas
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> taglibs-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> taglibs-user-help@jakarta.apache.org
>
=====
Morgan Delagrange
http://jakarta.apache.org/commons
http://axion.tigris.org
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
Re: DBTags Taglib
Posted by Morgan Delagrange <md...@yahoo.com>.
If you are using a recent implementation of the
Servlet specification, you should use Apache's
implementation of the JSTL, not DBTags. DBTags has
been inactive since development on JSTL began, and it
should be considered deprecated for Servlet 2.3 or 2.4
containers.
- Morgan Delagrange
--- "PAZDZIOREK,LUKASZ (HP-Poland,ex1)"
<lu...@hp.com> wrote:
> Hi Everybody,
>
> I am trying to process web form and insert its
> values to the database using
> DBTags.
> This is what I am doing:
>
> <%-- insert a row into the database --%>
> <sql:preparedStatement id="stmt1" conn="conn">
> <sql:query>
> INSERT INTO CUSTOMER (CUST_PHONENO, CUST_NAME,
> CUST_SURNAME, CUST_TOWN,
> CUST_EMAIL, CUST_USERNAME, CUST_PASSWORD,
> CUST_WWW_REGISTERED_DATE,
> CUST_FK_CT_ID, CUST_FK_CS_ID) values
> (?,?,?,?,?,?,?,?,?,?)
> </sql:query>
> <sql:setColumn position="1">48<%=
> CustomerBean.getPhone_no()%></sql:setColumn>
> <sql:setColumn position="2"><%=
> CustomerBean.getName()%></sql:setColumn>
> <sql:setColumn position="3"><%=
> CustomerBean.getSurname()%></sql:setColumn>
> <sql:setColumn position="4"><%=
> CustomerBean.getTown()%></sql:setColumn>
> <sql:setColumn position="5"><%=
> CustomerBean.getEmail()%></sql:setColumn>
> <sql:setColumn position="6"><%=
> CustomerBean.getLogin()%></sql:setColumn>
> <sql:setColumn position="7"><%=
> CustomerBean.getPasswd()%></sql:setColumn>
> <sql:setColumn position="8"><%=
> sqlDateTimeFormat_.format(Callendar_.getTime()) %>
> </sql:setColumn>
> <sql:setColumn position="9">WWW</sql:setColumn>
> <sql:setColumn
> position="10">ACTIVE</sql:setColumn>
> <sql:execute/>
> </sql:preparedStatement>
>
> I have one problem: 3 fileds in the formcould be
> emtand I would like to live
> these database fields set as NULL,
> How can I do it? Is it possible to insert NULL value
> using
> "preparedStatement" tag ?
>
> thank you for your help.
>
> regards,
> lukas
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> taglibs-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> taglibs-user-help@jakarta.apache.org
>
=====
Morgan Delagrange
http://jakarta.apache.org/commons
http://axion.tigris.org
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com