1.查询操作:
简单的直接使用SQLiteDatabase#query(table_name,columns,selections,selectionArgs,groupby,having,orderby,limits)
需要根据各种情况动态构建sql语句的,可以使用SQLiteQueryBuilder。用法如下:
DatabaseHelper database = getDatabaseForUri(uri);
SQLiteDatabase db = database.getReadableDatabase();
if (db == null) {
throw new IllegalStateException("Couldn't open database for " + uri);
}
SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
int albumid = Integer.parseInt(uri.getPathSegments().get(3));
qb.setTables("audio_meta");
qb.appendWhere("album_id=" + albu