Package l2p.database

Examples of l2p.database.ThreadConnection.prepareStatement()

706
707
708
709
710
711
712
713
714
715
716
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      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)
View Full Code Here
684
685
686
687
688
689
690
691
692
693
694
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      if(_enchantAttributeElement != L2Item.ATTRIBUTE_NONE)
      {
        statement = con.prepareStatement("UPDATE item_attributes SET augAttributes = -1, augSkillId = -1, augSkillLevel = -1 WHERE itemId = ? LIMIT 1");
      }
      else
      {
        statement = con.prepareStatement("DELETE FROM item_attributes WHERE itemId = ? LIMIT 1");
      }
View Full Code Here
688
689
690
691
692
693
694
695
696
697
698
      {
        statement = con.prepareStatement("UPDATE item_attributes SET augAttributes = -1, augSkillId = -1, augSkillLevel = -1 WHERE itemId = ? LIMIT 1");
      }
      else
      {
        statement = con.prepareStatement("DELETE FROM item_attributes WHERE itemId = ? LIMIT 1");
      }
      statement.setInt(1, getObjectId());
      statement.executeUpdate();
    }
    catch(Exception e)
View Full Code Here
723
724
725
726
727
728
729
730
731
732
733
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM item_attributes WHERE itemId = ?");
      statement.setInt(1, getObjectId());
      statement.executeUpdate();
    }
    catch(Exception e)
    {
View Full Code Here
745
746
747
748
749
750
751
752
753
754
755
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT augAttributes,augSkillId,augSkillLevel,elemType,elemValue FROM item_attributes WHERE itemId=? LIMIT 1");
      statement.setInt(1, getObjectId());
      ResultSet rs;
      rs = statement.executeQuery();
      if(rs.next())
      {
View Full Code Here
791
792
793
794
795
796
797
798
799
800
801
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("REPLACE INTO item_attributes VALUES(?,?,?,?,?,?)");
      statement.setInt(1, getObjectId());
      if(_augmentation == null)
      {
        statement.setInt(2, -1);
        statement.setInt(3, -1);
View Full Code Here
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
    FiltredPreparedStatement statement = null;
    ResultSet item_rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT * FROM items WHERE object_id=? LIMIT 1");
      statement.setLong(1, objectId);
      item_rset = statement.executeQuery();
      if(item_rset.next())
      {
        inst = restoreFromDb(item_rset, con, putInStorage);
View Full Code Here
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE items SET owner_id=?,count=?,loc=?,loc_data=?,enchant_level=?,shadow_life_time=?,item_id=?,flags=? WHERE object_id = ? LIMIT 1");
      statement.setInt(1, getOwnerId());
      statement.setLong(2, _count);
      statement.setString(3, _loc.name());
      statement.setInt(4, _loc_data);
      statement.setInt(5, getEnchantLevel());
View Full Code Here
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("REPLACE INTO items (owner_id,item_id,count,loc,loc_data,enchant_level,object_id,custom_type1,custom_type2,shadow_life_time,name,class,flags) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)");
      statement.setInt(1, getOwnerId());
      statement.setInt(2, _itemId);
      statement.setLong(3, _count);
      statement.setString(4, _loc.name());
      statement.setInt(5, _loc_data);
View Full Code Here
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM items WHERE object_id = ? LIMIT 1");
      statement.setInt(1, _objectId);
      statement.executeUpdate();
      _existsInDb = false;
      _storedInDb = false;
      Stat.increaseDeleteItemCount();
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.