cur =  helper.getAll();
cur.moveToFirst();
// data값 생성
for (int i = 0, id=0; i < lay.length; i++) { //10개
for (int j = 1; j <day_line.length; j++) { //6개
data[id] = new TextView(this);
data[id].setId(id);//data[0]  =  0
data[id].setTextSize(10);
data[id].setOnClickListener(this);
data[id].setGravity(Gravity.CENTER);
data[id].setBackgroundColor(Color.parseColor("#EAEAEA"));
 
db_id = cur.getInt(0);
if(counter!= 0 && db_id == data[id].getId()){
Log.i(tag,"if");
db_subject = cur.getString(1);
db_classroom = cur.getString(2);
data[id].setText(db_subject+"\n"+db_classroom); // 구현중...
cur.moveToNext();
}
else{
Log.i(tag, "else");
data[id].setText(""+id);
}
lay[i].addView(data[id], params_1); //시간표 데이터 출력
id++;
}
        }
==================================================================================================================
11-06 17:23:57.378: D/dalvikvm(1933): GC_CONCURRENT freed 149K, 3% free 9107K/9304K, paused 94ms+86ms, total 254ms
11-06 17:23:57.378: I/my db path=(1933): /data/data/com.example.capstone/databases/timetable.db
11-06 17:23:57.408: I/timetable.class(1933): counter = 4
11-06 17:23:57.458: I/timetable.class(1933): else
11-06 17:23:57.458: I/timetable.class(1933): else
11-06 17:23:57.458: I/timetable.class(1933): else
11-06 17:23:57.458: I/timetable.class(1933): else
11-06 17:23:57.470: I/timetable.class(1933): else
11-06 17:23:57.470: I/timetable.class(1933): if
11-06 17:23:57.478: I/timetable.class(1933): else
11-06 17:23:57.478: I/timetable.class(1933): else
11-06 17:23:57.478: I/timetable.class(1933): else
11-06 17:23:57.478: I/timetable.class(1933): else
11-06 17:23:57.490: I/timetable.class(1933): else
11-06 17:23:57.490: I/timetable.class(1933): else
11-06 17:23:57.490: I/timetable.class(1933): else
11-06 17:23:57.498: I/timetable.class(1933): else
11-06 17:23:57.498: I/timetable.class(1933): else
11-06 17:23:57.509: I/timetable.class(1933): else
11-06 17:23:57.509: I/timetable.class(1933): if
11-06 17:23:57.509: I/timetable.class(1933): else
11-06 17:23:57.518: I/timetable.class(1933): else
11-06 17:23:57.518: I/timetable.class(1933): else
11-06 17:23:57.518: I/timetable.class(1933): else
11-06 17:23:57.528: I/timetable.class(1933): else
11-06 17:23:57.528: I/timetable.class(1933): if
11-06 17:23:57.528: D/AndroidRuntime(1933): Shutting down VM
11-06 17:23:57.528: W/dalvikvm(1933): threadid=1: thread exiting with uncaught exception (group=0x2bd39930)
11-06 17:23:57.548: E/AndroidRuntime(1933): FATAL EXCEPTION: main
11-06 17:23:57.548: E/AndroidRuntime(1933): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.capstone/com.example.capstone.MainActivity}: java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.capstone/com.example.capstone.Timetable}: android.database.CursorIndexOutOfBoundsException: Index 3 requested, with a size of 3
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.ActivityThread.access$600(ActivityThread.java:141)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.os.Handler.dispatchMessage(Handler.java:99)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.os.Looper.loop(Looper.java:137)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.ActivityThread.main(ActivityThread.java:5039)
11-06 17:23:57.548: E/AndroidRuntime(1933): at java.lang.reflect.Method.invokeNative(Native Method)
11-06 17:23:57.548: E/AndroidRuntime(1933): at java.lang.reflect.Method.invoke(Method.java:511)
11-06 17:23:57.548: E/AndroidRuntime(1933): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
11-06 17:23:57.548: E/AndroidRuntime(1933): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
11-06 17:23:57.548: E/AndroidRuntime(1933): at dalvik.system.NativeStart.main(Native Method)
11-06 17:23:57.548: E/AndroidRuntime(1933): Caused by: java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.capstone/com.example.capstone.Timetable}: android.database.CursorIndexOutOfBoundsException: Index 3 requested, with a size of 3
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.ActivityThread.startActivityNow(ActivityThread.java:2023)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.LocalActivityManager.moveToState(LocalActivityManager.java:135)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.LocalActivityManager.startActivity(LocalActivityManager.java:347)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.widget.TabHost$IntentContentStrategy.getContentView(TabHost.java:749)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.widget.TabHost.setCurrentTab(TabHost.java:413)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.widget.TabHost.addTab(TabHost.java:240)
11-06 17:23:57.548: E/AndroidRuntime(1933): at com.example.capstone.MainActivity.onCreate(MainActivity.java:24)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.Activity.performCreate(Activity.java:5104)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
11-06 17:23:57.548: E/AndroidRuntime(1933): ... 11 more
11-06 17:23:57.548: E/AndroidRuntime(1933): Caused by: android.database.CursorIndexOutOfBoundsException: Index 3 requested, with a size of 3
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.database.AbstractCursor.checkPosition(AbstractCursor.java:424)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.database.AbstractWindowedCursor.checkPosition(AbstractWindowedCursor.java:136)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.database.AbstractWindowedCursor.getInt(AbstractWindowedCursor.java:68)
11-06 17:23:57.548: E/AndroidRuntime(1933): at com.example.capstone.Timetable.onCreate(Timetable.java:155)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.Activity.performCreate(Activity.java:5104)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
11-06 17:23:57.548: E/AndroidRuntime(1933): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
11-06 17:23:57.548: E/AndroidRuntime(1933): ... 21 more
===================================================================================================================
커서를 닫아주면 sstaledataexception 에러나고 
안닫아주면 cursor index out of bounds exception 오류나고...
cur.moveToNext 안해주면 오류는 안나지만 데이터가 1개만 출력이되고..
cur.moveToNext 에서 오류인데...아무리 바꿔서 해봐도 안됩니다....도와주세요!!


이 게시물을