studentmultietable

login(activity_main.xml)

<TextView
android:id="@+id/Login"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentStart="true"
android:layout_alignParentTop="true"
android:layout_marginStart="150dp"
android:layout_marginTop="24dp"
android:text="Login Page" />

⎗
✓
<EditText
    android:id="@+id/uname"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentTop="true"
    android:layout_centerHorizontal="true"
    android:layout_marginTop="101dp"
    android:ems="10"
    android:inputType="textPersonName"
    android:hint="Enter User Name" />

<EditText
    android:id="@+id/pass"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentTop="true"
    android:layout_centerHorizontal="true"
    android:layout_marginTop="225dp"
    android:ems="10"
    android:inputType="textPersonName"
    android:hint="Enter Password" />

<Button
    android:id="@+id/btnLogin"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentStart="true"
    android:layout_alignParentBottom="true"
    android:layout_marginStart="147dp"
    android:layout_marginBottom="296dp"
    android:text="Login" />

mainactivity:

public class MainActivity extends AppCompatActivity implements View.OnClickListener {
EditText uname,pass;
Button btnLogin;

⎗
✓
SharedPreferences sp;
private static final String sp_name="mypref";
private static final String key_uname="uname";
private static final String key_pass="pass";

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

    uname=findViewById(R.id.uname);
    pass=findViewById(R.id.pass);
    btnLogin=findViewById(R.id.btnLogin);
    sp=getSharedPreferences("sp_name",MODE_PRIVATE);
    btnLogin.setOnClickListener(this);
}

@Override
public void onClick(View view) {
    SharedPreferences.Editor editor=sp.edit();
    editor.putString(key_uname,uname.getText().toString());
    editor.putString(key_pass,pass.getText().toString());
    editor.apply();
    Intent i=new Intent(this,AddStudent.class);
    startActivity(i);
    Toast.makeText(this,"Login Success",Toast.LENGTH_SHORT).show();

}

}


ENTITY(STUDENT_ENTITY)

public class StudentEntity {

⎗
✓
int sid;
String sname,gender;
int phn;

public StudentEntity(String sname, String gender, int phn) {
    this.sname = sname;
    this.gender = gender;
    this.phn = phn;
}

public StudentEntity(int sid, String sname, String gender, int phn) {
    this.sid = sid;
    this.sname = sname;
    this.gender = gender;
    this.phn = phn;
}

public int getSid() {
    return sid;
}

public void setSid(int sid) {
    this.sid = sid;
}

public String getSname() {
    return sname;
}

public void setSname(String sname) {
    this.sname = sname;
}

public String getGender() {
    return gender;
}

public void setGender(String gender) {
    this.gender = gender;
}

public int getPhn() {
    return phn;
}

public void setPhn(int phn) {
    this.phn = phn;
}

}


MARK_ENTITY :

public class MarkEntity {

⎗
✓
Double mark1,mark2,mark3,total;
int sid,mid;
String name;


public MarkEntity(Double mark1, Double mark2, Double mark3, Double total, String name) {
    this.mark1 = mark1;
    this.mark2 = mark2;
    this.mark3 = mark3;
    this.total = total;

}

public MarkEntity(Double mark1, Double mark2, Double mark3, Double total, int sid, String name) {
    this.mark1 = mark1;
    this.mark2 = mark2;
    this.mark3 = mark3;
    this.total = total;
    this.sid = sid;

}

public MarkEntity(Double mark1, Double mark2, Double mark3, String name) {
    this.mark1 = mark1;
    this.mark2 = mark2;
    this.mark3 = mark3;
    this.name = name;
}

public Double getMark1() {
    return mark1;
}

public void setMark1(Double mark1) {
    this.mark1 = mark1;
}

public Double getMark2() {
    return mark2;
}

public void setMark2(Double mark2) {
    this.mark2 = mark2;
}

public Double getMark3() {
    return mark3;
}

public void setMark3(Double mark3) {
    this.mark3 = mark3;
}

public Double getTotal() {
    return total;
}

public void setTotal(Double total) {
    this.total = total;
}

public int getSid() {
    return sid;
}

public void setSid(int sid) {
    this.sid = sid;
}

public int getMid() {
    return mid;
}

public void setMid(int mid) {
    this.mid = mid;
}

public String getName() {
    return name;
}

public void setName(String name) {
    this.name = name;
}

}


