Once again you can use the sql tags available in the Standard tag library.
You can populate a bean like this:

 <sql:update var="newTable">
   create table mytable (
     nameid int primary key,
     name varchar(80)
    )
  </sql:update>

 <sql:query var="resultSet">
   SELECT * FROM mytable
 </sql:query>

  <c:forEach var="row" items="${resultSet.rowsByIndex}">
    <jsp:useBean id="mybean" class="mybean" scope="request"/>
       <jsp:setProperty name="mybean" property="nameId"
value="<%=row[0]%>"/>
       <jsp:setProperty name="mybean" property="name" value="<%=row[1]%>"/>
  </c:forEach>

Justy


----- Original Message -----
From: "Soefara Redzuan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 11, 2002 6:06 AM
Subject: can output of dbtags query be used to fill javabean properties ?


> Sorry I have another question. I have a form that sets the default values
of
> the fields with a javabean like this
>
> <jsp:useBean id="mybean" class="mybean" scope="request">
>
> <form>
> First name is <input type="text" name="firstname"
> value="<%=mybean.getFirstname()%>">
>
> Last name is <input type="text" name="lastname"
> value="<%=mybean.getLastname()%>">
> </form>
>
> This fills default field values if the parameters are submitted in the
> request otherwise it makes the fields blank "".
>
> But how can I set the values of the bean properties from the SQL result
> returned from the dbtags query ?
>
> For example I would like to loop through the results of a sql:query and
set
> or create a javabean each time.
>
> <sql:statement id="stmt1" conn="conn1">
>   <sql:query>
>     select * from members
>   </sql:query>
>   <%-- loop through the rows and create a bean each time --%>
>   <jsp:useBean id="resultbean" class="mybean">
>   <sql:resultSet id="rset2">
>     First name is <input type="text" name="firstname"
> value="<%=resultbean.getFirstname()%>">
>     Last name is <input type="text" name="lastname"
> value="<%=resultbean.getLastname()%>">
>   </sql:resultSet>
> </sql:statement>
>
> Is something like this possible ?
>
> Thank you, Soefara
>
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to