package com.test.sqlite;

import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.TextView;

public class SQLiteActivity extends Activity {
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        
        TextView textview = (TextView) findViewById(R.id.textview);//텍스트뷰를 뿌려줌
        
        DataBaseHelper myDbHelper = null;
        myDbHelper = new DataBaseHelper(this);

        SQLiteDatabase db; 
                
        // 테이블에 저장된 모든 레코드를 가져와서 TextView에 출력한다.
        db = myDbHelper.getReadableDatabase();// 읽어 오기
        Cursor cursor = db.query("PusanTour", null,null,null,null,null,null,null);
        while(!cursor.isAfterLast()){
         int id = cursor.getInt(0); 
         String store = cursor.getString(1);
         
         cursor.moveToNext();
        }
        cursor.close();
        db.close();
        
        
        
     }
}

package com.test.sqlite;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

 public class DataBaseHelper extends SQLiteOpenHelper{
 
    private static String DB_NAME = "MyTHirdDB.db";
    
    private static final String TABLE_CREATE =
     "create table PusanTour (_id integer primary key autoincrement, "
     +"userName text not null);";
    
    public DataBaseHelper(Context context) {
 
     super(context, DB_NAME, null, 1) ;
    }
    //테이블생성
    @Override
    public void onCreate(SQLiteDatabase db)
    {
     db.execSQL(TABLE_CREATE);
    }
    
    @Override
    public void onOpen(SQLiteDatabase db) {
     super.onOpen(db);
     Log.i("DB Open", "DB Open OK!");
 }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    {
     Log.w("DB Upgrade", "Upgrading database from version " + oldVersion
       + " to " + newVersion + ", which will destroy all old data");
     db.execSQL("DROP TABLE IF EXISTS PusanTour");
     onCreate(db);
    }
}