DBHANDLER :

public class DBHandler extends SQLiteOpenHelper {

⎗
✓
static String DBName="StudentDB";
static int DBVersion=1;
static String Table_Student="StudentTB";

static String KEY_SID="sid";
static String KEY_Name="sname";
static String KEY_Gender="gender";
static String KEY_Phn="phn";

static String Table_Mark="MarkTB";
static String KEY_MID="mid";
static String KEY_StudID="sid";
static String KEY_Mark1="mark1";
static String KEY_Mark2="mark2";
static String KEY_Mark3="mark3";
static String KEY_Total="total";

public DBHandler(@Nullable Context context) {
    super(context, DBName, null, DBVersion);
}

@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
    String query="CREATE TABLE "+Table_Student+" (" + KEY_SID + " INTEGER PRIMARY KEY AUTOINCREMENT ," + KEY_Name + " TEXT ," + KEY_Gender + " TEXT ," + KEY_Phn + " INTEGER)";
    String query2="CREATE TABLE "+Table_Mark+" (" + KEY_MID + " INTEGER PRIMARY KEY AUTOINCREMENT ," + KEY_StudID + " INTEGER ," + KEY_Mark1 + " DOUBLE ," + KEY_Mark2 + " DOUBLE ," + KEY_Mark3 + " DOUBLE ," + KEY_Total + " DOUBLE , " + " FOREIGN KEY " + "("+ KEY_StudID+")" + " REFERENCES " + Table_Student + "("+ KEY_Name +")" + " )";

    sqLiteDatabase.execSQL(query);
    sqLiteDatabase.execSQL(query2);
}

@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
    sqLiteDatabase.execSQL("DROP TABLE IF EXISTS "+Table_Student);
    sqLiteDatabase.execSQL("DROP TABLE IF EXISTS "+Table_Mark);
    onCreate(sqLiteDatabase);
}

public void addStudent(StudentEntity student){
    SQLiteDatabase db=this.getWritableDatabase();
    ContentValues values=new ContentValues();
    values.put(KEY_Name,student.getSname());
    values.put(KEY_Gender,student.getGender());
    values.put(KEY_Phn,student.getPhn());
    db.insert(Table_Student,null,values);
    db.close();
}

public void addMark(MarkEntity marks)
{
    Double total=marks.getMark1()+ marks.getMark2()+ marks.getMark3();
    SQLiteDatabase db=this.getWritableDatabase();
    ContentValues values=new ContentValues();
    values.put(KEY_Mark1,marks.getMark1());
    values.put(KEY_Mark2,marks.getMark2());
    values.put(KEY_Mark3,marks.getMark3());
    values.put(KEY_Total,total);
    db.insert(Table_Mark,null,values);
    db.close();
}

public ArrayList<StudentEntity> getAllStudent(){
    SQLiteDatabase db=this.getWritableDatabase();
    Cursor c=db.rawQuery("SELECT * FROM "+Table_Student,null);
    ArrayList<StudentEntity>list=new ArrayList<>();
    if(c.moveToFirst()){
        do {
            list.add(new StudentEntity(c.getString(1),c.getString(2),Integer.parseInt(c.getString(3))));
        }while (c.moveToNext());
    }
    c.close();
    return list;

}

public Double getMarkByID(int sid)
{
    SQLiteDatabase db=this.getReadableDatabase();
    Double mark1 = null,mark2=null,mark3=null,total=null;
    Cursor c= db.query(Table_Mark,new String[]{KEY_Total},KEY_StudID + "=?",new String[]{String.valueOf(sid)},null,null,null,null);
    if(c != null)
    {
        c.moveToFirst();

// mark1=Double.parseDouble(c.getString(2));
// mark2=Double.parseDouble(c.getString(3));
// mark3=Double.parseDouble(c.getString(4));
total=Double.parseDouble(c.getString(5));
}
return total;
}

