46. Android Sqlite Database Tutorial 5 - Insert into sqlite table example - Urdu/Hindi

In this video will show you how to insert data into android sqlite database.

it is a complete android sqlite database insert example.

Channel link

Kotlin Tutorials in English from IntelliLogics

Android Tutorials in Urdu from IntelliLogics

Java Tutorials in Pashto from IntelliLogics

find us on facebook

[sirajahmad]

package database;

import
import android.content.Context;
import android.database.Cursor;
import
import

import

import java.util.ArrayList;
import java.util.List;

import model.Student;

public class DBHelper extends SQLiteOpenHelper {

private static final String DATABASE_NAME = "intell.db";
private static final int DATABASE_VERSION = 1;

private static final String KEY_ID = "id";
private static final String KEY_NAME = "name";
private static final String KEY_COURSE = "course";
private static final String KEY_CONTACT = "contact";
private static final String KEY_TOTAL_FEE = "total_fee";
private static final String KEY_FEE_PAID = "fee_paid";

private static final String TABLE_STUDENT="tbl_student";



private static final String CREATE_TABLE_STUDENT = "CREATE TABLE " + TABLE_STUDENT + "("
+ KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+ KEY_NAME + "TEXT NOT NULL, "
+ KEY_COURSE + "TEXT NOT NULL, "
+ KEY_CONTACT + "TEXT NOT NULL, "
+ KEY_TOTAL_FEE + "INTEGER NOT NULL, "
+ KEY_FEE_PAID + "INTEGER NOT NULL)" ;


super(context, DATABASE_NAME, null, DATABASE_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {



}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

db.execSQL("DROP TABLE IF EXISTS " + TABLE_STUDENT);
onCreate(db);

}

public long addStudent(Student student) {

SQLiteDatabase db = getWritableDatabase();

ContentValues values = new ContentValues();
values.put(KEY_NAME, student.getName());
values.put(KEY_COURSE, student.getCourse());
values.put(KEY_CONTACT, student.getContact());
values.put(KEY_TOTAL_FEE, student.getTotalFee());
values.put(KEY_FEE_PAID, student.getFeePaid());


return db.insert(TABLE_STUDENT, null, values);

}

public List<Student> getAllStudents() {


List<Student> studentList=new ArrayList<>();
SQLiteDatabase db = getReadableDatabase();
Cursor cursor= db.rawQuery( "SELECT * from " + TABLE_STUDENT, null);

if(cursor.moveToFirst())
{
do {
int id=cursor.getInt(0);
String name=cursor.getString(1);
String course=cursor.getString(2);
String contact=cursor.getString(3);
int totalFee=cursor.getInt(4);
int feePaid=cursor.getInt(5);

Student student=new Student(id, name, course, contact, totalFee, feePaid);
studentList.add(student);

}while ( cursor.moveToNext());
}


return studentList;

}
}

[daniyalkhan]

AOA Sir! is code me DBhelper class ka object nai bn raha ha.wo activity k pakage me DBHelper pakage create krny ka option da raha haa.pr object nai bna raha please help.

[yasirqayyum]

sir, I have saved the database file on my pc (intell.db) but when I open it in DB browser and go to "browse data" over there shows no tables .. why?
though the app is working completely fine (saved successfully after clicking on the save button) by the way I'm using a real device not genymotion

[vijayshekhawat]

Sir please help me mere sb kuch shi chl rha h pr data base m insertion failed ho rha h

[sirajahmad]

Asalam o Alaikum Abid bhai, ma DBHelper code me send kare de. kindly lag check kai che kam zi ki ghalti da

[sirajahmad]

Asalam o Alaikum Sir
main ne same code same name se ye database bana li hy. lekin record save nahi hota. list view bhi khali nazar ata hy.
jab main save pr click krta hun to Failed ka msg ata hy.
plz help karen..
code ye hy
if ( result != -1 )
{
Toast.makeText(this, "Save Student Record", Toast.LENGTH_SHORT).show();
}
else
{
Toast.makeText(this, "Failed", Toast.LENGTH_SHORT).show();
}
break;

[technicalzameer]

sir men ne sona he k pakistan men MCB bank k debit card se playstore ka account 25$ de sakte hain...kya sir esa he..

[muhammadkashif]

Sir Make Tuts on App Which reject/Busy income call Automatically and send msg to the caller without interaction

[FarhanKhan-wcdv]

when ever i click on button save app is unfortunately stop i followed the same way as you did ???

[nawabrahbar]

How to insert decimal value. I have problem on that