@Override protected void onCreate(Bundle savedInstanceState) { MyHelper.writeMsg(CLASS_NAME + "-->onCreate is called"); super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); // Call this to test the MIME type // MyHelper.testMimeType(this); // Call this to create student record. Helper class cane handle 10 records // Refer the method description in helper class for more details // Please note this should not be done on UI thread but this is testing after all!! /* MarksHelper[] marksHelper; List<MarksHelper> lMarksHelper = new ArrayList<MarksHelper>(); marksHelper = MyHelper.insertStudent(this, 1); lMarksHelper = retriwveData(lMarksHelper, marksHelper); marksHelper = MyHelper.insertStudent(this,2); lMarksHelper = retriwveData(lMarksHelper, marksHelper); marksHelper = MyHelper.insertStudent(this,3); lMarksHelper = retriwveData(lMarksHelper, marksHelper); marksHelper = MyHelper.insertStudent(this,4); lMarksHelper = retriwveData(lMarksHelper, marksHelper); marksHelper = MyHelper.insertStudent(this,5); lMarksHelper = retriwveData(lMarksHelper, marksHelper); marksHelper = MyHelper.insertStudent(this,6); lMarksHelper = retriwveData(lMarksHelper, marksHelper); marksHelper = MyHelper.insertStudent(this,7); lMarksHelper = retriwveData(lMarksHelper, marksHelper); marksHelper = MyHelper.insertStudent(this,8); lMarksHelper = retriwveData(lMarksHelper, marksHelper); marksHelper = MyHelper.insertStudent(this,9); lMarksHelper = retriwveData(lMarksHelper, marksHelper); //Now pass the list and create the mark records MyHelper.insertMarks(this,lMarksHelper); */ // Call this with id to delete the record from Student // MyHelper.deleteStudent(this,1); // Call this with id to delete the record from Marks // MyHelper.deleteMark(this,1); // call the student update query MyHelper.updateStudent(this, "Robert", 7); // call the mark update query MyHelper.updateMark(this, 6, 88); // call the select query MyHelper.selectQuery(this); }