private static final String CREATE_TABLE_MYTABLE = "CREATE TABLE " + TABLE_MYTABLE + " (" + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COLUMN_NAME + " TEXT NOT NULL, " + COLUMN_AGE + " INTEGER );";
public void insertData(String name, int age) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(COLUMN_NAME, name); values.put(COLUMN_AGE, age); db.insert(TABLE_MYTABLE, null, values); db.close(); }
public Cursor getData() { SQLiteDatabase db = this.getReadableDatabase(); String query = "SELECT " + COLUMN_ID + ", " + COLUMN_NAME + ", " + COLUMN_AGE + " FROM " + TABLE_MYTABLE; Cursor cursor = db.rawQuery(query, null); return cursor; }
上一篇:AndroidStudio中,使用GridLayout和CardView无法显示内容。
下一篇:AndroidStudio中,startActivityForResult代码已被弃用,新的替代方法是什么?是否会报错?