03-22 09:30:55.914: E/Trace(7859): error opening trace file: No such file or directory (2)
03-22 09:30:56.785: E/AndroidRuntime(7859): FATAL EXCEPTION: main
03-22 09:30:56.785: E/AndroidRuntime(7859): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.sys.list/com.sys.list.MainActivity}: java.lang.IllegalArgumentException: column '_id' does not exist
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.app.ActivityThread.access$600(ActivityThread.java:141)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.os.Handler.dispatchMessage(Handler.java:99)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.os.Looper.loop(Looper.java:137)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.app.ActivityThread.main(ActivityThread.java:5041)
03-22 09:30:56.785: E/AndroidRuntime(7859): at java.lang.reflect.Method.invokeNative(Native Method)
03-22 09:30:56.785: E/AndroidRuntime(7859): at java.lang.reflect.Method.invoke(Method.java:511)
03-22 09:30:56.785: E/AndroidRuntime(7859): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
03-22 09:30:56.785: E/AndroidRuntime(7859): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
03-22 09:30:56.785: E/AndroidRuntime(7859): at dalvik.system.NativeStart.main(Native Method)
03-22 09:30:56.785: E/AndroidRuntime(7859): Caused by: java.lang.IllegalArgumentException: column '_id' does not exist
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.database.AbstractCursor.getColumnIndexOrThrow(AbstractCursor.java:303)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.widget.CursorAdapter.init(CursorAdapter.java:168)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.widget.CursorAdapter.<init>(CursorAdapter.java:145)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.widget.ResourceCursorAdapter.<init>(ResourceCursorAdapter.java:91)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.widget.SimpleCursorAdapter.<init>(SimpleCursorAdapter.java:104)
03-22 09:30:56.785: E/AndroidRuntime(7859): at com.sys.list.MainActivity.onCreate(MainActivity.java:25)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.app.Activity.performCreate(Activity.java:5104)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
03-22 09:30:56.785: E/AndroidRuntime(7859): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
03-22 09:30:56.785: E/AndroidRuntime(7859): ... 11 more
activity代码
package com.sys.list;
import android.os.Bundle;
import android.app.Activity;
import android.view.Menu;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.CursorAdapter;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
public class MainActivity extends Activity {
private ListView listView=null;
private Dbasedao dbasedao;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
dbasedao=new Dbasedao(this);
listView=(ListView) findViewById(R.id.list_1);
// dbasedao.select() 函数没问题已测试返回一个CURSOR
SimpleCursorAdapter simpleCursorAdapter=new SimpleCursorAdapter(this, R.layout.item_1, dbasedao.select(), new String[]{"_id","name","sex"}, new int[]{R.id._id,R.id._name,R.id._sex},CursorAdapter.FLAG_REGISTER_CONTENT_OBSERVER);
listView.setAdapter(simpleCursorAdapter);
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.main, menu);
return true;
}
}
list的布局文件
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical" >
<TextView
android:id="@+id/_id"
android:layout_width="match_parent"