package com.example.sharedpreferences;

import androidx.appcompat.app.AppCompatActivity;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.Toast;

import java.util.ArrayList;

public class DisplayNotes extends AppCompatActivity {

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

        ListView listView = findViewById(R.id.listView1);
        final ArrayList<String> notes_array = new ArrayList<String>();

        try {

            SQLiteDatabase sqLiteDatabase = this.openOrCreateDatabase("NotesDatabase", MODE_PRIVATE, null );

                Cursor cursor = sqLiteDatabase.rawQuery("SELECT * FROM mynotes", null);
                cursor.moveToFirst();

            for (int i=0; i<cursor.getCount();i++) {
                notes_array.add(cursor.getString(0));
                cursor.moveToNext();
            }

            ArrayAdapter<String> arrayAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, notes_array);
            listView.setAdapter(arrayAdapter);

        } catch (Exception e) { e.printStackTrace(); }

        }
    }