// public ArrayList<MarkEntity>getAllMark(){
// SQLiteDatabase db=this.getWritableDatabase();
// Cursor c=db.rawQuery("SELECT * FROM "+Table_Mark,null);
// }

⎗
✓
1
2
3
4
5
6
public void delStudent(StudentEntity student)
{
    SQLiteDatabase db=this.getWritableDatabase();
    db.delete(Table_Student,KEY_SID + "=?",new String[]{String.valueOf(student.getSid())});
    db.close();
}

}


ACTIVITY_ROW(STUDENT).XML :

<TextView
android:id="@+id/sname"
android:layout_width="wrap_content"
android:layout_height="wrap_content"

⎗
✓
    android:text="Name" />

<TextView
    android:id="@+id/gender"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_below="@id/sname"
    android:text="Gender" />

<TextView
    android:id="@+id/phn"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_below="@id/gender"
    android:text="Phn" />

<TextView
    android:id="@+id/total"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_below="@id/phn"
    android:text="Total" />

<ImageButton
    android:id="@+id/imgDetail"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentTop="true"
    android:layout_alignParentEnd="true"
    app:srcCompat="@android:drawable/ic_menu_info_details" />

<ImageButton
    android:id="@+id/btnDel"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentTop="true"
    android:layout_alignParentEnd="true"
    android:layout_marginEnd="57dp"
    app:srcCompat="@android:drawable/ic_menu_delete" />

ACTIVITY_DETAIL(MARK).XML :

<TextView
android:id="@+id/mark1"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentStart="true"
android:layout_alignParentTop="true"
android:layout_marginStart="11dp"
android:layout_marginTop="2dp"
android:text="Mark1" />
<TextView
android:id="@+id/mark2"
android:layout_width="wrap_content"
android:layout_height="wrap_content"

⎗
✓
    android:layout_below="@id/mark1"
    android:text="Mark2" />

<TextView
    android:id="@+id/mark3"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"

    android:layout_marginTop="45dp"
    android:text="Mark3" />

<TextView
    android:id="@+id/total"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"

    android:layout_marginTop="76dp"
    android:text="total" />

STUDENT_ADAPTER :

public class StudentAdapter extends RecyclerView.Adapter<StudentAdapter.MyViewHolder> {
Context context;
int resource;
DBHandler db;
ArrayList<StudentEntity> students;

⎗
✓
public StudentAdapter(Context context, int resource, ArrayList<StudentEntity> students) {
    this.context = context;
    this.resource = resource;
    this.students = students;
}

@NonNull
@Override
public StudentAdapter.MyViewHolder onCreateViewHolder(@NonNull ViewGroup parent, int viewType) {
   View view= LayoutInflater.from(context).inflate(resource,parent,false);
   return new MyViewHolder(view);
}

@Override
public void onBindViewHolder(@NonNull StudentAdapter.MyViewHolder holder, int position) {
    StudentEntity s=students.get(position);
    //MarkEntity m;
    holder.sname.setText(s.getSname());
    holder.gender.setText(s.getGender());
    holder.phn.setText(String.valueOf(s.getPhn()));
    holder.btnDel.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View view) {
            db=new DBHandler(context);
            db.delStudent(s);
            delete(holder.getAdapterPosition());
        }
    });

    holder.imgDetail.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View view) {
            db=new DBHandler(context);
            //ArrayList<MarkEntity>list=db.getMarkByID();
           // MarkAdapter adp=new MarkAdapter(this,R.layout.detail_row,list);


        }
    });
}

public void delete(int position) {
    students.remove(position);
    notifyItemRemoved(position);
    notifyItemChanged(position,students.size());
}


@Override
public int getItemCount() {
    return students.size();
}



public class MyViewHolder extends RecyclerView.ViewHolder {

    TextView sname,phn,gender,total;
    ImageButton imgDetail,btnDel;
    public MyViewHolder(@NonNull View itemView) {
        super(itemView);

        sname=itemView.findViewById(R.id.sname);
        phn=itemView.findViewById(R.id.phn);
        gender=itemView.findViewById(R.id.gender);
        imgDetail=itemView.findViewById(R.id.imgDetail);
        btnDel=itemView.findViewById(R.id.btnDel);
        total=itemView.findViewById(R.id.total);
    }
}

}


