JSON 변환

1. code

 

  List<Object> list = new ArrayList<Object>();

  JSONObject objTickets = new JSONObject();

  JSONArray arrTickets = new JSONArray();

  JSONObject objs = null;

  String sSql = "";

  String data = "";

  

  sSql = "SELECT OT.SEQ, OT.ORDER_NO, OT.KCODE, OT.BARCODE, OT.NAME, OT.MDN, ES.RNAME, ES.RMDN ";

  sSql += "FROM ORDER_TICKET OT LEFT OUTER JOIN ETC_SEASON ES ON (OT.SEQ=ES.T_SEQ) ";

  sSql += "WHERE 1=1";

  sSql += "    AND OT.NAME='aking'";

  sSql += "    AND OT.MDN='01000000000'";

  sSql += "    AND OT.STATUS=0";

  

  list = WebUtils.arrayListColumns_tables(sSql);

  int barCnt = list.size();

  

  if(!list.isEmpty() || barCnt >= 1) {

    for(int i=0; i < barCnt; i++) {

      objs = new JSONObject();

      objs.put("list", list.get(i));

      

      arrTickets.put(objs);

      objTickets.put("data", arrTickets);

      

    }

    

    data = objTickets.toString();

    

  } else {

    out.println("FAIL");

  }

  out.println(data);

 

 

 

2. json data

 

• data: 

   

  [

  •  

    {

    • list: 

       

      {

      • RNAME: "aking",
      • RMDN: "01000000000",
      • KCODE: "28747",
      • NAME: "aking",
      • BARCODE: "2195622600",
      • ORDER_NO: "E20160728125922_427989",
      • SEQ: "1484740",
      • MDN: "01000000000"

      }

    },
  •  

    {

    • list: 

       

      {

      • RNAME: null,
      • RMDN: null,
      • KCODE: "38131",
      • NAME: "aking",
      • BARCODE: "726903271604",
      • ORDER_NO: "E20161215175501_641843",
      • SEQ: "1988489",
      • MDN: "01000000000"

      }

    }

  ]

}