We would like to create a database file including out our Student Entity, so that we can put it in the project. Then every time the app runs, first it checks if it is the first time run of the app on the device or simulator. If so, the app will copy the file in to the SDCard. Next time that you run the application, it will know that the file is there, so will not override it. <Br/>

// here goes notice that the rest of way we are callling the StudentList constructor codeis now different. // Later on you will see that we should modify that class:

So, create a class called: SQLiteManager, with 2 private fields, and a constructor that sets them and then tries to open database:<source lang="java"> package cs.ecl.team1.project;   import java.util.Vector;import net.rim.device.api.database.Cursor;import net.rim.device.api.database.DataTypeException;import net.rim.device.api.database.Database;import net.rim.device.api.database.DatabaseException;import net.rim.device.api.database.DatabaseFactory;import net.rim.device.api.database.Row;import net.rim.device.api.database.Statement;import net.rim.device.api.io.URI;import net.rim.device.api.ui.UiApplication;import net.rim.device.api.ui.component.Dialog; public class SQLManager { private static Database db; private URI uri;  public SQLManager(Database db, URI uri) { this.uri = uri; this.db = db; openDB(); } }</source>'''11.6.1 Open Database'''<br/>Then we implement the openDB() method:<source lang="java"> void openDB() { try { this.db = DatabaseFactory.open(uri); } catch(DatabaseException dbe) { errorDialog(dbe.toString()); } } </source>'''11.6.2 Close Database'''<br/>Then we definitely need a closeDB() method to use later:<source lang="java"> static void closeDB() { try { db.close(); } catch(DatabaseException dbe) { errorDialog(dbe.toString()); } } </source>And as you noticed above, we are going to need a method called errorDialog():<source lang="java"> public static void errorDialog(final String message) { UiApplication.getUiApplication().invokeLater(new Runnable() { public void run() { Dialog.alert(message); } }); }</source>'''11.6.3 Select All StudentsInsert New Student'''<br/>The first query we need is a query that enables us add a new Student, so we need to implement a method for that:<source lang="java"> //ADD STUDENT Student addStudent(String fName, String lName, String email, String address){ Student student = null; try { Statement statement = db.createStatement("INSERT INTO Student VALUES(NULL,?,?,?,?)"); statement.prepare(); statement.bind(1,fName); statement.bind(2, lName); statement.bind(3, email); statement.bind(4, address); statement.execute(); statement.close(); statement = db.createStatement("SELECT id FROM Student WHERE firstName = ? AND lastName = ?"); statement.prepare(); statement.bind(1, fName); statement.bind(2, lName); Cursor cursor = statement.getCursor(); if(cursor.next()) { Row row = cursor.getRow(); int id = row.getInteger(0); student = new Student(id, fName, lName, email, address); } cursor.close(); statement.close(); }catch(DatabaseException dbe) { errorDialog(dbe.toString()); } catch(DataTypeException dte) { errorDialog(dte.toString()); } return student; }</source> '''11.6.4 Insert New Delete Student'''<br/>Then add a method to delete student by id: <source lang="java"> // DELETE STUDENT void deleteStudent(int id) { try { Statement statement = db.createStatement("DELETE FROM Student WHERE id = ?"); statement.prepare(); statement.bind(1, id); statement.execute(); statement.close(); } catch(DatabaseException dbe) { errorDialog(dbe.toString()); } } </source>'''11.6.5 Delete Update Student'''<br/>And a method to update Student:<source lang="java"> //UPDATE STUDENT void updateStudent(int id, String fName, String lName, String email, String address) { try { Statement statement = db.createStatement("UPDATE Student SET firstName = ?, lastName= ?, email = ?, address = ? WHERE id = ?"); statement.prepare(); statement.bind(1, fName); statement.bind(2, lName); statement.bind(3, email); statement.bind(4, address); statement.bind(5, id); statement.execute(); statement.close(); } catch(DatabaseException dbe) { errorDialog(dbe.toString()); } } </source> '''11.6.6 Update Select All Students'''<br/>And obviously we will need a method that gets all the students from database and returns a vector of Student, so that we can populate our student list:<source lang="java"> Vector getStudents(){ Vector students= new Vector(); try { Statement statement = db.createStatement("SELECT * FROM Student"); statement.prepare(); Cursor cursor = statement.getCursor(); // Iterate through the the result set. For each row, add a // new DirectoryItem object to the vector. while(cursor.next()) { Row row = cursor.getRow(); int id = row.getInteger(0); String fName = row.getString(1); String lName = row.getString(2); String email = row.getString(3); String address = row.getString(4); Student student = new Student(id, fName, lName, email, address); students.addElement(student); } statement.close(); cursor.close(); } catch(DatabaseException dbe) { errorDialog(dbe.toString()); } catch(DataTypeException dte) { errorDialog(dte.toString()); } return students; }<br/source>

So far the StudentList class we have, consumes a vector to store students whiche are note preserved. We will modify the methods of this list to use the SQLiteManager and preserve the objects.<br/>Add the following private fields to the StudentList Class:<source lang="java"> private Database db ; private URI uri;</source>Then modify its constructor to take and set thode fields:<source lang="java">public StudentList(Database db, URI uri) throws Exception { super(new StudentListComparator()); this.db = db; this.uri = uri; SQLManager sqlManager = new SQLManager(db, uri); loadFrom(sqlManager.getStudents().elements()); SQLManager.closeDB(); } </source> '''11.7.1 Load list'''<br/>As noticed above, the constructor then passes those objects to a new SQLiteManager object and gets students from the manager to load the list with. Then it closes the database.<br/> '''11.7.2 Add Student'''<br/>Now modify the addElement method:<source lang="java">/** * Adds a new element to the list. * @param element The element to be added. */ void addElement(Object element) { Student student = (Student) element; SQLManager sqlManager = new SQLManager(db, uri); sqlManager.addStudent(student.getFirstname(), student.getLastName(), student.getEmail(), student.getAddress()); doAdd(element); SQLManager.closeDB(); } </source>'''11.7.3 Edit Student'''<br/>And editElement method:<source lang="java">// added for Update: void updateElement(Object oldElement, Object newElement){ Student student = (Student) newElement; SQLManager sqlManager = new SQLManager(db, uri); sqlManager.updateStudent(student.getId(), student.getFirstname(), student.getLastName(), student.getEmail(), student.getAddress()); doUpdate(oldElement,newElement); SQLManager.closeDB(); }  </source>'''11.7.4 Delete Student'''<br/><source lang="java">/** * Removes element from the list * @param element */ void deleteElement(Object element) { Student student = (Student)element; SQLManager sqlManager = new SQLManager(db, uri); sqlManager.deleteStudent(student.getId()); doRemove(element); SQLManager.closeDB(); } </source>

===11.8 Run Student View Application in Action===Now if you run the application, you will get the same functionality as before, but this time data is saved. Don't forget to add SDCard to simulator before running it.