MARK_ADAPTER :

public class MarkAdapter extends RecyclerView.Adapter<MarkAdapter.MyViewHolder> {

⎗
✓
Context context;
int resource;
DBHandler db;

ArrayList<MarkEntity>marks;


public MarkAdapter(Context context, int resource, ArrayList<MarkEntity> marks) {
    this.context = context;
    this.resource = resource;
    this.marks = marks;
}

@NonNull
@Override
public MarkAdapter.MyViewHolder onCreateViewHolder(@NonNull ViewGroup parent, int viewType) {
    View view= LayoutInflater.from(context).inflate(resource,parent,false);
    return new MyViewHolder(view);
}

@Override
public void onBindViewHolder(@NonNull MarkAdapter.MyViewHolder holder, int position) {
    MarkEntity m=marks.get(position);
    holder.mark1.setText(String.valueOf(m.getMark1()));
    holder.mark2.setText(String.valueOf(m.getMark2()));
    holder.mark3.setText(String.valueOf(m.getMark3()));
    holder.total.setText(String.valueOf(m.getTotal()));
}

@Override
public int getItemCount() {
    return marks.size();
}

public class MyViewHolder extends RecyclerView.ViewHolder {
    TextView mark1,mark2,mark3,total;
    public MyViewHolder(@NonNull View itemView) {
        super(itemView);
        mark1=itemView.findViewById(R.id.mark1);
        mark2=itemView.findViewById(R.id.mark2);
        mark3=itemView.findViewById(R.id.mark3);
        total=itemView.findViewById(R.id.total);
    }
}

}


Avtivity_addstudent.xml :

<EditText
android:id="@+id/sname"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentStart="true"
android:layout_alignParentTop="true"
android:layout_marginStart="90dp"
android:layout_marginTop="44dp"
android:ems="10"
android:inputType="textPersonName"
android:hint="Enter Name" />

⎗
✓
<EditText
    android:id="@+id/phn"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentTop="true"
    android:layout_centerHorizontal="true"
    android:layout_marginTop="114dp"
    android:ems="10"
    android:hint="Enter Phone Number"
    android:inputType="phone" />

<RadioGroup
    android:layout_width="126dp"
    android:layout_height="175dp"
    android:layout_below="@id/phn"
    android:layout_alignParentStart="true"
    android:layout_alignParentTop="true"
    android:layout_centerHorizontal="true"
    android:layout_marginStart="96dp"
    android:layout_marginTop="180dp">

    <RadioButton
        android:id="@+id/male"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"

        android:checked="true"
        android:text="Male" />


    <RadioButton
        android:id="@+id/female"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"

        android:text="Female" />
</RadioGroup>

<Button
    android:id="@+id/btnAdd"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentStart="true"
    android:layout_alignParentBottom="true"
    android:layout_marginStart="142dp"
    android:layout_marginBottom="181dp"
    android:text="Add" />

ADDSTUDENT :

public class AddStudent extends AppCompatActivity implements View.OnClickListener {

⎗
✓
EditText sname,phn;
RadioButton male,female;
Button btnAdd;

DBHandler db=new DBHandler(this);
String gender,name;
int phone;

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

    sname=findViewById(R.id.sname);
    phn=findViewById(R.id.phn);
    male=findViewById(R.id.male);
    female=findViewById(R.id.female);
    btnAdd=findViewById(R.id.btnAdd);
    btnAdd.setOnClickListener(this);
}

@Override
public void onClick(View view) {
    name=sname.getText().toString();

    if(male.isChecked())
    {
        gender=male.getText().toString();
    }
    else {
        gender=female.getText().toString();
    }
    phone=Integer.parseInt(phn.getText().toString());

    db.addStudent(new StudentEntity(name,gender,phone));

    Intent i=new Intent(this,AddMark.class);
    startActivity(i);
}

}


ACTIVITY_ADDMARK.XML :

<TextView
android:id="@+id/sname"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentStart="true"
android:layout_alignParentTop="true"
android:layout_marginStart="141dp"
android:layout_marginTop="23dp"
android:hint="Enter Student Name" />

