Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.executeUpdate()

8014
8015
8016
8017
8018
8019
8020
8021
8022
8023
8024
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM character_hennas WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, getObjectId());
      statement.setInt(2, newclass);
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE character_hennas SET class_index=? WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, newclass);
      statement.setInt(2, getObjectId());
      statement.setInt(3, oldclass);
View Full Code Here
8020
8021
8022
8023
8024
8025
8026
8027
8028
8029
8030
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE character_hennas SET class_index=? WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, newclass);
      statement.setInt(2, getObjectId());
      statement.setInt(3, oldclass);
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM character_shortcuts WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, getObjectId());
      statement.setInt(2, newclass);
      statement.executeUpdate();
View Full Code Here
8025
8026
8027
8028
8029
8030
8031
8032
8033
8034
8035
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM character_shortcuts WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, getObjectId());
      statement.setInt(2, newclass);
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE character_shortcuts SET class_index=? WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, newclass);
      statement.setInt(2, getObjectId());
      statement.setInt(3, oldclass);
View Full Code Here
8031
8032
8033
8034
8035
8036
8037
8038
8039
8040
8041
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE character_shortcuts SET class_index=? WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, newclass);
      statement.setInt(2, getObjectId());
      statement.setInt(3, oldclass);
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM character_skills WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, getObjectId());
      statement.setInt(2, newclass);
      statement.executeUpdate();
View Full Code Here
8036
8037
8038
8039
8040
8041
8042
8043
8044
8045
8046
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM character_skills WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, getObjectId());
      statement.setInt(2, newclass);
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE character_skills SET class_index=? WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, newclass);
      statement.setInt(2, getObjectId());
      statement.setInt(3, oldclass);
View Full Code Here
8042
8043
8044
8045
8046
8047
8048
8049
8050
8051
8052
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE character_skills SET class_index=? WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, newclass);
      statement.setInt(2, getObjectId());
      statement.setInt(3, oldclass);
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM character_effects_save WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, getObjectId());
      statement.setInt(2, newclass);
      statement.executeUpdate();
View Full Code Here
8047
8048
8049
8050
8051
8052
8053
8054
8055
8056
8057
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM character_effects_save WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, getObjectId());
      statement.setInt(2, newclass);
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE character_effects_save SET class_index=? WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, newclass);
      statement.setInt(2, getObjectId());
      statement.setInt(3, oldclass);
View Full Code Here
8053
8054
8055
8056
8057
8058
8059
8060
8061
8062
8063
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE character_effects_save SET class_index=? WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, newclass);
      statement.setInt(2, getObjectId());
      statement.setInt(3, oldclass);
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM character_skills_save WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, getObjectId());
      statement.setInt(2, newclass);
      statement.executeUpdate();
View Full Code Here
8058
8059
8060
8061
8062
8063
8064
8065
8066
8067
8068
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("DELETE FROM character_skills_save WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, getObjectId());
      statement.setInt(2, newclass);
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE character_skills_save SET class_index=? WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, newclass);
      statement.setInt(2, getObjectId());
      statement.setInt(3, oldclass);
View Full Code Here
8064
8065
8066
8067
8068
8069
8070
8071
8072
8073
8074
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("UPDATE character_skills_save SET class_index=? WHERE char_obj_id=? AND class_index=?");
      statement.setInt(1, newclass);
      statement.setInt(2, getObjectId());
      statement.setInt(3, oldclass);
      statement.executeUpdate();
      DatabaseUtils.closeStatement(statement);
    }
    catch(final SQLException 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.