package com.java.wjd;import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.SimpleCursorAdapter;public class MaillistActivity extends Activity { private final static String DATABASE = "Info.db";
private final static String TABLE_NAME = "T_list";
private final static String ID = "id";
private final static String NAME = "name";
private final static String PHONE = "phone";
private final static String QQ = "qq";
private final static String ADDRESS = "address";
private final static int DB_VERSION = 1;
private Cursor m_cursor;
private Context m_context = null;
private SQLiteDatabase m_SQLiteDatabase;
private DBOpenHelper m_DBOpenHelper;
private ListView listview = null;
public final static String LOGIN_TABLE_NAME = "contantslogin";
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
m_DBOpenHelper = new DBOpenHelper(this);
m_DBOpenHelper.open();
m_DBOpenHelper.insert("wjd","123","123","123");
m_DBOpenHelper.select();
//m_DBOpenHelper.show();
findId();
}
public void findId(){
listview = (ListView)findViewById(R.id.lv);
ListAdapter adapter = new SimpleCursorAdapter(this,R.layout.main,
m_cursor,
new String[]{NAME,PHONE,QQ,ADDRESS},
new int[]{R.id.lv_name,R.id.lv_phone,R.id.lv_qq,R.id.lv_address});
listview.setAdapter(adapter);
}
class DBOpenHelper extends SQLiteOpenHelper{ public DBOpenHelper(Context context) {
super(context, DATABASE, null, DB_VERSION);
} public void onCreate(SQLiteDatabase db) {
String sql = "create table "+TABLE_NAME+"("
+ID+" integer primary key autoincrement,"
+NAME+" varchar,"
+PHONE+" varchar,"
+QQ+" varchar,"
+ADDRESS+" varchar)"; db.execSQL(sql);
} public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
String sql = "drop table if exists "+TABLE_NAME;
db.execSQL(sql);
sql = "drop table if exists "+LOGIN_TABLE_NAME;
db.execSQL(sql);
onCreate(db); }
public void open(){
m_SQLiteDatabase = m_DBOpenHelper.getWritableDatabase();
}
public void close(){
m_DBOpenHelper.close();
}
public long insert(String m_name,String m_phone,String m_qq,String m_address){
ContentValues cv = new ContentValues();
cv.put(NAME,m_name);
cv.put(PHONE,m_phone);
cv.put(QQ,m_qq);
cv.put(ADDRESS,m_address);
return m_SQLiteDatabase.insert(TABLE_NAME,null,cv);
}
public void select(){
m_cursor = m_SQLiteDatabase.rawQuery("select * from T_list",null);
}
public void show(){
if(m_cursor != null){
if(m_cursor.moveToFirst()){
do{
int num = m_cursor.getColumnIndex(NAME);
String str = m_cursor.getString(num);
System.out.println(str);
}while(m_cursor.moveToNext());
}
}
}
}
}main.xml<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
>
<ListView
android:id="@+id/lv"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:choiceMode="singleChoice"
></ListView>
</LinearLayout>detial.xml<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="horizontal"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
>
<TextView
android:id="@+id/lv_name"
android:layout_width="50dip"
android:layout_height="wrap_content"
android:layout_marginRight="10dip"
/>
<TextView
android:id="@+id/lv_phone"
android:layout_width="50dip"
android:layout_height="wrap_content"
android:layout_marginRight="10dip"
/>
<TextView
android:id="@+id/lv_qq"
android:layout_width="50dip"
android:layout_height="wrap_content"
android:layout_marginRight="10dip"
/>
<TextView
android:id="@+id/lv_address"
android:layout_width="50dip"
android:layout_height="wrap_content"
android:layout_marginRight="10dip"
/>
</LinearLayout>求各位大神指出错误啊
10-05 02:21:40.311: INFO/PackageManager(52): /data/app/vmdl37497.tmp changed; unpacking
10-05 02:21:40.331: DEBUG/installd(32): DexInv: --- BEGIN '/data/app/vmdl37497.tmp' ---
10-05 02:21:40.695: DEBUG/dalvikvm(338): DexOpt: load 42ms, verify 129ms, opt 17ms
10-05 02:21:40.721: DEBUG/installd(32): DexInv: --- END '/data/app/vmdl37497.tmp' (success) ---
10-05 02:21:40.721: DEBUG/PackageManager(52): Activities: com.java.wjd.MaillistActivity
10-05 02:21:40.741: DEBUG/ActivityManager(52): Uninstalling process com.java.wjd
10-05 02:21:40.741: DEBUG/ActivityManager(52): Force removing process ProcessRecord{44e62900 315:com.java.wjd/10029} (com.java.wjd/10029)
10-05 02:21:40.761: INFO/Process(52): Sending signal. PID: 315 SIG: 9
10-05 02:21:40.811: INFO/UsageStats(52): Unexpected resume of org.lee.android while already resumed in com.java.wjd
10-05 02:21:40.821: INFO/WindowManager(52): WIN DEATH: Window{44d675f8 com.java.wjd/com.java.wjd.MaillistActivity paused=false}
10-05 02:21:40.921: DEBUG/ActivityManager(52): Received spurious death notification for thread android.os.BinderProxy@44d8cd88
10-05 02:21:40.941: WARN/InputManagerService(52): Got RemoteException sending setActive(false) notification to pid 315 uid 10029
10-05 02:21:41.112: INFO/installd(32): move /data/dalvik-cache/data@[email protected]@classes.dex -> /data/dalvik-cache/data@[email protected]@classes.dex
10-05 02:21:41.141: DEBUG/PackageManager(52): New package installed in /data/app/com.java.wjd.apk
10-05 02:21:41.321: DEBUG/dalvikvm(52): GC freed 5522 objects / 384312 bytes in 168ms
10-05 02:21:41.511: DEBUG/AndroidRuntime(332): Shutting down VM
10-05 02:21:41.511: DEBUG/dalvikvm(332): DestroyJavaVM waiting for non-daemon threads to exit
10-05 02:21:41.522: DEBUG/dalvikvm(332): DestroyJavaVM shutting VM down
10-05 02:21:41.522: DEBUG/dalvikvm(332): HeapWorker thread shutting down
10-05 02:21:41.522: DEBUG/dalvikvm(332): HeapWorker thread has shut down
10-05 02:21:41.532: DEBUG/jdwp(332): JDWP shutting down net...
10-05 02:21:41.532: INFO/dalvikvm(332): Debugger has detached; object registry had 1 entries
10-05 02:21:41.541: DEBUG/dalvikvm(332): VM cleaning up
10-05 02:21:41.561: ERROR/AndroidRuntime(332): ERROR: thread attach failed
10-05 02:21:41.572: DEBUG/ActivityManager(52): Uninstalling process com.java.wjd
10-05 02:21:41.572: DEBUG/dalvikvm(332): LinearAlloc 0x0 used 623916 of 5242880 (11%)
10-05 02:21:42.101: DEBUG/dalvikvm(52): GC freed 2556 objects / 166776 bytes in 327ms
10-05 02:21:42.141: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f0700e5
10-05 02:21:42.171: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f020031
10-05 02:21:42.171: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f020030
10-05 02:21:42.171: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f050000
10-05 02:21:42.211: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f060000
10-05 02:21:42.221: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f060001
10-05 02:21:42.412: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f0700e5
10-05 02:21:42.422: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f020031
10-05 02:21:42.422: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f020030
10-05 02:21:42.422: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f050000
10-05 02:21:42.441: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f060000
10-05 02:21:42.441: WARN/ResourceType(52): Resources don't contain package for resource number 0x7f060001
10-05 02:21:42.631: DEBUG/AndroidRuntime(343): >>>>>>>>>>>>>> AndroidRuntime START <<<<<<<<<<<<<<
10-05 02:21:42.631: DEBUG/AndroidRuntime(343): CheckJNI is ON
10-05 02:21:43.021: DEBUG/AndroidRuntime(343): --- registering native functions ---
10-05 02:21:43.591: DEBUG/ddm-heap(343): Got feature list request
10-05 02:21:44.031: INFO/ActivityManager(52): Starting activity: Intent { act=android.intent.action.MAIN cat=[android.intent.category.LAUNCHER] flg=0x10000000 cmp=com.java.wjd/.MaillistActivity }
10-05 02:21:44.111: INFO/ActivityManager(52): Start proc com.java.wjd for activity com.java.wjd/.MaillistActivity: pid=351 uid=10029 gids={}
10-05 02:21:44.121: DEBUG/AndroidRuntime(343): Shutting down VM
10-05 02:21:44.121: DEBUG/dalvikvm(343): DestroyJavaVM waiting for non-daemon threads to exit
10-05 02:21:44.131: DEBUG/dalvikvm(343): DestroyJavaVM shutting VM down
10-05 02:21:44.131: DEBUG/dalvikvm(343): HeapWorker thread shutting down
10-05 02:21:44.131: DEBUG/dalvikvm(343): HeapWorker thread has shut down
10-05 02:21:44.131: DEBUG/jdwp(343): JDWP shutting down net...
10-05 02:21:44.196: ERROR/AndroidRuntime(343): ERROR: thread attach failed
10-05 02:21:44.196: DEBUG/jdwp(343): Got wake-up signal, bailing out of select
10-05 02:21:44.196: INFO/dalvikvm(343): Debugger has detached; object registry had 1 entries
10-05 02:21:44.196: DEBUG/dalvikvm(343): VM cleaning up
10-05 02:21:44.221: DEBUG/dalvikvm(343): LinearAlloc 0x0 used 639500 of 5242880 (12%)
10-05 02:21:44.401: DEBUG/ddm-heap(351): Got feature list request
10-05 02:21:45.091: DEBUG/dalvikvm(105): GC freed 156 objects / 6136 bytes in 2961ms
10-05 02:21:45.122: DEBUG/AndroidRuntime(351): Shutting down VM
10-05 02:21:45.132: WARN/dalvikvm(351): threadid=3: thread exiting with uncaught exception (group=0x4001b188)
10-05 02:21:45.132: ERROR/AndroidRuntime(351): Uncaught handler: thread main exiting due to uncaught exception
10-05 02:21:45.151: ERROR/AndroidRuntime(351): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.java.wjd/com.java.wjd.MaillistActivity}: java.lang.IllegalArgumentException: column '_id' does not exist
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2496)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2512)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.app.ActivityThread.access$2200(ActivityThread.java:119)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.os.Handler.dispatchMessage(Handler.java:99)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.os.Looper.loop(Looper.java:123)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.app.ActivityThread.main(ActivityThread.java:4363)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at java.lang.reflect.Method.invokeNative(Native Method)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at java.lang.reflect.Method.invoke(Method.java:521)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:860)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at dalvik.system.NativeStart.main(Native Method)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): Caused by: java.lang.IllegalArgumentException: column '_id' does not exist
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.database.AbstractCursor.getColumnIndexOrThrow(AbstractCursor.java:314)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.widget.CursorAdapter.init(CursorAdapter.java:111)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.widget.CursorAdapter.<init>(CursorAdapter.java:90)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.widget.ResourceCursorAdapter.<init>(ResourceCursorAdapter.java:47)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.widget.SimpleCursorAdapter.<init>(SimpleCursorAdapter.java:88)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at com.java.wjd.MaillistActivity.findId(MaillistActivity.java:50)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at com.java.wjd.MaillistActivity.onCreate(MaillistActivity.java:42)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2459)
10-05 02:21:45.151: ERROR/AndroidRuntime(351): ... 11 more
10-05 02:21:45.181: INFO/Process(52): Sending signal. PID: 351 SIG: 3
10-05 02:21:45.203: INFO/dalvikvm(351): threadid=7: reacting to signal 3
10-05 02:21:45.212: INFO/dalvikvm(351): Wrote stack trace to '/data/anr/traces.txt'
10-05 02:21:54.154: WARN/ActivityManager(52): Launch timeout has expired, giving up wake lock!
10-05 02:21:54.607: WARN/ActivityManager(52): Activity idle timeout for HistoryRecord{44d5df38 com.java.wjd/.MaillistActivity}
10-05 02:21:59.971: DEBUG/dalvikvm(227): GC freed 2148 objects / 134696 bytes in 351ms
10-05 02:22:05.421: DEBUG/dalvikvm(216): GC freed 43 objects / 2088 bytes in 256ms
10-05 02:24:06.870: DEBUG/dalvikvm(102): GC freed 10908 objects / 509272 bytes in 1483ms
10-05 02:26:45.271: INFO/Process(351): Sending signal. PID: 351 SIG: 9
10-05 02:26:45.311: INFO/ActivityManager(52): Process com.java.wjd (pid 351) has died.
10-05 02:26:45.351: INFO/UsageStats(52): Unexpected resume of org.lee.android while already resumed in com.java.wjd
10-05 02:26:45.552: WARN/InputManagerService(52): Window already focused, ignoring focus gain of: com.android.internal.view.IInputMethodClient$Stub$Proxy@44d52f30
_id这个字段是否存在，最好大小写也一样
或者你apk的数据库更改了
但是模拟器上的数据库还没有更改