⎗
✓
<EditText
    android:id="@+id/mark1"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentTop="true"
    android:layout_centerHorizontal="true"
    android:layout_marginTop="94dp"
    android:ems="10"
    android:inputType="textPersonName"
    android:hint="Enter Mark1" />

<EditText
    android:id="@+id/mark2"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentTop="true"
    android:layout_centerHorizontal="true"
    android:layout_marginTop="171dp"
    android:ems="10"
    android:inputType="textPersonName"
    android:hint="Enter Mark2" />

<EditText
    android:id="@+id/mark3"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentTop="true"
    android:layout_alignParentEnd="true"
    android:layout_marginTop="259dp"
    android:layout_marginEnd="90dp"
    android:ems="10"
    android:inputType="textPersonName"
    android:hint="Enter Mark3" />

<Button
    android:id="@+id/btnMark"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentStart="true"
    android:layout_alignParentBottom="true"
    android:layout_marginStart="139dp"
    android:layout_marginBottom="281dp"
    android:text="Add Mark" />

ADDMARK :

public class AddMark extends AppCompatActivity implements View.OnClickListener {

⎗
✓
EditText mark1,mark2,mark3;
TextView sname;
Button btnMark;
DBHandler db=new DBHandler(this);

Double m1,m2,m3;
String name;
@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_add_mark);

    mark1=findViewById(R.id.mark1);
    mark2=findViewById(R.id.mark2);
    mark3=findViewById(R.id.mark3);
    sname=findViewById(R.id.sname);
    btnMark=findViewById(R.id.btnMark);
    btnMark.setOnClickListener(this);
}

@Override
public void onClick(View view) {

    m1=Double.parseDouble(mark1.getText().toString());
    m2=Double.parseDouble(mark2.getText().toString());
    m3=Double.parseDouble(mark3.getText().toString());
    name=sname.getText().toString();
    db.addMark(new MarkEntity(m1,m2,m3,name));

    Intent i=new Intent(this,home.class);
    startActivity(i);
}

ACTIVITY_HOME.XML :

<Button
android:id="@+id/addS"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentStart="true"
android:layout_alignParentTop="true"
android:layout_marginStart="9dp"
android:layout_marginTop="5dp"
android:text="Add Student" />

⎗
✓
<androidx.recyclerview.widget.RecyclerView
    android:id="@+id/rcv"
    android:layout_width="match_parent"
    android:layout_height="match_parent"

    android:layout_marginTop="70dp" />

<Button
    android:id="@+id/addM"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_alignParentTop="true"
    android:layout_alignParentEnd="true"
    android:layout_marginEnd="25dp"
    android:text="Add Mark" />

MENU->RESOURCE FILE
LOGOUT_MENU.XML :

<?xml version="1.0" encoding="utf-8"?>
<menu xmlns:app="http://schemas.android.com/apk/res-auto"
xmlns:android="http://schemas.android.com/apk/res/android">

⎗
✓
1
2
3
4
<item android:title="Logout"
    app:showAsAction="ifRoom"
    android:id="@+id/menuOut"
  />

HOME(DISPLAY) :

public class home extends AppCompatActivity implements View.OnClickListener {
RecyclerView rcv;
Button addS,addM;

⎗
✓
DBHandler db=new DBHandler(this);
ArrayList<StudentEntity>students=new ArrayList<>();

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

    rcv=findViewById(R.id.rcv);

    students=db.getAllStudent();
    LinearLayoutManager lm=new LinearLayoutManager(this,LinearLayoutManager.VERTICAL,false);
    StudentAdapter adp=new StudentAdapter(this,R.layout.student_row,students);
    rcv.setLayoutManager(lm);
    rcv.setAdapter(adp);


    addS=findViewById(R.id.addS);
    addM=findViewById(R.id.addM);
    addS.setOnClickListener(this);
    addM.setOnClickListener(this);

}

@Override
public void onClick(View view) {
    if(view==addS)
    {
        Intent i=new Intent(this,AddStudent.class);
        startActivity(i);
    }
    else {
        Intent i=new Intent(this,AddMark.class);
        startActivity(i);
    }
}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
    getMenuInflater().inflate(R.menu.logout_menu,menu);
    return true;
}

