Package l2p.database

Examples of l2p.database.ThreadConnection.prepareStatement()

262
263
264
265
266
267
268
269
270
271
272
                                        subStatement = con.prepareStatement("UPDATE characters SET clanid=0 WHERE clanid=?;");
                                        subStatement.setString(1, rset.getString("clanid"));
                                        subStatement.executeUpdate();
                                        DatabaseUtils.closeStatement(subStatement);
                                        // Delete Clan
                                        subStatement = con.prepareStatement("DELETE FROM clan_data WHERE clan_id=?;");
                                        subStatement.setString(1, rset.getString("clanid"));
                                        subStatement.executeUpdate();
                                        DatabaseUtils.closeStatement(subStatement);
                                }
                                // skills
View Full Code Here
268
269
270
271
272
273
274
275
276
277
278
                                        subStatement.setString(1, rset.getString("clanid"));
                                        subStatement.executeUpdate();
                                        DatabaseUtils.closeStatement(subStatement);
                                }
                                // skills
                                subStatement = con.prepareStatement("DELETE FROM character_skills WHERE char_obj_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // shortcuts
                                subStatement = con.prepareStatement("DELETE FROM character_shortcuts WHERE char_obj_id=?;");
View Full Code Here
273
274
275
276
277
278
279
280
281
282
283
                                subStatement = con.prepareStatement("DELETE FROM character_skills WHERE char_obj_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // shortcuts
                                subStatement = con.prepareStatement("DELETE FROM character_shortcuts WHERE char_obj_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // items
                                subStatement = con.prepareStatement("DELETE FROM items WHERE owner_id=?;");
View Full Code Here
278
279
280
281
282
283
284
285
286
287
288
                                subStatement = con.prepareStatement("DELETE FROM character_shortcuts WHERE char_obj_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // items
                                subStatement = con.prepareStatement("DELETE FROM items WHERE owner_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // recipebook
                                subStatement = con.prepareStatement("DELETE FROM character_recipebook WHERE char_id=?;");
View Full Code Here
283
284
285
286
287
288
289
290
291
292
293
                                subStatement = con.prepareStatement("DELETE FROM items WHERE owner_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // recipebook
                                subStatement = con.prepareStatement("DELETE FROM character_recipebook WHERE char_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // quests
                                subStatement = con.prepareStatement("DELETE FROM character_quests WHERE char_id=?;");
View Full Code Here
288
289
290
291
292
293
294
295
296
297
298
                                subStatement = con.prepareStatement("DELETE FROM character_recipebook WHERE char_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // quests
                                subStatement = con.prepareStatement("DELETE FROM character_quests WHERE char_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // macroses
                                subStatement = con.prepareStatement("DELETE FROM character_macroses WHERE char_obj_id=?;");
View Full Code Here
293
294
295
296
297
298
299
300
301
302
303
                                subStatement = con.prepareStatement("DELETE FROM character_quests WHERE char_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // macroses
                                subStatement = con.prepareStatement("DELETE FROM character_macroses WHERE char_obj_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // friends
                                subStatement = con.prepareStatement("DELETE FROM character_friends WHERE char_id=? or friend_id = ?;");
View Full Code Here
298
299
300
301
302
303
304
305
306
307
308
                                subStatement = con.prepareStatement("DELETE FROM character_macroses WHERE char_obj_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // friends
                                subStatement = con.prepareStatement("DELETE FROM character_friends WHERE char_id=? or friend_id = ?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.setString(2, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // boxaccess
View Full Code Here
304
305
306
307
308
309
310
311
312
313
314
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.setString(2, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // boxaccess
                                subStatement = con.prepareStatement("DELETE FROM boxaccess WHERE charname=?;");
                                subStatement.setString(1, rset.getString("char_name"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // characters
                                subStatement = con.prepareStatement("DELETE FROM characters WHERE obj_Id=?;");
View Full Code Here
309
310
311
312
313
314
315
316
317
318
319
                                subStatement = con.prepareStatement("DELETE FROM boxaccess WHERE charname=?;");
                                subStatement.setString(1, rset.getString("char_name"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // characters
                                subStatement = con.prepareStatement("DELETE FROM characters WHERE obj_Id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                        }
                        DatabaseUtils.closeDatabaseSR(statement, rset);
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.