How to get a record from the database (SQLite) on a click on a textView?

Question

Java

Data from the database is successfully displayed in the textView. By clicking on the textView, the records in this textView should change (infa should be taken from the same database). How to rearrange the cursor to the desired position so that it reads the desired entry when clicked?

Answer 1

It was necessary to write the necessary SQL query. The specific answer is specific and I see no point in publishing it.

Answer 2

Intent i = new Intent(FirstScreen.this, SecondScreen.class);   
String strName = null;
i.putExtra("STRING_I_NEED", strName);

String newString;
if (savedInstanceState == null) {
    Bundle extras = getIntent().getExtras();
    newString= extras.getString("STRING_I_NEED");