[Struts2][Jqueryplugin] problem to populate grid .

[khekhone yvan]

hi greenhorn people
i can not understand a lot of thing about the tuto Jquery grid
i try to populate my grid but its blanked .
i put my code action before my jsp page.
code action

public class totoAction extends ActionSupport {
	
	
//static List<Friend> listfriend;	
	 
	
	public List <String>listCountry;
	 public List <Friend>listfriend;
	 
	
	
    
    	public void setListfriend(List <Friend>listfriend){
    	this.listfriend=listfriend;
    }
    	public List<Friend>  getListfriend(){
    	return listfriend;
    }
    
    

	public String execute()  {
		listfriend= new ArrayList<Friend>();
    	listfriend.add(new Friend("John"," Doe", new GregorianCalendar(1987,10,18).getTime(),"France","H"));       
    	listfriend.add(new Friend("Jeanette","Doe", new GregorianCalendar(1993,8,17).getTime(), "Ireland","F"));       
    	listfriend.add(new Friend("John"," Douey", new GregorianCalendar(1973,9,5).getTime(), "France","H"));       
    	listfriend.add(new Friend("Jane"," Doe", new GregorianCalendar(1989,0,18).getTime(), "Canada","H"));       
    	listfriend.add(new Friend("Johny"," Doe", new GregorianCalendar(2002,5,28).getTime(), "France","H"));       
    	listfriend.add(new Friend("Jean","Dot", new GregorianCalendar(1994,10,21).getTime(), "France","H"));       
    	listfriend.add(new Friend("Jane","Doue", new GregorianCalendar(2004,07,29).getTime(), "Great Britain","H"));       
    	listfriend.add(new Friend("John","Dor", new GregorianCalendar(1983,5,5).getTime(), "New Zealand","H"));   
     
  
   
   
    System.out.println("totfgdfhytro");
  System.out.println("klsfjdslfdd555555555");
    
	        return SUCCESS;
	    }
	
	
	
}

my jsp :

	<s:property value="%{listfriend.size}"/>
	<s:url id="remoteurl" action="JsonTable"/>
    <sjg:grid
        id="gridtable"
        caption="Customer Examples"
        dataType="json"
        href="%{remoteurl}"
        pager="true"
        gridModel="gridModel"
        rowList="10,15,20"
        rowNum="15"
        rownumbers="true"
    >
        
        <sjg:gridColumn name="nom_friend" index="nom_friend" title="nom_friend" sortable="true"/>
        
    </sjg:grid>



</body>

on my JsonTable

package showcase;





import java.util.List;

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 jpa.Friend;



import com.opensymphony.xwork2.ActionSupport;


@ParentPackage("showcase")
public class JsonTable extends ActionSupport {
	

	  /**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	//Your result List
	  private List<Friend>      gridModel;
	  public List<Friend>      listfriend;
	  //get how many rows we want to have into the grid - rowNum attribute in the grid
	  private Integer             rows             = 0;

	  //Get the requested page. By default grid sets this to 1.
	  private Integer             page             = 0;

	  // sorting order - asc or desc
	  private String              sord;

	  // get index row - i.e. user click to sort.
	  private String              sidx;

	  // Search Field
	  private String              searchField;

	  // The Search String
	  private String              searchString;

	  // he Search Operation ['eq','ne','lt','le','gt','ge','bw','bn','in','ni','ew','en','cn','nc']
	  private String              searchOper;

	  // Your Total Pages
	  private Integer             total            = 0;

	  // All Record
	  private Integer             records          = 0;


	  @Actions( {
		    @Action(value = "/JsonTable", results = {
		      @Result(name = "success", type = "json")
		    })
		  })
	  public String execute()
	  {

	    int to = (rows * page);
	    int from = to - rows;


	    //Count Rows (select count(*) from custumer)
	    //records = CustumerDAO.count();
	    setGridModel(listfriend);
	    records =gridModel.size() ;
	
	 
	    // Set to = max rows
	    if (to > records) to = records;

	    // Calculate total Pages
	    total = (int) Math.ceil((double) records / (double) rows);
	    System.out.println("klsfjdslfddputain");
	    return SUCCESS;
	  }

	  public String getJSON()
	  {System.out.println("klsfjdslfggsfsdfsdfsdfsfsd");
	    return execute();
	  }

	  //Getters and Setters for Attributes
	  /**
	   * @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 getRecords()
	  {
	    return records;
	  }

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

	    this.records = records;

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

	  /**
	   * @return an collection that contains the actual data
	   */
	  public List<Friend> getGridModel()
	  {
	    return gridModel;
	  }
	  public void setListfriend(List<Friend> listfriend )
	  {
	    listfriend=listfriend;
	  }
	 
	  public List<Friend> getListFriend()
	  {
	    return listfriend;
	  }
	  public void setGridModel(List<Friend> 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;
	  }
}

struts

<struts>
   <package name="showcase" extends="struts-default,json-default" namespace="/">
    </package>
</struts>

well i put println() in method execute on my JsonTable and no display something
i miss something

