Question

我拥有一个包含多个表格的SQite数据库的内容提供器,并使用URI这样的软件:

Uri.parse("content://" + AUTHORITY + "/" + TABLE_NAME);

这似乎是标准模式,1 URI到1数据库表,1 CONTENT_。缩略语

然而,我需要获得表格数据子的URIs。目前,在我的数据库中增加一个附加表格,对我来说是没有意义的。看起来像内容提供人打算这样做一样,我只能看到这一点。基本上,我想有一个URI,它要提出一个问题,而不是一个表格。希望是有意义的。

Answer 1

在您提出申请后,只要需要新的国际独立评估报告,你就应当修改其内容提供者的询问方法:

public class ExampleProvider extends ContentProvider {

    private static final UriMatcher sUriMatcher;


    sUriMatcher.addURI("com.example.app.provider", "table3", 1);
    sUriMatcher.addURI("com.example.app.provider", "table3/#", 2);
    sUriMatcher.addURI("com.example.app.provider", "table3/customquery", 3);

public Cursor query(
    Uri uri,
    String[] projection,
    String selection,
    String[] selectionArgs,
    String sortOrder) {

    switch (sUriMatcher.match(uri)) {


        // If the incoming URI was for all of table3
        case 1:

            if (TextUtils.isEmpty(sortOrder)) sortOrder = "_ID ASC";
            break;

        // If the incoming URI was for a single row
        case 2:

            /*
             * Because this URI was for a single row, the _ID value part is
             * present. Get the last path segment from the URI; this is the _ID value.
             * Then, append the value to the WHERE clause for the query
             */
            selection = selection + "_ID = " uri.getLastPathSegment();
            break;
        case 3:
             // handle your custom query here

             break;

    }
    // call the code to actually do the query
}

友情链接