java - 如果我只使用 SQLite 返回一行，是否需要循环？ (安卓开发)

Question

我一直在使用以下方法使用 for 循环，但我突然想到我只返回一行 - 那么是否有必要有一个循环？

即我的代码类似于:

public String topSwimmerSponsor() {
    Cursor c = ourDatabase.rawQuery("SELECT " + KEY_SWIMMERLAPS + " * "
            + KEY_SPONSOR + " AS result, " + KEY_NAME + " FROM "
            + DATABASE_TABLE + " ORDER BY result DESC limit 1", null);

    String result = "";

    for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {
        result = result + c.getString(1) + "\n";
    }
    return result;
}

但是我试图将其更改为以下内容:

public String topSwimmerSponsor() {
    Cursor c = ourDatabase.rawQuery("SELECT " + KEY_SWIMMERLAPS + " * "
            + KEY_SPONSOR + " AS result, " + KEY_NAME + " FROM "
            + DATABASE_TABLE + " ORDER BY result DESC limit 1", null);

    String result = "";

    result = result + c.getString(1) + "\n";

    return result;
}

但是我的应用程序崩溃了。实现这个的正确方法是什么？谢谢。

Answer 1

如果您只期望一个结果，您可以使用此:

if(c.moveToFirst())
  return c.getString(1) + "\n";