androidsql-serverweb-servicesjsonksoap

How to use JSON for inserting records into SQL database


Let's say I store a list of names , for eg: "abc","bcd","gdf"... in an array of Strings. I have an Android app that displays each of those values along with a checkbox. I need to convert my String array into a JSON String so that I can store it in a remote database. Right now I am working on localhost with a database created using SQL Server. I need to insert the JSON string values in the database using a web service , preferably SOAP

How should I do this ? Is there any other better way to do so ?

Here is my Android code.

Thanks


Solution

  • In my case this works fine,

              JSONObject jsonObject = new JSONObject();
    
                jsonObject.put("key1", value1);
                jsonObject.put("key2", value2);
    
                JSONArray jArrayParam = new JSONArray();
                jArrayParam.put(jsonObject);
    
                List<NameValuePair> nameValuePair = new ArrayList<NameValuePair>();
                nameValuePair.add(new BasicNameValuePair("bulkdata",
                        jArrayParam.toString()));
    
                Log.e("bulkdata", jArrayParam.toString());
    
            HttpClient httpclient = new DefaultHttpClient();
            HttpPost httppost = new HttpPost("yor remote database url");
    
            httppost.addHeader("Content-Type", "application/x-www-form-urlencoded");
            httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs, HTTP.UTF_8));
            // Execute HTTP Post Request
            HttpResponse response = httpclient.execute(httppost);
            // get response entity
            HttpEntity entity = response.getEntity();
    

    Try it. Thnx.