JAVA SQLite : Error Bad Request Field

Question

我在将搜索数据存储到列表时遇到问题。谁能检查我的存储数组和数组列表的构造。谢谢。

标签 CursorWinow:字段槽 0,12 的请求错误。行数 = 49，列数 = 12

public List<HashMap<String, String>> getAllDataFromTable(String tableName) {//, String[] ColumnList
        List<HashMap<String, String>> TableDataCollection;
        TableDataCollection = new ArrayList<HashMap<String, String>>();

        String selectQuery = "SELECT  * FROM " +tableName;
        SQLiteDatabase database = this.getWritableDatabase();
        Cursor cursor = database.rawQuery(selectQuery, null);
        String ColumnCollection[];

        int totalRecord=cursor.getColumnCount();
        if(tableName=="tbl_account_codes")
        {
        if (cursor.moveToFirst()) {
          do {
              int i=cursor.getColumnNames().length;
              ColumnCollection=new String[i];

              String MainColumnCollection[];
              MainColumnCollection=new String[i];
             String[] MyColumn= ColumnCollection=cursor.getColumnNames();//column
              for(int a=0;a<=i;a++) 
              {

                  MainColumnCollection[a]=(cursor.getString(a).toString());//= ColumnCollection[a]
                  String z="wala lang";
                  String x="wala lang";

                  //String AssignCol= MyColumn[a];
              }

               TableDataCollection.add((HashMap<String, String>) Arrays.asList(MainColumnCollection));
               String c="wala lang";
              } while (cursor.moveToNext());
            }
            return TableDataCollection;
            }
TableDataCollection.add((HashMap<String, String>) Arrays.asList(MainColumnCollection));

我在这条线上遇到问题。谢谢

Answer 1

尝试下面的行

MainColumnCollection[a]=(cursor.getString(cursor.getColumnIndex("YOUR_COLUMN_NAME")));

而不是

MainColumnCollection[a]=(cursor.getString(a).toString());

编辑

从 for 循环中删除 = 并进行如下更改

for(int a=0;a<i;a++)