由于 java.lang.IllegalArgumentException: 列“_id"不存在，应用程序在启动时崩溃 [英] App Crashes On Startup Due To java.lang.IllegalArgumentException: column '_id' does not exist

问题描述

每当我启动我的应用程序时，我都会在我的 LogCat 中收到 java.lang.IllegalArgumentException: column '_id' does not exist 错误.我已经创建了 '_id' 列，但它仍然抛出这个.这是我的主要 .java:

package com.gantt.shoppinglist;导入 android.app.Dialog;导入 android.app.ListActivity;导入 android.database.Cursor;导入 android.os.Bundle;导入 android.view.View;导入 android.view.View.OnClickListener;导入 android.widget.Button;导入 android.widget.EditText;导入 android.widget.ListView;导入 android.widget.SimpleCursorAdapter;公共类 ShoppingList 扩展了 ListActivity {私有 DataHelper DataHelper；/** 在第一次创建活动时调用.*/@覆盖protected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.main);DataHelper = new DataHelper(this);光标 c = (Cursor) DataHelper.selectAll();long id = c.getLong(c.getColumnIndex("_id"));startManagingCursor(c);ListView lv = (ListView) findViewById(android.R.id.list);String[] from = new String[] { com.gantt.shoppinglist.DataHelper.getDatabaseName() };int[] to = new int[] { android.R.id.text1 };SimpleCursorAdapter 适配器 = new SimpleCursorAdapter(this,android.R.layout.simple_list_item_1, c, from, to);lv.setAdapter(适配器);按钮 button1main = (Button) findViewById(R.id.add);button1main.setOnClickListener(new OnClickListener() {@覆盖public void onClick(View v) {final Dialog additem = new Dialog(ShoppingList.this);additem.setContentView(R.layout.maindialog);最终 EditText et = (EditText)additem.findViewById(R.id.edittext);additem.setTitle("输入你的物品");additem.setCancelable(true);et.setHint("输入物品名称...");Button button = (Button) additem.findViewById(R.id.cancel);button.setOnClickListener(new OnClickListener() {@覆盖public void onClick(View v) {additem.dismiss();}});additem.show();按钮确定 = (按钮) additem.findViewById(R.id.ok);ok.setOnClickListener(new OnClickListener() {@覆盖public void onClick(View v) {最终字符串文本 = et.getText().toString();additem.dismiss();et.setText("");}});}});}}

这是我的 DataHelper 类:

package com.gantt.shoppinglist;导入 java.util.ArrayList;导入 java.util.List;导入 android.content.Context;导入 android.database.Cursor;导入 android.database.sqlite.SQLiteDatabase;导入 android.database.sqlite.SQLiteOpenHelper；导入 android.database.sqlite.SQLiteStatement;导入 android.util.Log;公共类数据助手{private static final String DATABASE_NAME = "items.db";私有静态最终 int DATABASE_VERSION = 1;私有静态最终字符串 TABLE_NAME = "table1";public static final String KEY_ROWID = "_id";私有上下文上下文；私有 SQLiteDatabase 数据库；私有 SQLiteStatement insertStmt;private static final String INSERT = "插入"+ TABLE_NAME + "(name) 值 (?)";公共数据助手(上下文上下文){this.context = 上下文；OpenHelper openHelper = new OpenHelper(this.context);this.db = openHelper.getWritableDatabase();this.insertStmt = this.db.compileStatement(INSERT);}公共长插入(字符串名称){this.insertStmt.bindString(1, name);返回 this.insertStmt.executeInsert();}公共无效deleteAll(){this.db.delete(TABLE_NAME, null, null);}公共光标 selectAll() {列表<字符串>list = new ArrayList();Cursor cursor = this.db.query(TABLE_NAME, new String[] { "name" },null, null, null, null, "name desc");如果 (cursor.moveToFirst()) {做 {list.add(cursor.getString(0));} while (cursor.moveToNext());}如果(光标！= null && !cursor.isClosed()) {游标.关闭()；}返回游标；}公共静态字符串 getDatabaseName() {返回 DATABASE_NAME；}私有静态类 OpenHelper 扩展 SQLiteOpenHelper {OpenHelper(上下文上下文){超级(上下文，getDatabaseName()，空，DATABASE_VERSION)；}@覆盖公共无效onCreate(SQLiteDatabase db){db.execSQL("CREATE TABLE " + TABLE_NAME + "(id INTEGER PRIMARY KEY, name TEXT");}@覆盖public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {Log.w("Example", "升级数据库，这将删除表并重新创建.");db.execSQL("如果存在则删除表" + TABLE_NAME);onCreate(db);}}}

