java编写的json转select

package com.jdc.tplatform.utils;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import net.sf.json.JSONArray;
public class a {
public static void main(String[] args) {

    //JSONArray型装换成map遍历
    String jsonStr = "\n" +
            "[\n" +
            "    {\n" +
            "        \"x\":\"建筑建材\",\n" +
            "        \"y\":10\n" +
            "    },\n" +
            "    {\n" +
            "        \"x\":\"设备产品\",\n" +
            "        \"y\":20\n" +
            "    },\n" +
            "    {\n" +
            "        \"x\":\"食品加工\",\n" +
            "        \"y\":20\n" +
            "    },\n" +
            "    {\n" +
            "        \"x\":\"钢铁矿产\",\n" +
            "        \"y\":27\n" +
            "    },\n" +
            "    {\n" +
            "        \"x\":\"对外贸易\",\n" +
            "        \"y\":23\n" +
            "    },\n" +
            "    {\n" +
            "        \"x\":\"1\",\n" +
            "        \"y\":27\n" +
            "    },\n" +
            "    {\n" +
            "        \"x\":\"2\",\n" +
            "        \"y\":23\n" +
            "    }\n" +
            "]\n" +
            "\n";

    JSONArray array = JSONArray.fromObject(jsonStr);
    //System.out.println(array);
    String sqls="";
    List<Map<String, Object>> mapListJson = (List<Map<String, Object>>) array;
    for (int i = 0; i < mapListJson.size(); i++) {
        Map<String, Object> obj = mapListJson.get(i);
        String sql = "select ";
        int j= 0;
        for (Entry<String, Object> entry : obj.entrySet()) {
            String strkey1 = entry.getKey();
            Object strval1 = entry.getValue();
            if(j==obj.size()-1){
                sql = sql + " '" + strval1 + "' " + "as " + strkey1 + " ";
            }else {
                sql = sql + " '" + strval1 + "' " + "as " + strkey1 + ", ";
            }
            j++;
        }
        if(i==mapListJson.size()-1){
            sqls = sqls + sql + ";";
        }else{
        sqls = sqls + sql + " union all ";
        }
    }
    System.out.println(sqls);
}

}