struts2 + Json and JQuery.

[Amruth Puppala]

I am trying to display Grid with values. I am bale to get just header of the Grid but not the entire Grid.

I am missing something here.

I have also followed same example as all new people follow the Jason one.

I have following jars in my WEB-INF/lib

asm-3.1.jar
asm-commons-3.1.jar
asm-tree-3.1.jar
commons-fileupload-1.2.2.jar
commons-io-2.0.1.jar
commons-lang-2.5.jar
freemarker-2.3.16.jar
javassist-3.11.0.GA.jar
ognl-3.0.1.jar
struts2-core-2.2.3.1.jar
struts2-convention-plugin-2.2.3.1.jar
commons-logging-1.1.1.jar
xwork-core-2.2.3.1.jar
struts2-jquery-grid-plugin-3[1].1.1.jar
struts2-jquery-plugin-2.5.3.jar

Custmer class is

package com.test.sturts2;

import java.io.Serializable;

public class Customer implements Serializable{
	
	String name;       
	String country;       
	String city;      
	double creditLimit;
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getCountry() {
		return country;
	}
	public void setCountry(String country) {
		this.country = country;
	}
	public String getCity() {
		return city;
	}
	public void setCity(String city) {
		this.city = city;
	}
	public double getCreditLimit() {
		return creditLimit;
	}
	public void setCreditLimit(double creditLimit) {
		this.creditLimit = creditLimit;
	}

}

Jason table is (Same normally I got from net, I have changed DAO calls and prepared hardcoded customer Object)

package com.test.sturts2;

import java.util.ArrayList;
import java.util.Collection;
import java.util.Collections;
import java.util.List;
import java.util.Map;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Actions;
import org.apache.struts2.convention.annotation.ParentPackage;
import org.apache.struts2.convention.annotation.Result;
import org.apache.struts2.interceptor.SessionAware;


import com.opensymphony.xwork2.ActionSupport;

@ParentPackage(value = "showcase")
public class JsonTable extends ActionSupport implements SessionAware {

  private static final long   serialVersionUID = 5078264277068533593L;
  private static final Log    log              = LogFactory.getLog(JsonTable.class);

  private List<Customer>      gridModel;
  private List<Customer>      myCustomers;
  private Integer             rows             = 0;
  private Integer             page             = 0;
  private Integer             total            = 0;
  private Integer             record           = 0;
  private String              sord;
  private String              sidx;
  private String              searchField;
  private String              searchString;
  private String              searchOper;
  private boolean             loadonce         = false;
  private Map<String, Object> session;

  @Actions( {
    @Action(value = "/jsontable", results = {
      @Result(name = "success", type = "json")
    })
  })
  public String execute()
  {
    log.debug("Page " + getPage()+" Rows " + getRows() +" Sorting Order "+ getSord()+" Index Row :" + getSidx());
    log.debug("Search :" + searchField + " " + searchOper + " " + searchString);

    Object list = session.get("mylist");
    if (list != null)
    {
      myCustomers = (List<Customer>) list;
    }
    else
    {
      log.debug("Build new List");
      List<Customer> al = new ArrayList<Customer> (2);
  	Customer cu = new Customer();
  	cu.setName("abc");
  	cu.setCity("abc");
  	cu.setCountry("abc");
  	cu.setCreditLimit(2);
  	al.add(cu);
  	al.add(cu);
  	al.add(cu);
      myCustomers = al;
    }

    if (getSord() != null && getSord().equalsIgnoreCase("asc"))
    {
    //  Collections.sort(myCustomers);
    }
    if (getSord() != null && getSord().equalsIgnoreCase("desc"))
    {
   //   Collections.sort(myCustomers);
      Collections.reverse(myCustomers);
    }

    setRecord(2);

    int to = (getRows() * getPage());
    int from = to - getRows();

    if (to > getRecord()) to = getRecord();

    if (loadonce)
    {
      setGridModel(myCustomers);
    }
    else
    {
      if (searchString != null && searchOper != null)
      {
        int id = Integer.parseInt(searchString);
        if (searchOper.equalsIgnoreCase("eq"))
        {
          log.debug("search id equals " + id);
          List<Customer> cList = new ArrayList<Customer>();
         // cList.add(CustomerDAO.findById(myCustomers, id));
          List<Customer> al = new ArrayList<Customer> (2);
        	Customer cu = new Customer();
        	cu.setName("abc");
        	cu.setCity("abc");
        	cu.setCountry("abc");
        	cu.setCreditLimit(2);
        	al.add(cu);
        	al.add(cu);
        	al.add(cu);
         
          setGridModel(al);
        }
        else if (searchOper.equalsIgnoreCase("ne"))
        {
          log.debug("search id not " + id);
        //  setGridModel(CustomerDAO.findNotById(myCustomers, id, from, to));
          List<Customer> al = new ArrayList<Customer> (2);
      	Customer cu = new Customer();
      	cu.setName("abc");
      	cu.setCity("abc");
      	cu.setCountry("abc");
      	cu.setCreditLimit(2);
      	al.add(cu);
      	al.add(cu);
      	al.add(cu);
       
        setGridModel(al);
        }
        else if (searchOper.equalsIgnoreCase("lt"))
        {
          log.debug("search id lesser then " + id);
         // setGridModel(CustomerDAO.findLesserAsId(myCustomers, id, from, to));
          List<Customer> al = new ArrayList<Customer> (2);
      	Customer cu = new Customer();
      	cu.setName("abc");
      	cu.setCity("abc");
      	cu.setCountry("abc");
      	cu.setCreditLimit(2);
      	al.add(cu);
      	al.add(cu);
      	al.add(cu);
       
        setGridModel(al);
        }
        else if (searchOper.equalsIgnoreCase("gt"))
        {
          log.debug("search id greater then " + id);
          //setGridModel(CustomerDAO.findGreaterAsId(myCustomers, id, from, to));
          List<Customer> al = new ArrayList<Customer> (2);
      	Customer cu = new Customer();
      	cu.setName("abc");
      	cu.setCity("abc");
      	cu.setCountry("abc");
      	cu.setCreditLimit(2);
      	al.add(cu);
      	al.add(cu);
      	al.add(cu);
       
        setGridModel(al);
        }
      }
      else
      {
       // setGridModel(CustomerDAO.getCustomers(myCustomers, from, to));
        List<Customer> al = new ArrayList<Customer> (2);
    	Customer cu = new Customer();
    	cu.setName("abc");
    	cu.setCity("abc");
    	cu.setCountry("abc");
    	cu.setCreditLimit(2);
    	al.add(cu);
    	al.add(cu);
    	al.add(cu);
     
      setGridModel(al);
      }
    }

    setTotal((int) Math.ceil((double) getRecord() / (double) getRows()));

    session.put("mylist", myCustomers);

    return SUCCESS;
  }

