java.lang.IllegalArgumentException:如果列'_id'不存在 [英] java.lang.IllegalArgumentException: column '_id' does not exist
问题描述
我想调试我在真实设备上的应用程序,并有一个错误。但在模拟器中进行测试时,错误没有露面。以下是错误:
I'm trying to debug my application on a real device and having an error. But when testing on emulator, the error didn't show up. Here is the error:
ERROR / AndroidRuntime(981):产生的原因: java.lang.IllegalArgumentException异常: 列'_id'不存在
ERROR/AndroidRuntime(981): Caused by: java.lang.IllegalArgumentException: column '_id' does not exist
的误差给出的以下code中的最后一行。这是在活动。
The error is given in the last line of the following code. This is in the Activity.
adapter = new SimpleCursorAdapter(this, R.layout.list_item, c, new String[] {
DataHandlerDB.CONTACT_NAME_COL,
DataHandlerDB.CONTACT_NUMBER_COL,
DataHandlerDB.CONTACT_DURATION_COL,
DataHandlerDB.CONTACT_DATE_COL }, new int[] {
R.id.contact_name, R.id.phone_number, R.id.duration, R.id.date });
下面是我的活动:
public class MyActivity extends Activity {
private static final String LOG_TAG = "MyActivity";
private ListView listview;
private SimpleCursorAdapter adapter;
private DataHandlerDB handler;
private SQLiteDatabase db;
private OpenHelper helper;
private Cursor c;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
helper = new OpenHelper(this);
db = helper.getWritableDatabase();
helper.onCreate(db);
setBasicContent();
c.close();
}
@Override
public void onDestroy(){
super.onDestroy();
DataHandlerDB.makeTheSelection(this).close();
db.close();
helper.close();
}
@Override
public void onPause(){
super.onPause();
DataHandlerDB.makeTheSelection(this).close();
db.close();
helper.close();
}
@Override
public void onStop(){
super.onStop();
DataHandlerDB.makeTheSelection(this).close();
db.close();
helper.close();
}
@Override
protected void onResume(){
super.onResume();
setBasicContent();
}
public void setBasicContent() {
listview = (ListView) findViewById(R.id.list_view);
Log.i(LOG_TAG, "listview " + listview);
c = DataHandlerDB.makeTheSelection(this);
c.moveToFirst();
if(db.isOpen())
Log.i(LOG_TAG, "db is opened");
Log.i(LOG_TAG, "cursor: " + c.getCount());
startManagingCursor(c);
adapter = new SimpleCursorAdapter(this, R.layout.list_item, c, new String[] {
DataHandlerDB.CONTACT_NAME_COL,
DataHandlerDB.CONTACT_NUMBER_COL,
DataHandlerDB.CONTACT_DURATION_COL,
DataHandlerDB.CONTACT_DATE_COL }, new int[] {
R.id.contact_name, R.id.phone_number, R.id.duration, R.id.date });
Log.i(LOG_TAG, "before setAdapter");
Toast.makeText(this, "Before setAdapter", Toast.LENGTH_SHORT).show();
listview.setAdapter(adapter);
db.close();
if(db.isOpen()){
Log.i(LOG_TAG, "db is opened.");
}
if(!c.isClosed()){
Log.i(LOG_TAG, "cursor is opened");
}
}
}
这是查询并返回游标的方法是在类 DataHandlerDB
。
The method that query and return the cursor is in the class DataHandlerDB
.
public class DataHandlerDB {
private static final String DATABASE_NAME = "calls.db";
private static final int DATABASE_VERSION = 1;
protected static String CONTACT_NAME_COL = "contact_name";
protected static String CONTACT_NUMBER_COL = "contact_number";
protected static String CONTACT_DURATION_COL = "duration";
protected static String CONTACT_DATE_COL = "date";
protected static String CONTACT_MONTH_COL = "month";
// create the DB
public static SQLiteDatabase createDB(Context ctx) {
OpenHelper helper = new OpenHelper(ctx);
SQLiteDatabase db = helper.getWritableDatabase();
helper.onCreate(db);
helper.onOpen(db);
db.close();
return db;
}
public static Cursor makeTheSelection(Context ctx) {
OpenHelper helper = new OpenHelper(ctx);
SQLiteDatabase db = helper.getWritableDatabase();
Cursor cursor = db.query(TABLE_NAME_2, null, null, null, null, null,
"duration desc");
cursor.moveToFirst();
db.close();
return cursor;
}
// class OpenHelper
public static class OpenHelper extends SQLiteOpenHelper {
private final Context mContext;
OpenHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
this.mContext = context;
}
@Override
public void onCreate(SQLiteDatabase db) {
Log.i(LOG_TAG, "entrou no onCreate");
String[] sql = mContext.getString(
R.string.MyAppDatabase_OnCreate).split("\n");
db.beginTransaction();
try {
execMultipleSQL(db, sql);
db.setTransactionSuccessful();
} catch (SQLException e) {
Log.e("Error creating tables and debug data", e.toString());
throw e;
} finally {
db.endTransaction();
}
}
private void execMultipleSQL(SQLiteDatabase db, String[] sql) {
for (String s : sql) {
if (s.trim().length() > 0) {
db.execSQL(s);
}
}
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
Log.w("MyDB Database",
"Upgrading database, this will drop tables and recreate.");
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME); onCreate(db);
}
@Override
public void onOpen(SQLiteDatabase db) {
super.onOpen(db);
}
}
}
下面是使用SQL命令的XML文件。
Here is the xml file with the sql command.
<string name="MyAppDatabase_OnCreate">
"CREATE TABLE IF NOT EXISTS contact_data(_id INTEGER PRIMARY KEY AUTOINCREMENT, contact_id INTEGER, contact_name VARCHAR(50), number_type VARCHAR(50), contact_number VARCHAR(50), duration TIME, duration_sum TIME, date DATE, current_time TIME, cont INTEGER, type VARCHAR, month VARCHAR(50), day VARCHAR(50), year VARCHAR(50));"
</string>
从我的角度来看,我觉得开始的时候它的应用程序不创建数据库。因为,它可以找到列 _id
,但它明确地写在XML code与 _id $ C创建$ C>列。我认为,这也是因为我已经明确地写在列的选择方法,包括
_id
。我不喜欢这样的:
From my point of view, I think the application is not creating the db when starting it. Because, it can find the column _id
, but it is explicity written in the xml code to create it with the _id
column. And I think that also because I've explicity written the columns in the select method, including the _id
. I did like this:
Cursor cursor = db.query(TABLE_NAME_2,
new String[]{
"_id",
"contact_id",
"contact_name",
"number_type",
"contact_number",
"duration",
"duration_sum",
"date",
"current_time",
"cont", "type",
"month",
"day",
"year"}, null, null, null, null,
"duration desc");
和附带于该情况下的错误是几乎相同的:
And the error that comes for this case is almost the same:
引起的: android.database.sqlite.SQLiteException: 没有这样的列:_id:,而 编译:选择_id,CONTACT_ID, CONTACT_NAME,NUMBER_TYPE, contact_number,持续时间, duration_sum,日期,CURRENT_TIME, 续,类型,月,日,一年 contact_data ORDER BY时间递减
Caused by: android.database.sqlite.SQLiteException: no such column: _id: , while compiling: SELECT _id, contact_id, contact_name, number_type, contact_number, duration, duration_sum, date, current_time, cont, type, month, day, year FROM contact_data ORDER BY duration desc
任何人有任何解决方案?我不知道为什么我测试模拟器错误没有显示了,但在真正的设备它发生了。
Anyone has any solution?? I dont know why I tested it on emulator the error didnt show up, but in a real device it happened.
更新
我刚刚登录这样的数据库
I just logged the first column of the database like this
Log.i(LOG_TAG, "Cursor(0)" + cursor.getColumnName(0));
和它印 ID
不是 _id
。但正如你所看到的恰好有 _id
写在声明中。
and it printed id
not _id
. But as you can see there is exactly _id
written in the statement.
在此先感谢。
推荐答案
这个答案解决了这个问题。
这篇关于java.lang.IllegalArgumentException:如果列'_id'不存在的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!