Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.execute()

291
292
293
294
295
296
297
298
299
300
301
      statement.setInt(1, clanId);
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM clan_privs WHERE clan_id=?");
      statement.setInt(1, clanId);
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM clan_skills WHERE clan_id=?");
      statement.setInt(1, clanId);
      statement.execute();
    }
View Full Code Here
295
296
297
298
299
300
301
302
303
304
305
      statement.setInt(1, clanId);
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM clan_skills WHERE clan_id=?");
      statement.setInt(1, clanId);
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("could not dissolve clan:" + e);
    }
View Full Code Here
350
351
352
353
354
355
356
357
358
359
360
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE clan_data SET ally_id=0 WHERE ally_id=?");
      statement.setInt(1, allyId);
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM ally_data WHERE ally_id=?");
      statement.setInt(1, allyId);
      statement.execute();
    }
View Full Code Here
354
355
356
357
358
359
360
361
362
363
364
      statement.setInt(1, allyId);
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM ally_data WHERE ally_id=?");
      statement.setInt(1, allyId);
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("could not dissolve clan:" + e);
    }
View Full Code Here
381
382
383
384
385
386
387
388
389
390
391
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("REPLACE INTO clan_wars (clan1, clan2) VALUES(?,?)");
      statement.setInt(1, clan1.getClanId());
      statement.setInt(2, clan2.getClanId());
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("could not store clan war data:" + e);
    }
View Full Code Here
410
411
412
413
414
415
416
417
418
419
420
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM clan_wars WHERE clan1=? AND clan2=?");
      statement.setInt(1, clan1.getClanId());
      statement.setInt(2, clan2.getClanId());
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("could not delete war data:" + e);
    }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
      String value = getVars().getString(name, "");
      if(value.isEmpty())
      {
        statement = con.prepareStatement("DELETE FROM server_variables WHERE name = ?");
        statement.setString(1, name);
        statement.execute();
      }
      else
      {
        statement = con.prepareStatement("REPLACE INTO server_variables (name, value) VALUES (?,?)");
        statement.setString(1, name);
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
      else
      {
        statement = con.prepareStatement("REPLACE INTO server_variables (name, value) VALUES (?,?)");
        statement.setString(1, name);
        statement.setString(2, value);
        statement.execute();
      }
    }
    catch(Exception e)
    {
    }
View Full Code Here
5249
5250
5251
5252
5253
5254
5255
5256
5257
5258
5259
      {
        statement = con.prepareStatement("DELETE FROM character_skills WHERE skill_id=? AND char_obj_id=? AND class_index=?");
        statement.setInt(1, oldSkill.getId());
        statement.setInt(2, getObjectId());
        statement.setInt(3, getActiveClassId());
        statement.execute();
      }
    }
    catch(final Exception e)
    {
      _log.log(Level.WARNING, "Error could not delete Skill:", e);
View Full Code Here
5284
5285
5286
5287
5288
5289
5290
5291
5292
5293
5294
      statement.setInt(1, getObjectId());
      statement.setInt(2, newSkill.getId());
      statement.setInt(3, newSkill.getLevel());
      statement.setString(4, newSkill.getName());
      statement.setInt(5, getActiveClassId());
      statement.execute();
    }
    catch(final Exception e)
    {
      _log.log(Level.WARNING, "Error could not store Skills:", e);
    }
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.