????Android??????????SQLiteDatabase?????????????Щ??????????API?????????????????????????(Create)?????(Retrieve)??????(Update)?????(Delete)????????Щ????????CRUD??
????SQLite ?????  NULL??INTEGER??REAL(????????)??TEXT??BLOB(?????????)??5???????????
????SQLite ?????????????λ??/data/data/package-name/databases ?????
????????????????????????SQLiteOpenHelper??????????MySqlHelper.java???????????SQLiteOpenHelper?????????

 

package com.alpha.sqlite;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class MySqlHelper extends SQLiteOpenHelper {
public MySqlHelper(Context context?? String name?? CursorFactory factory??
int version) {
super(context?? name?? factory?? version);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
//???????????????    3?????????
//primary key   ????????   ?????????о?????????л??е????????????????е????С?????????л???г?????????
db.execSQL("create table mytable(id integer primary key autoincrement??name text??age text)");
}
@Override
public void onUpgrade(SQLiteDatabase arg0?? int arg1?? int arg2) {
// TODO Auto-generated method stub
}
}

????????????????????? SQLiteOpenHelper ??????  MySqlHelper ??????????????????   ??onCreate??????   ????????????Ρ?

 

private MySqlHelper mysql;
private SQLiteDatabase db;
mysql=new MySqlHelper(MainActivity.this??"mydb"??null??1);
db=mysql.getReadableDatabase();   //??????????????

????getReadableDatabase()??????????????????????д???????????????????洢??????????????????????????????????????????????
????getWritableDatabase()??????????????????????д???????????????????洢?????????????????????????
??????????????getReadableDatabase()???????????????