android sqlite的一些简单的操作

//MySQLHelper .javapublic class MySQLHelper extends SQLiteOpenHelper {public static String DB_NAME = "Samyou";public static String TABLE_NAME = "user_profile";public static String COLUME_ID = "id";public static String COLUME_NAME = "name";public static String COLUME_AGE = "age";public static String COLUME_LOCATION = "location";public MySQLHelper(Context context, String name, CursorFactory factory,int version) {super(context, name, factory, version);}@Overridepublic void onCreate(SQLiteDatabase db) {System.out.println("db onCreate!!!!!!");Log.e("sqltest", "onCreat table");String sql = "create table if not exists "+ TABLE_NAME+ " (" + COLUME_ID + " integer primary key," + COLUME_NAME + " varchar," + COLUME_AGE+ " integer," + COLUME_LOCATION +" varchar);";Log.e("sqltest", sql);db.execSQL(sql);}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {db.execSQL("drop table if exists "+TABLE_NAME);onCreate(db);}}//MainPage.javapublic class MainPage extends Activity {MySQLHelper mySQLHelper = null;    public void onCreate(Bundle savedInstanceState)     {        super.onCreate(savedInstanceState);        setContentView(R.layout.main);        mySQLHelper = new MySQLHelper(this,MySQLHelper.DB_NAME,null,8);        ContentValues contentValues = new ContentValues();        contentValues.put(MySQLHelper.COLUME_NAME, "samyou");        long now = System.currentTimeMillis();        contentValues.put(MySQLHelper.COLUME_AGE, now);        System.out.println(now);        contentValues.put(MySQLHelper.COLUME_LOCATION, "loc");        insertColume(contentValues);        ContentValues contentValues2 = new ContentValues();        contentValues2.put(MySQLHelper.COLUME_NAME, "samyou2");        contentValues2.put(MySQLHelper.COLUME_AGE, System.currentTimeMillis());        contentValues2.put(MySQLHelper.COLUME_LOCATION, "loc2");        insertColume(contentValues2);                Vector<ContentValues> v = getAll();        Log.e("sqltest", "v,size: "+v.size());        for(int i=0;i<v.size();i++)        {        ContentValues contentValues3 = v.elementAt(i);        System.out.println("person: "+i);        Log.e("sqltest", "COLUME_ID "+contentValues3.getAsInteger(MySQLHelper.COLUME_ID));        Log.e("sqltest", "COLUME_NAME "+contentValues3.getAsString(MySQLHelper.COLUME_NAME));        Log.e("sqltest", "COLUME_AGE "+contentValues3.getAsLong(MySQLHelper.COLUME_AGE));        Log.e("sqltest", "COLUME_LOCATION "+contentValues3.getAsString(MySQLHelper.COLUME_LOCATION));        }    }        private Vector<ContentValues> getAll()    {    Vector<ContentValues> v = new Vector<ContentValues>();    SQLiteDatabase db = mySQLHelper.getWritableDatabase();    Cursor cursor = db.query(MySQLHelper.TABLE_NAME, new String[]{MySQLHelper.COLUME_ID,      MySQLHelper.COLUME_NAME,      MySQLHelper.COLUME_AGE,      MySQLHelper.COLUME_LOCATION},      null, null, null, null,       MySQLHelper.COLUME_ID);    int idindex = cursor.getColumnIndex(MySQLHelper.COLUME_ID);    int nameindex = cursor.getColumnIndex(MySQLHelper.COLUME_NAME);    int ageindex = cursor.getColumnIndex(MySQLHelper.COLUME_AGE);    int locationindex = cursor.getColumnIndex(MySQLHelper.COLUME_LOCATION);    cursor.moveToFirst();    while(!cursor.isAfterLast())    {    Log.e("", "move cursor");    ContentValues contentValues = new ContentValues();    contentValues.put(MySQLHelper.COLUME_ID, cursor.getInt(idindex));    contentValues.put(MySQLHelper.COLUME_NAME, cursor.getString(nameindex));    contentValues.put(MySQLHelper.COLUME_AGE, cursor.getLong(ageindex));//cursor.getInt(ageindex));    contentValues.put(MySQLHelper.COLUME_LOCATION, cursor.getString(locationindex));    v.add(contentValues);    cursor.moveToNext();    }    cursor.close();    db.close();    return v;    }        private void updateColume(ContentValues contentValues,int id)    {    SQLiteDatabase db = mySQLHelper.getWritableDatabase();    db.update(MySQLHelper.TABLE_NAME, contentValues, MySQLHelper.COLUME_ID+"=?", new String[]{id+""});    db.close();    }        private void deleteColume(int id)    {    Log.e("", "deleteColume");    SQLiteDatabase db = mySQLHelper.getWritableDatabase();    int a = db.delete(MySQLHelper.TABLE_NAME, MySQLHelper.COLUME_ID+"=?", new String[]{id+""});    db.close();    Log.e("", "delete colume: "+ a);    }        private int insertColume(ContentValues contentValues)    {    int cnt = -1;    SQLiteDatabase db = mySQLHelper.getWritableDatabase();    cnt = (int)db.insert(MySQLHelper.TABLE_NAME, MySQLHelper.COLUME_ID, contentValues);    Log.e("sqltest", "insert cnt: "+cnt);    db.close();    return cnt;    }            }