package com.dbtest;
import java.util.ArrayList;
import java.util.HashMap;

import android.app.ListActivity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.SimpleAdapter;
 

public class DbtestActivity extends ListActivity {
    /** Called when the activity is first created. */
    private SQLiteDatabase db;
    Cursor mCursor;
 @Override
 protected void onCreate(Bundle savedInstanceState) {
  // TODO Auto-generated method stub
  super.onCreate(savedInstanceState);
  db = openOrCreateDatabase("MyUserDB",MODE_PRIVATE, null);
  db.execSQL("drop table if exists user1");
  
  db.execSQL("create table users1("
  +"_id integer primary key autoincrement,"
  +"LastName text not null," + "FirstName text not null,"
  + "City text not null,"+"Age int not null);");
  
  db.execSQL("insert into users1" + "(LastName,FirstName,City,Age)"
    +"values('Android',Google','America',20);");
  ContentValues insertValues = new ContentValues();
  
  insertValues.put("LastName", "JungAh");
  insertValues.put("FirstName","Park");
  insertValues.put("City","Korea");
  insertValues.put("Age",24);
  
  db.insert("users1", null, insertValues);
  ContentValues updateValue = new ContentValues();
  updateValue.put("LastName", "ju");
  updateValue.put("FirstName", "pa");
  updateValue.put("Age",30);
  db.update("users1", updateValue, "_id=2", null);
  mCursor = db.query("users1",
    new String[]{"FirstName","LastName","City","Age"}, "Age>19", null, null, null, "_id","5");
  
  
  ArrayList<HashMap<String, String>> mList = new ArrayList<HashMap<String, String>>();
  if(mCursor != null){
   if(mCursor.moveToFirst()){
    do{
     HashMap<String,String> item = new HashMap<String, String>();
     for(int j=0 ; j<mCursor.getColumnCount();j++){
      item.put(mCursor.getColumnName(j), mCursor.getString(j));
     
     }
     mList.add(item);
    }while(mCursor.moveToNext());
   }
  }
   
 SimpleAdapter adapter2 = new SimpleAdapter(this,mList,R.layout.main,
   new String[]{"FirstName","LastName","City","Age"},
   new int[]{R.id.text1,R.id.text2,R.id.text3,R.id.text4});
 setListAdapter(adapter2);
 if(db!=null){
  db.close();
 
 }
      
 }
  }

간단하게 db 공부 하려는데 이게 실행이 안되네요 ㅠㅠㅠ