Sq

package com.bw.mysqlite;

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

public class MySqlite extends SQLiteOpenHelper{
    public MySqlite(Context context) {
        super(context, "user.db", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE preson(presonid INTEGER PRIMARY KEY AUTOINCREMENT," +
                "_id VARCHAR(20),name VARCHAR(20),rank VARCHAR(20))");
    }

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

    }
}

package com.bw.mysqlite;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class Dao {

    private final SQLiteDatabase db;

    public Dao(Context context){
        MySqlite sqlite = new MySqlite(context);

        db = sqlite.getWritableDatabase();

    }


    public long intert(String table, String nullColumnHack, ContentValues values){
        return db.insert(table, nullColumnHack, values);
    }
    public Cursor select(String table, String[] columns, String selection,
                         String[] selectionArgs, String groupBy, String having,
                         String orderBy){
        return  db.query( table,  columns,  selection,
                 selectionArgs,  groupBy,  having,
                 orderBy);
    }
}

package com.bw.mysqlite;

import android.content.ContentValues;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;

public class MainActivity extends AppCompatActivity {

    private Button button;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        button = findViewById(R.id.but);
        button.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Dao dao = new Dao(MainActivity.this);
                ContentValues values = new ContentValues();
                values.put("name","李瑞");
                values.put("rank","www.baidu.com");

                dao.intert("preson",null,values);
            }
        });

    }
}