  public String getJSON()
  {
    return execute();
  }

  /**
   * @return how many rows we want to have into the grid
   */
  public Integer getRows()
  {
    return rows;
  }

  /**
   * @param rows
   *          how many rows we want to have into the grid
   */
  public void setRows(Integer rows)
  {
    this.rows = rows;
  }

  /**
   * @return current page of the query
   */
  public Integer getPage()
  {
    return page;
  }

  /**
   * @param page
   *          current page of the query
   */
  public void setPage(Integer page)
  {
    this.page = page;
  }

  /**
   * @return total pages for the query
   */
  public Integer getTotal()
  {
    return total;
  }

  /**
   * @param total
   *          total pages for the query
   */
  public void setTotal(Integer total)
  {
    this.total = total;
  }

  /**
   * @return total number of records for the query. e.g. select count(*) from
   *         table
   */
  public Integer getRecord()
  {
    return record;
  }

  /**
   * @param record
   *          total number of records for the query. e.g. select count(*) from
   *          table
   */
  public void setRecord(Integer record)
  {

    this.record = record;

    if (this.record > 0 && this.rows > 0)
    {
      this.total = (int) Math.ceil((double) this.record / (double) this.rows);
    }
    else
    {
      this.total = 0;
    }
  }

  /**
   * @return an collection that contains the actual data
   */
  public List<Customer> getGridModel()
  {
    return gridModel;
  }

  /**
   * @param gridModel
   *          an collection that contains the actual data
   */
  public void setGridModel(List<Customer> gridModel)
  {
    this.gridModel = gridModel;
  }

  /**
   * @return sorting order
   */
  public String getSord()
  {
    return sord;
  }

  /**
   * @param sord
   *          sorting order
   */
  public void setSord(String sord)
  {
    this.sord = sord;
  }

  /**
   * @return get index row - i.e. user click to sort.
   */
  public String getSidx()
  {
    return sidx;
  }

  /**
   * @param sidx
   *          get index row - i.e. user click to sort.
   */
  public void setSidx(String sidx)
  {
    this.sidx = sidx;
  }

  public void setSearchField(String searchField)
  {
    this.searchField = searchField;
  }

  public void setSearchString(String searchString)
  {
    this.searchString = searchString;
  }

  public void setSearchOper(String searchOper)
  {
    this.searchOper = searchOper;
  }

  public void setLoadonce(boolean loadonce)
  {
    this.loadonce = loadonce;
  }

  public void setSession(Map<String, Object> session)
  {
    this.session = session;
  }

}

Strust.xml is

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">
 
<struts>
	<constant name="struts.enable.DynamicMethodInvocation"
		value="false" />
	<constant name="struts.devMode" value="false" />
 
	<constant name="struts.custom.i18n.resources"
		value="ApplicationResources" />
 
	<package name="default" extends="struts-default" namespace="/">
 
	<!-- 	<action name="login" method="authenticate"
			class="com.test.sturts2.LoginAction">
			<result name="success">Welcome.jsp</result>
			<result name="error">Login.jsp</result>
 
		</action> -->
	
	<action name="jsontable" method="getJSON"
			class="com.test.sturts2.JsonTable">
			<result name="success">Welcome.jsp</result>
			<result name="error">Login.jsp</result>
 
		</action>
	</package>
</struts>

I am not sure what Am I missing here, I simply getting empty Table with just header in it.
Can some one help me in understanding or simple strust2 wirh Jquery Grids working example app also help if you send as attachment.

[Amruth Puppala]

Hi,

Can any one post or point to me to the link of any Sturts2 Jquery Edit Grid examples.

I want a Data Grid editable using Sturts2 JQuery.

I need other then Showcase example one. I have used it.

I really in the need of this as my project demands it.