public class MySqliteHelper extends SQLiteOpenHelper {

     private static String My_sql;

     private Context context;

     public MySqliteHelper(Context context, String name, CursorFactory factory,

             int version) {

         super(context, name, null, version);

         this.context = context;

     }

     @Override

     public void onCreate(SQLiteDatabase db) {

         My_sql = "CREATE TABLE MYTABLE (_ID INTEGER PRIMARY KEY,_NAME,_AGE,_ADDRESS)";

         db.execSQL(My_sql);

     }

     @Override

     public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

         Toast.makeText(context, "旧版本："+oldVersion+"，新版本"+newVersion, 0).show();

     }

 }

 public class MainActivity extends Activity implements OnClickListener{

     private Button btnQuery,btnUpdate,btnAdd,btnDelete;

     private MySqliteHelper mySqliteHelper;

     private int version = 2;

     private SQLiteDatabase database;

     private ContentValues contentValues;

     @Override

     protected void onCreate(Bundle savedInstanceState) {

         super.onCreate(savedInstanceState);

         setContentView(R.layout.activity_main);

         initView();

         setEvent();

     }

     private void setEvent() {

         btnQuery.setOnClickListener(this);

         btnUpdate.setOnClickListener(this);

         btnAdd.setOnClickListener(this);

         btnDelete.setOnClickListener(this);

     }

     private void initView() {

         btnAdd = (Button) this.findViewById(R.id.id_databaseButtonAdd);

         btnDelete = (Button) this.findViewById(R.id.id_databaseButtonDelete);

         btnQuery = (Button) this.findViewById(R.id.id_databaseButtonQuery);

         btnUpdate = (Button) this.findViewById(R.id.id_databaseButtonUpdate);

         mySqliteHelper  = new MySqliteHelper(this, "MySqlite.db", null, version);//创建数据库

         database =    mySqliteHelper.getReadableDatabase();//打开数据库返回SQLiteDatabase对象

         contentValues = new ContentValues();

     }

     @Override

     public void onClick(View v) {

         switch (v.getId()) {

         case R.id.id_databaseButtonAdd:

             contentValues.clear();

             contentValues.put("_NAME","QQ");

             contentValues.put("_AGE","15");

             contentValues.put("_ADDRESS","NO");

             database.insert("MYTABLE", null, contentValues);

             break;

         case R.id.id_databaseButtonQuery:

             Cursor cursor = database.query("MYTABLE", null, null, null, null, null, null);

             while (cursor.moveToNext()) {

                 String name =cursor.getString(cursor.getColumnIndex("_NAME"));

                 String id =cursor.getString(cursor.getColumnIndex("_ID"));

                 String age =cursor.getString(cursor.getColumnIndex("_AGE"));

                 String address =cursor.getString(cursor.getColumnIndex("_ADDRESS"));

                 Toast.makeText(this,id+"|"+name+"|"+age+"|"+address, 0).show();

             }

             break;

         case R.id.id_databaseButtonDelete:

             //与上一篇同样的操作

             break;

         case R.id.id_databaseButtonUpdate:

             //与上一篇同样的操作

             break;

         default:

             break;

         }

     }

 }

 <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

     android:layout_width="fill_parent"

     android:layout_height="fill_parent"

     android:orientation="vertical" >

     <Button

         android:id="@+id/id_databaseButtonAdd"

         android:layout_width="match_parent"

         android:layout_height="wrap_content"

         android:text="添加数据" />

     <Button

         android:id="@+id/id_databaseButtonUpdate"

         android:layout_width="match_parent"

         android:layout_height="wrap_content"

         android:text="修改数据" />

     <Button

         android:id="@+id/id_databaseButtonDelete"

         android:layout_width="match_parent"

         android:layout_height="wrap_content"

         android:text="删除数据" />

     <Button

         android:id="@+id/id_databaseButtonQuery"

         android:layout_width="match_parent"

         android:layout_height="wrap_content"

         android:text="查询数据" />

 </LinearLayout>