Android Coursor出界

Question

代码运行良好，我在数据库中又添加了2条记录，开始出现问题。这是我的密码：

 //Workout Name Decider
    public String Workout_Name(String id_S) {
        String workout_name = "";
        String template = "";
        String holder = "";

        if (id_S.equals("REST")) {
            workout_name = "Rest";
        } else {
            String[] allColumns = new String[]{
                    Dbhelper.WORKOUTS_ID,
                    Dbhelper.WORKOUT_NAME,
                    Dbhelper.WORKOUT_TIME

            };
            Cursor cursor = database.query(Dbhelper.TABLE_WORKOUTS_STOCK, allColumns, "_id=\'" + id_S + "\'", null, null, null, null, "1");

            if (cursor != null) {
                cursor.moveToFirst();
                //id = cursor.getString(2);

                if (cursor.getString(1).contains("SPARTAN SPECIALE ADVANCED") || cursor.getString(1).contains("SPARTAN SPECIALE BEGINNER") || cursor.getString(1).contains("TRICEPS SMASHER REPS")) {
                    template = "(reps)";
                } else {
                    template = "(" + cursor.getString(2) + ")";
                }

            }


            try {
                workout_name_shortener = cursor.getString(1).split("\\s+");
            } catch (PatternSyntaxException ex) {
            }

            int counter = 0;

            for (int i = 0; i < workout_name_shortener.length; i++) {

                if (workout_name_shortener[i].equals("TIMER") || workout_name_shortener[i].equals("REPS") || workout_name_shortener[i].equals("ADVANCED") || workout_name_shortener[i].equals("BEGINNER") && counter != 0) {
                    break;
                } else {
                    holder += workout_name_shortener[i] + " ";
                }

                counter++;
            }

            workout_name = holder + template;


            cursor.close();
        }


        return workout_name;
    }

这里是错误：

致命异常：主进程：com.spartanbodyweightworkouts，PID:9198 java.lang.RuntimeException:无法启动活动组件信息{com.spartanbodyweightworkouts/com.spartanbodyweightworkouts.tabs.plan.planAdapter.planAdapter}:android.database.CursorIndexOutboundsException:请求索引0，android.app.ActivityThread.performLaunchActivity（ActivityThread.java:2416）的大小为0，android.app.ActivityThread.handleLaunchActivity（ActivityThread.java:2476）的大小为0，android.app.ActivityThread.java的大小为-wrap11（ActivityThread.java），android.os.Handler.dispatchMessage的大小为$H.handleMessage（ActivityThread.java:1344）（Handler.java:102）在android.os.Looper.loop（Looper.java:148）在android.app.ActivityThread.main（ActivityThread.java:5417）在java.lang.reflect.Method.invoke（Native Method）在com.android.internal.os.zgoteinit$MethodAndArgsCaller.run（zgoteinit.java:726）在com.android.internal.os.zgoteinit.java.main（zgoteinit:616）上原因：android.database.CursorIndexOutOfBoundsException:请求索引0，大小为0。。。。。

Answer 1

代码是工作，我犯了一个错误，而把数据在表中。

Answer 2

将if语句更改为：

if (cursor != null && cursor.moveToNext()) {
  //id = cursor.getString(2);
  if (cursor.getString(1).contains("SPARTAN SPECIALE ADVANCED") || cursor.getString(1).contains("SPARTAN SPECIALE BEGINNER") || cursor.getString(1).contains("TRICEPS SMASHER REPS")) {
    template = "(reps)";
  } else {
    template = "(" + cursor.getString(2) + ")";
  }
}