Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.execute()

709
710
711
712
713
714
715
716
717
718
719
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM residence_functions WHERE id=? AND type=?");
      statement.setInt(1, getId());
      statement.setInt(2, type);
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("Exception: removeFunctions(int type): " + e);
    }
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE clanhall SET ownerId=?, lease=?, inDebt=0 WHERE id=?");
      statement.setInt(1, getOwnerId());
      statement.setLong(2, getLease());
      statement.setInt(3, getId());
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE clan_data SET hasHideout=0 WHERE hasHideout=?");
      statement.setInt(1, getId());
      statement.execute();
      DatabaseUtils.closeStatement(statement);
View Full Code Here
243
244
245
246
247
248
249
250
251
252
253
      statement.setInt(3, getId());
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE clan_data SET hasHideout=0 WHERE hasHideout=?");
      statement.setInt(1, getId());
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE clan_data SET hasHideout=? WHERE clan_id=?");
      statement.setInt(1, getId());
      statement.setInt(2, getOwnerId());
      statement.execute();
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE forts SET siegeDate = ? WHERE id = ?");
      statement.setLong(1, _siege.getSiegeDate().getTimeInMillis() / 1000);
      statement.setInt(2, _siege.getSiegeUnit().getId());
      statement.execute();
      ((Fortress) _siege.getSiegeUnit()).setSiegeDate((int) (_siege.getSiegeDate().getTimeInMillis() / 1000));
    }
    catch(Exception e)
    {
      System.out.println("Exception: saveSiegeDate(): " + e.getMessage());
View Full Code Here
248
249
250
251
252
253
254
255
256
257
258
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE clan_data SET hasHideout=? WHERE clan_id=?");
      statement.setInt(1, getId());
      statement.setInt(2, getOwnerId());
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM residence_functions WHERE id=?");
      statement.setInt(1, getId());
      statement.execute();
      DatabaseUtils.closeStatement(statement);
View Full Code Here
252
253
254
255
256
257
258
259
260
261
262
      statement.setInt(2, getOwnerId());
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM residence_functions WHERE id=?");
      statement.setInt(1, getId());
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      // Announce to clan memebers
      if(clan != null)
      {
        clan.setHasHideout(getId()); // Set has hideout flag for new owner
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE forts SET lastSiegeDate = ? WHERE id = ?");
      statement.setLong(1, _siege.getSiegeUnit().getLastSiegeDate());
      statement.setInt(2, _siege.getSiegeUnit().getId());
      statement.execute();
    }
    catch(Exception e)
    {
      System.out.println("Exception: saveSiegeDate(): " + e.getMessage());
      e.printStackTrace();
View Full Code Here
273
274
275
276
277
278
279
280
281
282
283
        statement.setString(4, "NPC Clan");
        statement.setString(5, getName());
        statement.setLong(6, getPrice());
        statement.setLong(7, 0);
        statement.setLong(8, endDate.getTimeInMillis());
        statement.execute();
        DatabaseUtils.closeStatement(statement);
        //выставляем сразу на аукцион
        AuctionManager.getInstance().getAuctions().add(new Auction(getId()));
      }
    }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("REPLACE INTO siege_territory_members (obj_Id, side, type) VALUES (?, ?, ?)");
      statement.setInt(1, obj_Id);
      statement.setInt(2, side);
      statement.setInt(3, type);
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("Exception: saveSiegeMember: " + e);
      e.printStackTrace();
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM siege_territory_members");
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("Exception: clearSiegeMembers(): " + e);
      e.printStackTrace();
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.