解决方案

我遇到了类似的问题 - 我认为这是一种情况，必须选择"(或选择为")称为 _id 因为 SimpleCursorAdapter 需要它.

来自文档:><块引用>

处理内容 URI ID

按照惯例，提供者通过以下方式提供对表中单行的访问接受内容 URI 的末尾行的 ID 值URI.同样按照惯例，提供者将 ID 值与表的_ID 列，并对匹配的行执行请求的访问.

这个约定促进了应用程序访问的通用设计模式提供者.该应用程序对提供者进行查询并显示使用 CursorAdapter 在 ListView 中生成 Cursor.定义CursorAdapter 要求 Cursor 中的列之一是 _ID.

就我而言，我的表中有一个名为oid"的自动编号列，因此我将 SELECT 命令更改为(例如)...

SELECT oid as _id, name, number FROM mytable

这为我解决了问题.

编辑以显示更广泛的代码...

@Overridepublic void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.channel_selector);GridView channel_selector_grid = (GridView) findViewById(R.id.channel_grid);sca = getGuideAdapter();channel_selector_grid.setAdapter(sca);}公共 SimpleCursorAdapter getGuideAdapter() {SimpleCursorAdapter 适配器 = null;SQLiteDatabase db = SQLiteDatabaseHelper.getReadableDatabase();Cursor cursor = db.rawQuery("SELECT DISTINCT oid as _id, name, number FROM CHAN_TABLE ORDER BY number", null);如果 (cursor.moveToFirst()) {String[] columnNames = { "name" };int[] resIds = { R.id.channel_name };adapter = new SimpleCursorAdapter(this, R.layout.channel_selector_item, cursor, columnNames, resIds);}返回适配器；}

Whenever I start my app, I get a java.lang.IllegalArgumentException: column '_id' does not exist error in my LogCat. I have created the column '_id', but it still throws this. Here is my main .java:

package com.gantt.shoppinglist;

import android.app.Dialog;
import android.app.ListActivity;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;

public class ShoppingList extends ListActivity {

    private DataHelper DataHelper;
    /** Called when the activity is first created. */
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        DataHelper = new DataHelper(this);

        Cursor c = (Cursor) DataHelper.selectAll();
        long id = c.getLong(c.getColumnIndex("_id"));
        startManagingCursor(c);

        ListView lv = (ListView) findViewById(android.R.id.list);

        String[] from = new String[] { com.gantt.shoppinglist.DataHelper.getDatabaseName() };
        int[] to = new int[] { android.R.id.text1 };

        SimpleCursorAdapter adapter = new SimpleCursorAdapter(this,
                android.R.layout.simple_list_item_1, c, from, to);       
        lv.setAdapter(adapter);

        Button button1main = (Button) findViewById(R.id.add);
        button1main.setOnClickListener(new OnClickListener()  {
            @Override
            public void onClick(View v)  {
            final Dialog additem = new Dialog(ShoppingList.this);
            additem.setContentView(R.layout.maindialog);
            final EditText et = (EditText)additem.findViewById(R.id.edittext);
            additem.setTitle("Type your item");
            additem.setCancelable(true);
            et.setHint("Type the name of an item...");

            Button button = (Button) additem.findViewById(R.id.cancel);
            button.setOnClickListener(new OnClickListener()  {
                @Override
                public void onClick(View v)  {
                    additem.dismiss();
                }
            });
            additem.show();

            Button ok = (Button) additem.findViewById(R.id.ok);
            ok.setOnClickListener(new OnClickListener() {
                @Override
                public void onClick(View v) {
                    final String text = et.getText().toString();
                    additem.dismiss();
                    et.setText("");
                }
            });
       }
        });
    }
}

