dongling4383 2016-01-15 18:45 采纳率: 100%
浏览 651

如何修复FATAL EXCEPTION：AsyncTask＃2错误

I just want to access my database using PHP, and view the result in a Toast, but I don't know where I should looking for the error (FATAL EXCEPTION: AsyncTask #2).

Android Code:

btnLogin.setOnClickListener(new View.OnClickListener() {

        @Override
        public void onClick(View arg0) {
            // TODO Auto-generated method stub

            if (  ( !username.getText().toString().equals("")) && ( !password.getText().toString().equals("")) )
              {
                 new Connect().execute();
              }
              else if ( ( !username.getText().toString().equals("")) )
              {
                  Toast.makeText(getApplicationContext(),
                          "Password field empty", Toast.LENGTH_SHORT).show();
              }
              else if ( ( !password.getText().toString().equals("")) )
              {
                  Toast.makeText(getApplicationContext(),
                          "User Name field empty", Toast.LENGTH_SHORT).show();
              }
              else
              {
                  Toast.makeText(getApplicationContext(),
                          "User Name and Password field are empty", Toast.LENGTH_SHORT).show();
              }


        }
    });
}


class Connect extends AsyncTask<String, String, String>
{
    @Override
    protected String doInBackground(String... arg0) {
        // TODO Auto-generated method stub
        List<NameValuePair> params= new ArrayList<NameValuePair>();
        params.add(new BasicNameValuePair("username", username.getText().toString()));
        params.add(new BasicNameValuePair("password", password.getText().toString()));

        JSONObject json=JSONParser.getJSONFromUrl(loginURL, params);

        try {
            String login = json.getString(sTag_Login);
            if (login=="Admin") {
                Toast.makeText(getApplicationContext(), "Welcome Admin", Toast.LENGTH_LONG).show();
            }
            else if (login=="Customer") {
                Toast.makeText(getApplicationContext(), "Welcome", Toast.LENGTH_LONG).show();
            }
            {
                Toast.makeText(getApplicationContext(), "error ", Toast.LENGTH_LONG).show();
            }
        } catch(JSONException e) {
            e.printStackTrace();
        }

        return null;
    }
}

And this's my PHP code:

<?php

 // array for JSON response
$response = array();
$db = mysqli_connect('mysql.hostinger.ae','u641845309_ur','q1p0w2o9','u641845309_song');

// username and password sent from Form and protect MySQL injection for Security purpose
$username = $_POST['username']; 
$password = $_POST['password']; 

$sql = "SELECT * FROM customer WHERE UName='$username' and Password='$password'";

// Establishing Connection with Server by passing server_name, user_id and password as a parameter
$result=mysqli_query($db,$sql);  

// If result matched $myusername and $mypassword, table row must be 1 row
if ($result)
{ 
    while($row = mysqli_fetch_array($result)) {
        if(strtolower($username) == 'admin') 
            $response["login"] =   "Admin"; 
        else 
            $response["login"] = "Customer"; 
    }
}
else 
{
    $response["login"] ="error"; 
}

// echoing JSON response
echo json_encode($response);

JSON Code:

public class JSONParser {
    static InputStream is = null;
    static JSONObject jObj = null;
    static String json = "";

    // constructor
    public JSONParser() {

    }

