ViewStudent.java

package com.example.selab_project;

import androidx.appcompat.app.AppCompatActivity;

import android.database.Cursor;
import android.os.Bundle;
import android.widget.TextView;

public class ViewStudent extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_view_student);
        String name="Name\n";
        String phone="Phone\n";
        String email="   Email\n";
        String Class="Class\n";
        String Tname="Teacher\n";
        TextView n,p,e,c,t;
        n=findViewById(R.id.stunames);
        p=findViewById(R.id.stucontacts);
        e=findViewById(R.id.stuemails);
        c=findViewById(R.id.stuclass);
        t=findViewById(R.id.cTeacher);
        DatabaseHelper DB=new DatabaseHelper(this);
        Cursor result=DB.getStudents();
        while(result.moveToNext()){
          name=name+result.getString(0)+"\n";
          phone=phone+result.getString(2)+"\n";
          email=email+"   "+result.getString(3)+"\n";
          Class=Class+result.getString(6)+"\n";
          Tname=Tname+result.getString(7)+"\n";
        }
        n.setText(name);
        p.setText(phone);
        e.setText(email);
        c.setText(Class);
        t.setText(Tname);
    }
}