Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.executeQuery()

35
36
37
38
39
40
41
42
43
44
45
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT obj_Id, side, type FROM siege_territory_members");
      rset = statement.executeQuery();
      while(rset.next())
      {
        if(rset.getInt("type") == 0)
        {
          TerritorySiege.getPlayers().put(rset.getInt("obj_Id"), rset.getInt("side"));
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT * FROM `forts` WHERE `id` = ?");
      statement.setInt(1, _id);
      rs = statement.executeQuery();
      while(rs.next())
      {
        _name = rs.getString("name");
        _siegeDate = rs.getInt("siegeDate");
        _lastSiegeDate = rs.getInt("lastSiegeDate");
View Full Code Here
205
206
207
208
209
210
211
212
213
214
215
        }
      }
      DatabaseUtils.closeDatabaseSR(statement, rs);
      statement = con.prepareStatement("SELECT `clan_id` FROM `clan_data` WHERE hasFortress = ?");
      statement.setInt(1, _id);
      rs = statement.executeQuery();
      while(rs.next())
      {
        _ownerId = rs.getInt("clan_id");
      }
      _zone = ZoneManager.getInstance().getZoneByIndex(ZoneType.Fortress, getId(), true);
View Full Code Here
268
269
270
271
272
273
274
275
276
277
278
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT * FROM items WHERE object_id=? AND loc=? LIMIT 1");
      statement.setLong(1, objectId);
      statement.setString(2, loc.name());
      item_rset = statement.executeQuery();
      if(item_rset.next())
      {
        L2Item item = ItemTable.getInstance().getTemplate(item_rset.getInt("item_id"));
        if(item == null)
        {
View Full Code Here
310
311
312
313
314
315
316
317
318
319
320
    FiltredPreparedStatement statement = null;
    try
    {
      statement = con.prepareStatement("SELECT elemType,elemValue FROM item_attributes WHERE itemId=? LIMIT 1");
      statement.setInt(1, getObjectId());
      ResultSet rs = statement.executeQuery();
      rs = statement.executeQuery();
      if(rs.next())
      {
        byte elem_type = rs.getByte(1);
        int elem_value = rs.getInt(2);
View Full Code Here
311
312
313
314
315
316
317
318
319
320
321
    try
    {
      statement = con.prepareStatement("SELECT elemType,elemValue FROM item_attributes WHERE itemId=? LIMIT 1");
      statement.setInt(1, getObjectId());
      ResultSet rs = statement.executeQuery();
      rs = statement.executeQuery();
      if(rs.next())
      {
        byte elem_type = rs.getByte(1);
        int elem_value = rs.getInt(2);
        if(getItem().getItemType() instanceof WeaponType)
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement(Olympiad.OLYMPIAD_LOAD_NOBLES);
      rset = statement.executeQuery();
      while(rset.next())
      {
        int classId = rset.getInt(Olympiad.CLASS_ID);
        if(classId < 88) // Если это не 3-я профа, то исправляем со 2-й на 3-ю.
        {
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement(Olympiad.GET_ALL_CLASSIFIED_NOBLESS);
      rset = statement.executeQuery();
      int place = 1;
      while(rset.next())
      {
        tmpPlace.put(rset.getInt(Olympiad.CHAR_ID), place++);
      }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement2 = con.prepareStatement("SELECT object_id,item_id,loc_data,enchant_level FROM items WHERE owner_id=? AND loc='PAPERDOLL'");
      statement2.setInt(1, objectId);
      invdata = statement2.executeQuery();
      while(invdata.next())
      {
        int slot = invdata.getInt("loc_data");
        paperdoll[slot][0] = invdata.getInt("object_id");
        paperdoll[slot][1] = invdata.getInt("item_id");
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement(classId == 132 ? Olympiad.GET_EACH_CLASS_LEADER_SOULHOUND : Olympiad.GET_EACH_CLASS_LEADER);
      statement.setInt(1, classId);
      rset = statement.executeQuery();
      while(rset.next())
      {
        names.add(rset.getString(Olympiad.CHAR_NAME));
      }
      return names;
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.