    public static JSONObject getJSONFromUrl(String url, List<NameValuePair> params) {
        // Making HTTP request
        try {
            // defaultHttpClient
            DefaultHttpClient httpClient = new DefaultHttpClient();
            HttpPost httpPost = new HttpPost(url);
            httpPost.setEntity(new UrlEncodedFormEntity(params));

            HttpResponse httpResponse = httpClient.execute(httpPost);
            HttpEntity httpEntity = httpResponse.getEntity();
            is = httpEntity.getContent();

        } catch (UnsupportedEncodingException e) {
            e.printStackTrace();
        } catch (ClientProtocolException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }

        try {
            BufferedReader reader = new BufferedReader(new InputStreamReader(
                    is, "iso-8859-1"), 8);
            StringBuilder sb = new StringBuilder();
            String line = null;
            while ((line = reader.readLine()) != null) {
                sb.append(line + "
");
            }
            is.close();
            json = sb.toString();
            Log.e("JSON", json);
        } catch (Exception e) {
            Log.e("Buffer Error", "Error converting result " + e.toString());
        }

        // try parse the string to a JSON object
        try {
            jObj = new JSONObject(json);
        } catch (JSONException e) {
            Log.e("JSON Parser", "Error parsing data " + e.toString());
        }

        // return JSON String
        return jObj;

    }
}

And this is logcat:

01-15 13:49:35.770: D/gralloc_goldfish(2098): Emulator without GPU emulation detected.
01-15 13:49:39.800: D/dalvikvm(2098): GC_FOR_ALLOC freed 166K, 7% free 3117K/3348K, paused 54ms, total 68ms
01-15 13:49:39.800: D/InputEventConsistencyVerifier(2098): KeyEvent: ACTION_UP but key was not down.
01-15 13:49:39.800: D/InputEventConsistencyVerifier(2098):   in android.widget.LinearLayout{b3d26008 V.E..... ......I. 0,59-455,118}
01-15 13:49:39.800: D/InputEventConsistencyVerifier(2098):   0: sent at 8592505000000, KeyEvent { action=ACTION_UP, keyCode=KEYCODE_TAB, scanCode=15, metaState=0, flags=0x8, repeatCount=0, eventTime=8592505, downTime=8592401, deviceId=0, source=0x101 }
01-15 13:50:01.560: W/System.err(2098): java.net.UnknownHostException: Unable to resolve host "mwssong.esy.es": No address associated with hostname
01-15 13:50:01.570: W/System.err(2098):     at java.net.InetAddress.lookupHostByName(InetAddress.java:424)
01-15 13:50:01.580: W/System.err(2098):     at java.net.InetAddress.getAllByNameImpl(InetAddress.java:236)
01-15 13:50:01.580: W/System.err(2098):     at java.net.InetAddress.getAllByName(InetAddress.java:214)
01-15 13:50:01.580: W/System.err(2098):     at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:137)
01-15 13:50:01.590: W/System.err(2098):     at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:164)
01-15 13:50:01.590: W/System.err(2098):     at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:119)
01-15 13:50:01.590: W/System.err(2098):     at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:360)
01-15 13:50:01.600: W/System.err(2098):     at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:555)
01-15 13:50:01.600: W/System.err(2098):     at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:487)
01-15 13:50:01.600: W/System.err(2098):     at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:465)
01-15 13:50:01.600: W/System.err(2098):     at com.example.e_music.JSONParser.getJSONFromUrl(JSONParser.java:44)
01-15 13:50:01.610: W/System.err(2098):     at com.example.e_music.MainActivity$Connect.doInBackground(MainActivity.java:126)
01-15 13:50:01.620: W/System.err(2098):     at com.example.e_music.MainActivity$Connect.doInBackground(MainActivity.java:1)
01-15 13:50:01.620: W/System.err(2098):     at android.os.AsyncTask$2.call(AsyncTask.java:288)
01-15 13:50:01.620: W/System.err(2098):     at java.util.concurrent.FutureTask.run(FutureTask.java:237)
01-15 13:50:01.640: W/System.err(2098):     at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:231)
01-15 13:50:01.640: W/System.err(2098):     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112)
01-15 13:50:01.650: W/System.err(2098):     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587)
01-15 13:50:01.650: W/System.err(2098):     at java.lang.Thread.run(Thread.java:841)
01-15 13:50:01.670: W/System.err(2098): Caused by: libcore.io.GaiException: getaddrinfo failed: EAI_NODATA (No address associated with hostname)
01-15 13:50:01.670: W/System.err(2098):     at libcore.io.Posix.getaddrinfo(Native Method)
01-15 13:50:01.670: W/System.err(2098):     at libcore.io.ForwardingOs.getaddrinfo(ForwardingOs.java:61)
01-15 13:50:01.670: W/System.err(2098):     at java.net.InetAddress.lookupHostByName(InetAddress.java:405)
01-15 13:50:01.670: W/System.err(2098):     ... 18 more
01-15 13:50:01.680: E/Buffer Error(2098): Error converting result java.lang.NullPointerException: lock == null
01-15 13:50:01.680: E/JSON Parser(2098): Error parsing data org.json.JSONException: End of input at character 0 of 
01-15 13:50:01.680: W/dalvikvm(2098): threadid=12: thread exiting with uncaught exception (group=0xb3a22ba8)
01-15 13:50:01.750: E/AndroidRuntime(2098): FATAL EXCEPTION: AsyncTask #2
01-15 13:50:01.750: E/AndroidRuntime(2098): Process: com.example.e_music, PID: 2098
01-15 13:50:01.750: E/AndroidRuntime(2098): java.lang.RuntimeException: An error occured while executing doInBackground()
01-15 13:50:01.750: E/AndroidRuntime(2098):     at android.os.AsyncTask$3.done(AsyncTask.java:300)
01-15 13:50:01.750: E/AndroidRuntime(2098):     at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:355)
01-15 13:50:01.750: E/AndroidRuntime(2098):     at java.util.concurrent.FutureTask.setException(FutureTask.java:222)
01-15 13:50:01.750: E/AndroidRuntime(2098):     at java.util.concurrent.FutureTask.run(FutureTask.java:242)
01-15 13:50:01.750: E/AndroidRuntime(2098):     at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:231)
01-15 13:50:01.750: E/AndroidRuntime(2098):     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112)
01-15 13:50:01.750: E/AndroidRuntime(2098):     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587)
01-15 13:50:01.750: E/AndroidRuntime(2098):     at java.lang.Thread.run(Thread.java:841)
01-15 13:50:01.750: E/AndroidRuntime(2098): Caused by: java.lang.NullPointerException
01-15 13:50:01.750: E/AndroidRuntime(2098):     at com.example.e_music.MainActivity$Connect.doInBackground(MainActivity.java:129)
01-15 13:50:01.750: E/AndroidRuntime(2098):     at com.example.e_music.MainActivity$Connect.doInBackground(MainActivity.java:1)
01-15 13:50:01.750: E/AndroidRuntime(2098):     at android.os.AsyncTask$2.call(AsyncTask.java:288)
01-15 13:50:01.750: E/AndroidRuntime(2098):     at java.util.concurrent.FutureTask.run(FutureTask.java:237)
01-15 13:50:01.750: E/AndroidRuntime(2098):     ... 4 more
  • 写回答

