Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- JSONObject jsonObject = JSONFactoryUtil.createJSONObject();
- JSONObject obj = JSONFactoryUtil.createJSONObject();
- JSONObject jsonObjectReturn = JSONFactoryUtil.createJSONObject();
- //JSONOBJECT RETURN
- JSONArray array = JSONFactoryUtil.createJSONArray();
- Session session = null;
- Connection conn = null;
- CallableStatement callableStatement = null;
- CallableStatement csUpdate = null;
- try {
- BeanLocator beanLocator = PortletBeanLocatorUtil
- .getBeanLocator("Mrcos-services-portlet");
- BasicDataSource bds = (BasicDataSource) beanLocator
- .locate("mrcosDataSourceTarget");
- conn = (Connection) bds.getConnection();
- jsonObject = JSONFactoryUtil.createJSONObject(stringArray);
- JSONArray jsonArray = jsonObject.getJSONArray("dataArray");
- JSONArray generateAlgo = TaxPayerLocalServiceUtil.checkAlgoEReceipt(stringArray);
- for (int i = 0; i < jsonArray.length(); i++) {
- obj = jsonArray.getJSONObject(i);
- obj2 = generateAlgo.getJSONObject(i);
- callableStatement = (CallableStatement) conn
- .prepareCall("{call TaxpaymentSPv2(?,?,?,?,?,?,?,?)}");
- callableStatement.setString(1, obj.getString("rdoCode"));
- callableStatement.setString(2, obj.getString("rcoCode"));
- callableStatement.setString(3, obj.getString("tpTin"));
- callableStatement.setString(4, obj.getString("tpName"));
- callableStatement.setString(5, obj.getString("tpAddress"));
- callableStatement.setString(6, obj.getString("receiptType"));
- callableStatement.registerOutParameter(7, Types.VARCHAR);
- callableStatement.registerOutParameter(8, Types.VARCHAR);
- callableStatement.executeUpdate();
- String rNo = callableStatement.getString(7);
- String date = callableStatement.getString(8);
- //---->This is my second Array inside my JSON where im having an error <------
- String checkArray = obj.getString("checkArray");
- JSONArray jsonArrayCheck = JSONFactoryUtil.createJSONArray(stringArray);
- JSONArray jsonArray2 = jsonObject.getJSONArray("checkArray");
- System.out.println("..........." + jsonArray2);
- jsonObjectReturn = JSONFactoryUtil.createJSONObject();
- jsonObjectReturn.put("rNo", rNo);
- jsonObjectReturn.put("date", date);
- array.put(jsonObjectReturn);
- }
- return array;
- {
- "dataArray": [{
- "rdoCode": "001",
- "rcoCode": "002911",
- "tpTin": "200746409",
- "tpName": "JOHN DOE",
- "tpAddress": "LA CALIFORNIA",
- "receiptType":"ROR",
- "receiptMode":"AUTO",
- "manualReceiptNo":"",
- "checkArray":[{
- "ptchkNumber": 14546,
- "ptchkDate": 2014-01-01,
- "ptchkAmount": 5332,
- "ptchkStatus": ""
- }]
- }]
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement