数据库的增删改查——自定义权限

添加数据的APP,内容提供者

内容提供者

package com.example.homework_one.Provider;

import android.content.ContentProvider;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.net.Uri;

import com.example.homework_one.sql.MySql;

public class MyProvider extends ContentProvider {
   
    private SQLiteDatabase db;
    public MyProvider() {
   
    }

    @Override
    public int delete(Uri uri, String selection, String[] selectionArgs) {
   
      return db.delete("message",selection,selectionArgs);
    }

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

    @Override
    public Uri insert(Uri uri, ContentValues values) {
   
        db.insert("message",null,values);
        return uri;
    }

    @Override
    public boolean onCreate() {
   
        MySql mySql = new MySql(getContext(), "messages.db", null, 1);
        db= mySql.getReadableDatabase();
        if (db == null){
   
            return  false;
        }
        return true;
    }

    @Override
    public Cursor query(Uri uri, String[] projection, String selection,
                        String[] selectionArgs, String sortOrder) {
   
        return db.query("message",projection,selection,selectionArgs,null,null,sortOrder);
    }

    @Override
    public int update(Uri uri, ContentValues values, String selection,
                      String[] selectionArgs) {
   
        return db.update("message",values,selection,selectionArgs);
}
}

继承SQLiteOpenHelper

package com.example.homework_one.sql;

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

public class MySql extends SQLiteOpenHelper {
   
    public MySql( Context context,  String name,  SQLiteDatabase.CursorFactory factory, int version) {
   
        super(context, name, factory, version);
    }

    //给用户创建表用的
    @Override
    public void onCreate(SQLiteDatabase db) {
   
        db.execSQL("create table message(picid integer primary key autoincrement,picpic varchar(1000),picurl varchar(30))");
        db.beginTransaction();
        db.setTransactionSuccessful();
        db.endTransaction();
    }

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

    }
}

网络请求

package com.example.homework_one;

import android.util.Log;

import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net