You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Mallik <ma...@yahoo.com> on 2006/11/18 08:37:06 UTC
help?
Hi friends
this is my situation:
here i am going do app for a college, there may be any no of colleges and
each college may have any no of blocks.
i have a jsp where i display all the details of blocks in row wise(this is a
view block details page) and there will be some provision to modify any row(
means that block details).
>From there i transfer to blocksModify page in which she can modify any
details.
Problem is:
My modify blocks form has some text boxes and some select bokes
i am getting the text box values,but for the select box the all ready
assiged college name should display from the rest of the options . i am not
getting this
i am using the same form bean for both listing college details in select box
and displaying the rest of the details
this is my modify antion class
-----------------------------------------------------------------------------------
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) throws Exception
{
String id = request.getParameter("id");
if(id==null)
return mapping.findForward("accessDenied");
String query = null;
BlocksForm block = null;
try
{
ds = getDataSource(request);
conn = ds.getConnection();
stmt = conn.createStatement();
}catch(SQLException e)
{
e.printStackTrace();
return mapping.findForward("sqlException");
}
try
{
query = "SELECT COLLEGEID,SHORTDESCRIPTION FROM COLLEGES";
rs = stmt.executeQuery(query);
colleges = new ArrayList();
if(rs.next())
{
do
{
block = new BlocksForm();
block.setCollege(rs.getString("COLLEGEID"));
block.setCollegeShortDesc(rs.getString("SHORTDESCRIPTION"));
colleges.add(block);
}while(rs.next());
}
request.getSession().setAttribute("COLLEGES",colleges);
query = "SELECT UNIQUE BLOCKID, SHORTDESCRIPTION, DESCRIPTION, ADDRESS,
PHONE, COLLEGEID FROM BLOCKS WHERE BLOCKID='"+id+"' ORDER BY
SHORTDESCRIPTION";
rs = stmt.executeQuery(query);
blocks = new ArrayList();
if(rs.next())
{
block = new BlocksForm();
block.setId(rs.getString("BLOCKID"));
block.setShortDesc(rs.getString("SHORTDESCRIPTION"));
block.setDesc(rs.getString("DESCRIPTION"));
block.setLocation(rs.getString("ADDRESS"));
block.setPhoneNo(rs.getString("PHONE"));
block.setCollege(rs.getString("COLLEGEID"));
blocks.add(block);
}else
{
return mapping.findForward("noCollegeSetup");
}
}catch(Exception e)
{
e.printStackTrace();
return mapping.findForward("exception");
}finally
{
if(conn!=null)
conn.close();
}
request.getSession().setAttribute("BLOCKS", blocks);
return mapping.findForward("continue");
}
-------------------------------------------------------------------------------------------------------------
this is my modify jsp page
-------------------------------------------------------------------------------------------------------------
<html:errors/>
<table id="blocksTable" width="600" class="tableborder1"
cellspacing="2" >
<tr>
<td colspan="5" class="heading"><bean:message
key="subheading.blocksDetails"/></td>
</tr>
<logic:iterate id="blocks" name="BLOCKS">
<tr>
<td class="rightsubheading1"><bean:message key="label.id"/></td>
<td class="leftsubheading1"><html:text name="blocks" property="id"
styleClass="formtext10"/></td>
</tr>
<tr>
<td class="rightsubheading1"><bean:message
key="label.shortDesc"/></td>
<td class="leftsubheading1"><html:text name="blocks"
property="shortDesc" styleClass="formtext10"/></td>
</tr>
<tr>
<td class="rightsubheading1"><bean:message key="label.desc"/></td>
<td class="leftsubheading1">
<html:textarea property="desc" name="blocks" cols="62"
rows="4"></html:textarea>
</td>
</tr>
<tr>
<td class="rightsubheading1"><bean:message
key="label.location"/></td>
<td class="leftsubheading1"><html:text name="blocks"
property="location" styleClass="formtext15"/></td>
</tr>
<tr>
<td class="rightsubheading1"><bean:message
key="label.phoneNo"/></td>
<td class="leftsubheading1"><html:text name="blocks"
property="phoneNo" styleClass="formtext15"/></td>
</tr>
<tr>
<td class="rightsubheading1"><bean:message
key="label.college"/></td>
<td class="leftsubheading1">
<bean:define id="colleges" name="COLLEGES" scope="session" />
<html:select property="college" styleClass="formlist1">
<html:option value="">Select</html:option>
<html:options collection="colleges" property="college"
labelProperty="collegeShortDesc"/>
</html:select>
</td>
</tr>
</logic:iterate>
<tr>
<td class="centersubheading1"><html:button property="cancel"
value="Cancel" onclick="javaScript:history.go(-1);"/></td>
<td class="centersubheading1"><html:submit property="update"
value="Update"/></td>
</tr>
</table>
-----------------------------------------------------------------------------------------------------------------------------------
let me know where i did worng or how to handle this
help me please
ur's
Mallik
--
View this message in context: http://www.nabble.com/%3Cbean%3Adefine%3E-help--tf2658641.html#a7415847
Sent from the Struts - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org