Package net.rim.device.api.database

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

63
64
65
66
67
68
69
70
71
72
73
        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
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
            // 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);
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
        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();
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
            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();
View Full Code Here
176
177
178
179
180
181
182
183
184
185
186
        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
View Full Code Here
185
186
187
188
189
190
191
192
193
194
195
            // 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
205
206
207
208
209
210
211
212
213
214
215
    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
227
228
229
230
231
232
233
234
235
236
237
        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;
View Full Code Here
269
270
271
272
273
274
275
276
277
278
279
        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()) {
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.