jQuery Grid Plugin - jqGridForum

Forum

November 2nd, 2014

A A A

Topic RSS

Related Topics sp_TopicIcon

Obtaining JSON object from struts action response

Tags: Struts1.x json jqgrid

06/01/2011
07:04

aarati

Member

Members

Forum Posts: 8

Member Since:
05/01/2011

Offline

Hello,

I get an empty grid when trying to obtain a json object from struts action method.

Making use of the following in the application:

1) Struts 1.2

2) JQGrid 3.8.2

3) JQuery 1.4.4

The Struts action method returns a json object after obtaining data from the database. See code below:

public ActionForward getJSONData(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {

…
…
JSONObject jsonObj = createJSONTestData();
response.setHeader("X-JSON", jsonObj.toString());
System.out.println("Final JSON OBj: " + jsonObj.toString());
return mapping.findForward(sForward);
}

/*
*This piece of code is the same as the php code mentioned in one of the examples
*provided in jqgrid demos
*/
public JSONObject createJSONTestData() {
….
….
//Hit the database and obtain the resultset and create the json object

JSONObject responcedata=new JSONObject();
net.sf.json.JSONArray cellarray=new net.sf.json.JSONArray();
responcedata.put("total","3″);
responcedata.put("page",cpage);
responcedata.put("records","2″);

net.sf.json.JSONArray cell=new net.sf.json.JSONArray();
net.sf.json.JSONObject cellobj=new net.sf.json.JSONObject();

int i=1;
while(rs.next()){
  cellobj.put("id",rs.getInt(1));
  cell.add(rs.getInt(1));
  cell.add(rs.getString(2));
  cell.add(rs.getString(3));
  cellobj.put("cell",cell);
  cell.clear();
  cellarray.add(cellobj);
  i++;
        }
PrintWriter out = response.getWriter();
responcedata.put("rows",cellarray);

return responcedata;

}

The struts-config.xml action forward mapping points to an empty.jsp that has no specific code.

The jsp file formulates the jqgrid as shown below:

$(document).ready(function(){
$("#load_callback1″).click(function(){
jQuery("#list10″).jqGrid({
url:'/TestJSON/testAction.do?method=getJSONData',
datatype: "json",
   colNames:['Invoice Number','Invoice Date','Invoice Name'],
   colModel:[
     {name:'id',index:'id', id:'id',width:90},
     {name:'invdate',index:'invdate', width:120},
     {name:'invname',index:'invname', width:200}
   ],
   rowNum:10,
   autowidth: true,
   rowList:[10,20,30],
   pager: jQuery('#pager1'),
   sortname: 'invname',
    sortorder: "desc",
    caption:"JSON Example"
}).navGrid('#pager1',{edit:false,add:false,del:false});
});
});

The grid comes up with no data. A similar example works well with the doGet method of a servlet.

Questions:

1) How do we obtain the json object returned from a struts action method?

2) Is there any process to be done in the empty.jsp file to handle the response object and obtain the json data?

Awaiting for a clarification at the earliest. Thank you.

Regards,

Aarati

06/01/2011
09:26

aarati

Member

Members

Forum Posts: 8

Member Since:
05/01/2011

Offline

Hello,

Finally got it to work Smile .

Made slight modifications to the existing code:

Struts Action:

1) Earlier was returning to an empty jsp page with no specific code. Now returning null.

2) Using the write method of the jsonObj to write the response data.

The action method now looks like the following:

public ActionForward getJSONData(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {

…
…
JSONObject jsonObj = createJSONTestData();

System.out.println("Final JSON OBj: " + jsonObj.toString());

jsonObj.write(response.getWriter());

return null;
}

--------------------------------------------------------------------------------------------------------------------------

JSP:

JSP Code to populate the grid is shown below:

$(document).ready(function(){
$.ajax(
    {
       type: "POST",
       url:' /TestJSON/testAction.do?method=getJSONData',
       data: "",
       dataType: "json",
       success: function(result)
       {
            alert("success");
            alert("result: " + result.total);
            jQuery("#list10").jqGrid({
            url:' /TestJSON/testAction.do?method=getJSONData',
                datatype: 'json',
                mtype: 'POST',
                colNames:['Invoice Number','Invoice Date','Invoice Name'],
         colModel:[
             {name:'id',index:'id', id:'name',width:90},
             {name:'invdate',index:'invdate', width:120},
             {name:'invname',index:'invname', width:200}
    ],
                pager: jQuery('#pager1'),
                rowNum: 5,
                rowList: [5, 10, 20, 50],
                viewrecords: true
            })
       },
       error: function(x, e)
       {
            alert("errorddd " + x.readyState + " "+ x.status +" "+ e);
            if (x.readyState == 4) {
            var response = x.responseText;
            alert(response);
            }
       }
    });
setTimeout(function() {$("#list10").jqGrid('setGridParam',{datatype:'json'}); },50);
});

--------------------------------------------------------------------------------------------------------------------------

If any one faces any problem with the above mentioned implementation please post a reply to this topic.

Regards,

Aarati

20/03/2011
12:14

kirangentlebreeze1987

New Member

Members

Forum Posts: 1

Member Since:
20/03/2011

Offline

aarati said:

Hello,

Finally got it to work .

Made slight modifications to the existing code:

Struts Action:

1) Earlier was returning to an empty jsp page with no specific code. Now returning null.

2) Using the write method of the jsonObj to write the response data.

The action method now looks like the following:

public ActionForward getJSONData(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response) {

…
…
JSONObject jsonObj = createJSONTestData();

System.out.println("Final JSON OBj: " + jsonObj.toString());

jsonObj.write(response.getWriter());

return null;
}

--------------------------------------------------------------------------------------------------------------------------

JSP:

JSP Code to populate the grid is shown below:

$(document).ready(function(){
$.ajax(
    {
       type: "POST",
       url:' /TestJSON/testAction.do?method=getJSONData',
       data: "",
       dataType: "json",
       success: function(result)
       {
            alert("success");
            alert("result: " + result.total);
            jQuery("#list10").jqGrid({
            url:' /TestJSON/testAction.do?method=getJSONData',
                datatype: 'json',
                mtype: 'POST',
                colNames:['Invoice Number','Invoice Date','Invoice Name'],
         colModel:[
             {name:'id',index:'id', id:'name',width:90},
             {name:'invdate',index:'invdate', width:120},
             {name:'invname',index:'invname', width:200}
    ],
                pager: jQuery('#pager1'),
                rowNum: 5,
                rowList: [5, 10, 20, 50],
                viewrecords: true
            })
       },
       error: function(x, e)
       {
            alert("errorddd " + x.readyState + " "+ x.status +" "+ e);
            if (x.readyState == 4) {
            var response = x.responseText;
            alert(response);
            }
       }
    });
setTimeout(function() {$("#list10").jqGrid('setGridParam',{datatype:'json'}); },50);
});

--------------------------------------------------------------------------------------------------------------------------

If any one faces any problem with the above mentioned implementation please post a reply to this topic.

Regards,

Aarati

i do have some problem populating a json object values to my grid

can you help me???

24/03/2011
05:36

aarati

Member

Members

Forum Posts: 8

Member Since:
05/01/2011

Offline

Hi Kiran,

Which version of struts are you using? What is the problem that you are facing?

Regards,

Aarati

26/04/2011
07:39

moin_mkhan

New Member

Members

Forum Posts: 1

Member Since:
26/04/2011

Offline

aarati said:

Hello,

Finally got it to work .

Made slight modifications to the existing code:

Struts Action:

1) Earlier was returning to an empty jsp page with no specific code. Now returning null.

2) Using the write method of the jsonObj to write the response data.

The action method now looks like the following:

public ActionForward getJSONData(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response) {

…
…
JSONObject jsonObj = createJSONTestData();

System.out.println("Final JSON OBj: " + jsonObj.toString());

jsonObj.write(response.getWriter());

return null;
}

--------------------------------------------------------------------------------------------------------------------------

JSP:

JSP Code to populate the grid is shown below:

$(document).ready(function(){
$.ajax(
    {
       type: "POST",
       url:' /TestJSON/testAction.do?method=getJSONData',
       data: "",
       dataType: "json",
       success: function(result)
       {
            alert("success");
            alert("result: " + result.total);
            jQuery("#list10").jqGrid({
            url:' /TestJSON/testAction.do?method=getJSONData',
                datatype: 'json',
                mtype: 'POST',
                colNames:['Invoice Number','Invoice Date','Invoice Name'],
         colModel:[
             {name:'id',index:'id', id:'name',width:90},
             {name:'invdate',index:'invdate', width:120},
             {name:'invname',index:'invname', width:200}
    ],
                pager: jQuery('#pager1'),
                rowNum: 5,
                rowList: [5, 10, 20, 50],
                viewrecords: true
            })
       },
       error: function(x, e)
       {
            alert("errorddd " + x.readyState + " "+ x.status +" "+ e);
            if (x.readyState == 4) {
            var response = x.responseText;
            alert(response);
            }
       }
    });
setTimeout(function() {$("#list10").jqGrid('setGridParam',{datatype:'json'}); },50);
});

--------------------------------------------------------------------------------------------------------------------------

If any one faces any problem with the above mentioned implementation please post a reply to this topic.

Regards,

Aarati

Hi,

For populating the grid this code works fine. But i am unable to make the grid editable even by setting the editable:true option.

Can you please help resolve this issue?

Thanks,

Moin

02/07/2011
08:47

mlotfi

Boston

New Member

Members

Forum Posts: 2

Member Since:
28/05/2010

Offline

Hi aarati,

I am new here, I will appreciate if you can send me the src code of a working example using :

1) Struts 1.2

2) JQGrid 3.8.2

3) JQuery 1.4.4

my email is : majidnakit@yahoo.com

Thanks lot.

03/07/2011
10:05

aarati

Member

Members

Forum Posts: 8

Member Since:
05/01/2011

Offline

moin_mkhan said:

aarati said:

Hello,

Finally got it to work .

Made slight modifications to the existing code:

Struts Action:

1) Earlier was returning to an empty jsp page with no specific code. Now returning null.

2) Using the write method of the jsonObj to write the response data.

The action method now looks like the following:

public ActionForward getJSONData(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response) {

…
…
JSONObject jsonObj = createJSONTestData();

System.out.println("Final JSON OBj: " + jsonObj.toString());

jsonObj.write(response.getWriter());

return null;
}

--------------------------------------------------------------------------------------------------------------------------

JSP:

JSP Code to populate the grid is shown below:

$(document).ready(function(){
$.ajax(
    {
       type: "POST",
       url:' /TestJSON/testAction.do?method=getJSONData',
       data: "",
       dataType: "json",
       success: function(result)
       {
            alert("success");
            alert("result: " + result.total);
            jQuery("#list10").jqGrid({
            url:' /TestJSON/testAction.do?method=getJSONData',
                datatype: 'json',
                mtype: 'POST',
                colNames:['Invoice Number','Invoice Date','Invoice Name'],
         colModel:[
             {name:'id',index:'id', id:'name',width:90},
             {name:'invdate',index:'invdate', width:120},
             {name:'invname',index:'invname', width:200}
    ],
                pager: jQuery('#pager1'),
                rowNum: 5,
                rowList: [5, 10, 20, 50],
                viewrecords: true
            })
       },
       error: function(x, e)
       {
            alert("errorddd " + x.readyState + " "+ x.status +" "+ e);
            if (x.readyState == 4) {
            var response = x.responseText;
            alert(response);
            }
       }
    });
setTimeout(function() {$("#list10").jqGrid('setGridParam',{datatype:'json'}); },50);
});

--------------------------------------------------------------------------------------------------------------------------

If any one faces any problem with the above mentioned implementation please post a reply to this topic.

Regards,

Aarati

Hi,

For populating the grid this code works fine. But i am unable to make the grid editable even by setting the editable:true option.

Can you please help resolve this issue?

Thanks,

Moin

Did you include the necessary js files required for making the jqgrid editable.

Regards,

Aarati

10/02/2012
14:42

surendra

Noida

Member

Members

Forum Posts: 3

Member Since:
10/02/2012

Offline

kirangentlebreeze1987 said:

aarati said:

Hello,

Finally got it to work .

Made slight modifications to the existing code:

Struts Action:

1) Earlier was returning to an empty jsp page with no specific code. Now returning null.

2) Using the write method of the jsonObj to write the response data.

The action method now looks like the following:

public ActionForward getJSONData(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response) {

…
…
JSONObject jsonObj = createJSONTestData();

System.out.println("Final JSON OBj: " + jsonObj.toString());

jsonObj.write(response.getWriter());

return null;
}

--------------------------------------------------------------------------------------------------------------------------

JSP:

JSP Code to populate the grid is shown below:

$(document).ready(function(){
$.ajax(
    {
       type: "POST",
       url:' /TestJSON/testAction.do?method=getJSONData',
       data: "",
       dataType: "json",
       success: function(result)
       {
            alert("success");
            alert("result: " + result.total);
            jQuery("#list10").jqGrid({
            url:' /TestJSON/testAction.do?method=getJSONData',
                datatype: 'json',
                mtype: 'POST',
                colNames:['Invoice Number','Invoice Date','Invoice Name'],
         colModel:[
             {name:'id',index:'id', id:'name',width:90},
             {name:'invdate',index:'invdate', width:120},
             {name:'invname',index:'invname', width:200}
    ],
                pager: jQuery('#pager1'),
                rowNum: 5,
                rowList: [5, 10, 20, 50],
                viewrecords: true
            })
       },
       error: function(x, e)
       {
            alert("errorddd " + x.readyState + " "+ x.status +" "+ e);
            if (x.readyState == 4) {
            var response = x.responseText;
            alert(response);
            }
       }
    });
setTimeout(function() {$("#list10").jqGrid('setGridParam',{datatype:'json'}); },50);
});

--------------------------------------------------------------------------------------------------------------------------

If any one faces any problem with the above mentioned implementation please post a reply to this topic.

Regards,

Aarati

i do have some problem populating a json object values to my grid

can you help me???

10/02/2012
14:43

surendra

Noida

Member

Members

Forum Posts: 3

Member Since:
10/02/2012

Offline

aarati said:

Hello,

I get an empty grid when trying to obtain a json object from struts action method.

Making use of the following in the application:

1) Struts 1.2

2) JQGrid 3.8.2

3) JQuery 1.4.4

The Struts action method returns a json object after obtaining data from the database. See code below:

public ActionForward getJSONData(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response) {

…
…
JSONObject jsonObj = createJSONTestData();
response.setHeader("X-JSON", jsonObj.toString());
System.out.println("Final JSON OBj: " + jsonObj.toString());
return mapping.findForward(sForward);
}

/*
*This piece of code is the same as the php code mentioned in one of the examples
*provided in jqgrid demos
*/
public JSONObject createJSONTestData() {
….
….
//Hit the database and obtain the resultset and create the json object

JSONObject responcedata=new JSONObject();
net.sf.json.JSONArray cellarray=new net.sf.json.JSONArray();
responcedata.put("total","3″);
responcedata.put("page",cpage);
responcedata.put("records","2″);

net.sf.json.JSONArray cell=new net.sf.json.JSONArray();
net.sf.json.JSONObject cellobj=new net.sf.json.JSONObject();

int i=1;
while(rs.next()){
  cellobj.put("id",rs.getInt(1));
  cell.add(rs.getInt(1));
  cell.add(rs.getString(2));
  cell.add(rs.getString(3));
  cellobj.put("cell",cell);
  cell.clear();
  cellarray.add(cellobj);
  i++;
        }
PrintWriter out = response.getWriter();
responcedata.put("rows",cellarray);

return responcedata;

}

The struts-config.xml action forward mapping points to an empty.jsp that has no specific code.

The jsp file formulates the jqgrid as shown below:

$(document).ready(function(){
$("#load_callback1″).click(function(){
jQuery("#list10″).jqGrid({
url:'/TestJSON/testAction.do?method=getJSONData',
datatype: "json",
   colNames:['Invoice Number','Invoice Date','Invoice Name'],
   colModel:[
     {name:'id',index:'id', id:'id',width:90},
     {name:'invdate',index:'invdate', width:120},
     {name:'invname',index:'invname', width:200}
   ],
   rowNum:10,
   autowidth: true,
   rowList:[10,20,30],
   pager: jQuery('#pager1'),
   sortname: 'invname',
    sortorder: "desc",
    caption:"JSON Example"
}).navGrid('#pager1',{edit:false,add:false,del:false});
});
});

The grid comes up with no data. A similar example works well with the doGet method of a servlet.

Questions:

1) How do we obtain the json object returned from a struts action method?

2) Is there any process to be done in the empty.jsp file to handle the response object and obtain the json data?

Awaiting for a clarification at the earliest. Thank you.

Regards,

Aarati

10/02/2012
14:47

surendra

Noida

Member

Members

Forum Posts: 3

Member Since:
10/02/2012

Offline

hiii aarti would you explain how to use jquery , json with java & jsp in struts 1.2 ? Please clarrify your code and what is the use url an how to automaically create jquery grid in jsp.

26/06/2012
15:07

rohan.gandhi

New Member

Members

Forum Posts: 1

Member Since:
26/06/2012

Offline

Thanks a zillion Arati! That works like magic! Cool

13/09/2012
05:30

vsendhil

Sydney

Member

Members

Forum Posts: 3

Member Since:
13/09/2012

Offline

What are the java libraries (jar) required for json?

I tried the above with json-lib-2.2.2-jdk15.jar and I am getting "java.lang.NoClassDefFoundError: net.sf.ezmorph.Morpher" error.

13/09/2012
10:18

vsendhil

Sydney

Member

Members

Forum Posts: 3

Member Since:
13/09/2012

Offline

aarati said:

Hello,

Finally got it to work .

Made slight modifications to the existing code:

Struts Action:

1) Earlier was returning to an empty jsp page with no specific code. Now returning null.

2) Using the write method of the jsonObj to write the response data.

The action method now looks like the following:

public ActionForward getJSONData(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response) {

…
…
JSONObject jsonObj = createJSONTestData();

System.out.println("Final JSON OBj: " + jsonObj.toString());

jsonObj.write(response.getWriter());

return null;
}

--------------------------------------------------------------------------------------------------------------------------

JSP:

JSP Code to populate the grid is shown below:

$(document).ready(function(){
$.ajax(
    {
       type: "POST",
       url:' /TestJSON/testAction.do?method=getJSONData',
       data: "",
       dataType: "json",
       success: function(result)
       {
            alert("success");
            alert("result: " + result.total);
            jQuery("#list10").jqGrid({
            url:' /TestJSON/testAction.do?method=getJSONData',
                datatype: 'json',
                mtype: 'POST',
                colNames:['Invoice Number','Invoice Date','Invoice Name'],
         colModel:[
             {name:'id',index:'id', id:'name',width:90},
             {name:'invdate',index:'invdate', width:120},
             {name:'invname',index:'invname', width:200}
    ],
                pager: jQuery('#pager1'),
                rowNum: 5,
                rowList: [5, 10, 20, 50],
                viewrecords: true
            })
       },
       error: function(x, e)
       {
            alert("errorddd " + x.readyState + " "+ x.status +" "+ e);
            if (x.readyState == 4) {
            var response = x.responseText;
            alert(response);
            }
       }
    });
setTimeout(function() {$("#list10").jqGrid('setGridParam',{datatype:'json'}); },50);
});

--------------------------------------------------------------------------------------------------------------------------

If any one faces any problem with the above mentioned implementation please post a reply to this topic.

Regards,

Aarati

Hi Aarthi,

I tried this and I am getting the alerts but there is not table populated, could you please share the full source code (jsp and action) or let us know the steps to do this. Thanks

13/09/2012
10:19

vsendhil

Sydney

Member

Members

Forum Posts: 3

Member Since:
13/09/2012

Offline

vsendhil said:What are the java libraries (jar) required for json?

I tried the above with json-lib-2.2.2-jdk15.jar and I am getting "java.lang.NoClassDefFoundError: net.sf.ezmorph.Morpher" error.

I downloaded the JARs and fixed this

05/07/2014
09:47

anees.iny

New Member

Members

Forum Posts: 1

Member Since:
05/07/2014

Offline

kirangentlebreeze1987 said

aarati said:
Hello,

Finally got it to work .

Made slight modifications to the existing code:

Struts Action:

1) Earlier was returning to an empty jsp page with no specific code. Now returning null.

2) Using the write method of the jsonObj to write the response data.

The action method now looks like the following:

public ActionForward getJSONData(ActionMapping mapping, ActionForm form,
Â Â Â HttpServletRequest request, HttpServletResponse response) {

â€¦
â€¦
Â JSONObject jsonObj = createJSONTestData();

System.out.println("Final JSON OBj: " + jsonObj.toString());Â

jsonObj.write(response.getWriter());

return null;
Â }

Â

--------------------------------------------------------------------------------------------------------------------------

JSP:

JSP Code to populate the grid is shown below:

$(document).ready(function(){
$.ajax(
Â Â Â {
Â Â Â Â Â Â type: "POST",
Â Â Â Â Â Â url:' Â /TestJSON/testAction.do?method=getJSONData',
Â Â Â Â Â Â data: "",
Â Â Â Â Â Â dataType: "json",
Â Â Â Â Â Â success: function(result)
Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â alert("success");
Â Â Â Â Â Â Â Â Â Â Â alert("result: " + result.total);
Â Â Â Â Â Â Â Â Â Â Â jQuery("#list10").jqGrid({
Â Â Â Â Â Â Â Â Â Â Â Â url:' Â /TestJSON/testAction.do?method=getJSONData',
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â datatype: 'json',
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â mtype: 'POST',
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â colNames:['Invoice Number','Invoice Date','Invoice Name'],
Â Â Â Â Â Â Â Â colModel:[
Â Â Â Â Â Â Â Â Â Â Â Â {name:'id',index:'id', id:'name',width:90},
Â Â Â Â Â Â Â Â Â Â Â Â {name:'invdate',index:'invdate', width:120},
Â Â Â Â Â Â Â Â Â Â Â Â {name:'invname',index:'invname', width:200}
Â Â Â Â ],
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â pager: jQuery('#pager1'),
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â rowNum: 5,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â rowList: [5, 10, 20, 50],
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â viewrecords: true
Â Â Â Â Â Â Â Â Â Â Â })
Â Â Â Â Â Â },
Â Â Â Â Â Â error: function(x, e)
Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â alert("errorddd " + x.readyState + " "+ x.status +" "+ e);
Â Â Â Â Â Â Â Â Â Â Â if (x.readyState == 4) {
Â Â Â Â Â Â Â Â Â Â Â Â var response = x.responseText;
Â Â Â Â Â Â Â Â Â Â Â Â alert(response);
Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â }
Â Â Â });
setTimeout(function() {$("#list10").jqGrid('setGridParam',{datatype:'json'}); },50);
});

--------------------------------------------------------------------------------------------------------------------------

Â If any one faces any problem with the above mentioned implementation please post a reply to this topic.

Regards,

Aarati

i do have some problem populating a json object values to my gridÂ

can you help me???

Hi aarati,

Can u provide me full code which is mentioned above.I need it very urgently Pls reply fast.

Thanks,

anees.iny

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
29 Guest(s)

Currently Browsing this Page:
1 Guest(s)