Changes

Jump to: navigation, search

Teams Winter 2011/team1/BlackBerry/Use SQLite

662 bytes added, 23:50, 11 April 2011
11.6 Create SQLiteManager Class
Now we need a class that will be the only class interacting with our database. It will take a Database object and a URI object to open database in the constructor. It will have methods to perform all the queries we need and at the end of each query will close the database. <br/>
So, create a class called: SQLiteManager, with 2 private fields :<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;}</source>
11.6.1 Open Database<br/>
11.6.2 Close Database<br/>
1
edit

Navigation menu