2条回答 默认 最新

  • 普通网友 2016-01-15 19:04
    关注

    Remove your Toast from doInBackground(), AsyncTask is working independently from your UI activity, so if you want to call Toast in it, you should at least run it inside this block:

                    runOnUiThread(new Runnable() {
                    @Override
                    public void run() {
                        Toast.makeText(getApplicationContext(),
                                       "Your code is looking very bad!",
                                       Toast.LENGTH_LONG);
                    }
                });

    Another problem is, that your getJSONFromUrl() function might return null if any exception will occur in it, because you are doing nothing in your exception handlers to prevent it from returning null.
    Inside doInBackground() method you are trying to catch JSONException, but it likely will be a NullPointerException because of getJSONFromUrl() might return null. You need to review your code briefly. Consider using isEmpty() instead of comparing to empty strings, handle exceptions properly.
    You get clear UnknownHostException for mwssong.esy.es, did you add http:// to it?

    评论

报告相同问题？

悬赏问题

  • ¥15 apm2.8飞控罗盘bad health，加速度计校准失败
  • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
  • ¥15 谁有desed数据集呀
  • ¥20 手写数字识别运行c仿真时，程序报错错误代码sim211-100
  • ¥15 关于#hadoop#的问题
  • ¥15 (标签-Python|关键词-socket)
  • ¥15 keil里为什么main.c定义的函数在it.c调用不了
  • ¥50 切换TabTip键盘的输入法
  • ¥15 可否在不同线程中调用封装数据库操作的类
  • ¥15 微带串馈天线阵列每个阵元宽度计算