In my first run, I created 3 record and that worked nice!
But when I thought to add a new record and wanted all the 4(3+1) record to be Toasted, it only Toast the 3 past records!
public class MainActivity extends AppCompatActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
try {
SQLiteDatabase sqLiteDatabase = this.openOrCreateDatabase("Database", MODE_PRIVATE, null);
sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS database(name VARCHAR,age INT(3))");
sqLiteDatabase.execSQL("INSERT INTO database(name,age) VALUES('ARGHA',20)");
sqLiteDatabase.execSQL("INSERT INTO database(name,age) VALUES('CHANDRA',21)");
sqLiteDatabase.execSQL("INSERT INTO database(name,age) VALUES('DHAR',22)");
sqLiteDatabase.execSQL("INSERT INTO database(name,age) VALUES('AMIT',26)");
Cursor cursor = sqLiteDatabase.rawQuery("SELECT * FROM database", null);
cursor.moveToFirst();
int nameIndex = cursor.getColumnIndex("name");
int ageIndex = cursor.getColumnIndex("age");
while (cursor != null) {
Toast.makeText(this, cursor.getString(nameIndex) + ":" + Integer.toString(cursor.getInt(ageIndex)), Toast.LENGTH_SHORT).show();
cursor.moveToNext();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}