java - android 如何在android的Asynctask中加载sqlite数据

Question

我是java和android的新手。我想在 asyntask 类中获取 sqlite 行。但它返回 NullpointerException 我不知道如何传递 key ，任何人都可以告诉我实现这一目标的正确方法是什么。

类数据库

public class DatabaseHandler extends SQLiteOpenHelper {
private static final int DATABASE_VERSION=1;
private static final String DATABASE_NAME="cloud_contacts";
public static final String TABLE_LOGIN="login";
public static final String KEY_ID="id";
private static final String KEY_USERNAME="uname";
private static final String KEY_PASSWORD="password";
public static final String KEY_USERNAME_DEVICE="unamedevice";
public static final String KEY_PASSWORD_DEVICE="passworddevice";
private static final String CREATE_LOGIN_TABLE="CREATE TABLE "+TABLE_LOGIN + " ("
        +KEY_ID+" INTEGER PRIMARY KEY, "
        +KEY_USERNAME + " TEXT, "
        +KEY_PASSWORD + " TEXT, "
        +KEY_USERNAME_DEVICE + " TEXT, "
        +KEY_PASSWORD_DEVICE+" TEXT"+ ")";
public  DatabaseHandler(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
}


/**
 * tao bang sql user
 *
 */
@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(CREATE_LOGIN_TABLE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_LOGIN);
    onCreate(db);
}

public  String getKeyUsernameDevice(int id) {
    String infor = null;
     SQLiteDatabase db=DatabaseHandler.this.getWritableDatabase();
    Cursor cursor =  db.rawQuery("select " + KEY_USERNAME_DEVICE + " from  " + TABLE_LOGIN + " where " + KEY_ID
            + " =? ", new String[]{String.valueOf(1)});
    if (cursor != null) {
        // move cursor to first row
        if (cursor.moveToFirst()) {
            do {
                // Get version from Cursor
                infor = cursor.getString(cursor.getColumnIndex(KEY_USERNAME_DEVICE));
                // add the bookName into the bookTitles ArrayList
                // move to next row
            } while (cursor.moveToNext());
        }
    }
    return infor;
}
public  String getKeyPasswordDevice(int id) {
    String infor = null;
    SQLiteDatabase db=DatabaseHandler.this.getWritableDatabase();
    Cursor cursor =  db.rawQuery("select " + KEY_PASSWORD_DEVICE + " from  " + TABLE_LOGIN + " where " + KEY_ID
            + " =? ", new String[]{String.valueOf(1)});
    if (cursor != null) {
        // move cursor to first row
        if (cursor.moveToFirst()) {
            do {
                // Get version from Cursor
                infor = cursor.getString(cursor.getColumnIndex(KEY_PASSWORD_DEVICE));
                // add the bookName into the bookTitles ArrayList
                // move to next row
            } while (cursor.moveToNext());
        }
    }
    return infor;
}

类包含 Asyntask

   public  class MyCommandTask extends AsyncTask<String,Void,Document>
{
    String username;
    String password;
    DatabaseHandler databaseHandler;
    @Override
    protected void onPreExecute() {
        super.onPreExecute();
    }
    @Override
    protected Document doInBackground(String... params) {
        InputStream inputStream = null;
        HttpURLConnection urlConnection = null;
        try {
            this.databaseHandler=new DatabaseHandler(getApplicationContext());
            username=databaseHandler.getKeyUsernameDevice(1);
            password="admin";
            /* forming th java.net.URL object */
            URL url = new URL(params[0]);
            urlConnection = (HttpURLConnection) url.openConnection();
            String basicAuth ="Basic " + Base64.encodeToString((username + ":" + password).getBytes(),Base64.NO_WRAP);
            urlConnection.setRequestProperty("Authorization", basicAuth);
            /* for Get request */
            urlConnection.setRequestMethod("GET");
            inputStream =urlConnection.getInputStream();
            /* 200 represents HTTP OK */
            Document responseXML = parseXmlDom(inputStream);
            return responseXML;
        }
        catch (Exception ex)
        {
            ex.printStackTrace();
        }
       return null;

    }

Answer 1

好吧，首先要提高性能，不要在游标的所有迭代中搜索相同的 columnIndex。

你应该这样做:

if (cursor != null) {
    Integer colIndex = cursor.getColumnIndex(KEY_USERNAME_DEVICE);
    // move cursor to first row
    if (cursor.moveToFirst()) {
        do {
            // Get version from Cursor
            infor = cursor.getString( colIndex );
            // add the bookName into the bookTitles ArrayList
            // move to next row
        } while (cursor.moveToNext());
    }
}

然后你能告诉我们你的 logCat 以确定 NullpointerException 的位置吗？是？