package mju.visual;

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.ListView;
import android.widget.SimpleCursorAdapter;

public class memo_activity extends Activity {

 DBHelper helper;
 ListView memoList;
 Cursor cursor;
 ContentValues v;
 SQLiteDatabase db;
 SimpleCursorAdapter adapter;
 /** Called when the activity is first created. */
 @Override
 public void onCreate(Bundle savedInstanceState) {
     super.onCreate(savedInstanceState);
     
     setContentView(R.layout.listview_layout);
     
     helper = new DBHelper(this);
     db = helper.getWritableDatabase();
     memoList = (ListView)findViewById(R.id.memo_list);

     cursor = db.rawQuery("select *from memo_table", null);
     startManagingCursor(cursor);

     adapter = new SimpleCursorAdapter(this, android.R.layout.simple_list_item_2, cursor, new String[]{"memo","date"},new int[]{android.R.id.text1,android.R.id.text2});
     
     memoList.setAdapter(adapter);
     memoList.setChoiceMode(ListView.CHOICE_MODE_SINGLE);
 }

}

class DBHelper extends SQLiteOpenHelper
{
 public DBHelper(Context context)
 {
  super(context, "my_db.db" , null, 1);
 }

 @Override
 public void onCreate(SQLiteDatabase db)
 {
  db.execSQL("create table memo_table(_id integer primary key autoincrement, memo text not null, date text not null);");
 }

 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
 {
  db.execSQL("drop table if exists memo_table");
  onCreate(db);
 }
 
}

위의 화면을 보시면 알겠지만 memo_table이 존재 하는데요 .,

자꾸 실행시켜보면 로그캣이

12-03 12:10:52.691: E/AndroidRuntime(799): java.lang.RuntimeException: Unable to start activity ComponentInfo{mju.visual/mju.visual.memo_activity}: android.database.sqlite.SQLiteException: no such table: memo_table: , while compiling: select *from memo_table

이렇게 나옵니다. memo_table을 찾지 못하는거 같은데 왜 그런 걸까요 ㅜㅜ