[Johannes Geppert]

what is happens when you call your JsonTable action directly?
Do You get an valid JSON Result?

Johannes

[khekhone yvan]

hi tx to answer me johannes
Are you JqueryTeam ?because the package has your name in the queryshowcase.war


well
when i call directly jsontable a window is open and displayed ( download file ,inconnu file do you want seach a application who can read or save on the disk or ignore.)
i think i miss something

[khekhone yvan]

application cannot entry on the jsontable.

[Johannes Geppert]

I guesss the problem is the name of your gridmodel. You have named it in your action listfriend but in your grid tag you named it gridModel.

<s:property value="%{listfriend.size}"/> <s:url id="remoteurl" action="JsonTable"/> <sjg:grid id="gridtable" caption="Customer Examples" dataType="json" href="%{remoteurl}" pager="true" gridModel="listfriend" rowList="10,15,20" rowNum="15" rownumbers="true" > <sjg:gridColumn name="nom_friend" index="nom_friend" title="nom_friend" sortable="true"/> </sjg:grid>
Johannes

[khekhone yvan]

no i think its not that because app d'ont entry to the method execute ..i changed to test if friendlist can display it.
i put my code
totoAction:

import java.util.ArrayList;
import java.util.GregorianCalendar;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import jpa.Friend;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;


public class totoAction extends ActionSupport {
	
	
//static List<Friend> listfriend;	
	 
	
	public List <String>listCountry;
	 public List <Friend>listfriend;
	 
	public List <String> getCountry(){return listCountry;}
	int toto;
	private List<Friend> gridModel;
	public void setCountry(List<String>listcountry){this.listCountry=listcountry;}
    	void setToto(int toto){this.toto=toto;}
    	int getToto(){return toto;}
    
    	public void setListfriend(List <Friend>listfriend){
    	this.listfriend=listfriend;
    }
    	public List<Friend>  getListfriend(){
    	return listfriend;
    }
    
    	  public List<Friend> getGridModel()
    	  {
    	    return gridModel;
    	  }
    
    	 
    	  public List<Friend> getListFriend()
    	  {
    	    return listfriend;
    	  }
    	  public void setGridModel(List<Friend> gridModel)
    	  {
    	    this.gridModel=gridModel;
    	  }

	public String execute()  {
		listfriend= new ArrayList<Friend>();
    	listfriend.add(new Friend("John"," Doe", new GregorianCalendar(1987,10,18).getTime(),"France","H"));       
    	listfriend.add(new Friend("Jeanette","Doe", new GregorianCalendar(1993,8,17).getTime(), "Ireland","F"));       
    	listfriend.add(new Friend("John"," Douey", new GregorianCalendar(1973,9,5).getTime(), "France","H"));       
    	listfriend.add(new Friend("Jane"," Doe", new GregorianCalendar(1989,0,18).getTime(), "Canada","H"));       
    	listfriend.add(new Friend("Johny"," Doe", new GregorianCalendar(2002,5,28).getTime(), "France","H"));       
    	listfriend.add(new Friend("Jean","Dot", new GregorianCalendar(1994,10,21).getTime(), "France","H"));       
    	listfriend.add(new Friend("Jane","Doue", new GregorianCalendar(2004,07,29).getTime(), "Great Britain","H"));       
    	listfriend.add(new Friend("John","Dor", new GregorianCalendar(1983,5,5).getTime(), "New Zealand","H"));   
     setGridModel(listfriend);
    listCountry = new CountryProvider().getList(); 
   Map<String, Object> context = new HashMap<String, Object>();
    context.put("listfriend",listfriend);
    context.put("listCountry",listCountry);
    context.put("gridModel",listfriend);
    ActionContext.getContext().getValueStack().push(context);
    System.out.println("totfgdfhytro"); 
    System.out.println("klsfjdslfdd555555555");System.out.println("klsfjdslfdd555555555");
    
	        return SUCCESS;
	    }
	
	
	
}

totoaction redirect to the toto/toto.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
     <%@ taglib prefix="s" uri="/struts-tags" %>
     <%@ taglib prefix="sx" uri="/struts-dojo-tags" %>
     <%@ taglib uri="http://struts-menu.sf.net/tag" prefix="menu" %>

<%@ taglib prefix="sj" uri="/struts-jquery-tags"%>
<%@ taglib prefix="sjg" uri="/struts-jquery-grid-tags"%>
     <%@ taglib prefix="ria" uri="http://sweetdev-ria.ideotechnologies.com" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head><sj:head jqueryui="true" jquerytheme="redmond" /><sx:head parseContent="true"/> <link rel="stylesheet" type="text/css" href="style.css">
 <ria:resourcesImport />
<title>Insert title here</title>

</head>
<body>
<s:debug></s:debug>
dfgdf

	<s:property value="%{listfriend.size}"/>
	<s:url id="remoteurl" action="jsontable"/>
    <sjg:grid
        id="gridtable"
        caption="Customer Examples"
        dataType="json"
        href="%{remoteurl}"
        pager="true"
        gridModel="gridmodel"
        rowList="10,15,20"
        rowNum="15"
        rownumbers="true"
    >
        
        <sjg:gridColumn name="nom_friend" index="nom_friend" title="nom_friend" sortable="true"/>
        
    </sjg:grid>