@Override
public boolean onOptionsItemSelected(@NonNull MenuItem item) {
   if(item.getItemId()==R.id.menuOut)
   {
       AlertDialog.Builder ad=new AlertDialog.Builder(this);
        ad.setMessage("Are You Sure want to logout?");
        ad.setPositiveButton("YES", new DialogInterface.OnClickListener() {
            @Override
            public void onClick(DialogInterface dialogInterface, int i) {
                SharedPreferences sp=getSharedPreferences("sp_name",MODE_PRIVATE);
                SharedPreferences.Editor editor=sp.edit();
                editor.clear();
                editor.apply();
                Intent i1=new Intent(home.this,MainActivity.class);
                startActivity(i1);

            }
        });

        ad.setNegativeButton("NO", new DialogInterface.OnClickListener() {
            @Override
            public void onClick(DialogInterface dialogInterface, int i) {
                dialogInterface.cancel();
            }
        });
       Dialog d=ad.show();
        d.show();
   }
   return super.onOptionsItemSelected(item);
}

}
----------------------------------FINISHH---------

EXTRA:

if (v == btninsert) {
// Inserting Contacts
Log.v("Insert: ", "Inserting ..");
db.addContact(new Contact("Aashka", "9100000000"));
db.addContact(new Contact("Varun", "92111111111"));
db.addContact(new Contact("Karan", "9522222222"));
db.addContact(new Contact("Kartik", "9533333333"));
}


UPDDATE:

void addContact(Contact contact) {
SQLiteDatabase db = this.getWritableDatabase();

⎗
✓
    ContentValues values = new ContentValues();
    values.put(KEY_NAME, contact.get_name()); // Contact Name
    values.put(KEY_PH_NO, contact.get_phone_number()); // Contact Phone

    // Inserting Row
    db.insert(TABLE_CONTACTS, null, values);
    db.close(); // Closing database connection
}

// Getting single contact
Contact getContact(int id) {
    SQLiteDatabase db = this.getReadableDatabase();

    Cursor cursor = db.query(TABLE_CONTACTS, new String[]{KEY_ID,
                    KEY_NAME, KEY_PH_NO}, KEY_ID + "=?",
            new String[]{String.valueOf(id)}, null, null, null, null);
    if (cursor != null)
        cursor.moveToFirst();

    Contact contact = new Contact(Integer.parseInt(cursor.getString(0)),
            cursor.getString(1), cursor.getString(2));
    // return contact
    return contact;
}

// Getting All Contacts
public ArrayList<Contact> getAllContacts() {
    ArrayList<Contact> contactList = new ArrayList<Contact>();
    // Select All Query
    String selectQuery = "SELECT  * FROM " + TABLE_CONTACTS;

    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);

    // looping through all rows and adding to list
    if (cursor.moveToFirst()) {
        do {
            Contact contact = new Contact();
            contact.set_id(Integer.parseInt(cursor.getString(0)));
            contact.set_name(cursor.getString(1));
            contact.set_phone_number(cursor.getString(2));
            // Adding contact to list
            contactList.add(contact);
        } while (cursor.moveToNext());
    }

    // return contact list
    return contactList;
}

// Updating single contact
public void updateContact(Contact contact) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();
    values.put(KEY_NAME, contact.get_name());
    values.put(KEY_PH_NO, contact.get_phone_number());

    // updating row
    db.update(TABLE_CONTACTS, values, KEY_ID + " = ?",
            new String[]{String.valueOf(contact.get_id())});
}

// Deleting single contact
public void deleteContact(Contact contact) {
    SQLiteDatabase db = this.getWritableDatabase();
    db.delete(TABLE_CONTACTS, KEY_ID + " = ?",
            new String[]{String.valueOf(contact.get_id())});
    db.close();
}


// Getting contacts Count
public int getContactsCount() {
    String countQuery = "SELECT * FROM " + TABLE_CONTACTS;
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery(countQuery, null);
    // return count
    return cursor.getCount();

}

Edit

Pub: 28 Apr 2023 04:35 UTC

Views: 133