db.execSQL("CREATE TABLE IF NOT EXISTS schedule (" +
    "_id  INTEGER PRIMARY KEY," +
    "day  TEXT," +
    "step  INTEGER," +
    "cal  INTEGER," +
    "time  TEXT" +
          ");");
SQLiteDatabase db = openOrCreateDatabase("StepCount.db", Context.MODE_PRIVATE, null);
        ListView listView = (ListView)findViewById(R.id.main_listview_data);
        mCursor = db.rawQuery("SELECT * FROM schedule", null); 
        int[] to = new int[]{R.id.lf_tv_day,R.id.lf_tv_step,R.id.lf_tv_cal,R.id.lf_tv_time}; 
        String[] from = new String[] { "day","step","cal","time"};
        final SimpleCursorAdapter adapter = new SimpleCursorAdapter(
                 listView.getContext(), 
                 R.layout.list_fruit, 
                 mCursor, 
                 from, 
                 to
                 );
        listView.setAdapter(adapter); 
        db.close();

 

int[] to = new int[]{R.id.lf_tv_day,R.id.lf_tv_step,R.id.lf_tv_cal,R.id.lf_tv_time};
String[] from = new String[] { "day","step","cal","time"};

schedule table을 생성하는 것 까지는 오류가 없습니다.

저기 빨간색으로 밑줄친 부분을 삭제하고 실행하면 잘 되는거 같습니다.

하지만 저 부분을 추가하면 어플이 죽어버리는군요.

다른방법과 똑같이 했는데 왜 죽는지 잘 모르겠습니다.

도움 부탁드립니다 ㅠㅠ

 

 

 

 

 

06-15 10:57:03.218: E/AndroidRuntime(14205): FATAL EXCEPTION: main
06-15 10:57:03.218: E/AndroidRuntime(14205): java.lang.RuntimeException: Unable to resume activity {kr.pe.roter.sample.customlistview/kr.pe.roter.sample.customlistview.CustomListViewSample}: java.lang.IllegalArgumentException: column 'time' does not exist
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2120)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.app.ActivityThread.handleResumeActivity(ActivityThread.java:2135)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1668)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.app.ActivityThread.access$1500(ActivityThread.java:117)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.app.ActivityThread$H.handleMessage(ActivityThread.java:931)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.os.Handler.dispatchMessage(Handler.java:99)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.os.Looper.loop(Looper.java:123)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.app.ActivityThread.main(ActivityThread.java:3683)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at java.lang.reflect.Method.invokeNative(Native Method)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at java.lang.reflect.Method.invoke(Method.java:507)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at dalvik.system.NativeStart.main(Native Method)
06-15 10:57:03.218: E/AndroidRuntime(14205): Caused by: java.lang.IllegalArgumentException: column 'time' does not exist
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.database.AbstractCursor.getColumnIndexOrThrow(AbstractCursor.java:314)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.widget.SimpleCursorAdapter.findColumns(SimpleCursorAdapter.java:312)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.widget.SimpleCursorAdapter.<init>(SimpleCursorAdapter.java:87)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at kr.pe.roter.sample.customlistview.CustomListViewSample.onResume(CustomListViewSample.java:68)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.app.Instrumentation.callActivityOnResume(Instrumentation.java:1150)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.app.Activity.performResume(Activity.java:3832)
06-15 10:57:03.218: E/AndroidRuntime(14205):  at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2110)
06-15 10:57:03.218: E/AndroidRuntime(14205):  ... 12 more

이 게시물을