Here is my DataHelper class:

package com.gantt.shoppinglist;

import java.util.ArrayList;
import java.util.List;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteStatement;
import android.util.Log;

public class DataHelper {

       private static final String DATABASE_NAME = "items.db";
       private static final int DATABASE_VERSION = 1;
       private static final String TABLE_NAME = "table1";
       public static final String KEY_ROWID = "_id";

       private Context context;
       private SQLiteDatabase db;

       private SQLiteStatement insertStmt;
       private static final String INSERT = "insert into " 
          + TABLE_NAME + "(name) values (?)";

       public DataHelper(Context context) {
          this.context = context;
          OpenHelper openHelper = new OpenHelper(this.context);
          this.db = openHelper.getWritableDatabase();
          this.insertStmt = this.db.compileStatement(INSERT);
       }

       public long insert(String name) {
          this.insertStmt.bindString(1, name);
          return this.insertStmt.executeInsert();
       }

       public void deleteAll() {
          this.db.delete(TABLE_NAME, null, null);
       }

       public Cursor selectAll() {
          List<String> list = new ArrayList<String>();
          Cursor cursor = this.db.query(TABLE_NAME, new String[] { "name" }, 
            null, null, null, null, "name desc");
          if (cursor.moveToFirst()) {
             do {
                list.add(cursor.getString(0)); 
             } while (cursor.moveToNext());
          }
          if (cursor != null && !cursor.isClosed()) {
             cursor.close();
          }
          return cursor;
       }

       public static String getDatabaseName() {
        return DATABASE_NAME;
    }

    private static class OpenHelper extends SQLiteOpenHelper {

          OpenHelper(Context context) {
             super(context, getDatabaseName(), null, DATABASE_VERSION);
          }

          @Override
          public void onCreate(SQLiteDatabase db) {
              db.execSQL("CREATE TABLE " + TABLE_NAME + "(id INTEGER PRIMARY KEY, name TEXT");

          }

          @Override
          public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
             Log.w("Example", "Upgrading database, this will drop tables and recreate.");
             db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
             onCreate(db);
          }
       }
    }

解决方案

I had a similar issue - I think it's a case of having to 'select' (or 'select as') something called _id because the SimpleCursorAdapter needs it.

From the documentation:

Handling content URI IDs

By convention, providers offer access to a single row in a table by accepting a content URI with an ID value for the row at the end of the URI. Also by convention, providers match the ID value to the table's _ID column, and perform the requested access against the row that matches.

This convention facilitates a common design pattern for apps accessing a provider. The app does a query against the provider and displays the resulting Cursor in a ListView using a CursorAdapter. The definition of CursorAdapter requires one of the columns in the Cursor to be _ID.

In my case, I have an autonumber column in my table called 'oid' so I altered my SELECT command to be (for example)...

SELECT oid as _id, name, number FROM mytable

This cured the problem for me.

EDIT to show more extensive code...

@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.channel_selector);

    GridView channel_selector_grid = (GridView) findViewById(R.id.channel_grid);
    sca = getGuideAdapter();
    channel_selector_grid.setAdapter(sca);
}

public SimpleCursorAdapter getGuideAdapter() {
    SimpleCursorAdapter adapter = null;
    SQLiteDatabase db = SQLiteDatabaseHelper.getReadableDatabase();
    Cursor cursor = db.rawQuery("SELECT DISTINCT oid as _id, name, number FROM CHAN_TABLE ORDER BY number", null);
    if (cursor.moveToFirst()) {
        String[] columnNames = { "name" };
        int[] resIds = { R.id.channel_name };
        adapter = new SimpleCursorAdapter(this, R.layout.channel_selector_item, cursor, columnNames, resIds);
    }
    return adapter; 
}

这篇关于由于 java.lang.IllegalArgumentException: 列“_id"不存在，应用程序在启动时崩溃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！