Examples of net.rim.device.api.database.Statement

net.rim.device.api.database.Statement

     */
    Category addCategory(final String name) {
        Category category = null;
        try {
            // INSERT a row into the Category table for the new category
            Statement statement =
                    _db.createStatement("INSERT INTO Category VALUES(null, ?)");
            statement.prepare();
            statement.bind(1, name);
            statement.execute();
            statement.close();


            // Query the database for the auto-generated ID of the category just
            // added
            // and create a new Category object.
            statement =
                    _db.createStatement("SELECT category_id FROM Category WHERE category_name = ?");
            statement.prepare();
            statement.bind(1, name);
            final Cursor cursor = statement.getCursor();
            if (cursor.next()) {
                final Row row = cursor.getRow();
                final int id = row.getInteger(0);
                category = new Category(id, name);
            }
            cursor.close();
            statement.close();
        } catch (final DatabaseException dbe) {
            SQLiteDemo.errorDialog(dbe.toString());
        } catch (final DataTypeException dte) {
            SQLiteDemo.errorDialog(dte.toString());
        }

View Full Code Here

            final int categoryID) {
        long id = -1;


        try {
            // Insert a new record in the DirectoryItems table
            final Statement statement =
                    _db.createStatement("INSERT INTO DirectoryItems VALUES(null, ?, ?, ?, ?)");
            statement.prepare();
            statement.bind(1, categoryID);
            statement.bind(2, name);
            statement.bind(3, location);
            statement.bind(4, phone);
            statement.execute();
            statement.close();


            // Retrieve the auto-generated ID of the item just added
            id = _db.lastInsertedRowID();
        } catch (final DatabaseException dbe) {
            SQLiteDemo.errorDialog(dbe.toString());

View Full Code Here

     */
    void updateItem(final int id, final String name, final String location,
            final String phone) {
        try {
            // Update the record in the DirectoryItems table for the given id
            final Statement statement =
                    _db.createStatement("UPDATE DirectoryItems SET item_name = ?, location = ?, phone = ? WHERE id = ?");
            statement.prepare();
            statement.bind(1, name);
            statement.bind(2, location);
            statement.bind(3, phone);
            statement.bind(4, id);
            statement.execute();
            statement.close();
        } catch (final DatabaseException dbe) {
            SQLiteDemo.errorDialog(dbe.toString());
        }
    }

View Full Code Here

     */
    void deleteCategory(final int id) {
        try {
            // Delete all items in the DirectoryItems database
            // table belonging to the highlighted category.
            Statement statement =
                    _db.createStatement("DELETE FROM DirectoryItems WHERE category_id = ?");
            statement.prepare();
            statement.bind(1, id);
            statement.execute();
            statement.close();


            // Delete the record in the Category database table
            // corresponding to the highlighted category.
            statement =
                    _db.createStatement("DELETE FROM Category WHERE category_id = ?");
            statement.prepare();
            statement.bind(1, id);
            statement.execute();
            statement.close();
        } catch (final DatabaseException dbe) {
            SQLiteDemo.errorDialog(dbe.toString());
        }
    }

View Full Code Here

     *            The id of the directory item to delete
     */
    void deleteItem(final int id) {
        try {
            // Delete the record in the DirectoryItems table for the given id
            final Statement statement =
                    _db.createStatement("DELETE FROM DirectoryItems WHERE id = ?");
            statement.prepare();
            statement.bind(1, id);
            statement.execute();
            statement.close();
        } catch (final DatabaseException dbe) {
            SQLiteDemo.errorDialog(dbe.toString());
        }
    }

View Full Code Here

     */
    IntHashtable getCategories() {
        final IntHashtable categories = new IntHashtable();
        try {
            // Read in all records from the Category table
            final Statement statement =
                    _db.createStatement("SELECT * FROM Category");
            statement.prepare();
            final Cursor cursor = statement.getCursor();


            Row row;
            int id;
            String name;
            Category category;


            // Iterate through the result set. For each row, create a new
            // Category object and add it to the hash table.
            while (cursor.next()) {
                row = cursor.getRow();
                id = row.getInteger(0);
                name = row.getString(1);
                category = new Category(id, name);
                categories.put(id, category);
            }
            statement.close();
            cursor.close();
        } catch (final DatabaseException dbe) {
            SQLiteDemo.errorDialog(dbe.toString());
        } catch (final DataTypeException dte) {
            SQLiteDemo.errorDialog(dte.toString());

View Full Code Here

    Vector getItems() {
        final Vector directoryItems = new Vector();


        try {
            // Read in all records from the DirectoryItems table
            final Statement statement =
                    _db.createStatement("SELECT * FROM DirectoryItems");
            statement.prepare();
            final Cursor cursor = statement.getCursor();


            // Iterate through the the result set. For each row, add a
            // new DirectoryItem object to the vector.
            while (cursor.next()) {
                final Row row = cursor.getRow();


                final int id = row.getInteger(0);
                final int categoryId = row.getInteger(1);
                final String name = row.getString(2);
                final String location = row.getString(3);
                final String phone = row.getString(4);


                final DirectoryItem item =
                        new DirectoryItem(id, name, location, phone, categoryId);
                directoryItems.addElement(item);
            }
            statement.close();
            cursor.close();
        } catch (final DatabaseException dbe) {
            SQLiteDemo.errorDialog(dbe.toString());
        } catch (final DataTypeException dte) {
            SQLiteDemo.errorDialog(dte.toString());

View Full Code Here

TOP

Related Classes of net.rim.device.api.database.Statement

com.rim.samples.device.sqlitedemo.SQLManager

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.