Android之ContentProvider

ContentProvider,实现跨程序数据共享,像是通讯录之类的都有使用。以下为代码。

DbOpenHelper.java代码:

package com.minardwu.learnprovider;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * Created by MinardWu on 2016/10/4.
 */
public class DbOpenHelper extends SQLiteOpenHelper {
    private static final String DB_NAME = "myprovide.db";
    private static final int DB_VERSION = 1;
    public static final String TABLE_USER_NAME = "user";
    public static final String TABLE_BOOK_NAME = "book";
    private String CREATE_TABLE_USER = "create table if not exists "+TABLE_USER_NAME+"(_id INTEGER PRIMARY KRY,name TEXT,sex INT)";
    private String CREATE_TABLE_BOOK = "create table if not exists "+TABLE_BOOK_NAME+"(_id INTEGER PRIMARY KRY,name TEXT)";

    public DbOpenHelper(Context context) {
        super(context,DB_NAME, null, DB_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_TABLE_USER);
        db.execSQL(CREATE_TABLE_BOOK);
    }

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

    }
}
MyProvider代码:

package com.minardwu.learnprovider;

import android.content.ContentProvider;
import android.content.ContentValues;
import android.content.Context;
import android.content.UriMatcher;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.net.Uri;
import android.support.annotation.Nullable;

import java.net.URI;

/**
 * Created by MinardWu on 2016/10/4.
 */
public class MyProvider extends ContentProvider{

    public static final String AUTHORITIES = "com.minardwu.learnprovider.MyProvider";
    public static final Uri USER_URI = Uri.parse("content://"+AUTHORITIES+"/user");
    public static final Uri BOOK_URI = Uri.parse("content://"+AUTHORITIES+"/book");
    public static final int USER_URI_CODE = 0;
    public static final int BOOK_URI_CODE = 1;
    private static final UriMatcher matcher = new UriMatcher(UriMatcher.NO_MATCH);
    static {
        matcher.addURI(AUTHORITIES,"user",USER_URI_CODE);
        matcher.addURI(AUTHORITIES,"book",BOOK_URI_CODE);
    }
    private SQLiteDatabase sqLiteDatabase;

    @Override
    public boolean onCreate() {
        sqLiteDatabase = new DbOpenHelper(getContext()).getWritableDatabase();
        sqLiteDatabase.execSQL("delete from "+DbOpenHelper.TABLE_USER_NAME);
        sqLiteDatabase.execSQL("delete from "+DbOpenHelper.TABLE_BOOK_NAME);
        sqLiteDatabase.execSQL("insert into user values(1,'wu','1');");
        sqLiteDatabase.execSQL("insert into book values(1,'Android');");
        return true;
    }

    private String getTableName(Uri uri){
        String tableName = null;
        switch (matcher.match(uri)){
            case USER_URI_CODE:
                tableName = DbOpenHelper.TABLE_USER_NAME;
                break;
            case BOOK_URI_CODE:
                tableName = DbOpenHelper.TABLE_BOOK_NAME;
                break;
            default:
                break;
        }
        return tableName;
    }

    //Provider的增删改查函数里面执行的是SQLite数据库的增删改查函数,sqLiteDatabase.query/insert/update/delete.
    @Nullable
    @Override
    public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
        //先确定是哪个表,所有操作都有以下两个步骤
        String tableName = getTableName(uri);
        if(tableName==null) throw new IllegalArgumentException("uri为:"+uri+",找不到对应的表。");
        return sqLiteDatabase.query(tableName,projection,selection,selectionArgs,null,null,sortOrder,null);
    }

    //update、insert、delete会引起数据源的改变所以需要notifyChange()函数来通知外界数据已经发生变化
    @Nullable
    @Override
    public Uri insert(Uri uri, ContentValues values) {
        String tableName = getTableName(uri);
        if(tableName==null) throw new IllegalArgumentException("uri为:"+uri+",找不到对应的表。");
        sqLiteDatabase.insert(tableName,null,values);
        getContext().getContentResolver().notifyChange(uri,null);
        return uri;
    }

    @Override
    public int delete(Uri uri, String selection, String[] selectionArgs) {
        String tableName = getTableName(uri);
        if(tableName==null) throw new IllegalArgumentException("uri为:"+uri+",找不到对应的表。");
        int count = sqLiteDatabase.delete(tableName,selection,selectionArgs);
        if(count>0) getContext().getContentResolver().notifyChange(uri,null);//count>0表明有数据被删除
        return count;
    }

    @Override
    public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {
        String tableName = getTableName(uri);
        if(tableName==null) throw new IllegalArgumentException("uri为:"+uri+",找不到对应的表。");
        int count = sqLiteDatabase.update(tableName,values,selection,selectionArgs);
        if(count>0) getContext().getContentResolver().notifyChange(uri,null);//count>0表明有数据被更新
        return count;
    }

    @Nullable
    @Override
    public String getType(Uri uri) {
        return null;
    }

}

MainActivity代码:

package com.minardwu.learnprovider;

import android.content.ContentValues;
import android.database.Cursor;
import android.net.Uri;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        ContentValues values = new ContentValues();
        values.put("_id","2");
        values.put("name","zhang");
        //调用ContentProvider的insert函数,该函数有调用数据库的insert函数
        getContentResolver().insert(MyProvider.USER_URI,values);
        Cursor cursor = getContentResolver().query(MyProvider.USER_URI,new String[]{"_id","name"},null,null,null);
        while (cursor.moveToNext()){
            System.out.println(cursor.getInt(0)+cursor.getString(1));
        }
        cursor.close();
    }
}
内容概要:本文详细介绍了“秒杀商城”微服务架构的设计与实战全过程,涵盖系统从需求分析、服务拆分、技术选型到核心功能开发、分布式事务处理、容器化部署及监控链路追踪的完整流程。重点解决了高并发场景下的超卖问题,采用Redis预减库存、消息队列削峰、数据库乐观锁等手段保障数据一致性,并通过Nacos实现服务注册发现与配置管理,利用Seata处理跨服务分布式事务,结合RabbitMQ实现异步下单,提升系统吞吐能力。同时,项目支持Docker Compose快速部署和Kubernetes生产级编排,集成Sleuth+Zipkin链路追踪与Prometheus+Grafana监控体系,构建可观测性强的微服务系统。; 适合人群:具备Java基础和Spring Boot开发经验,熟悉微服务基本概念的中高级研发人员,尤其是希望深入理解高并发系统设计、分布式事务、服务治理等核心技术的开发者;适合工作2-5年、有志于转型微服务或提升架构能力的工程师; 使用场景及目标:①学习如何基于Spring Cloud Alibaba构建完整的微服务项目;②掌握秒杀场景下高并发、超卖控制、异步化、削峰填谷等关键技术方案;③实践分布式事务(Seata)、服务熔断降级、链路追踪、统一配置中心等企业级中间件的应用;④完成从本地开发到容器化部署的全流程落地; 阅读建议:建议按照文档提供的七个阶段循序渐进地动手实践,重点关注秒杀流程设计、服务间通信机制、分布式事务实现和系统性能优化部分,结合代码调试与监控工具深入理解各组件协作原理,真正掌握高并发微服务系统的构建能力。
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值