Package net.rim.device.api.database

Examples of net.rim.device.api.database.Statement.bind()

64
65
66
67
68
69
70
71
72
73
74
        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
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
            // 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);
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
        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();
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
            // 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();
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
            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
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
                    _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();
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
        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();
View Full Code Here
153
154
155
156
157
158
159
160
161
162
163
            // 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) {
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
            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
155
156
157
158
159
160
161
162
163
164
165
                    _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
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.