Package net.rim.device.api.database

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

65
66
67
68
69
70
71
72
73
74
75
            // 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.
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
            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) {
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
            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
178
179
180
181
182
183
184
185
186
187
188
            // 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 =
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
            // 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
207
208
209
210
211
212
213
214
215
216
217
            // 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
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.