This Android tutorial will teach you how to do basic database functions that are CREATE RETIEVE UPDATE and DELETE and SEARCH using SQLite Database. The INSERT, SELECT, UPDATE and DELETE statements can be used in any database system, because this is support by all relational database systems.due to current techoligal demend we also created an app you friendly.The app is developed steps ahead of the existing world. While app development will be very useful for the future as well.
We will learn how to INSERT, SELECT, UPDATE and DELETE and SEARCH in database by writing code to manage the records table in the database named SliteDb. records table consist of following columns name,course,fee
We made the layout design
activity_main.xml
you have to change the layout as LinearLayout
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 | <?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" android:gravity="center" tools:context=".MainActivity"> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="vertical" android:gravity="center"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Course Registation" android:textColor="@color/colorAccent" android:textSize="30dp" /> </LinearLayout> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal" android:gravity="center"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Name" /> <EditText android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:ems="10" android:id="@+id/name" android:textAlignment="center" /> </LinearLayout> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal" android:gravity="center"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Course" /> <EditText android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:ems="10" android:id="@+id/course" android:textAlignment="center" /> </LinearLayout> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal" android:gravity="center"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Fee" /> <EditText android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:ems="10" android:id="@+id/fee" android:textAlignment="center" /> </LinearLayout> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal" android:gravity="center"> <Button android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:id="@+id/bt1" android:text="Ok" android:background="@color/colorPrimary" /> <Button android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:id="@+id/bt2" android:text="View" android:background="@color/colorAccent" /> </LinearLayout> </LinearLayout> |
Add Records
MainActivity.java
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 | public class MainActivity extends AppCompatActivity { EditText ed1,ed2,ed3; Button b1,b2; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); ed1 = findViewById(R.id.name); ed2 = findViewById(R.id.course); ed3 = findViewById(R.id.fee); b1 = findViewById(R.id.bt1); b2 = findViewById(R.id.bt2); b2.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { Intent i = new Intent(getApplicationContext(),view.class); startActivity(i); } }); b1.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { insert(); } }); } public void insert() { try { String name = ed1.getText().toString(); String course = ed2.getText().toString(); String fee = ed3.getText().toString(); SQLiteDatabase db = openOrCreateDatabase("SliteDb",Context.MODE_PRIVATE,null); db.execSQL("CREATE TABLE IF NOT EXISTS records(id INTEGER PRIMARY KEY AUTOINCREMENT,name VARCHAR,course VARCHAR,fee VARCHAR)"); String sql = "insert into records(name,course,fee)values(?,?,?)"; SQLiteStatement statement = db.compileStatement(sql); statement.bindString(1,name); statement.bindString(2,course); statement.bindString(3,fee); statement.execute(); Toast.makeText(this,"Record addded",Toast.LENGTH_LONG).show(); ed1.setText(""); ed2.setText(""); ed3.setText(""); ed1.requestFocus(); } catch (Exception ex) { Toast.makeText(this,"Record Fail",Toast.LENGTH_LONG).show(); } } } |
View
activity_view.xml
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | <?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".view"> <ListView android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/lst1" /> </LinearLayout> |
Create a Student Class
1 2 3 4 5 6 7 8 9 10 11 | package com.example.kobinath.courseregapp; public class student { String id; String name; String course; String fee; String titles; } |
view.java
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 | package com.example.kobinath.courseregapp; import android.content.Context; import android.content.Intent; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.view.View; import android.widget.AdapterView; import android.widget.ArrayAdapter; import android.widget.ListView; import android.widget.Toast; import java.util.ArrayList; public class view extends AppCompatActivity { ListView lst1; ArrayList<String> titles = new ArrayList<String>(); ArrayAdapter arrayAdapter; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_view); SQLiteDatabase db = openOrCreateDatabase("SliteDb",Context.MODE_PRIVATE,null); lst1 = findViewById(R.id.lst1); final Cursor c = db.rawQuery("select * from records",null); int id = c.getColumnIndex("id"); int name = c.getColumnIndex("name"); int course = c.getColumnIndex("course"); int fee = c.getColumnIndex("fee"); titles.clear(); arrayAdapter = new ArrayAdapter(this,R.layout.support_simple_spinner_dropdown_item,titles); lst1.setAdapter(arrayAdapter); final ArrayList<student> stud = new ArrayList<student>(); if(c.moveToFirst()) { do{ student stu = new student(); stu.id = c.getString(id); stu.name = c.getString(name); stu.course = c.getString(course); stu.fee = c.getString(fee); stud.add(stu); titles.add(c.getString(id) + " \t " + c.getString(name) + " \t " + c.getString(course) + " \t " + c.getString(fee) ); } while(c.moveToNext()); arrayAdapter.notifyDataSetChanged(); lst1.invalidateViews(); } lst1.setOnItemClickListener(new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView<?> parent, View view, int position, long id) { String aa = titles.get(position).toString(); student stu = stud.get(position); Intent i = new Intent(getApplicationContext(),edit.class); i.putExtra("id",stu.id); i.putExtra("name",stu.name); i.putExtra("course",stu.course); i.putExtra("fee",stu.fee); startActivity(i); } }); } } |
Edit and Delete
activity_edit.xml
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 | <?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" tools:context=".edit" android:orientation="vertical" android:gravity="center" > <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="vertical" android:gravity="center"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Course Registation" android:textColor="@color/colorAccent" android:textSize="30dp" /> </LinearLayout> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal" android:gravity="center"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="ID" /> <EditText android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:ems="10" android:id="@+id/id" android:textAlignment="center" /> </LinearLayout> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal" android:gravity="center"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Name" /> <EditText android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:ems="10" android:id="@+id/name" android:textAlignment="center" /> </LinearLayout> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal" android:gravity="center"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Course" /> <EditText android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:ems="10" android:id="@+id/course" android:textAlignment="center" /> </LinearLayout> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal" android:gravity="center"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Fee" /> <EditText android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:ems="10" android:id="@+id/fee" android:textAlignment="center" /> </LinearLayout> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal" android:gravity="center"> <Button android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:id="@+id/bt1" android:text="Edit" android:background="@color/colorPrimary" /> <Button android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:id="@+id/bt2" android:text="Delete" android:background="@color/colorAccent" /> <Button android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:id="@+id/bt3" android:text="Back" android:background="@color/colorPrimaryDark" /> </LinearLayout> </LinearLayout> |
edit.java
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 | public class edit extends AppCompatActivity { EditText ed1,ed2,ed3,ed4; Button b1,b2,b3; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_edit); ed1 = findViewById(R.id.name); ed2 = findViewById(R.id.course); ed3 = findViewById(R.id.fee); ed4 = findViewById(R.id.id); b1 = findViewById(R.id.bt1); b2 = findViewById(R.id.bt2); b3 = findViewById(R.id.bt3); Intent i = getIntent(); String t1 = i.getStringExtra("id").toString(); String t2 = i.getStringExtra("name").toString(); String t3 = i.getStringExtra("course").toString(); String t4 = i.getStringExtra("fee").toString(); ed4.setText(t1); ed1.setText(t2); ed2.setText(t3); ed3.setText(t4); b2.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { Delete(); } }); b3.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { Intent i = new Intent(getApplicationContext(),view.class); startActivity(i); } }); b1.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { Edit(); } }); } public void Delete() { try { String id = ed4.getText().toString(); SQLiteDatabase db = openOrCreateDatabase("SliteDb",Context.MODE_PRIVATE,null); String sql = "delete from records where id = ?"; SQLiteStatement statement = db.compileStatement(sql); statement.bindString(1,id); statement.execute(); Toast.makeText(this,"Record Deleted",Toast.LENGTH_LONG).show(); ed1.setText(""); ed2.setText(""); ed3.setText(""); ed1.requestFocus(); } catch (Exception ex) { Toast.makeText(this,"Record Fail",Toast.LENGTH_LONG).show(); } } public void Edit() { try { String name = ed1.getText().toString(); String course = ed2.getText().toString(); String fee = ed3.getText().toString(); String id = ed4.getText().toString(); SQLiteDatabase db = openOrCreateDatabase("SliteDb",Context.MODE_PRIVATE,null); String sql = "update records set name = ?,course=?,fee=? where id= ?"; SQLiteStatement statement = db.compileStatement(sql); statement.bindString(1,name); statement.bindString(2,course); statement.bindString(3,fee); statement.bindString(4,id); statement.execute(); Toast.makeText(this,"Record Updateddd",Toast.LENGTH_LONG).show(); ed1.setText(""); ed2.setText(""); ed3.setText(""); ed1.requestFocus(); } catch (Exception ex) { Toast.makeText(this,"Record Fail",Toast.LENGTH_LONG).show(); } } } |
I have attached the video tutorial below it will help you to do this step by step.
