转换成json

win3394393

这个是在  UI层下面.J文件中查出的   数据库  内容  {"rows":[{"FCODE":{"changed":"1","value":"440000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"360000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"430000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"350000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"520000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"340000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"530000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"370000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"410000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"420000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"540000","originalValue":null},"FNAME":{"changed":"1","value":"?????","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"140000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"110000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"120000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"130000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"310000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"320000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"330000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"150000","originalValue":null},"FNAME":{"changed":"1","value":"??????","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"210000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"220000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"230000","originalValue":null},"FNAME":{"changed":"1","value":"????","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"630000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"450000","originalValue":null},"FNAME":{"changed":"1","value":"???????","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"510000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"660000","originalValue":null},"FNAME":{"changed":"1","value":"????????","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"610000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"620000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"640000","originalValue":null},"FNAME":{"changed":"1","value":"???????","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"650000","originalValue":null},"FNAME":{"changed":"1","value":"????????","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"460000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}},{"FCODE":{"changed":"1","value":"500000","originalValue":null},"FNAME":{"changed":"1","value":"???","originalValue":null},"userdata":{"recordState":"new"}}],"@type":"table","userdata":{"relationTypes":"String,String","relationAlias":"FCODE,FNAME","relations":"EXPRESS,EXPRESS","updateMode":"whereVersion"}}



怎么转换成 这种  JSON   格式
[{
    "adcd": "",
    "adnm": "全部"
}, {
    "adcd": "100000",
    "adnm": "北京"
}, {
    "adcd": "430000",
    "adnm": "湖南"
}, {
    "adcd": "230000",
    "adnm": "湖北"
}]

吉他爱天涯

都是json数据，具体需求是什么？

win3394393

怎么转换成 这种  JSON   格式
[{
     "adcd": "",
     "adnm": "全部"
}, {
     "adcd": "100000",
     "adnm": "北京"
}, {
     "adcd": "430000",
     "adnm": "湖南"
}, {
     "adcd": "230000",
     "adnm": "湖北"
}]         
外面一个中括号，  里面有很多大括号
要这种固定的 格式

吉他爱天涯

win3394393 发表于 2013-6-6 13:28
怎么转换成 这种  JSON   格式
[{
     "adcd": "",

外面加[]  ,就行

win3394393

吉他爱天涯 发表于 2013-6-6 14:00
外面加[]  ,就行

不是  外面现在多{}东西，要把[] 这个外面的    {}   去掉   ，要里面的[] 的内容   
"{"FCODE":{"changed":"1","value":"440000","originalValue":null}," 变成  {"FCODE":410000,"FNAME":"北京"}

win3394393

win3394393 发表于 2013-6-6 14:08
不是  外面现在多{}东西，要把[] 这个外面的    {}   去掉   ，要里面的[] 的内容   
"{"FCODE":{"change ...

        private String getProvinceAdcdInfo()throws UnknownHostException{
                //business-server
                String BusinessServer="http://127.0.0.1:8080/BusinessServer";
                String loginName="system";
                String password="123456";
                String localIp = java.net.InetAddress.getLocalHost().getHostAddress();
                String res = "";
       
        Action action=new Action();  
                action.setProcess("/strplan/org/m06Gis/process/sheng/shengProcess");
                action.setActivity("mainActivity");
                action.setName("shengAction");
               

            //初始化Action引擎
                ActionEngine.init(BusinessServer);
            //获取bSessionID
                String bSessionID = ActionEngine.login(loginName, ActionUtils.md5(password), localIp, null);
               
                //执行Action
                ActionResult result=ActionEngine.invokeAction(action, ActionUtils.JSON_CONTENT_TYPE, bSessionID,null, null);
        //判断是否执行了Action
        System.out.println("-----------------------------------");
                if(result.isSuccess()){
                        res = result.getDatas().get(0).toString();
                }else{
                        res = "error";
                }
               
                return res;
               
        }
}
这是我 写的代码  哪里需要改

吉他爱天涯

win3394393 发表于 2013-6-6 14:08
不是  外面现在多{}东西，要把[] 这个外面的    {}   去掉   ，要里面的[] 的内容   
"{"FCODE":{"change ...

QQ  519895187  聊一下

win3394393

吉他爱天涯 发表于 2013-6-6 14:23
QQ  519895187  聊一下

OK  问题解决了 谢谢

win3394393

win3394393 发表于 2013-6-7 10:29
OK  问题解决了 谢谢

主要是改动 你的Action    返回结果变成 把Table变成List   就行了    如果是Table  会附带一些东西 去不掉

win3394393

win3394393 发表于 2013-6-7 10:31
主要是改动 你的Action    返回结果变成 把Table变成List   就行了    如果是Table  会附带一些东西 去 ...

StringBuffer sb = new StringBuffer();
  return sb.toString()