Datagrid in struts page

[luckay win]

Hi,

Can anybody share a code with me for displaying a datagrid in a struts page? The data will be populated from DB and filled in grid.

Is there any other way to display such data on jsp page?

Rgs,

[Johannes Geppert]

There exists two proper ways for grids.

The first is the displaytag taglib which work well with struts2 together.
The other soultion is the Struts2 jQuery Grid Taglib which provide a more dynamic Grid.

Displaytag:
http://displaytag.sourceforge.net/1.2/

Struts2 Grid Showcase with Examples:
http://www.weinfreund.de/struts2-jquery-grid-showcase/index.action

Johannes

[luckay win]

Interested to try:

Struts2 Grid Showcase with Examples:
http://www.weinfreund.de/struts2-jquery-grid-showcase/index.action

but it does not have a tutorial for getting the data displayed into the grid..

hmmm.. any body have tutorial for doing this??

I need advise..

many thanks in advance

Regards
Luc

[Johannes Geppert]

Have you take a look at the Project Wiki?

http://code.google.com/p/struts2-jquery/wiki/GridTag

And in both showcases are several examples.

Johannes

[luckay win]

Yes,
I also have tried it .. and got little bit answer.. but still don't know how to display records into the grid?
and refer to the example..I also don't understand what is in CustomerDAO?

Could you please advise what is in CustomerDAO? ..and how do I show records into the grid? (ie. select from mytable order by myfield)

I also have registered to http://code.google.com and have added a comment.. still no luck

[Johannes Geppert]

there exists several tutorials which shows you how to access a database.

http://techblog.zabuchy.net/2010/spring-hibernate-maven-struts2-integration-tutorial/
http://techblog.zabuchy.net/2010/spring-hibernate-maven-and-struts2-integration-tutorial-part-2/

The CustomerDao can be a class which access the Database you prefer
and map the result to an Java Object.

For the Struts2 jQuery Grid Plugin you need to use the json plugin.
which transform your database result in a json object.

[Johannes Geppert]

Maybe also this tutorials helps you out.

http://javanus.com/blogs/?p=182

[luckay win]

I am learning what you wrote on http://www.weinfreund.de/struts2-jquery-showcase/index.action
I have downloaded the source codes..

I tried to read the source codes ..and currently I am on JsonTable.java..
I met the following stack trace below:

HTTP Status 500 -

type Exception report
message
descriptionThe server encountered an internal error () that prevented it from fulfilling this request.
exception
java.lang.UnsupportedOperationException: Not supported yet.

it thrown on this line below:


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"); // this line thrown the above exception


please help

thanks & regards
Winan

[luckay win]

any clue? .. how to show records to the grid?
the codes below compiled with no errors or warnings .. but still unable to show the records array into the grid.. it seems like the gridModel does not effect the .jsp page..

    
private List<Host>            gridModel;
  private List<Host>          myHosts;
  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;

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)
    {
      myHosts = (List<Host>) list;
    }
    else
    {
      log.debug("Build new List");
      myHosts = HostDAO.buildList();
    }

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

    setRecord(HostDAO.getHostCount(myHosts));

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

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

    if (loadonce)
    {
      setGridModel(myHosts);
    }
    else
    {
      if (searchString != null && searchOper != null)
      {
        int id = Integer.parseInt(searchString);
        if (searchOper.equalsIgnoreCase("eq"))
        {
          log.debug("search id equals " + id);
          List<Host> cList = new ArrayList<Host>();
          cList.add(HostDAO.findById(myHosts, id));
          setGridModel(cList);
        }
        else if (searchOper.equalsIgnoreCase("ne"))
        {
          log.debug("search id not " + id);
          setGridModel(HostDAO.findNotById(myHosts, id, from, to));
        }
        else if (searchOper.equalsIgnoreCase("lt"))
        {
          log.debug("search id lesser then " + id);
          setGridModel(HostDAO.findLesserAsId(myHosts, id, from, to));
        }
        else if (searchOper.equalsIgnoreCase("gt"))
        {
          log.debug("search id greater then " + id);
          setGridModel(HostDAO.findGreaterAsId(myHosts, id, from, to));
        }
      }
      else
      {
        setGridModel(HostDAO.getHosts(myHosts, from, to));
      }
    }
    setTotal((int) Math.ceil((double) getRecord() / (double) getRows()));
    session.put("mylist", myHosts);           // myHosts already had array values ..
    return SUCCESS;
  }

<%@ taglib prefix="s" uri="/struts-tags"%>
<%@ taglib prefix="sj" uri="/struts-jquery-tags"%>
<%@ taglib prefix="sjg" uri="/struts-jquery-grid-tags"%>
<html>
    <head>
        <sj:head jqueryui="true" jquerytheme="redmond" />
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JQuery Grid Page</title>
    </head>
    <body>
        <h1>Hello World!</h1>
        <h2><s:property value="message"/></h2>
        <s:url id="remoteurl" action="doHelloStruts2p3"/>
        <sjg:grid
            id="gridtable"
            caption="Host Examples"
            dataType="json"
            href="%{remoteurl}"
            pager="true"
            gridModel="gridModel"
            rowList="10,15,20"
            rowNum="15"
            rownumbers="true"
            navigator="true"
            navigatorSearch="true"
            navigatorSearchOptions="{multipleSearch:true}"
            >
            <sjg:gridColumn name="hostid" index="hostid" title="ID" formatter="integer" sortable="false"/>
            <sjg:gridColumn name="hostname" index="hostname" title="Name" sortable="true"/>
            <sjg:gridColumn name="email" index="email" title="Email" sortable="true"/>
            <sjg:gridColumn name="remarks" index="remarks" title="Remarks" sortable="false"/>
        </sjg:grid>
    </body>
</html>

[dips pandey]

I Have been facing the same problem no error but my grid does not get populated with values please help..need to resolve this.

[Johannes Geppert]

without some informations, it is impossible to help you?

How looks your config and code? Do you have check your JSON result?

Johannes