创建数据库

 

 

package com.xrj.myapplication.utils;

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

public class PersonDBHelper extends SQLiteOpenHelper {

    public PersonDBHelper(Context context) {
        super(context,"mydb.db",null,1);
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table person (id integer primary key autoincrement,name varchar(20),number varchar(20))");

    }

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

    }
}

 

 

package com.xrj.myapplication;

import androidx.test.InstrumentationRegistry;
import androidx.test.ext.junit.runners.AndroidJUnit4;

import com.xrj.myapplication.utils.PersonDBHelper;

import org.junit.Test;
import org.junit.runner.RunWith;

@RunWith(AndroidJUnit4.class)
public class PersonDBHelperTest {
    @Test
    public void createDBTest() {
        PersonDBHelper helper = new PersonDBHelper(InstrumentationRegistry.getTargetContext());
        helper.getWritableDatabase();
    }
}