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);
// }
| 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">
| <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---------
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();
}
|