如何在Android上多次有效地查询sqlite数据库(How to efficiently query sqlite database multiple times on Android)

 对于我的应用程序，我需要查询sqlite数据库大约40-50次。 我确信我写的代码效率很低。 不幸的是，我找不到很多涉及多次查询数据库的在线示例。 
 
String[] entryValArray = new String[indicesList.size()];
DBHelper dbHelper = new DBHelper(MainActivity.context);
SQLiteDatabase db = dbHelper.getReadableDatabase();

for (int i = 0; i < indicesList.size(); i++) {
    int moddedIndex = Integer.parseInt(indicesList.get(i), 16) % DBHelper.numEntries;
    String queryStr = "select * from " + DBHelper.TBL_NAME + " where " + DBHelper.IDStr +
            " = " + Integer.toString(moddedIndex);
    Cursor cursor = db.rawQuery(queryStr, null);
    if (cursor.moveToFirst())
        entryValArray[i] = cursor.getString(1);
    cursor.close();
}
 
 基本上，我正在获取字符串列表，将它们转换为十六进制值，然后修改该值以获取sqlite数据库的索引。 这是一个密码生成器应用程序。 
 
 有没有更好的方法来执行此操作，尤其是在创建游标然后在每次迭代中关闭它时。 

For my application, I need to query a sqlite database around 40-50 times. I am sure that the code I wrote is very inefficient. Unfortunately, I cannot find many examples online that involves querying the database many times.
 
String[] entryValArray = new String[indicesList.size()];
DBHelper dbHelper = new DBHelper(MainActivity.context);
SQLiteDatabase db = dbHelper.getReadableDatabase();

for (int i = 0; i < indicesList.size(); i++) {
    int moddedIndex = Integer.parseInt(indicesList.get(i), 16) % DBHelper.numEntries;
    String queryStr = "select * from " + DBHelper.TBL_NAME + " where " + DBHelper.IDStr +
            " = " + Integer.toString(moddedIndex);
    Cursor cursor = db.rawQuery(queryStr, null);
    if (cursor.moveToFirst())
        entryValArray[i] = cursor.getString(1);
    cursor.close();
}
 
Basically, I am taking a list of strings, converting them to hex values, and then modding the value to get an index into a sqlite database. This is for a password generator application.
 
Is there a better way to do this, especially regarding creating a cursor and then closing it in every iteration.

原文：https://stackoverflow.com/questions/33622815