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 "Weßling, Achim" <Ac...@gt-net.de> on 2001/03/22 16:53:40 UTC
validation problem in JSP
Hallo,
I did the following code. My problem is marked with '*'. How can I validate
the value of <infokomGT:rowCount/> (jdbc:rowCount) with '1' so that my
condition-tag gets the body-value 'true' or 'false'?
<%@page contentType="text/html"%>
<%@ taglib uri="/infokomGT" prefix="infokomGT" %>
<html>
<head><title>User Validation</title></head>
<body>
<h1>Validation</h1>
<br>Diese Werte wurden eingegeben:
<br>
Benutzername: <infokomGT:parameter name="user" />
<br>
Passwort: <infokomGT:parameter name="pw" />
<%-- Open Database Connection --%>
<infokomGT:connection id="con1">
<infokomGT:url>jdbc:odbc:user</infokomGT:url>
<infokomGT:driver>sun.jdbc.odbc.JdbcOdbcDriver</infokomGT:driver>
</infokomGT:connection>
<%-- Open Database --%>
<infokomGT:statement id="stmt1" conn="con1">
<infokomGT:query>
SELECT FirstName, LastName, Anrede, Typ
FROM User
WHERE UserName LIKE '<infokomGT:parameter name="user" />'
AND Kennwort LIKE '<infokomGT:parameter name="pw" />'
</infokomGT:query>
<%-- loop through the rows of query --%>
<infokomGT:resultSet id="rs1">
<infokomGT:wasNotEmpty>
<infokomGT:if>
****************************************************************************
*********************************
<infokomGT:condition><%= <infokomGT:rowCount/> == 1
%></infokomGT:condition>
****************************************************************************
*********************************
<infokomGT:then>
<br>Allright, you did it!
</infokomGT:then>
</infokomGT:if>
</infokomGT:wasNotEmpty>
</infokomGT:resultSet>
<infokomGT:wasEmpty>
<br>Sorry, but you did something wrong!
</infokomGT:wasEmpty>
</infokomGT:statement>
<%-- close Database Connection --%>
<infokomGT:closeConnection conn="con1"/>
</body>
</html>
Mit freundlichem Gruß
Achim Weßling
**************************************************************************
INFOKOM Gütersloh
Fachbereich Technische Anwendungen / Zentrale Anwendungen
Tel.: 05241/85-2926
Achim.Wessling@gt-net.de
http://www.infokom-gt.de/produkte/gis/index.htm
_\|/_
(o o)
---oOO-{_}-OOo---