// StudentsDb1 Example 
// MainActivity.java

package it372.smiths.studentdb1;
import androidx.appcompat.app.AppCompatActivity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.widget.TextView;
import android.widget.Toast;
public class MainActivity extends AppCompatActivity {

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

        TextView txtOutput = findViewById(R.id.txt_output);
        SQLiteOpenHelper dbh = new StudentsDBHelper(this);
        try {
            SQLiteDatabase db = dbh.getReadableDatabase();
            Cursor cursor = db.query("students",
                    new String[ ] {"name", "grade", "gender"},
                    null, null, null,
                    null, null) ;
            if (cursor.moveToLast()) {
                String name = cursor.getString(0);
                int grade = cursor.getInt(1);
                String gender = cursor.getString(2);
                String output = String.format("%s %d %s",
                        name, grade, gender);
                txtOutput.setText(output);
            }
        }
        catch(SQLiteException e) {
            Toast toast = Toast.makeText(this, "Database not created.",
               Toast.LENGTH_LONG);
        }
    }
}