Forum:

Struts

Need immediate help, my job is stuck

Greenhorn

Posts: 26

posted 11 years ago

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,

David Newton

Author

Posts: 12617

I like...

posted 11 years ago

"Immediate" help is unlikely, as this is a forum that people read at their leisure.

It's also a completely useless subject line: see here.

Without the use of code tags code is very difficult to read--particularly when there's that much of it. I'll try to read it, but I'm also suspicious that this much code was necessary to communicate the problem.

David Newton

Author

Posts: 12617

I like...

posted 11 years ago

You don't actually state what problem(s) you're having. Are you unable to do one or more of the three things you list as the requirement?

kaushal sharma

Greenhorn

Posts: 26

posted 11 years ago

Hi David,

I really understand, i did some stupid thins here. But i was quite confused with my work and i posted here in hurry. I will take care of this next time.

Yes, i am not sure what to do with this on this level. hope you can suggest me a solution.

-Thanks & Regards,
Kaushal Sharma

David Newton

Author

Posts: 12617

I like...

posted 11 years ago

A solution for what? You don't say what isn't working.

You can edit your post to include code tags, or re-post using them correctly.

kaushal sharma

Greenhorn

Posts: 26

posted 11 years ago

hi David,

Kindly let me know how to post my code in the best fit?

-Thanks

David Newton

Author

Posts: 12617

I like...

posted 11 years ago

By following the link I gave you about code tags.

Here it is again:

http://faq.javaranch.com/java/UseCodeTags

kaushal sharma

Greenhorn

Posts: 26

posted 11 years ago

Thanks David for such a helpful information.

Here i go....

my JSP FIle,

<%@ 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" %>

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">
<span class='warning'>Attention</span>
<span class='warningtxt'>
<ul id='validationList'></ul>
</span>
<hr>
</div>

<fieldset id='LineItemAttributeNames'><legend><b>PARTNER-EDIT CONTROL   </b></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>

<%-- 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>

My 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"));
}
}

My 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;
}

}

hope you can provide me some help.

-Thanks & Regards,
Kaushal K. Sharma

David Newton

Author

Posts: 12617

I like...

posted 11 years ago

Do you really not indent your code?!

Again: help with ***what***? What doesn't work?

kaushal sharma

Greenhorn

Posts: 26

posted 11 years ago

Hi David,

Actually i need get data from database to my jsp page that will be displayed in a form - tabular form. I have created the view and the first field with <select>

is working fine, similarly i need data for other fields.

Later, i need to do some operations on the jsp page like 'save', 'add field', 'delete', 'cancel'.

As you look into the jsp page every last column in the table is having an in image to delete the row with the data from the database. i am not sure how to do this...

i created a javascript function to add and delete the row but need to add records to the database when i click to 'save' button and delete the records from the database when i click on the 'cancel' image in last coulmn of every row. the add and delete fuctions are as given below,

i need to send data back to my ActionServlet in an arraylist.

Please suggest.

-Thanks & Regards,
Kaushal K. Sharma

kaushal sharma

Greenhorn

Posts: 26

posted 11 years ago

Hi David,

Are you there?

Please suggest me anyone.

-Thanks & Regards,
Kaushal K. Sharma

David Newton

Author

Posts: 12617

I like...

posted 11 years ago

Please see this.

David Newton

Author

Posts: 12617

I like...

posted 11 years ago

So you have one field--why don't you have the rest? How are you sending the data to the JSP?

Do your JavaScript functions for adding/deleting rows work? Are you using indexed fields?

What version of Struts are you even using?

kaushal sharma

Greenhorn

Posts: 26

posted 11 years ago

Hi David,

Yes, i used Indexed Fields.

-Thanks & Regards,
Kaushal K. Sharma

David Newton

Author

Posts: 12617

I like...

posted 11 years ago

You answered one question out of five :/

If you're using indexed fields, and your JavaScript works correctly, and your ActionForm is defined correctly, then I don't know what the problem is, and you don't want to tell us.

Can you really tell me that we aren't dealing with suspicious baked goods? And then there is this tiny ad:

Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop

https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton