Java Representation of JSON String

[Gregg Bolinger]

I'm trying to create a transport object in Java for a json string. I'm using jqGrid which is a jquery plugin and it accepts a json string representing the data in the table. Up to now I've hand coded the bits to take the data I need and construct the json String. I need to create a JavaBean that I can use a JSON library on to make things easier. But the json string I am dealing with is making me wonder if it is even going to be possible.

{"page":"1","total":2,"records":"13","rows":[
   {"id":"13","cell":["2007-10-06","Client 3","1000.00"]}
]}

That is a short example of the format of the json. Any help is appreciated. If I get something close in the mean time I'll post back.

[Gregg Bolinger]

Here's what I've got so far:

public class JsonModel {
  private String page;
  private String total;
  private String records;
  private List<JsonRow> rows;
 
  public String getPage() {
    return page;
  }
 
  public void setPage(String page) {
    this.page = page;
  }
 
  public String getTotal() {
    return total;
  }
 
  public void setTotal(String total) {
    this.total = total;
  }
 
  public String getRecords() {
    return records;
  }
 
  public void setRecords(String records) {
    this.records = records;
  }
 
  public List<JsonRow> getRows() {
    return rows;
  }
 
  public void setRows(List<JsonRow> rows) {
    this.rows = rows;
  }
}

public class JsonRow {
 
  private Integer id;
  private List<String> cell;
 
  public Integer getId() {
    return id;
  }
 
  public void setId(Integer id) {
    this.id = id;
  }
 
  public List<String> getCell() {
    return cell;
  }
 
  public void setCell(List<String> cell) {
    this.cell = cell;
  }
}

Populating the data with a single row I get:

{"class":"com.pnp.model.JsonModel","page":"12","records":"12","rows":[{"cell":["Test","Test 2","Test 3"],"class":"com.pnp.model.JsonRow","id":1}],"total":"12"}

It's not too far off but I don't need the class names. That might just be an API issue.

[Gregg Bolinger]

Actually, I think if I can get rid of the class values, I'll have what I need.

[Gregg Bolinger]

Yep, adjusting the json library to exclude the "class" was all that was left. Problem solved.

[David O'Meara]

Anything else you need?

[Jim Yingst]

I notice that in the original sample input, total appears to be an integer, and everything else is a string. In your generated output, total is a string, and id is an integer. Don't know if it matters, but it may cause some mismatch problems later. Or not.

[Gregg Bolinger]

Originally posted by Jim Yingst:
I notice that in the original sample input, total appears to be an integer, and everything else is a string. In your generated output, total is a string, and id is an integer. Don't know if it matters, but it may cause some mismatch problems later. Or not.

Thanks Jim. It doesn't seem to matter at the moment. I've blogged about the whole thing here.

[Jim Yingst]

I see. So this was all just a ploy to pimp your blog. Got it.

[Gregg Bolinger]

Originally posted by Jim Yingst:
I see. So this was all just a ploy to pimp your blog. Got it.

Darn. Busted.

[vicky kumar]

Hi Gregg,
I read your blog and found out that you converted the Java Bean into JqGrid specific JSON string using FlexJSON which is build on Java 1.5. Is there any way I can do the same using JDK1.4? FlexJSON doesn't 1.5 binaries.
Please suggest...

Thanks
Vicky

[Martijn Verburg]

Hi Vicky,

You might get more luck posting your question in a new thread as we try not to WakeTheZombies