2017-03-21 15:33
浏览 1.0k

如何将JSON数组转换为Java String数组

I have a php file which fetches all rows from a specific column. The result is then put into an array and then json_encoded. When I Toast the output from the php file it shows a JSON string with the correct values. I need to convert this to a Java String array so I can iterate through it one by one on a button click.
I've tried multiple solutions on here but to no avail so any help will be greatly appreciated!


$sql = "SELECT advert_File_Path FROM Ads";
$result = $mysql_con->query($sql) or die('Query problem: '.mysqli_error($mysql_con));

//create array
$resultarray = array();

while($row = mysqli_fetch_assoc($result)){
    $resultarray[] = $row;
echo json_encode($resultarray); (only the code that is relevant)

 private void loadNextAdvert()
    Toast.makeText(this, "Please wait, image may take a few seconds to load...", Toast.LENGTH_LONG).show();

    dbhelper = (DbHelper) new DbHelper(new DbHelper.AsyncResponse() {
        public void processFinish(String output) {
            if(output.equalsIgnoreCase("exception") || output.equalsIgnoreCase("unsuccessful")){
                Toast.makeText(MainActivity.this, "Connection error", Toast.LENGTH_SHORT).show();
                //initializes ArrayList
                stringList = new ArrayList<>();
                try {
                    //initializes JSONArray with output from php getImage file
                    jsonArray = new JSONArray(output);
                    if(jsonArray != null){
                        int len = jsonArray.length();
                        for(int i=0; i<len; i++){

                } catch (JSONException e) {
                Toast.makeText(MainActivity.this, String.valueOf(stringList), Toast.LENGTH_LONG).show();

The Toast which should display the contents of the ArrayList just appears as '[]'.

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

4条回答 默认 最新

  • douge3113 2017-03-21 16:47

    Managed to solve it myself.
    So here goes,

    Step 1. I had to remove commented code from my php file as it was breaking through somehow, thats where the came from at the end of the JSON array.

    Step 2. I had to remove an additional echo from the php file which I was using for error checking. I think I'm right in saying the only echo you want to have is the json_encode.

    Step 3. Checked the length of JSONarray in Java and it was logging 5 so I now knew it was reading correctly.

    Step 4. Added Pavneet_Singh's code snippet to replace stringList.add(jsonArray.get(i).toString()); with stringList.add(jsonArray.getJSONObject(i).optString("advert_File_Path"));

    Step 5. Converted stringList from an ArrayList to a String array using this code stringArray = new String[stringList.size()]; stringArray = stringList.toArray(stringArray);

    Happy days! I've spent far too long trying to figure this out haha the first two steps are pretty noobish but it's sometimes the most obvious things in life that are the hardest to find. Hopefully this can help someone else too!

    解决 无用
    打赏 举报

相关推荐 更多相似问题