sqlite Êý¾Ý¿âµÄ²Ù×÷

********´´½¨***********
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
public class DataBaseOpenHelper extends SQLiteOpenHelper {
 public static final String DATABASE_NAME = "my.db";
 /**
  * @param context ÉÏÏÂÎÄ
  * @param name Êý¾Ý¿âµÄÃû³Æ
  * @param factory Óα깤³§ --CursorFactory factoryÒ»°ãÇé¿öÏÂÊDz»ÐèÒªÖ¸¶¨µÄ
  * @param version °æ±¾ µ±ÎÒÃǵİ汾ºÅ¸üеÄʱºòϵͳ»á×Ô¶¯µ÷ÓÃonCreate(SQLiteDatabase db)Õâ¸ö·½·¨
  *
  */
 public DataBaseOpenHelper(Context context,int version) {
  super(context, DATABASE_NAME, null, version);
 }
 /**
  * 1. Õâ¸ö·½·¨ÓÃÓÚ³õʼ»¯Êý¾Ý¿â±í£¬±í½á¹¹µÄ´´½¨
  */
 @Override
 public void onCreate(SQLiteDatabase db) {
  db.execSQL("CREATE TABLE person (personid integer primary key autoincrement, name varchar(20), age integer)");
  
 }
 /**
  * µ±°æ±¾ºÅ¸ü¸ÄµÄʱºò»áµ÷ÓÃÕâ¸ö·½·¨ @Override
  */
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  db.execSQL("DROP TABLE IF EXISTS person");
        onCreate(db);
 }
}
********²Ù×÷***********
import java.util.ArrayList;
import java.util.List;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import cn.itcast.domain.Person;
import cn.itcast.sqlite.opendb.DataBaseOpenHelper;
public class DataBaseService {
 private DataBaseOpenHelper opendb;
 private SQLiteDatabase db ;
 public DataBaseService(DataBaseOpenHelper opendb) {
  this.opendb = opendb;
  db = this.opendb.getReadableDatabase();
 }
 public void save(Person person) {
  db.execSQL("insert into person(name,age) values(?,?)",new Object[]{person.getName(),person.getAge()})