12-01 15:23:24.545: ERROR/AndroidRuntime(11780): Uncaught handler: thread main exiting due to uncaught exception
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): java.lang.RuntimeException: Unable to start activity ComponentInfo{pack.WakeUpMe/pack.WakeUpMe.NumSearch}: android.database.sqlite.SQLiteException: no such table: bus: , while compiling: SELECT * FROM bus WHERE BUSLINENUM=126
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2496)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2512)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.app.ActivityThread.access$2200(ActivityThread.java:119)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.os.Handler.dispatchMessage(Handler.java:99)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.os.Looper.loop(Looper.java:123)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.app.ActivityThread.main(ActivityThread.java:4363)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at java.lang.reflect.Method.invokeNative(Native Method)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at java.lang.reflect.Method.invoke(Method.java:521)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:860)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at dalvik.system.NativeStart.main(Native Method)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): Caused by: android.database.sqlite.SQLiteException: no such table: bus: , while compiling: SELECT * FROM bus WHERE BUSLINENUM=126
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.database.sqlite.SQLiteProgram.native_compile(Native Method)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.database.sqlite.SQLiteProgram.compile(SQLiteProgram.java:110)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:49)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:49)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1221)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1194)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at pack.WakeUpMe.NumSearch.onCreate(NumSearch.java:39)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2459)
12-01 15:23:24.575: ERROR/AndroidRuntime(11780): ... 11 more
로그캣이구요...
mHelper = new BusDBHelper(this);
Cursor cursor;
SQLiteDatabase db = mHelper.getReadableDatabase();
cursor = db.rawQuery("SELECT * FROM bus WHERE BUSLINENUM=126", null);
startManagingCursor(cursor);
SimpleCursorAdapter Adapter = null;
Adapter = new SimpleCursorAdapter(this,
android.R.layout.simple_list_item_1,
cursor, new String[] { "NAME"},
new int[] { android.R.id.text1});
ListView list = (ListView)findViewById(R.id.list);
list.setAdapter(Adapter);
}
소스 입니다...
try, catch 는 앞 전에 했던 분들도 안 해도 잘 돌아가셨다길래 신경 안 썼는데... 어디가 에러인지 모르겠어요... ㅠㅠ
공지사항 다 읽었습니다.
class BusDBHelper extends SQLiteOpenHelper
{
public BusDBHelper (Context context) {
super(context, "bus.db", null, 1);
}
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE bus(_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
"BUSLINENUM INTEGER, ORD INTEGER, NAME TEXT, SIGUNNAME TEXT," +
"GUNNAME TEXT, DONGNAME TEXT, X FLOAT, Y FLOAT");
}
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS bus");
onCreate(db);
}
}
BusDBHelper 입니다;;; 파일이름에도 제대로 준거 같은데... 후우... 에러를 모르겠네요...
int AlbumCount = albumArtCursor.getCount() + 1;
String albumArtDataValue[] = new String[AlbumCount];
String albumArtistValue[] = new String[AlbumCount];
if (albumArtCursor.moveToFirst()) {
int IDColumn2 = albumArtCursor.getInt(albumArtCursor
.getColumnIndex(MediaStore.Audio.Albums._ID));
int albumArtColumn = albumArtCursor
.getColumnIndex(MediaStore.Audio.Albums.ALBUM_ART);
int artistColumn = albumArtCursor
.getColumnIndex(MediaStore.Audio.Albums.ARTIST);
do {
if (albumArtCursor.getString(albumArtColumn) != null) {
albumArtDataValue[idCount2] = albumArtCursor
.getString(albumArtColumn);
albumArtistValue[idCount2] = albumArtCursor
.getString(artistColumn);
idCount2++;
}
} while (albumArtCursor.moveToNext());
}
식으로 사용합니다.
디비 자체가 잘못된거라면..
제가 개발정보방 소스쪽에 소스 올려놨습니다.
제가 사용할려고 만든건데 급하게 약간 수정해서 올렸습니다.
http://www.androidpub.com/?mid=android_dev_info&category=274552&document_srl=1067178