easyui 联表查询转json怎么搞啊 求大神解救

Question

easyui 联表查询转json

Answer 1

可以使用一些工具类
来把Object转成easyui要的 json啊
你自己拼接的json,好麻烦前台可以利用formatter来显示
$('#dg').datagrid({
columns:[[
{field:'userId',title:'User', width:80,
formatter: function(value,row,index){
if (row.user){
return row.user.name;
} else {
return value;
}
}
}
]]
});

Answer 2

最好下个json转换的jar包 可以直接一步转json格式
自己封装要累死 还常常出错

Answer 3

{"total":"2680","rows":[{"id":"154738","firstname":"","lastname":"","phone":"","email":""},{"id":"154740","firstname":"","lastname":"","phone":"","email":""},{"id":"154741","firstname":"","lastname":"","phone":"","email":""},{"id":"154743","firstname":"","lastname":"","phone":"","email":""},{"id":"154744","firstname":"","lastname":"","phone":"","email":""},{"id":"154745","firstname":"","lastname":"","phone":"","email":""},{"id":"154746","firstname":"","lastname":"","phone":"","email":""},{"id":"154747","firstname":"","lastname":"","phone":"","email":""},{"id":"154748","firstname":"","lastname":"","phone":"","email":""},{"id":"154749","firstname":"","lastname":"","phone":"","email":""}]}json 格式包括 total ，rows

Answer 4

最近才学这个  我的转出来时这样的
3191,"北京软件技术有限公司","哈哈（女士）","010-82843500",null,null,"null","软件系统开发","x.yan","普通客户","May 19, 2014 3:19:21 PM"

Answer 5

要是json格式的。 你看看api 吧。

Answer 6

var getParams=function(){
var b = false;
var paramArr=[];
$("[name='ary']").each(function(i){
if($(this).val().trim() != ''){
b = true;
var params={"ptext":$(this).attr("id"),"pvalue":$(this).val()};
paramArr.push(params);
}
});
if(!b)
return "";
return JSON.stringify(paramArr);
}
自己拼装(key,value) 在转成json  传到后台  再取出来

Answer 7

我是这样搞的  终于ok啦 
public static String PartListToJson(List list) {
    JSONArray json = new JSONArray();
           for (int i = 0; i < list.size(); i++) {
               Object[] obj = (Object[]) list.get(i);
               JSONObject jo = new JSONObject();
               jo.put("id",obj[0]);
               jo.put("companyName", obj[1]);
               jo.put("linkName", obj[2]);
               jo.put("tell", obj[3]);
               jo.put("telephone", obj[4]);
               jo.put("position", obj[5]);
               jo.put("email", obj[6]);
               jo.put("companyType", obj[7]);
               jo.put("createMan", obj[8]);
               jo.put("customerType", obj[9]);
               jo.put("createDate", "'"+obj[10]+"'");
               json.add(jo);
   }
    return json.toString();
}