DatabaseContract.java

// Define Column Table & Table Name
public final class DatabaseContract {
    private DatabaseContract() {
    }

    public static class TbDosen implements BaseColumns {
        public static final String TABLE_NAME = "dosen";
        public static final String COLUMN_NAME_NAMA = "nama";
        public static final String COLUMN_NAME_EMAIL = "email";
    }
}

DatabaseHelper.java

// Membuat Helper untuk SQLite dengan mengextend SQLiteOpenHelper
// Mendfinisikan DB
public class DatabaseHelper extends SQLiteOpenHelper {
    public DatabaseHelper(Context context, String dbName, @Nullable SQLiteDatabase.CursorFactory factory, int dbVersion) {
        super(context, dbName, factory, dbVersion);
    }

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

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }


    public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        onUpgrade(db, oldVersion, newVersion);
    }

    // DDL Create Table
    private static final String SQL_CREATE_TbDOSEN =
            "CREATE TABLE " + DatabaseContract.TbDosen.TABLE_NAME + " (" +
                    DatabaseContract.TbDosen._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
                    DatabaseContract.TbDosen.COLUMN_NAME_NAMA + " TEXT," +
                    DatabaseContract.TbDosen.COLUMN_NAME_EMAIL + " TEXT)";
}

MainActivity.java

public class MainActivity extends AppCompatActivity {
    DBCrudHelper _SQLITE_crudHelper;
    DatabaseHelper _dbHelper;
    ArrayList<RecyclerViewList> myListData = new ArrayList<RecyclerViewList>();
    
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        // Create DB and Dosen Table
        _dbHelper = new DatabaseHelper(this, "dbBimbingan", null, 1); // Instance SQLite Helper
        _SQLITE_crudHelper = new DBCrudHelper(_dbHelper); // Instance DB Helper (Query)
        _SQLITE_crudHelper.clearTable(DatabaseContract.TbDosen.TABLE_NAME);

        // Declare ContentValues (A key/value store that inserts data into a row of a table.)
        ContentValues Dosen1 = new ContentValues();
        ContentValues Dosen2 = new ContentValues();

        // Insert to ContentValues (key & value)
        Dosen1.put("nama", "nama dosen 1");
        Dosen1.put("email", "[email protected]");

        Dosen2.put("nama", "nama dosen 2");
        Dosen2.put("email", "[email protected]");

        //Insert Data to DB
        _SQLITE_crudHelper.insertDosen(Dosen1);
        _SQLITE_crudHelper.insertDosen(Dosen2);

        //Store data from SQLite to Array list RecyclerViewList
        myListData.add(new RecyclerViewList(_SQLITE_crudHelper.getDosen(null).get(0).get("nama") + " (id: " + _SQLITE_crudHelper.getDosen(null).get(0).get("id") + ") " + _SQLITE_crudHelper.getDosen(null).get(0).get("email")));
        myListData.add(new RecyclerViewList(_SQLITE_crudHelper.getDosen(null).get(1).get("nama") + " (id: " + _SQLITE_crudHelper.getDosen(null).get(1).get("id") + ") " + _SQLITE_crudHelper.getDosen(null).get(1).get("email")));
        
        // Set Recyclerview Adapter
        RecyclerView recyclerView = (RecyclerView) findViewById(R.id.rec);
        MyListAdapter adapter = new MyListAdapter(myListData);
        recyclerView.setHasFixedSize(true);
        recyclerView.setLayoutManager(new LinearLayoutManager(this));
        recyclerView.setAdapter(adapter);
    }

    // Close SQLite Connection
    @Override
    protected void onDestroy() {
        _dbHelper.close();
        super.onDestroy();
    }
 }