</body>

my jsontable

package showcase;





import java.util.List;

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 jpa.Friend;



import com.opensymphony.xwork2.ActionSupport;


@ParentPackage("showcase")

public class jsontable extends ActionSupport {
	

	  /**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	//Your result List
	  private List<Friend>      gridModel;
	  public List<Friend>      listfriend;
	  //get how many rows we want to have into the grid - rowNum attribute in the grid
	  private Integer             rows             = 0;

	  //Get the requested page. By default grid sets this to 1.
	  private Integer             page             = 0;

	  // sorting order - asc or desc
	  private String              sord;

	  // get index row - i.e. user click to sort.
	  private String              sidx;

	  // Search Field
	  private String              searchField;

	  // The Search String
	  private String              searchString;

	  // he Search Operation ['eq','ne','lt','le','gt','ge','bw','bn','in','ni','ew','en','cn','nc']
	  private String              searchOper;

	  // Your Total Pages
	  private Integer             total            = 0;

	  // All Record
	  private Integer             records          = 0;


	  @Actions( {
		    @Action(value="jsontable" ,results = {
		      @Result(name = "success", type = "json")
		    })
		  })
	  public String execute()
	  {

	    int to = (rows * page);
	    int from = to - rows;


	    //Count Rows (select count(*) from custumer)
	    //records = CustumerDAO.count();
	    setGridModel(listfriend);
	    records =gridModel.size() ;
	
	 
	    // Set to = max rows
	    if (to > records) to = records;

	    // Calculate total Pages
	    total = (int) Math.ceil((double) records / (double) rows);
	    System.out.println("klsfjdslfddputain");
	    return SUCCESS;
	  }

	  public String getJSON()
	  {System.out.println("klsfjdslfggsfsdfsdfsdfsfsd");
	    return execute();
	  }

	  //Getters and Setters for Attributes
	  /**
	   * @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 getRecords()
	  {
	    return records;
	  }

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

	    this.records = records;

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

	  /**
	   * @return an collection that contains the actual data
	   */
	  public List<Friend> getGridModel()
	  {
	    return gridModel;
	  }
	  public void setListfriend(List<Friend> listfriend )
	  {
	    this.listfriend=listfriend;
	  }
	 
	  public List<Friend> getListFriend()
	  {
	    return listfriend;
	  }
	  public void setGridModel(List<Friend> 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;
	  }
}

on my default package i have
totoaction
on showcase package
i have
jsontable


on my struts
<package>
<action name="totoAction" class="totoAction">

<result name="success">/toto/toto.jsp</result>
</action>

</package>
<package name="showcase" namespace="/" extends="struts-default,json-default">
<action name="jsontable" >
<result type="json"/> </action>


</package>

[khekhone yvan]

my struts

<?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="Global" />
 
 <include file="showcase.xml" />


    <package name="default" namespace="/" extends="struts-default,json-default">
        
        <action name="Login" class="Login" >
            <result name="input">/index.jsp</result> 
  <result name="success">/page2.jsp</result>
  </action>
   <action name="GlobalAction" class="GlobalAction"> 
  <result name="success">/index.jsp</result></action>
   <action name="SubcriptionAction" class="SubcriptionAction"> 
  <result name="success">/subcription/subcription.jsp</result>
  <result name="deconnection">/index.jsp</result></action>
  <action name="inscription" class="inscription"> 
  <result name="success">/page3.jsp</result></action>
 <action name="Deconnection" class="Deconnection">
   <result name="success">/index.jsp</result>
   </action>
   
  <action name="Bookprogrammeraction">
   <result name="1">/index.jsp</result>
   <result name="error">/index.html</result>
   </action>
   
   <action name="totoAction" class="totoAction">
   
   <result name="success">/toto/toto.jsp</result>
   </action>
 
   </package>
 <package name="showcase" namespace="/" extends="struts-default,json-default">
 <action name="jsontable" >
        <result type="json"/> </action>
    
     
     </package>
    

    <!-- Add packages here -->

</struts>

[khekhone yvan]

i instance my listfriend and populate it on the method and its work thank you

[khekhone yvan]

why i have to instance all my field?
i have getter and setter ?
shoud i put on my value stack ?
its very strange
sombody can help me ?
i think i use jsonno effeciently because i have to instanciate alll my field on the classe its is normal ?
i think not because on action on the ewample it not instanciate session map.

[debraj mallick]

hi khekhone,

use "excludeProperties" followed by the service names, put these in your code

<result type="json">
   <param name="excludeProperties">serviceOne, serviceTwo</param>
</result>

otherwise you will all the instance of your setter-getters...

hope this would help.

[khekhone yvan]

its good to know
but i want have all rhe property and i dont understand why i cannot link with value stack
i think i understand json at all