You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by "kaushal.sharma" <ka...@gmail.com> on 2009/10/04 13:40:22 UTC
Need immediate help - Struts, my job is stuck
Hi,
Sorry to be late here, but i need an immediate help. I am new to struts and
recently put into a struts project.
FYI
I have a jsp file, where I am getting values from SQL SERVER 2000 database
using an Action Class and A Form Bean.
This jsp view is as a tabular format, where data is populated.
Selectbox text checkbox checkbox text
text cancel_image
This page having operations like cancel_row / save_table / add_row
First : I need to populate the values from database to this jsp page
during the opening of this page
Second : how can I add row to this table dynamically so that I can enter a
few records and save the data to the database.
Third : When I save the records the values must go to ActionServlet, where
I need them all in an ArrayList.
Kindly see the code below.
-Thanks & Regards,
// JSP
...........................................................................................................................................................................
<%@ page contentType="text/html;charset=UTF-8" language="java"%>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic"
%>
<html>
<head>
<title></title>
</head>
<body>
<link rel="stylesheet" href="/themes/userAccountAdmin.css">
<script type="text/javascript" language="javascript"
src="/themes/userAccountSearch.js"></script>
<script type='text/javascript'
src='/dwr/interface/DwrUserAccountAdminDelegator.js'></script>
<script language="javascript">
<!--
function addRow(tableID) // table id="dataTable"
{
var table = document.getElementById(tableID);
var rowCount = table.rows.length;
var row = table.insertRow(rowCount);
var colCount = table.rows[0].cells.length;
alert(table.rows.length - 1);
for(var i=0; i<colCount; i++)
{
var newcell = row.insertCell(i);
newcell.innerHTML = table.rows[1].cells[i].innerHTML;
}
}
function deleteRow(target)
{
do {
if ( target.nodeName.toUpperCase() == 'TR' ) {
target.parentNode.removeChild(target);
break;
}
alert(target);
} while ( target = target.parentNode );
}
-->
</script>
<body onkeypress="entsub(event)">
<div id="errorsMessage" class="errors">
Attention
<ul id='validationList'></ul>
<hr>
</div>
<fieldset id='LineItemAttributeNames'><legend>PARTNER-EDIT CONTROL
</legend> <input type="hidden"
id="deleteAttributeNameId" />
<table width="95%" align="center">
<tr>
</tr>
</table>
<table class='headcollapse' width="90%" align="center" id="dataTable" >
<thead>
<tr>
<th style='width: 20%'>ACCOUNT ID/NAME</th>
<th style='width: 8%'>PAGE ID</th>
<th style='width: 8%'>TABLE NAME</th>
<th style='width: 10%'>FIELD NAME</th>
<th style='width: 4%'>DISPLAY FIELD VALUE</th>
<th style='width: 4%'>ALLOW EDIT</th>
<th style='width: 4%'>RECORD HISTORY</th>
<th style='width: 4%'>REQ</th>
<th style='width: 12%'>HELP TEXT</th>
<th style='width: 8%'> </th>
</tr>
</thead>
<%
for (int count=0; count<10; count++){%>
<tr onmouseover='greyIn(this)' onmouseout='greyOut(this)'
onclick="rowID(this);">
<td>
<select name="partnerName" id="_partnernameList">
<option value="0" selected="selected">Select Partner Name </option>
<logic:notEmpty name="partnerEditControlForm" property="partnerList">
<logic:iterate id="partner" name="partnerEditControlForm"
property="partnerList">
<option value='<bean:write name="partner" property="value"/>'>
<bean:write name="partner" property="displayString"/>
</option>
</logic:iterate>
</logic:notEmpty>
</select>
</td>
<td>
<html:text name="pageId" property="pageId" maxlength="10" size="10"
value="" />
</td>
<td>
<html:text name="tableName" property="tableNameList" maxlength="10"
size="10" value="" />
</td>
<td>
<html:text name="fieldName" property="fieldName" maxlength="10"
size="10" value="" />
</td>
<td>
<input type="checkbox" name="DisplayFied" property="displayFieldValue">
</td>
<td>
<input type="checkbox" name="allowEdit">
</td>
<td>
<input type="checkbox" name="recordHistory" property="recordHistory">
</td>
<td>
<input type="checkbox" name="req">
</td>
<td>
<html:text name="helpText" property="helpText" maxlength="10" size="20"
value="" />
</td>
<td>
../images/cancelCross.jpg <!-- name=<%//=count%> -->
</td>
</tr>
<%-- end interate --%>
<%}%>
</table>
<table width="100%">
<tr>
<td align="right" width="100%">
<input type="button" value="ADD FIELD" onclick="addRow('dataTable');"
class="buttonSize65"/>
</td>
</tr>
<tr>
<td align="right" width="100%">
<input type="button" value="SAVE" onclick="doSave(this.form);"
class="buttonSize65"/>
<input type="button" value="CANCEL" class="buttonSize65"/>
</td>
</tr>
</table>
</fieldset>
</form>
</body>
</html>
// Actionservlet
.......................................................................................................................................................................
package com.development.web.admin;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessages;
import com.development.dao.PartnerEditControlDAO;
import com.development.valueObjects.Company;
import com.development.valueObjects.PartnerEditControl;
import com.development.core.assumptions.api.common.DisplayString;
import com.development.core.configure.PartnerEditControlManager;
import com.development.web.utilities.Utilities;
import com.development.dao.UserDAO;
import com.development.valueObjects.User;
import com.development.core.configure.UserManager;
public class PartnerEditControlAction extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm theform,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
ActionMessages errors = new ActionMessages();
// Extract attributes we will need
PartnerEditControlForm form = (PartnerEditControlForm) theform;
/* PartnerEditControlManager pecm = new PartnerEditControlManager();
ArrayList<PartnerEditControl> list = new
ArrayList<PartnerEditControl>();
list = pecm.getSelectDefaultUserbyAccountGeneralId(Integer userId);
*/
PartnerEditControlDAO peDao= new PartnerEditControlDAO();
PartnerEditControlManager pecm =new PartnerEditControlManager();
// ArrayList <PartnerEditControl>
list=peDao.selectDefaultUserbyAccountGeneralId(user.getAccountGeneralId());
ArrayList <PartnerEditControl>
list=pecm.getSelectDefaultUserbyAccountGeneralId(1);
System.out.println("tmp for the list
==================================================="+list.size());
//userForm.setPartnerEditControl(List < Company > )
UserManager.getCompanyList(userId));
// form.setPartnerEditControl(list);
PartnerEditControl partnereditcontrol=null;
int s = list.size();
for (int i=0; i< s; i++)
{
partnereditcontrol = (PartnerEditControl)list.get(i);
/* System.out.println("tmp for the list
==================================================="+list.get(i).getUserId());
System.out.println("tmp for the list
==================================================="+(list.get(i)).getPartnerId());
System.out.println("tmp for the list
==================================================="+(String)(list.get(i)).getTableName());
System.out.println("tmp for the list
==================================================="+(String)list.get(i).getPageId());
System.out.println("tmp for the list
==================================================="+(String)list.get(i).getFieldName());
System.out.println("tmp for the list
==================================================="+list.get(i).getDisplayFieldValue());
//System.out.println("tmp for the list
==================================================="+list.get(i).getAllowEdit());
System.out.println("tmp for the list
==================================================="+list.get(i).getRecordHistory());
System.out.println("tmp for the list
==================================================="+list.get(i).getHelpText());*/
//form.getListSize(list.size());
form.getUserIdList().add(list.get(i).getUserId());
form.getPartnerIdList().add(list.get(i).getPartnerId());
String tmp=(String)list.get(i).getTableName();
//form.getTableNameList.add("Attyyyyyyyyy");
form.getTableNameList().add(list.get(i).getTableName());
form.getFieldNameList().add(list.get(i).getFieldName());
form.getDisplayFieldValueList().add((String)list.get(i).getFieldName());
form.getRecordHistoryList().add((String)list.get(i).getDisplayFieldValue());
form.getHelpTextList().add((String)list.get(i).getRecordHistory());
String tempName=list.get(i).getTableName();
System.out.println("partnereditcontrol.getTableName()=====================>"+partnereditcontrol.getTableName());
// form.setTableNameList(new ArrayList ());
/* form.getTableNameList().add(list.get(i).getTableName());
form.getTableNameList().add(list.get(i).getTableName());
form.getTableNameList().add(list.get(i).getTableName());
form.getTableNameList().add(list.get(i).getTableName());
form.getTableNameList().add(list.get(i).getTableName());
form.getTableNameList().add(list.get(i).getTableName());
form.getTableNameList().add(list.get(i).getTableName());*/
//form.getAfg();
}
Map < Integer, String > partnerListMap =
UserManager.getPartnerList();
Integer partnerId;
String partnerFullName;
if (form.getPartnerList() == null) {
form.setPartnerList(new ArrayList < DisplayString > ());
} else {
form.getPartnerList().clear();
}
for (Iterator < Integer > iter = partnerListMap.keySet().iterator();
iter.hasNext();) {
partnerId = iter.next();
partnerFullName = partnerListMap.get(partnerId);
form.getPartnerList().add(
new DisplayString(partnerFullName, partnerId));
}
//form.
/*if(list.size()==1 && list.get(0).getUserId()==user.getUserId())
{
errors.add(ActionMessages.GLOBAL_MESSAGE, new
ActionMessage("error.defaultUser.atleastOne"));
return errors;
}*/
return (mapping.findForward("success"));
}
}
// Form Bean
.................................................................................................................................................................
package com.development.web.admin;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import com.development.core.configure.UserManager;
import com.development.core.assumptions.api.common.DisplayString;
public class PartnerEditControlForm extends ActionForm {
int listSize=0;
private String action;
public ArrayList userIdList = new ArrayList();
public ArrayList pageId = new ArrayList();
public ArrayList partnerId = new ArrayList();
public ArrayList tableNameList = new ArrayList();
public ArrayList fieldName = new ArrayList();
public ArrayList displayFieldValue = new ArrayList();
public ArrayList recordHistory = new ArrayList();
public ArrayList helpText = new ArrayList();
public List < DisplayString > partnerList;
/**
* Gets the partner list.
* @return the partner list
*/
public List < DisplayString > getPartnerList() {
return partnerList;
}
/**
* Sets the partner list.
* @param partnerList the new partner list
*/
public void setPartnerList(List < DisplayString > partnerList) {
this.partnerList = partnerList;
}
public ArrayList getTableNameList()
{
return tableNameList;
}
public void setTableNameList(ArrayList tableNameList)
{
this.tableNameList = tableNameList;
}
public ArrayList getFieldNameList()
{
return fieldName;
}
public void setFieldNameList(ArrayList fieldName)
{
this.fieldName = fieldName;
}
/**
* Returns the action
*
* @return String
*/
public String getAction()
{
return action;
}
/**
* Sets the action
*
* @param action
* String
*/
public void setAction(String action)
{
this.action = action;
}
/**
* Used to reset the form
*/
public void reset()
{
;
}
/**
* This reset is called before validation
*
* @param mapping
* @param request
*/
public void reset(ActionMapping mapping, HttpServletRequest request)
{
;
}
public ActionErrors validate(ActionMapping mapping, HttpServletRequest
request) {
ActionErrors errors = null;
return errors;
}
public List < DisplayString > getPartnerEditControl() {
return partEditControlList;
}
public void setPartnerEditControl(List < DisplayString >
partEditControlList) {
this.partEditControlList = partEditControlList;
}
public ArrayList getUserIdList()
{
return userIdList;
}
public void setUserIdList(ArrayList userIdList)
{
this.userIdList = userIdList;
}
//Added by KKS...
public ArrayList getPageId()
{
return pageId;
}
public void setPageId(ArrayList pageId)
{
this.pageId = pageId;
}
public ArrayList getPartnerIdList()
{
return partnerId;
}
public void setPartnerIdList(ArrayList partnerId)
{
this.partnerId = partnerId;
}
public ArrayList getHelpTextList()
{
return helpText;
}
public void setHelpTextList(ArrayList helpText)
{
this.helpText = helpText;
}
public ArrayList getRecordHistoryList()
{
return recordHistory;
}
public void setRecordHistoryList(ArrayList recordHistory)
{
this.recordHistory = recordHistory;
}
public ArrayList getDisplayFieldValueList()
{
return displayFieldValue;
}
public void setDisplayFieldValueList(ArrayList displayFieldValue)
{
this.displayFieldValue = displayFieldValue;
}
Map < Integer, String > partnerListMap = UserManager.getPartnerList();
Integer partnerID;
String partnerFullName;
public StringBuffer DisplayOption()
{
ArrayList list = new ArrayList();
StringBuffer text = new StringBuffer();
/*
for (int i = 0; i < partnerList.size(); i++)
{
text.append("<select name='partnerList'> " );
//ArrayList tmp=new ArrayList(partnerList.get(i));
//text.append("<Option value ='"+tmp[0]+"'>");
text.append("'"+partnerList.get(i)+"'</select>");
}//end of for
*/
for (Iterator < Integer > iter = partnerListMap.keySet().iterator();
iter.hasNext();) {
partnerID = iter.next();
partnerFullName = partnerListMap.get(partnerId);
text.append("<select name='partnerList'> " );
//text.append("<Option value ='"+partnerID+"'>");
//text.append("'"+partnerFullName+"'</select>");
}
return text;
}
}
--
View this message in context: http://www.nabble.com/Need-immediate-help---Struts%2C-my-job-is-stuck-tp25737228p25737228.html
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
RE: Need immediate help - Struts, my job is stuck
Posted by "Kawczynski, David" <da...@merck.com>.
It looks like the help Paul gave was spot-on, and sufficient. If you have a focused question on one aspect of your code, please post it here. If you want someone to write or modify code for you, perhaps you should ask some co-workers, classmates, or the person who originally wrote the code.
> -----Original Message-----
> From: kaushal.sharma [mailto:kaushalksharma.mtech@gmail.com]
> Sent: Sunday, October 04, 2009 4:52 PM
> To: user@struts.apache.org
> Subject: Re: Need immediate help - Struts, my job is stuck
>
>
> Hi Paul,
>
> Thanks for your prompt reply. i can understand you were in hurry for
> something important. not a prob.
>
> But as i am new to struts, i need suggestions with some code
> help. Hope you
> can help me at this level.
>
>
>
> -Thanks & Regards
> Kaushal K. Sharma
>
>
>
>
>
>
> Paul Benedict-2 wrote:
> >
> > Kaushal,
> >
> > I don't have time to read all the source you posted, but here's my
> > answers to your direct questions:
> >
> > First : I need to populate the values from database to
> this jsp page
> > during the opening of this page
> >
> >>> You need to have an action mapping for this. Something like
> >>> /loadmydata.do
> >
> > Second : how can I add row to this table dynamically so
> that I can enter
> > a
> > few records and save the data to the database.
> >
> >>> You can use JSP <c:forEach> to loop over a list of an
> array, and produce
> >>> new <tr> and <td> elements.
> >
> > Third : When I save the records the values must go to
> ActionServlet,
> > where
> > I need them all in an ArrayList.
> >
> >>> You need a second action mapping for this. Remember this
> pattern: Use
> >>> one action for loading data, another action for saving the data.
> >
> > Paul
> >
> > On Sun, Oct 4, 2009 at 6:40 AM, kaushal.sharma
> > <ka...@gmail.com> wrote:
> >>
> >> Hi,
> >>
> >> Sorry to be late here, but i need an immediate help. I am
> new to struts
> >> and
> >> recently put into a struts project.
> >>
> >> FYI
> >>
> >> I have a jsp file, where I am getting values from SQL SERVER 2000
> >> database
> >> using an Action Class and A Form Bean.
> >> This jsp view is as a tabular format, where data is populated.
> >> Selectbox text checkbox checkbox
> text
> >> text cancel_image
> >>
> >> This page having operations like cancel_row / save_table
> / add_row
> >>
> >> First : I need to populate the values from database to
> this jsp page
> >> during the opening of this page
> >> Second : how can I add row to this table dynamically so
> that I can enter
> >> a
> >> few records and save the data to the database.
> >> Third : When I save the records the values must go to
> ActionServlet,
> >> where
> >> I need them all in an ArrayList.
> >>
> >> Kindly see the code below.
> >>
> >> -Thanks & Regards,
> >>
> >>
> >> // JSP
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > For additional commands, e-mail: user-help@struts.apache.org
> >
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Need-immediate-help---Struts%2C-my-job-i
s-stuck-tp25737228p25742091.html
> 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
>
>
Notice: This e-mail message, together with any attachments, contains
information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station,
New Jersey, USA 08889), and/or its affiliates (which may be known
outside the United States as Merck Frosst, Merck Sharp & Dohme or
MSD and in Japan, as Banyu - direct contact information for affiliates is
available at http://www.merck.com/contact/contacts.html) that may be
confidential, proprietary copyrighted and/or legally privileged. It is
intended solely for the use of the individual or entity named on this
message. If you are not the intended recipient, and have received this
message in error, please notify us immediately by reply e-mail and
then delete it from your system.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: Need immediate help - Struts, my job is stuck
Posted by "kaushal.sharma" <ka...@gmail.com>.
Hi Paul,
Thanks for your prompt reply. i can understand you were in hurry for
something important. not a prob.
But as i am new to struts, i need suggestions with some code help. Hope you
can help me at this level.
-Thanks & Regards
Kaushal K. Sharma
Paul Benedict-2 wrote:
>
> Kaushal,
>
> I don't have time to read all the source you posted, but here's my
> answers to your direct questions:
>
> First : I need to populate the values from database to this jsp page
> during the opening of this page
>
>>> You need to have an action mapping for this. Something like
>>> /loadmydata.do
>
> Second : how can I add row to this table dynamically so that I can enter
> a
> few records and save the data to the database.
>
>>> You can use JSP <c:forEach> to loop over a list of an array, and produce
>>> new <tr> and <td> elements.
>
> Third : When I save the records the values must go to ActionServlet,
> where
> I need them all in an ArrayList.
>
>>> You need a second action mapping for this. Remember this pattern: Use
>>> one action for loading data, another action for saving the data.
>
> Paul
>
> On Sun, Oct 4, 2009 at 6:40 AM, kaushal.sharma
> <ka...@gmail.com> wrote:
>>
>> Hi,
>>
>> Sorry to be late here, but i need an immediate help. I am new to struts
>> and
>> recently put into a struts project.
>>
>> FYI
>>
>> I have a jsp file, where I am getting values from SQL SERVER 2000
>> database
>> using an Action Class and A Form Bean.
>> This jsp view is as a tabular format, where data is populated.
>> Selectbox text checkbox checkbox text
>> text cancel_image
>>
>> This page having operations like cancel_row / save_table / add_row
>>
>> First : I need to populate the values from database to this jsp page
>> during the opening of this page
>> Second : how can I add row to this table dynamically so that I can enter
>> a
>> few records and save the data to the database.
>> Third : When I save the records the values must go to ActionServlet,
>> where
>> I need them all in an ArrayList.
>>
>> Kindly see the code below.
>>
>> -Thanks & Regards,
>>
>>
>> // JSP
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/Need-immediate-help---Struts%2C-my-job-is-stuck-tp25737228p25742091.html
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
Re: Need immediate help - Struts, my job is stuck
Posted by Paul Benedict <pb...@apache.org>.
Kaushal,
I don't have time to read all the source you posted, but here's my
answers to your direct questions:
First : I need to populate the values from database to this jsp page
during the opening of this page
>> You need to have an action mapping for this. Something like /loadmydata.do
Second : how can I add row to this table dynamically so that I can enter a
few records and save the data to the database.
>> You can use JSP <c:forEach> to loop over a list of an array, and produce new <tr> and <td> elements.
Third : When I save the records the values must go to ActionServlet, where
I need them all in an ArrayList.
>> You need a second action mapping for this. Remember this pattern: Use one action for loading data, another action for saving the data.
Paul
On Sun, Oct 4, 2009 at 6:40 AM, kaushal.sharma
<ka...@gmail.com> wrote:
>
> Hi,
>
> Sorry to be late here, but i need an immediate help. I am new to struts and
> recently put into a struts project.
>
> FYI
>
> I have a jsp file, where I am getting values from SQL SERVER 2000 database
> using an Action Class and A Form Bean.
> This jsp view is as a tabular format, where data is populated.
> Selectbox text checkbox checkbox text
> text cancel_image
>
> This page having operations like cancel_row / save_table / add_row
>
> First : I need to populate the values from database to this jsp page
> during the opening of this page
> Second : how can I add row to this table dynamically so that I can enter a
> few records and save the data to the database.
> Third : When I save the records the values must go to ActionServlet, where
> I need them all in an ArrayList.
>
> Kindly see the code below.
>
> -Thanks & Regards,
>
>
> // JSP
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org