android - 在 BroadcastReceiver 中使用 sqlite

Question

我想在 android 中执行一个简单的任务，当接到电话时，电话号码将与我的数据库中的号码相匹配。但是我已经读到 sqlite 和 BroadcastReceiver 结合起来并不那么容易。下面是代码:

public class incomingcall extends BroadcastReceiver{

        String caller;
        Cursor c;

        @Override
        public void onReceive(Context context, Intent intent) {


                sqlitedatabase search = new sqlitedatabase(context);

                Bundle bundle = intent.getExtras(); 

                if(null == bundle)
                        return;

                Log.i("IncomingCallReceiver",bundle.toString());

                String state = bundle.getString(TelephonyManager.EXTRA_STATE);

                Log.i("IncomingCallReceiver","State: "+ state);

                if(state.equalsIgnoreCase(TelephonyManager.EXTRA_STATE_RINGING))
                {
                        String phonenumber = bundle.getString(TelephonyManager.EXTRA_INCOMING_NUMBER);

                        Log.i("IncomingCallReceiver","Incomng Number: " + phonenumber);

                        try{

                            search.open();

                            c = search.callinfo(phonenumber);

                            if(c != null){

                                int iFN = c.getColumnIndex("firstname");
                                int iLN = c.getColumnIndex("lastname");
                                String FN = c.getString(iFN);
                                String LN = c.getString(iLN);
                                caller = FN + " " + LN;
                            }
                            else{

                                caller = "Unknown";
                            }

                            search.close();
                         }

                        catch (Exception e){

                            Toast.makeText(context, "error"+e.toString(), Toast.LENGTH_LONG).show();
                        }

                        Toast.makeText(context, caller, Toast.LENGTH_LONG).show();
                }
        }
}

我认为问题不在于方法“.callinfo()”，尽管如此我还是在下面发布了它:

public Cursor callinfo(String l) {
        // TODO Auto-generated method stub
        String[] columns = new String[]{"phonenumber", "homenumber"};
        Cursor c = db.query("mycontacts", columns, "phonenumber = " + l + " OR " + "homenumber = " + l, null, null, null, null);
        return c;
    }

Catch 返回:errorandroid.database.CursorIndexOutOfBoundsException:请求索引 -1，大小为 1。

预先感谢您能给我的任何帮助。

干杯

Answer 1

因为初始光标位置是-1，所以尝试使用if(c.moveToNext())而不是if(c != null)。