android数据库

private static class DBOpenHelper extends SQLiteOpenHelper { // 继承SQLITEOpenHelper的静态内部类 private static final String DB_CREATE = "create table " + DB_TABLE + " (" + KEY_ID + " integer primary key autoincrement, " + KEY_NAME + " text not null, " + KEY_AGE + " integer," + KEY_HEIGHT + " float);"; //SQL建表语句 public DBOpenHelper(Context context, String name, CursorFactory factory, int version) { super(context, name, factory, version); } @Override public void onCreate(SQLiteDatabase _db) { // 创建数据库 // db.execSQL(DB_NAME); _db.execSQL(DB_CREATE); } @Override public void onUpgrade(SQLiteDatabase _db, int oldVersion, int newVersion) { // 更新数据库 _db.execSQL("DROP TABLE IF EXISTS " + DB_TABLE); onCreate(_db); } }

android Menu

Menu的基本用法public boolean onCreateOptionsMenu (Menu menu){ menu.add(0,MENU_UPLOAD,0,"上传"); SubMenu uploadMenu = (SubMenu) menu.addSubMenu(0,MENU_DOWNLOAD,1,"下载设置"); uploadMenu.setHeaderIcon(R.drawable.icon); uploadMenu.setHeaderTitle("下载参数设置"); uploadMenu.add(0,SUB_MENU_UPLOAD_A,0,"下载参数A"); uploadMenu.add(0,SUB_MENU_UPLOAD_B,0,"下载参数B"); menu.add(0,MENU_CLICK,2,"查看点击次数").setIcon(R.drawable.icon); return true; }